Hi,
I have a splashscreen set up to display for 3 seconds on starting up my Access database. Due to response time issues over the network, I want to amend the process so that at startup a n...
I'm an access newbie so hopefully this has a simple answer.
I have created some vba scripting that takes data from a couple tables, creates some temp tables, performs some analysis and then f...
I have the attached code in Access 2003 VB which which creates a record set, loops through it and creates and sends excel spreadsheets as email attachments. The excel attachements are created...
I do many MSAccess 2003 projects on our LAN/WAN. Most of my MSAccess databases are set to automatically compact & repair after the MACRO runs.
Lately I have noticed that the db1.mdb files a...
I have been running a database trigger for years that kicks off an access database program with a /X "macro name" that starts a series of queries. All of a sudden it has stopped working - the...
I need to append data from a table to a text file that has already been created with a DoCmd method. Here is that
DoCmd.TransferText acExportFixed, "EXPORT_TABLE_Export_Specification", "EXPO...
Hello all,
I would like to develop a date search from Form in Access. Here is the sample of previous search coding I have developed used the help of experts on this site.
I do want to de...
Hello,
I have 3 boxes/fields in a search form. I can perform a search by filling out 1 field, 2 fields or all 3 of them.
The fields are
1 combo box (I can select a country, say Canada...
I want to create a type of array that is populated with the results of a SQL query. The array will be used in another query which in turn needs to be exported to an excel file.
My array qu...
I have a gut feeling this is a relatively simple thing to do, just can't quite get where to do / program it...
Basic data structure: We have Projects, and each Project has multiple Estimates...
newtbl = wrdDoc.Tables.Add(wrdRow.Cells(z), 2, 3)
see the above line in the code snippet.
I am trying to create a 2 column x 3 row table nested in a cell using Microsoft Access and this a...
In Access 2003 I want to be able to have the option to select a different printer when printing reports.
Currently I have a Macro Button on a form that previews a report. When I press the ...
i want a dialog box to ask a user if they want to insert a block of text on a report...if yes, the text they type in will appear, if not, nothing
I have limited Visual Basic knowledge, so any precise input would be appreciated. I am looking to create a macro in Access 2007 that will export multiple queries to a single Excel workbook wi...
Hi All,
I hope this is clear enough for someone to understand because I am at a standstill without help.
I have inherited an Access 2000 "app" that is the front-end to a SQL 2000 databas...
Hi,
I have used the attached code to add an outlook appointment from Access to outlook and it's working nicely, but I want to assign the appointment to different employees who are involved. ...
Successfully running a macro that has been running every day for months. Now during the run the program stops and gets this error ever so often. "A problem occurred while Microsoft Access w...
We have been successfully using Access 2003 to process Sharepoint Surveys (Currently running Sharepoint 2003). Since upgrading to Office 2007, Access 2007 does not appear to have that same fu...
Hi, I have an Access DB that contains a list of individuals (agents). I also have a folder that contains Excel Spreadsheets with a file name exactly the same as the agent name in the Access D...
I know the code to import dbf file to access
DoCmd.TransferDatabase acImport, "dBase 5.0", strLocalDir, acTable,
strFileName, strTableName
But how can I check before import so that duplica...
Hello,
I have a listbox that populates via hard coded query in the after update event of a text box. What I would like to do is take the results from this listbox and insert them into a tex...
Looking for VBA code to import data from Excel to Access Table. The code needs to bring the tables from every worksheet in the workibook into an access table. No duplicate field names in the...
I have a couple reports that are modified by VB code onload to populate titles and other fields. Because this changes the report each time its opened I get prompted to save the report when I ...
Hi
Is there a way using VB to open an Access Database and check the content of the VB modules for a particular string (I'm looking for a server address that will shortly be changing)
I would...
Hi,
I encountered an error when trying to use a UPDATE statement with INNER JOIN.
First let me explain to you the task I have. I have two tables tbl_A and tbl_B like this:
...
