In an Access 2003 program, I'm using the code located at http://www.mvps.org/access/api/api0001.htm to Browse for a file. This code is beyond my level of expertise, but I do have it working b...
Dear VBA expert. I have successfully opened a browser and executed a javascript function which opens a Save As dialog box with the code below. NOW I would like to be able to automate the Sav...
Hi,
I have this code which allows a user to select a CSV file to import into the database. I am a little stuck when it comes to actually getting the CSV file imported and named [tbl_temp]....
Hi
I'm not sure if I'm going about this the right way. I'm trying to update a table with values from a form. The problem I am having is that sometimes these values are empty, and sometimes ...
MS Access 2003
I'm somewhat new to VBA coding so please bear with me. The snippet I have below is supposed to create a button that will fill in fields for a table using data from another ta...
I have a report that feeds directly from a query. In the detail section of the report, I have a label ("ProdNotes") and a text box ("Comments"). The goal is to allow the user to click on "No...
I am working on a piece of code that I obtained from my last question on this site. Here is the code:
Function DateDiffs(EarlierDate As Date, LaterDate As Date, one as integer) As Long
'Ret...
I created a string
Dim strSQLdate as string
Dim dtmindate as date
strSQL = " SELECT min(date) FROM [query1]"
dtmindate = cdate(strQL)
I need to import data from an excel file into an access table. I will need to import only certain columns from the excel file, columns A C D and E, but all of the rows that have data from al...
Hi,
I have inherited some Excel Sheets and Access databases which use the BLP Add-ins to retrive data from Bloomberg.
The Access database is using the Subscribe method - example code below....
I've got a MS Access db, with one table "tblMaster" three fields: "Value","MTG", and "Equity"
The Equity field is currently empty (null). I want Access to take the {Value-MTG} and place th...
Access 2007 VBA - This is probably very simple so appolgies in advance...
I have two forms open. All I need to do is to save the current record in form1 from form 2 (which must keep the focu...
Hey EE:
I am trying to run the following VB code in MS Access and keep getting "object required" error message for my Set statements. Not sure why.
Private Sub savenote_Click()
Dim str...
Hi All,
I need to run a vbscript from MS Access 2003. I generate the script in VBA and store it in an external vbs file. I then want to run/open/launch the vbs file. (The file checks to s...
i have created the following code to automatically set up an ODBC connection in my access database. this code works great if i use the trusted connection option but when i try and give it a ge...
I have some VBA Code that goes to a specific directory, and allows the user to choose a file (excel spreadsheet) to open. I need to include in the VBA code, once the spreadsheet is open, it d...
is there a way to do an IF/else/endif statment inside of the Expression Builder?
Hi experts,
I have a query on my form that updates a field on the same form from an OnClick event in a list box. Where there is a value from the query it updates the field ok. Where there ...
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...
I am designing a Microsoft Access Database and i will like to write a VBA code to stop the security warning from poping up each time the application is loaded. i know i can set the security o...
I am using access 2003 to open a spreadsheet with 250 sheets. Splitting those sheets into single excel 2003 workbooks and adding some data validation to them via VBA.
Everything was workin...
I built an Access application that worked just fine for some time. I package the application with ms access developer extensions and include the ms access runtime version. Recently, I made a f...
I currently have code that opens and updates Oracle tables. Need to modify to update a single field for Comments into the Oracle table. I am use to DAO What is the proper syntax to set the r...
How do I concatenate two fields into one text box (and table)?
me.txtIndexID.Value = "txtApplicationNumber" & "txtBldgPermitNo"
I'm trying to do the following:
Enter your name
Enter you password
[submit]
After submission with button and authentication, populate the appropriate data based off a query on the pers...
