Near the end you'll see >>>>> It's happening here <<<<<<< what I'm trying to do is check to see if there are any records returned from the sql if so step into the IF statement and produce a...
How do I create a variable in an Excel Macro referencing a certain cell A1 and then use it in a concatanate statement. I have the following concatenate statement and need to add the variable...
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 ...
I have a Access database that was designed and developed to be deployed in Access 2003, in the interim the client has made a policy change to Office 2007. After sorting out numerous macro err...
I need to have a function that will allow me to use lists of tables and ODBC entries to allow VBA driven linking of tables. The ODBC entries will be created before the code is executed.
I h...
Hello,
I am trying to find some completed excel VBA code or a macro that allows me to specify a directory and automatically generates a list in Excel of the folders, subfolders and files - ...
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 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 use sendobject (acSendNoObject) with no problem in an Access 2007 DB. I am now attempting to email a report using sendobject (acReport). Each time I attempt to run the code from a button i...
Hello,
I've recently parsed 50k txt files (via cmd line script) then imported into an Access Table. I am attempting to clean the "Size" field, it contains a number stored as a string. There...
is there a way in VBA to make a query datasheet scroll to the bottom when it loads? The only thing I'm finding with jumping to the last record is that it is hidden behing the record selector ...
I would like to have a custom toolbar appear on all my access reports that displays a print button and a save as button, is this possible, if so how can I go about implementing this, I am far ...
Has anyone seen a 3rd. party Access ODBC Driver for 64 bit Windows Server 2008 somewhere?
What are the alternatives.
(preferable simpel implemented)
How do I tell Access to show a form in Access 2007 while in tab view? I've tried form.setfocus with no results.
To be specific, this problem invloves 3 forms... You click a button on th...
Hi,
I have used the attached code to add an outlook appointment from Access to outlook and it's working nicely, but I want to assign the appointment to different employees who are involved. ...
This works
CurrentDb.Execute "CREATE TABLE MyTable ([FindText] TEXT, [ReplaceText] TEXT, [WholeWord] TEXT);"
strQuery = "SELECT * FROM MyTable"
Set rstMyTable = CurrentDb.OpenRecordse...
I have created a recordset using three tables and criteria received from user input on a form. I would like to be able to view the recordset in a datasheet. How do I create a view for this r...
i have a similar question open but am hoping an updated question will help as i have spent some time on this, i created a Questionnarie using a word form check boxes drop down list and text bo...
I am getting a write conflict error on one of my forms. I think I know the reason why, I just don't know how to fix it.
On my main form, I do a "Select * FROM TableName" query...
There is ...
Dear Experts,
when I open an Access 2003 database in Access 2007 and tell Access to hide the navigation pane (see attached file), the pane keeps reappearing everytime I open the Access appl...
Hi
I'm setting up an Access DB for easy distribution to my colleagues. Trying to avoid having to setup the DSNs and the linked tables over and over again.
Have a good script which sets u...
Hello Experts,
I think there is a straight-forward solution to this, but I am struggling with it.
I have a query (qryConvertProdNum) that returns the following fields
Product, Old...
I am trying to COPY & PASTE a file from one directory to another directory. Source file is defined by the user and the destination folder is auto created. See below...
STEP 1: I am creatin...
Hi
I have two variables oTable, oField and oID
How do I write VBA code to find the record containing oID for field oField intable oTable
and open the table with that record selected
...
I currently run a custom operations database on MS-Access. We have upgraded recently to Access 2007.
There are several reports that we need to send to clients via email - invoices, receipts...
