In preparing to migrate to SQL Server, I need to write some code that would remove the spaces from table and field names. Here are the requirements:
From VBA in the front-end, go through e...
Hi All,
I have a small access application developed in Access 2007. Every time I run it on a machine that has no access but just the run time files(downloaded from Microsoft site) it pops up...
Hi experts,
I am trying to disable the shift key in my MS Access 2003 application so that users cannot bypass the runtime MDE properties and access the design view where they have a full ve...
Hi everybody,
How do I delete a record from the recordset, I wanted to check if my record on my table exist on the other table? I am using ADO and MS access VBA. The problem is I wanted to ...
Using Access 2003 I have a table with emails. The data was imported from a text file. I have to remove the double quotes from each email in the table. Lest say it is Field1, how do I remove...
I am trying to create a Printable report which will have different information on it depending upon what product has been selected.
This is my current code:
If Make = "AVG" Then
...
I'm using MS Access VBA and would like to open a dialog open box, similar to MS Excel's "GetOpenFileName" function for the user to select a specific file. I then would like to capture the com...
When the user changes the data in a field in a form I'd like to display a message like
"Are you sure?" with a OK and Cancel button.
My attempt hasn't worked. When I change the SubCateg...
Does anyone know of a way to combine multiple Access queries into one? Assume I have two queries, a make table query and a second query that updates a field in the newly created table based o...
(It was suggest I ask in the VBA section.. this appears to be the closest to VBA for Access)
I'm using Access 2003. I have different reports printing on different printers. One of those pri...
I have a large text file with about 100 fields that I import into Access 2007 with a Macro and a Import Spec that works fine. However I would like to write a VBA procedure to import this and ...
I have a query that when you run it you get an Enter Parameter Value window. I want to run this query along with several others in a macro and I don't want to have to enter this value every t...
Is there a way to bind an unbound text box in a continuous form to a record set? I want to be able to enter different values in the text box in the continuous form and then send the values t...
I have a macro where I us the "OutputTo" action and I am getting prompted if I want to override the file everytime it runs. I have tried setting the "SetWarnings" to off and I have set the "A...
Hi,
I am trying to open another MDE file in RUNTIME mode though the code of a button of another MDE running in RUNTIME mode.
I have tried opening with a command line string that works wh...
Hello,
Here is a simple question - how do you create an AutoExec macro that runs when MDB is being opened up?
I have a MS Access 2003 form with a label named 'lblTrackingHyperlinkNumber'. The label's caption is the Tracking Number from the United States Postal Service. What is the label's hyperlink ...
I have an excel spreadsheet that was created in Access and exported into Excel. I have a field in the Excel spreadsheet that contains email addresses.
Is there a simple way to change the...
Hi, I currently have Sales information stored in an Access Data table. This table has the names of all the Salesman in the field "Salesman". I want to export this data to excel on seperate s...
This should be simple, but I'm going round in circles!
We have a table (tblResults) that contains a time field (Tm) that is stored in the format dd/mm/yyyy hh:mm:ss This table also contain...
I have a problem when I am trying to display crosstab query on Access form, I send parameters as date and I suppose to populete the form with these result, but I got this error
You can't us...
Hi all,
I have a memo field that gets populated from imported Word Documents. I would like a way to strip out the special characters from the Memo field - ie Carriage Returns, Tab Mark etc....
I have an Access Form that contains a combobox (Combo0), a Textbox (Text1), and another Textbox (Text2). There is a table that has a column of cities called NAME, a column of States called ST...
How do I concatenate two fields into one text box (and table)?
me.txtIndexID.Value = "txtApplicationNumber" & "txtBldgPermitNo"
Convert VBScript to VBA - so code can be used in an access project.
Yesterday I had a problem whereby I need some vbscript code - to search text files in a given folder and sub foler for a te...
