I have a main form and a subform.
My application has relied on the fact that the "on open" code on the subform is executed prior to the "on open" section on the main form.
However my app...
Hi,
Please excuse the explanation, I will do my best to make it clear what I want. Can anyone help me with the following?
I have three tables: tblWorkOrder, tblWorkScope, tblTest. Basica...
I cannot figure out how to make a particular query work the way Id like. I have a form with a combo box where the user can select a value that is passed to a query. Lets say the values are...
This validation code works fine, but I forgot to ask (this comes from a previous question):
I want to validate three textboxes, one combo box and 6 checkbox fields. This code does this fine...
Experts,
I need to add 4 hours to a date field in access using the expression builder. The date is in this format 7/31/2008 7:55:00 PM, I need the output to be a date in the same format.
...
Hi,
I need an access macro which can import any xls or csv files and create a table in an access database...
Please help me...
I have one but it shows error....External table is not i...
I am having difficulty with an If Then Statement, and was wondering if anyone could help me out.
I have a field that is calculated off of a Date of Birth, it returns an age at a future day....
I have Access 2003 SP3 database using VBA. 4 identically set up dropdown boxes, 1 quit showing the data for no reason. I have not been able to find out if any updates were applied to the netw...
Hello,
I'm looking to create a loop that repeats every 5 minutes then I can start the program in the morning
and it will keep running till 6pm.
What would be great if I could start the lo...
hi
I have a function reference library called MyFuncLib.MDE. In other user MDBs or MDEs I set a reference to MyFuncLib.MDE. Then in the user MDB/MDE I can refer to my function library. It w...
I want to write a macro in VBA Editor in Access 2003, and then select that macro and run it in the database window, and have the macro name appear in the RUN MACRO window in Access.
How do ...
It seems like a very simple question, but I can't find the answer. I have a field that concatenates the contents of a table into a memo field. I am using a function that does the concatenation...
Whenever I try to run this function, I'm getting a type-mismatch error on the line "Set m = mf.Items.Count.Item(i)"
It's picking up the correct number of e-mails (218), but it won't go past...
Hi all.
I'm trying to set up a procedure in VBA, where I grab the e-mails from Outlook and write them into an Access table and then for all the ones that have been written to the table, mov...
I am developing an Access MDB type application.
I have a table named tblAccounts1 with the following fields of data. I am working with over 3,000 records in total. I will illustrate an examp...
I am developing an Access MDB application. In the application I call a Sybase Stored Procedure and return the result set to a recordset. I can only call this Stored Procedure. I do not own thi...
Hi,
Hi my access code application doesn't run in xp or Vista.The application is to add records to access database by access macro coding.But it is not running in both xp and vista.
Pleas...
Running from access vba, writing to table in external mdb (fNameOutput)
xStr = INSERT INTO [" + fNameOutput + "].[table1] " _
& " (fielddata)" _
& " SELE...
The Calendar control in Access 2003 (see picture), it is possible to change a specific data number ie lets say Auguest 5 to red.
What I am attempting to do is if the sales persons has an ap...
I have a query that brings back 300K+ rows. I need to only see those rows that contain alpanumeric data in the address field. I have tried to use Like "[0-9a-zA-Z ]*" in the where clause but...
I see quite a few answers on using environment.commandline to extract arguments from a command line. I would like to use this feature but I don't know where it is so I can satisfy the referen...
Simple MS Access 2003 database resides on our server. Only one person accesses it. I tried to open it the other day to no avail. The shortcut says it cannot find the database. Then opened Acce...
My database has 3 queries (2 make table queries + 1 append table query) which must be run the first time the database is opened each workday. Can VBA automate this process?
I have Access 2003 and I created a button on a form to create a new querry. I also have a button on the same form to create a new report.
Both these buttons basically open the new report/qu...
I can not send e-mails from access 97. I am using my e-mail account that is configurated on outlook 2007.
