Search results

Yes, pr2-eugin, that is where I am stuck, as you put it. Your example gives me a better picture using the queries as you have explained. Thankyou, my goal is to learn VBA not just get this to work so I appreciate everyones input. Is there a way to do that in a module so I can learn VBA...

Do I even need to declare a recordset? Do I even need a Dlookup function? Im trying to learn this so if I'm way off, let me know so i don't waste anyone's time. I will keep reading and watching videos to learn more.

This is my first code I've tried to write so forgive basic errors please. I've Searched this forum for examples and issues but all the answers havent worked and I'm not sure if Im even in the ballpark of writing this correctly. I have a table ,tblVehicles, with vehicle data. When I open my...

no, not a web database.

I apoligize for my absence, been busy with other jobs. Yes I use Access 2010. I am slowly learing about VBA but just not understanding the terminology yet so I try to use macros. I will add the format to date and see how that helps.

I have a relationship between tblCustomers (pk) and tblCustomersSub (fk) I have a StartTime field in table (tblCustomersSub) that has a lookup in "before changes" to set a field to yes or no that is in another table (tblCustomers) I can get it to work so it looks up the date and sets the...

I went back and created a report and had the same problem. However, after trial and error, I found in the properties in format section a 'can grow' option. I selected 'no' and it fixed it. Not sure if this is helpful to anyone but anyways, Thanks to everyone. :)

I will look at making a report then to print based on what you have mentioned. Thanks.

I am using tblCustomers as master for clients info and using iform to collect data in the field and import it into another tblCustomerSub. I created a frmWorkOrder and displayed clients from tblCustomers and additonal information from tblCustomersSub in 2 subforms. It all works in form view...

I have a small amount of understanding of Macros but keep running into this VBA terminology stuff. Only thing i have gotten is you gotta use DIM alot. lol I just wanted to know where is a good place or way to get started learning this. A lot of my answers to problems have all been in VBA...

Im Dwayne Wilson, I work for Arbor Associates Inc. in Dallas Texas. I am using Access 2010 to manage our pest control data and some other ideas I am trying it out with. I will post some questions later but Hope to chat with you later.