I'm trying to set up an auto-run macro to export my data as an ASCII pipe-delimited format. Anyone have ideas on how i could achieve this. Data export format:
- Ascii file (pipe delimited)
...
What VBA code do I use to access the various regional settings on the PC on which the code is being run. Specifically, I am looking for the Time Zone.
I have 2 forms:
frmHistory
frmHistory-sub ---which is a subform of frmHistory
View Selector
When I'm trying to open frmHistory I have error message 2450 can't find a form "View Selec...
I am using Access 2000. I have a form. On that form is a button titled: "Print Report". When the report opens, if a user shrinks the report the background form shrinks with it. How do I preven...
I have the following attached code that looks at a file on a network drive. I get File and/or Path Not Found, but the code works fine if I have it look at a path/file on my c: drive.
What ...
Experts, right now am using VBA to automatically run a query that creates a table with subdatasheets. The program then automatically exports the primary table to excel. My question is, how do ...
I used to know how to do this, but it has been a long time, and the examples I had appear to be long gone.
I have a table with field names and a true/false indicator
I need to retrieve t...
Hi
I have a form which has 6 check boxes on it which all represent different cities. The check boxes represent the "WHERE" condition of my query. So, say the 6 check boxes are London, Lisb...
What do I need to change in this code to make a popup appear within the access environment instead of a new internet explorer page?
This link provides more details, the solution there did n...
I have a form(Name"Old_Date") On this form I have a textbox(Name: "Date")
I also have a table(Name:"Date_List", Columns: "Dates")
How do I make it so that when I press a button my textbox ...
I have a MS Access table call tblTest: Sample data like the following:
PID Visite Code1 Code2 Code3 Code4
111111 1/2/2007 1A 2A 4A 3A
111111 2/2/2007 1A 3A 4A 5A
111111 3/...
I have a form the prompts the user to enter a begin and end date and a company #. When they click Next a subform opens with a multiselect listbox and based on the company that they selected t...
Perhaps an ODBC issue, but after user does the FileOpenSave and navigates to any drive/subdirectory outside of the "default application path", the combo box on the same screen can no longer 'f...
I am trying to calculate the date of every 3rd Thursday of the month for given the year. I have seen some code for calculating, say the 4th Thursday in VB on this site but have not seen anyth...
Considering I have a very busy form and want to avoid making it any larger, is there a way to code the F2 shortcut within an OnEnter or OnClick event of a field? I'd like the user to have mor...
Looking for the best approach to open a File dialog, so that the user can select doc, xls, etc and place that data (filename, filepath, and attachment type) in a listbox(underlying table), the...
I am relatively new to VBA programming. I have a form in an ACCESS 2000 Database that requests a start and end date to pass to a query; the results of which are to be transferred to an Excel s...
Hi, I have a make table query [qryOutput] in Access that filters results when a user chooses the criteria. When the form [assessment] filters the data I would like a command button on it to ex...
I've got a form that opens very slowly because of the recordset queries that are run on the On_Current event. Is there any way to allow the form to open and let the code run in the background...
Please see ID: 22608925 for the full story here.
I am trying to get a fixed width delimited file to work. I go through the wizard as instructed and at the end it makes a file that is exactl...
Can anyone tell me where I can find a code sample for how to compare two recordsets to see if they are identical? We are entering two datasets, A & B, with a main record and several linked su...
Hi experts,
I have created an SQL inside a combo box that displays values relating to a location reference. This works ok but I would like to have an "ALL" in the list that can be selected...
Dear Experts, I am not sure what the syntax for this DCount VBA is which is on_Current of the mainform...Please help:
If DCount(Me.Fo_Treatment_Course_Subform) = 0 Then
Me.CmdEditTreatment...
Access 2003 on WindowsXP:
(1) I ran the duplicates wizard to get Dups in a table on 2 fields, about 3,000 out of 170,000
(2) In a module I wrote a sub to open the DupQuery as a recordset, lo...
I want to show a relationship in Microsoft Access made database. I am making a Member Profile Database.
What I want is this: When I enter profiles: for instance Me and my daughter. One fie...
