Search results

Are they calculated textboxes? It may be that when the code runs there is nothing in them therefore they are always the same? Try putting a breakpoint in your code and step through it so you can see what values Access thinks are in the textboxes at that point.

There can be lots of reasons for seeing this e.g. if a column is formatted as text and Access sees it as text but the value is a number or a date then it will show the dreaded #NUM! You can get round this by forcing it to see the number as text by putting a ' in front of the number. Have a...

Sorry but I don't use Access 2010 to so I can't give you exact instructions but try this link for some useful tips: http://www.functionx.com/access/Lesson05.htm

I would link the csv file as a table in access because you can then define how it splits the data e.g. by comma. Then you could run an update query or use VBA to loop through the linked table and add to your database.

Figured it out - I needed to put the form in design view to save the changes.

I am trying to set the AfterUpdate of a control to target a function (e.g. =FunctionName) and then save it in VBA so the next time the form is opened and the button is clicked the function will run.

So as the title says I am trying to set an Event property of a control and save it in VBA. So in code I set a control's AfterUpdate event to target a function and then to close and save the form I use docmd.Close acForm,,acSaveYes but it doesn't save the Event properties. Can anyone help...

Do you want to flag this before the report is opened if so the following may help? If each line in your report (i.e. record) is of a similar size then you could use the recordcount (of the recordsource) as an estimate. To do this you would have to work out how many records on average are to...

I would hardwrite the code using a number you kno should work i.e. ..."EMPLOYEEREVIEWID = 6" I would also try putting a breakpoint on the event trigger and step through the code a line at a time and see exactly what is going on.

What I meant was what datatype e.g. text, date, number etc. If text then you will need to add quotes like this: ..."EMPLOYEEREVIEWID = '" & Me.lst3month & "'"

I don't have any experience importing from emails but if you can link the file as a table then you could use an append query to add the data to your table with the autonumber. This could be automated quite easily with VBA on a button. Just link the table, create your append query and use the...

Instead of sending the results via email could you just save them straight into an Access db?

If the RecordSource for the form is a Select statement then you will have to open it in queyr view and manually add it. The only way the new field would auto-appear is if the RecordSource was the name of the table or the Select statement was using TableName.* on the table (i.e. to bring in all...

Thanks for the reply and explanation.

Is this true? I use this method alot and have never had a problem!?

Try formatting the date/time column as just a date like this: Format(LastCoreUpdate,"dd/mm/yyyy")) Also, instead of using Now() in your query use Date()

What data is Me.lst3month? The error points to this being the problem.

Yes, there should be no problem in saving new versions of the master Excel file over the old one as long as you keep the same column headers and refresh the link.

Where is flightdetails.tempflight_id coming from in the Where clause? If it's a control then the code should be something like this: db.Execute "Update tempflightheight, flightdetails Set tempflightheight.flight_id = 2000 where tempflightheight.flight_id = " & me!controlname & ";", dbFailOnError

If the Excel file and table also have the same ID field then you could link the Excel file in to Access. Then create a query with the linked excel file and your table joined on the id field. Now add all the columns you need to see and then in a new column add something like this...