Hi,
My Access 2003 workgroup file includes Tables, Forms, Macros and modules.
How can I transfere it into executable file (.exe)?
Thanks
Toni
I am trying to export an Access 2002 db table in a csv format
I want it to look like this when exported
"field1","field2","field3","field4"
instead I am getting this if i put a txt ex...
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 am developing an Access database in 2007 with a FE/BE configuration. I implemented a number of UI changes yesterday that worked just fine.... yesterday...
Today, in testing the very same ...
I am getting an Error 2455 - invalid reference to Form/Report on this line:
If Forms!frmAccountParameters!frmDisbAccountingSub.Form.RecordsetClone.RecordCount = 0 Then
The form that it ...
I'm trying to figure out the correct syntax for directly updating a table column....the RecordSource for my form looks like this:
SELECT dbo_instr_test_xref.test_no, dbo_instr_test_xref.sys...
My multi-user replicated database has daily conflicts as a result of user writes to the same tables. I have tried several pieces of code to "trap" the conflicts in order to advise the user of...
I know there is a way to do so as before...
How do you set a reference using VBA only instead of going to Tools - References and checking on what you need?
I think the VBA I used in the pa...
I want to write a function with input of sOrderNo (=12345678 in this case), and output of corresponding ID. But when I use the following code, an error occurs,
Run-time error '3061': Too...
Hi,
I have the following code which is ran when the "Purchase" button is clicked.
The code is looking at what has been entered in the textbox txtBarCode1.
I have 7 other barcode txtbo...
I need to add a button to the main form of my database that will prompt a user for a location and then copy the database to that location. This is a reporting database and the data is only up...
I've only found this error in Access 2007. I create a database and a form and add controls with code behind them - say a button to open a form. It works great. Then when I close the db and reo...
Hi,
When i import the excel file using import offences it working well.
When i'm using import students,first time it works perfectly.But for the next time if we import the excel file,
i...
Hi,
Now I have an Access 2003 MDE file, I want to run it on other PC(s) but I'm not sure if they contain Access 2003 or not (because other people should use it)
Are there any tools (Mdac_Typ...
I have discovered that i can edit properties of controls that are selected in design view with -
Screen.ActiveControl.Property.
Is there any way i can do this with multiple controls ie se...
If I manually import a .csv file in an access table, I have no problem. However I am now trying to use Transfer Text in a macro to import the data. When I do the import using Transfer Text, ...
Hello,
I have a recordset of 1,000,000 records with about 10 fields per record. I am using visual basic code to extract the data from the table, perform some basic calculations, and repop...
Hello all.
I'm using Outlook and Access 2003. I have an Exchange folder called eCounts that receives e-mail from a particular sender called ecounts@count.com.
I would like to import or...
We have an Access 2000 database that contains a table with a column of subject's first and last names.
For security reasons, we need to change all first/last names to initials. What VBA code...
Hello Expert people,
I think this question is probably pretty easy but hopefully can explain correctly. I have this form with a subform, which shows rows of data for a particular company. T...
I cannot get code with a tight loop (series of ADODB commands) to stop when I hit ctrl-break unless I put in a DoEvents statement to execute every 100 iterations of the loop. When the code do...
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 am trying to delete the current record on my form using the following code
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70...
Hello Experts,
I was wondering if its possible to put dynamic condition/criteria in if - then - else statement or in anyway achieve the same.
for example :
if <dynamic criteria> then
...
I have a custom function to concatenate related text fields together into one memo field. When I first added it to my database, I had to compile to be sure that Access understood it, and I got...
