Hi Experts,
i am looking for a way to export the output of a query into a .dat file using macro.
there are five fields in a table.
ID (field size = 12)
text1 (field size = 4)
date...
Hi
I have an Access report. I need to open a specific Excel file when the user closes the report. I've used Event Procedure on Close and have tried various bits of code from the answers I...
Can I use an array or something else to choose the last 3 customer records? I'm trying to show an order history and we can to do the last 3 records by their transaction date. How can I do thi...
Is it possible to update and/or add VBA code, Macros, Forms and Reports in an Access 2007 DB that is in runtime mode (.accde)? We want to be able to make changes to the screens and reports bu...
I noticed recently that a database continues to grow (almost doubled in size) over a short period of time. The growth is not due to an increade in data in the database. Would the use of VBA ...
How do I change the default value of a field on a table using VB?
I have a table titled: "Table1" with a field titled "Type". I have a form with recordsource = "Table1" and a textbox with c...
I have a form where navigation buttons are set to "Yes". The form is not continuous.
How do I make it so that when a user presses on any of the navigation buttons, code will run.
i.e. Wh...
I have written code to create queries on the fly, however, I am looking for code that will delete any and all queries from the database on close of a form or on open of the main menu. I am us...
I use a routine to call a chart in a form. When it is first called the graph layout is messy, with the legend overlapping the plot area.
However when I step into the code it draws neatly. I...
I am using Access 2003. I have a form with 2 datepickers on it that drives a query that calculates totalsell, totalcost and totalprofit. When I add date to the query I get weird results, howe...
I have a table with a bunch of names in the following format: (Last, First) (i.e. Sampson, Brock) Sometimes there are extra spaces after the comma.
What query or code could I use that would...
I have a table with a single field titled: "SSNumbers". This field contains a list of numbers. What VB code would I use that would find the largest number in the table and display a message bo...
I have a simple function to give a group category to a person's age.
In running my code the variable age will calculate the correct age. Let's use 18.
In my Case structure the 2nd Case ...
I have a form that has combobox's...
I have the first one populated with our "TOP LEVEL" organizational names. When a user selects the organzation, I want to have the second combo box get...
I have an unbound form that opens up in add mode with certain required fields. I need to check if the fields are null and if so have the system return the user back to the null field(s).
...
Hi,
I'm parsing in a block of text from a .txt file into a string in VBA in Microsoft Access 2003.
Here's the code i use:
[CODE]
DataOut = ""
Open TemplatePathAndName F...
Using VBA code, ADO, and Sql Server, I get "Timeout Expired" when trying to find a record in a table. All other machines are executing the same code, updating different document records. The...
I need to put some vb code in the Before Update Event of a field on my form that will not allow the user to enter a event that is in the qryRestrictedEvents. Basically the code should look at...
I've never used the Macro object in Access, but I've inherited a project, and I need to. I cannot get the runcode option to run a UDF, getPeachtree().
The macro name is importPeachtree; so...
I am trying to transfer data into an Excel workbook via the attached code snippet, but when I get to:
rst1.Fields(1) = "test"
I get the following error:
"Cannot update. Database or ob...
I am using a macro in Access to import a comma delimited file. However, I encounter errors while importing because a field is automattically to an integer data type. There are records in the...
I am about to scream at all of the errors I am getting in Access!! I keep getting errors that pop up almost nonstop while I am trying to edit my code in Access 2003. I think that I created a...
Hi, I have a module that when run will automatically send out agents a commission report (.xls attachment). The problem I'm having is that the function is wanting to send out an email for eve...
Hello,
I'm not sure if this is possible or not but what I'm trying to do is get Access to delete a target file (word doc, image). I have a form that contains a link displayed in a text box ...
