Search results

Same error message and the table is called My Company Information

Thanks JHB but adding the My Company Information table to the actual complex query that I am using causes the error message that I attached in my previous post....

I'm back! Ok, I have attached a small sample database with the following: 1. Table - Workorders 2. Table - My Company Information 3. Query - Workorders Query 4. Form - fWorkorders In the query, you will see where I am using the following to filter the records in the Workorders table...

Hi JHB, I'm in the process of stripping down my database into a smaller version. I have also switched to using the DateDiff function in the query...give me a few minutes.

Hi JHB, Sorry for not providing the entire query but it is quite big and I was trying to explain the issue more simply. Yes, I did include the table in my query but it displayed the attached error message. Here is the query as it currently stands: SELECT Workorders.WorkorderID...

Hi Guys I have tried to figure this out but can't so I'm hoping I'm missing something easy that somebody will help me solve. I have a query that basically chooses records from a table that contains a list of Invoices with a field, [InvoiceDate] based upon the following criteria: Is Not...

Thanks Doc Man

Hi Guys Thanks for all of your replies....I really appreciate them. based upon your comments, I have decided to change my approach and my logic to the following: 1. When the user right clicks TextBox1, it now opens Form2 and passes it the PartID of the record of interest using the...

Hi Guys Would somebody please look at answering my questions: Ok, so here are my questions: 1. how do I specify a Global variable as the Control source for my text box either via VBA or direct? 2. Is if possible to directly set the Control Source of the text box to pick the PartName from...

Hi Uncle Gizmo, I don't know how to do what you are suggesting....

Hi Guys, I've spent hours trying to figure this out but just can't crack it. Here is a simplified explanation: I have a form (Form1) that has a tab control that has a number of Sub forms called subform1, subform2, subform3 etc. On subform1 there are text boxes called "TextBox1", TextBox2"...

Thanks MajP

Thanks DocMan. You have certainly given me some things to mull over..... Thanks again to everyone for your replies. Cheers

Thanks Sonic8, I'll have a look at the video... Cheers Greg

Hi guys, Firstly, thanks for the replies. I think I also need to further clarify what I am looking for. I'm 60 years old and come from a mainframe computing background and am familiar with a range of programming languages. Most of these had ways to enable the developer to create a...

Hi guys, Whilst I am still learning about Access and VBA I'm not a total "newbie" and have developed a large application. I now want to tidy up the code so as I have a lot of code duplicated from form to form. For example, I have a form (called Form1) that has a number of buttons that have...

Hi and thanks for the reply and comments I'm a bit of a newbie and am struggling with implementing this that's why i asked for a sample DB. Cheers

Hi, Can you please post a sample database so that I can better understand how to implement this into my code? Thanks Cheers Greg

Thanks for the utility that displays the number of table connections! I have been chasing this issue for a while and I can now see what is actually happening....all I need to figure out is how to fix it! Cheers Greg

Hi guys Any ideas?