My old employer built a slick little tool that built an ODBC connect string in Access and then used that string to connect the Access front-end to a SQL Server backend. I know he used some op...
Is it possible from within a query to call a function or a sub that would return several values into multiple columns.
I only want to call the query and function/sub once. but the results ar...
I'm sure I did a terrible job describing my question and hopefully I can do a better job here.
I have a query (final query) that is the result of several other queries. There is a unique fi...
I want to generate a report from the database in Access by writing some VBA code.
I will have a Form containing a text box where I can enter the ID, and by clicking "Enter" the system will ge...
OKay.. so I'm using VBA automation from an Access script to generate an outlook e-mail. However, I'd like to embed images in the email... (not as an attachment) (CID?)
Now I thought that i...
I have a tblMain that has a 1-to-Many relationship with 2 other tables, tblNotes & tblBills, related thru tblMain's PK 'MainID'. I have a Microsoft Access Form whose first tab is getting data ...
Hello Everyone,
I am trying to write a code that will import an excel file with multiple worksheets called "Planogram_Data" which resides in "C:\Super_Import\Planogram_Data.xls". I would l...
Well, what is the Modulus operator in MS Access? I need to know this so that I can use this function for a programming thing I have to do. Thanks!
The field contains characters that I think are carriage returns. The character looks like a square. I cannot do a Find and Replace. I'm able to highlight and copy the character into notepad...
This works
CurrentDb.Execute "CREATE TABLE MyTable ([FindText] TEXT, [ReplaceText] TEXT, [WholeWord] TEXT);"
strQuery = "SELECT * FROM MyTable"
Set rstMyTable = CurrentDb.OpenRecordse...
Hi Experts,
In my current procedures, I will pop up a form using DoCmd.OpenForm "FormName". This form constitutes several text boxes that I need the user to fill in the required information...
User needs option of inputing a Canadian postal code or US zip code in the postal code field. The mask must allow either type of code but prevent any errors. Application is for small busines...
I am looking to be able to export from Access to and Excel template using VBA. I have read where you can't format an Excel file on export from access, but I thought maybe if I designed a temp...
In Access 2000 I used to enter a line
Set Warnings Off
(or something)
How do I do this in Access 2007
Thanks
Paul
This is a method that was working fine about two weeks ago and havent touched it since, now when i was entering info for an employee and went to save and add new i receive this error message. ...
I have a query that need to be exported on Pivot Table for Analysis proposes.
The required pivot wanted is called "finalpivot.jpg"
I just got an error, "see runtime-jpg"
the code below only...
Hi everyone:
I am trying to add an option to my Access 2000 application that will allow the end user to click a command button that would open up an InputBox so that they could type in an e...
I am trying to check if data is present in a specific table using vba. So far i have this line of code written but when i try to run it i get "invalid operation"
If CurrentDb.TableDefs("myT...
I need to change the field names in a number of MS Access tables to standard field names than I have defined.
I have attached the code I was trying to use.
The line: Set tdef = Current...
Hi All,
I hope this is clear enough for someone to understand because I am at a standstill without help.
I have inherited an Access 2000 "app" that is the front-end to a SQL 2000 databas...
There are many threads on this, but after spending over 1/2 hour trying to find something that works - I need to move on.
I 'm attaching the code snippet that I'm using (on a command button...
Hi
is it possible to add parameters to a query ?
docmd.openquery(testquery)
and then some how add a starting date or other data to the query
Hi, I have an Access DB that contains a list of individuals (agents). I also have a folder that contains Excel Spreadsheets with a file name exactly the same as the agent name in the Access D...
I am in MS ACCESS 2003. I'm making a Make-Table Query where it outputs to another database. When it's done compiling, it again "prompts" me to say 'yes' or 'no' saying that it is about to p...
Hi Experts,
I have installed Oracle Client and have been able to import oracle tables from our enterprise database.
How do I write an automation script to import Oracle table into the Acce...
