Syntax error in date in query expression issue I have a macro on change of a field that sets the value of various other fields in a form, based on ID's matching. I just needed to add another field to set the value of and on update am gettings this error: "sntax error in date in query expression." The field who's value I'm trying to set is not a date, it's tex... 2 Feb 2010 17:24
Calnedar Control Hi, I developed an Access2007 application and I use frequently the calendar-Control. I wrote a huge number lines in VBA-code and it works excellent. However in Access 2010, this control disapeared. When my clients are going to upgrade to Office 2010, my application will be errored. Please reïntegrate his calend... 2 Feb 2010 17:24
If you buy the world's best and the cheapest batteries will not blame me www.laptop-battery-inc.co.uk This is inside what used between the plates ������spy pen http://www.laptop-battery-inc.co.uk/spy-pen.htm ... 28 Jan 2010 03:10
Closing forms help please, Could someone please help me? I have read some of the threads relating to closing forms, how and where do you write the code to close one form, when you open another one. My example is, I have a switchboard form from where I navigate around the database. Various buttons open the forms I need. How can I get the... 2 Feb 2010 17:24
Yes/No Field Size Is there a way to increase the size of the check box for a Yes/No field? James ... 27 Jan 2010 13:47
Access Form I have created a form when I open it, it has 1 of 1 in the record navigator. I want to be able to see 1 of however many records I have so I can use the find key to update a record if needed. ... 2 Feb 2010 17:24
Closing Balance figure to be carried as Opening Balance in a new record I have fields like Opening Balance and Closing Balance besides other fields. I want the closing balance of one record to be carried as opening balance for the next new record. Please help me urgently. It is a number field at both the places. -- Message posted via http://www.accessmonster.com ... 27 Jan 2010 16:04
HOW TO MOVE FOCUS TO ANOTHER FIELD IN A FORM dear sir I am a middle aged retired man and I am trying to learn MSaccess2007 . I have created a small database and i am trying to create a data entry form. In the form i want to move from one field to another depending on the value entered in a particular field. For example i have a field called "Doc Type"- ... 27 Jan 2010 10:23
addition on a form i need to add totals in text boxes to give me one total for all on the form ... 26 Jan 2010 22:19
Calendar Form Hi Groupies I'm wondering if anybody has an example of how to create an Outlook Month view form in Access? I would like to be able to see what has been input for each day and if possible be able to click on it. I would prefer NOT to have to pay for add in software. It's incredibly frustrating that this and... 26 Jan 2010 18:57 |