I have created a recordset using three tables and criteria received from user input on a form. I would like to be able to view the recordset in a datasheet. How do I create a view for this r...
Using Access 2003 I have a table with emails. The data was imported from a text file. I have to remove the double quotes from each email in the table. Lest say it is Field1, how do I remove...
I am trying to insert a bunch of dummy records into an Access Database table using VBA in a module called survey_results. Below is the code I am using. I'm getting the infamous Object variable...
Hello Experts,
I have developed an access database, along with all the vba code, using Access 2000. One of my users recently upgraded to Access 2007 and is now receiving error number 2950 wh...
I have a text box called Txt_Date_Opened.
Rather than have the standard error message that if a use does not enter the proper date I would like to prompt with a more helpful message such as...
I'm trying to figure out the best way to refresh data in a dropdown list on a form. The dropdown list contains customers, and the form that the dropdown list is on has a button to click on to...
Looking for a "can it be done?" answer, not really how to do it at this point. I have a complicated Excel Workbook that feeds a report (lots of graphs). I am moderately confident with Excel, b...
Hello experts,
I want to write some VBA (Microsoft Access) code to do the following:
I have a folder (actually i have l list of folders) named 'abcd'. Inside the folder there are lots of fil...
I am trying to create a Printable report which will have different information on it depending upon what product has been selected.
This is my current code:
If Make = "AVG" Then
...
I am using access 2003 to open a spreadsheet with 250 sheets. Splitting those sheets into single excel 2003 workbooks and adding some data validation to them via VBA.
Everything was workin...
I need to change the way a certain field calculates data, but at the same time not endanger the 5 years worth of historical data that reside in the underlying table.
I need to create a for...
The form has one sub form. The focus is on the sub form, I need to move the focus to a list control on the main form, select the first entry and activate, this then refeshes the sub form.
Al...
This works
CurrentDb.Execute "CREATE TABLE MyTable ([FindText] TEXT, [ReplaceText] TEXT, [WholeWord] TEXT);"
strQuery = "SELECT * FROM MyTable"
Set rstMyTable = CurrentDb.OpenRecordse...
User needs option of inputing a Canadian postal code or US zip code in the postal code field. The mask must allow either type of code but prevent any errors. Application is for small busines...
Dear Experts,
Access 2002 w/SP3
Access 2003 w/SP2
Windows XP Pro w/SP2
The API: Shell and Wait, by Terry Kreft is not working to me
http://www.mvps.org/access/api/api0004.htm
I k...
Is it possible to create an Excel file in Access using VBA that has multiple tabs. I have code where I can pass in a recordset and it will create an Excel file with it, but it can only put da...
Experts-
I have a third-party utility that automatically generates an Access MDB. I have a series of queries and reports that I want to run against the MDB each time it's created. Currently...
How do I concatenate two fields into one text box (and table)?
me.txtIndexID.Value = "txtApplicationNumber" & "txtBldgPermitNo"
I am using MS Access 2003. I want to have my database open up in maximized view when opened. I have a form open up on startup and I need it to open maximized. I created a macro and in that mac...
I would like to pause an execution of VBA code in the MS ACCESS, I have a loop that will run multiple times and update a table records with each loop. I would like to pause for 10 sec after ea...
The field contains characters that I think are carriage returns. The character looks like a square. I cannot do a Find and Replace. I'm able to highlight and copy the character into notepad...
I am designing a Microsoft Access Database and i will like to write a VBA code to stop the security warning from poping up each time the application is loaded. i know i can set the security o...
Hi, Having just executed a do.cmd transferspreadsheet called say "My_New_Sheet" how can I select the sheet to start formating it. I can open a new workbook and sheet with dim and set obj etc....
I need to implement making $ amounts either red or green in color identifying whether or not the amount is in the negative or positive. How would I do that within a report or form field?
T...
Is there a way to import an xml field from an xml file into a variable using VBA in Access 2003?
