I want to make a macro or write code that I will execute from a swtichboard that runs a series of Make Table Queries (about 21 total) that will be overwriting the pre-existing tables with upda...
ok, I'm going to do my best to be as thorough as i can here cuz this is a bit convoluted... please bear in mind that I'm a newbie and have been figuring this out as I go - using the snippets t...
I'm trying to get the correct connection string down to connect to a DB2 table that is linked to a query. The connection string itself appears to be correct as it is not throwing any errors, h...
I have the following code in a fuction to reterive Network login ID and than I am comparing this LoginID with the pre-listed users on the table to see if it matches. If it does match the swi...
Is there a way in Access 2003 to find out if the "shift" key is being held down? When a label is double clicked, I want one thing to happen if "shift" is held down and another thing to happen...
I have a syntax error in the following SQL statement:
INSERT INTO [Level8] (OpeningName, RoomNumberCHI, OpeningNumber, SuffixNumber, Size, DoorType, OpeningMaterial, FrameType, ElevationTyp...
I've spent entirely too much time on something that should be simple. I'm trying to get a cursor placed at the front of any data in a textbox when the field gets the focus.
What code do I u...
How do I make my Access database read email from my inbox in outlook?
Is there a way to maybe import emails from my Outlook inbox to a table? If so how would I do this?
I have a query which i want to export to a text file. The problem occurs when i do this manually after running the query or in code using transfertext as below.
DoCmd.TransferText acExport...
Hello,
I have the following code which i have attached.
But when I try to open the template file after the script has completed it say's I still have
it open and can only have read-only a...
Experts,
I have converted a macro to VBA and I need to modify with a where condition. On the DoCmd line I need to add a record where "[COID]=" & me.COID
I added it to the line and must ha...
I have a multicolumn listbox with 7 columns. The listbox is a VALUE LIST, therefore not bound to a query. I would like to have a button, say for example, to sort ascending by the 2nd column,...
Within an Outlook 2003 macro, I am trying to populate an Access database with content from an email. When I try to connect to the Access database on a shared network drive, I get the followin...
I need to run an autoexec macro once when access is opened the first time each month and only run the first time it is opened. The file may be opened 5 times in one day or every 5 days. Due t...
Hi experts,
I have some VBA code on open of my switchboard that adds fields to a linked table. The trouble is the code is running each time the switchboard opens which is making the openin...
Experts, I have the following DSum in the control source of [Usage] on frmFacilityDetails:
=nz(DSum("[Amount]","tblLetterOfCredit","[facilityDetailsID] = " & [facilityDetailsID]),0)+nz(DSum("...
I have a field that has both alpha and numeric data in it
44444
a
32
ggg
How would I select only the values that are alpha?
Have a Main form to choose person's record and a sub form to choose which month for entry of hours worked on each day. If a person has submitted their month as finished I want to make the sub...
I'm using a function to concatenate values (separated by a comma) of a field in a summarized data set. I have a data set that lists the types of items (eg. B, P, F, D) associated with an order...
I need someone to combine the logic of the Sub GenericSubWithHandler (in the bottom half of the code snippet below) into the Function DAO_Transactions (in the TOP half of the code snippet below).
I have an Access table that has fields. I used to import Excel spreadsheets using these fields. The customer has changed the Spreadsheet column names (these USED to match the field names) so...
I have some code that is pulling a report and printing it in PDF format. What want to do is change the name of the document as it is printed - exported out ie.
The Report I am printing I...
I have a continuous form where I have multiple fields to update or create new records.
The afterUpdate event works when I modify the "txtNo" field, but when I create a new record and add va...
Hi
i have a table i use as a temp table is it possible to make a range on autonumber field so that it always starts from 1
Hi
Using Access 2003, the code below points to the specified expected location of a back end data file and then refereshes the tables.
Whilst I DO want to verify that the data file exis...
