I am using this SQL statement to delete a table in Access. I want to Append the table to Table2 before deleting it. The entire table. What SQL statement would be best to use and how?
With D...
In a previous post -I had asked the following question and rockiroad provided the code below -
I hope that Rockiroad will answer this question so I can give him the appropriate points.
We...
I need some help making my form more efficient. Right now, I have a textbox "Currency Rate" and a combobox "Currency Type". The user chooses a bunch of items that he wants to buy and all the p...
I have a large multiuser access database.
The front end is stored on each user's computer.
The back end is in a shared network drive.
The application should NEVER lock the database, excep...
Hello Guys,
I have created my code so Access sends an e-mail and it works, very proud of myself so far.
But I now have the outlook secruity settings to get past, sure as you know the pop-u...
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 ...
Hi experts,
Thanks for your time and efforts.
I have been asked to re-phrase a question of the same title so here goes.
I have two unbound combo boxes on a form; "Variety" and "Sectio...
Hello,
I have a command button that starts a series of processes. These are broken down to:
Import
run query 1
run query 2
run query 3
run query 4
move file from network drive to ...
I have query to create combined data:
SELECT [MASTER-Completed].ACCTNO, [MASTER-Completed].[ESC TYP01], [MASTER-Completed].[NEXT DUE DATE01], [MASTER-Completed].[AMT DUE01], [MASTER-Comple...
hi experts,
I have a function to extract information from a field.
However, some of the data does not contain the char i am looking for in the field.
Hence, i receive error in these re...
Hello experts,
I have a weekday string (Monday) stored in a table I want to be get the next Monday in the calendar based on the current day.
Ex.
Today's date:09/12/08 is Friday
so th...
I'm hoping this will be the last thing in this project!!
I have a macro sorting through data and redistributing it to different cells. I ran into an issue where some of the data I need is n...
How do I filter in a Query to exclude any that contain Alpha Characters, and also are no more than 7 Characters long?
Thanks,
gdunn59
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 an Access ADP project that allows users to send an email from the system, I use Redemption to bypass the Outlook security dialogues. Once the email has been sent it must be saved in the...
When I use this snippet of code, 584 records are returned (which is what is expected)
Set db = CurrentDb
Set rs = db.OpenRecordset("Contacts")
MsgBox rs.RecordCount
However, ...
I have reports setup in Access 2002.
I dont think I can do this from a macro but hopefully from some VBA coding.
I have approximately 50 pages to the report
Each page needs to be prin...
Hello -
I have an access\VBA generated e-mail that e-mails a client when something is ordered on their case. Based on the check marks in the form (Forms!OpportunityDetails.RequirementsQuer...
I am importing a table one of the fields is coming in as "text" in excel and causes a problem with the relationships.
How can i change this field automatially when it comes in using VBA?
I...
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...
Hi,
I have this code which i have altered to allow the user to select from a combo box which field they want to search in and then let the user enter a search string in a text box to search...
Is there a trap-able event tripped by the cursor moving through the rows of a listBox - such has happens when the up- or down-arrows are used to navigate from one element to the next without m...
I want a splash page (Bitmap) to open up first before the autoexec form loads on my access db. I think i need to use the timer event, just not sure how. Just for 2 seconds or so.
Running from access vba, writing to table in external mdb (fNameOutput)
xStr = INSERT INTO [" + fNameOutput + "].[table1] " _
& " (fielddata)" _
& " SELE...
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...
