|
More site info...
Microsoft Access | Forum profile
|
|
Forum profile page for Microsoft Access on http://www.mrexcel.com.
This report page is the aggregated overview from a single forum: Microsoft Access, located on the Message Board at http://www.mrexcel.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Microsoft Access" on the Message Board at http://www.mrexcel.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Microsoft Access:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
64
|
340
|
1,120
|
|
Post:
|
240
|
1,192
|
3,670
|
|
|
Microsoft Access Posting activity graph:
|
Top authors during last week:
user's latest post:
Send Word attachment via Access...
Published (2010-01-05 14:46:00)
Quote: Originally Posted by hcabs99 Many thanks (again!) Have put the code in as you suggest, but i get an Error 438 (Object does not support this property or method) in Procedure TestEmailWithAttachment Any ideas? Yes, remove the line with the Hyperlinks.Add.... that rconverse suggested. Access is telling you that that construct is not supported . I'm not sure how familiar you are with vba. My last post showed an example of how to...
user's latest post:
iif with multiple outcome
Published (2010-01-04 18:56:00)
If you want to see both 2009 and 2010 data why don't you use other criteria? If you look at the query by design view you'll notice 'or' below Criteria on the far left. So you might be able to put other criteria in another row.
user's latest post:
Dirty Form...
Published (2010-01-04 21:16:00)
Quote: Originally Posted by hollifd Hey Thanks Bob, That did the trick. I appreciate the help on this. David Glad we could help out.
user's latest post:
Help with VBA script that...
Published (2010-01-05 14:18:00)
One other thing. You have declared "dbs", but it doesn't look like you set it to anything (unless you did and just are not showing it here). Usually, you should have a statement like: Set dbs=CurrentDb before you start executing queries on it.
user's latest post:
Apply Dif Rates dependent on...
Published (2010-01-03 12:55:00)
Thanks for the links - guess I've forgotten some basics. The bit that I still can't quite get is how it works when the specific date isn't listed. i.e the timesheet date is 14/11/09 but the rates table only has a listing showing a start date of say 01/03/09 and an end date of 31/12/09
user's latest post:
UDF with ADO - Page 3 - MrExcel...
Published (2009-12-28 22:46:00)
Thanks. I'm working with it now, I think the size of n is an issue, good call. It's pretty quick, too! 100k+ records using it takes a few seconds.
user's latest post:
IS Error In Formula
Published (2010-01-05 12:44:00)
Thank you this works well. Happy New Year
user's latest post:
Output Filtered Form results...
Published (2010-01-05 12:01:00)
Hi I have created a form that uses combo boxes to filter a subform results this works great, but my final stage is to output or export the filtered result to Excel. I am using Access 2007. I had created a temp table to store the results in but it fills the table with all the records. Can you append records to a temp table from a filtered Form? The subform data source is a query but the program I have written is based within the form.
user's latest post:
New Access forms (tabbed)
Published (2010-01-02 19:25:00)
Nevermind. Found answer here: http://www.btabdevelopment.com/main/...1/Default.aspx (thank you Bob Larson!).
|
|
|
|
Latest active threads on Microsoft Access::
Started 1 week ago (2009-12-30 11:56:00)
by hcabs99
Hi All
Can anyone advise please. I have various macros running in access which send emails with attachments containing tables from the database. This all works fine.
On one of the emails sent out, i need to send a word document which contains instructions on what to do when the attachment is sent. Any idea how i can send this on the same macro?
Cheers
Started 2 days, 15 hours ago (2010-01-04 14:35:00)
by Norie
Jon
How exactly are you trying to run the query/code?
Which application is giving you the error, Excel or Access?
Does the query use any UDFs (user defined functions)?
Started 2 days, 12 hours ago (2010-01-04 17:55:00)
by Norie
Could you explain in words what this is mean to do?
Some sample data would be nice too.
I've got a feeling that Iif isn't the right thing to use and/or you are using incorrectly.
Started 1 day, 17 hours ago (2010-01-05 12:25:00)
by Joe4
Welcome to the Board! For things like Importing and Appending to tables, Access error descriptions are less than ideal, and often not very helpful.
Check the properties of the fields on your tables. Are you trying to import invalid values in?
Things to look for:
1. Are you trying to import invalid data types, i.e. are you trying to import text into numeric fields?
2....
Started 2 weeks ago (2009-12-24 02:05:00)
by Dembo
Help with VBA script that updates field in table
Hi There,
I have tried to find a vba script which updates a field in a table, I have found reference to using the SQL from an update query, but I do not know the syntax.
The database I am building is going to be used to track equipment being signed to a person and signed ...
Started 1 day, 17 hours ago (2010-01-05 12:27:00)
by Joe4
How about something like this?
Exposure Change: NZ([Renewing Exposure],0)/NZ([Expiring Exposure],1)
Started 2 days, 10 hours ago (2010-01-04 19:25:00)
by ccoleman
Whether it's correct or not I can't really say but I tend to make the combo box 2 columns, the first being the ID the second being the actual name. Then under the column widths make it "0,".
This makes the first row the bound column which is the ID (so any value you set from this box is the ID) but the user will only ever see what's in the second column (i.e. the name).
Started 2 weeks, 1 day ago (2009-12-22 14:20:00)
by Joe4
It looks like you want them in alphabetic order, so why not just sort by that field in your query, and that should take care of it?
|
|
Hot threads for last week on Microsoft Access::
Started 1 week, 1 day ago (2009-12-30 01:46:00)
by dogdays
You could create a table containing 1-resource code, 2-starting date, 3-ending date, 4-hourly rate for this period. To get the rate for a specific time period you would select hourly rate from table where yourdate > = starting date and yourdate
Started 1 week ago (2009-12-30 11:56:00)
by hcabs99
Hi All
Can anyone advise please. I have various macros running in access which send emails with attachments containing tables from the database. This all works fine.
On one of the emails sent out, i need to send a word document which contains instructions on what to do when the attachment is sent. Any idea how i can send this on the same macro?
Cheers
Started 1 week ago (2009-12-30 06:22:00)
by barry houdini
If you have a column of dates in the format 20091230 then you can use Text to columns to convert
Select column and then
Data > Text to columns > Next > Next > under "column data format" choose "date" and the format YMD > Finish
Started 2 days, 12 hours ago (2010-01-04 17:55:00)
by Norie
Could you explain in words what this is mean to do?
Some sample data would be nice too.
I've got a feeling that Iif isn't the right thing to use and/or you are using incorrectly.
Started 2 days, 9 hours ago (2010-01-04 20:21:00)
by boblarson
If the controls that have entries being made in them are not bound to a field in the form's records source, then the dirty event will not fire. It only works with bound fields.
Started 6 days, 14 hours ago (2009-12-31 15:48:00)
by Norie
I think we need more information.
For example, how are you populating the form?
Is there perhaps some issue with referential integrity, joins, required fields etc?
Started 2 days, 16 hours ago (2010-01-04 13:15:00)
by Norie
Which line is the error on?
The very last one, or the previous one.
Whichever it is, what's the error message?
Started 6 days, 12 hours ago (2009-12-31 17:58:00)
by Norie
Nucor
What makes you think you need code?
What is it you are actually trying to achieve?
If all you want to do is import data into Access from another source, eg Excel, then you should just be able to goto File> Get External Data...
If that doesn't work, say because the data isn't well structured, then you might need code.
But that code wouldn't necessarily be Access specific....
Started 6 days, 14 hours ago (2009-12-31 16:08:00)
by Norie
Why are you doing this in the first place?
It's not a good idea to update data like this.
Started 2 days, 13 hours ago (2010-01-04 16:32:00)
by jackd
Quote:
Originally Posted by healey21
I have a form that I have inherited from someone who left the company years ago. What I would like to do is change an IF statement around from searching for Text to now use Long Interger
The code I have is this:
Dim strYear As String
If IsNull(Me.cboYear.Value) Then
...
|
|
Size: 409 bytes
