Search results

Please bear with me; and thank you so much for your help. I am getting a very large number that is not tied to anything that I can see. To reflect the last ending mileage of a vehicle in a text box I have the following: =DMax("[End Hrs/Miles]","[Vehicle Usage]","[BCO #]") Field...

I'm sure I have missed something because it says "#Name" but this is what put in the control source of the text box for last mileage. Thank you for your help. This helps me learn as well:(Table is Vehicle Usage) =DMax("[Vehicle Usage]![End Hrs/Miles]" , "[Vehicle Usage]![BCO #]" & Me.[Vehicle...

Thank you so much; I will give that a try.

Thank you so very much. So would I in form design create a text box who's property is the vmax query? IN the vmax query would I include a prompt for the veh #? I really appreciate the help.

I have a table that tracks vehicle mileage and have created a form for data entry. I would like the form to reflect the last mileage when a user selects a vehicle #. Is that macro within the form or how would I best accomplish that?:confused:

Thank you so much! I really appreciate all the help; this is really great.

I am using Access 2007 and would like to have a macro run on start up that would run an update query. I have looked at the Access button/Access Options but not sure where to go from there. Thanks so much!:confused:

I am importing an excel file and in the import options it asks if I want to import to a new table, append to an existing table and that is what I am trying to do. I have also imported to a new table and tried to append table to table and am still getting the error. Thank you.

Thanks so much. I changed the name of the field to EE_Name in both the imported file and the table I'm trying to import to and again am getting the "Max was unable to applend all of the records, the content of the fields in 0 records were deleted and records were lost due to key violations"...

I am trying to convert my .mdb data base to the .accdb format and when I try to run a simple table to table append query and I am getting "Max can't append all the records in the append query. Max Set 0 field(s) to null value due to a type conversion failure due to key violations" I have never...

Now I need to create a form for updating information and would like to use the same type of criteria. How would I open the form based on the combo box criteria? Thanks so much for any help.:confused:

Thank you so much Trevor; worked like a charm!:D

I have a report that is based on a query that currently asks for the area that they want for the report. I would like to instead make this a look up query and bring back results in the report for the selection(s) made. How would I do that? Thanks for any help; really, really appreciate it.

That worked! Thank you!

I have a query that provides a lookup for possible sections within an Orchard but it's driven by row so I get multiple results; how do I get results for just the sections possible? Is there a hide duplicate way in a query? Thanks for any help!:rolleyes:

I have an Access 2007 simple db that I am building for a non Access user. I would like to do some of the data entry for him by having a macro or some process that when he selects a certain value in one field it populates another with a date. So in example if he selects "Bus 3" or "Bus 4" in the...

Awesome! Thank you so much!

I have a simple question (I hope). I want an expression that iif ([Dt] Between 08/01/2010 and 08/07/2010, "Wk1", "WK2"). All I get back when I run it is Wk2.

I currently have a macro that sends a daily report via Outlook. We are in the process of learning SharePoint and I was wondering what the best process would be to upload this report directly into SharePoint. Would that be a daily upload or process or could the macro in Access output it directly...

I have a table in a Word document that I want to insert names from a query but I can't figure out how to do next record within the same document. How do I do that?:confused: Thanks so much!