Search results

Thanks for this. I sorta skipped it because I didn't want to join it. But, I need to unpack this more carefully and read about max().

First, thanks for the help. I do use the Docmd.openreport. as for the where clause... we come back to my original post. I'd like the report to open the highest number (Id or date) on a table. Can a where clause do this? Here's why - sorry if I didn't make it clear, I don't know the id of bol...

I'm traveling. Thanks so much! Can't wait to try this.

Since I'm pretty new, looking for commonly implemented solutions. It seems like my idea is not that. But since JDraw asked, here's an almost brief description: The output of this basic database is A Bill Of Lading form for a shipping company. they do art transportation - need 3,000 a year. Their...

its probably the correct solution. i was hoping to make a form do something without several more queries or getting a recordset and building the whole form in code. the form is complicated and has a lot of static text with lots of formatting. ( beyond my control ) the dynamic part is by...

I'm new to VBA but know a bit of SQL im trying to call a report. i want it to open and see only the highest id from a query. could i make a working "on load" event using the docmd.runsql then select top 1 from queryname? im getting an error ive tried looking at tables (instead of queries) too-no...

i probably should move to thread now... but i think its this...

I'm not good at this yet but I do this as best I can. One problem is I crash. I become too detailed and have to research if something will work. Then I start testing code. How do you know -what-exactly to document?

Thanks everyone! Late in the day I 'found' record sets. Seemed to address the following but will ask anyway! To me, SQL is sort of easy and explicit. But with VBA I'm having trouble with telling SQL to get variables from a form ( all user work is done on them) what's with this " me." How can I...

Thanks! In my VBA code editor, the immediate box never displays output of any kind. I googled and read for several hours yesterday, couldn't find a solution. Also, if I 'play button ' - run code, a pop up box asks what macro I would like to run. I was able to run code from the access form where...

I learned a bit of SQL in a free class a few years ago. But now with my second database gig I'm hitting VBA hard. What are the most used skills or objects?