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...
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...
I'm importing an excel spreadsheet in vba code, after it imports there are tons of blank records in the table. Is there anyway possible to not import blanks?
I have a MS Access subform called "Verify". Within verify, there is a field "approved", which is a True/False field. I would like to add a combo box to filter the subform based on the field fo...
Experts,
Can you please help with the code below.
I have a query that returns the number of rows, and I want to assign that value to the variable lnCountReload.
When I try to execute,...
In an access query I would like to display only the first 20 characters of a 40 character text field. I don't want to change the size of the field in the underlying table just display the firs...
I created a string
Dim strSQLdate as string
Dim dtmindate as date
strSQL = " SELECT min(date) FROM [query1]"
dtmindate = cdate(strQL)
I'm writing a Microsoft Excel Macro that copies information from one sheet in a workbook to another and concatenates the values to create a single string. The string is then used in a batch ...
Hopefully an easy one this, believe it or not I cannot find anything that gives the solution!
I have a VBA sub that will continually check something at set times, so needs to run forever, a...
Application - Office 2003 , Platform - Windows 2003 Server. I have written a VBA macro in Excel which basically imports a (variable ) number of comma delimited text files, sorts them into alph...
Is there an easy way to compile an Access database complete with forms and macros into an executable that can be run on a windows pc that does not have Access installed on it?
I am a novice with Access, the error I get when running my iif statement is expression is too complex.
The iif statement is in a query...
thanks for any help
I have a database built in Access 2003. When I open in Access 2007 I find that I cannot export to Excel using a Macro although I have set (or think I have done it correctly) the Trust Centre ...
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 have a Private Sub named, 'cmdSave_Click()' and I want to call it from the click event of another button, say, 'cmdSave2_Click()' and this other button is on another form. Can you tell me ho...
The search key was not found in any record. (Error 3709).
I have an access database that 1 full line in a table has got corrupt and many of the fields have what looks like chinese symbols i...
I have the following Code that IS working:
Function fncBatchImport(strFolder As String) As Boolean
' function to import multiple .xls files into one table
' just make sure all fields are ...
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 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...
Hi, I have 3 queries that are doing some computations. 2 of them are SELECT queries that I'm using to store values in. When I call these queies using docmd.openquery, the SELECT query windo...
I have created a form that displays, in labels, information based upon the user's selection from a combobox and allows to edit, delete and create a new record in another form from textboxes(VB...
All I want to do is display the Record Set on screen (only if records are found) in table format or perhaps print it; which ever is easier.
However; I continually get one of these errors......
I have a small set of code which I just added a nested loop. Basically the program will loop through multiple selections and get multiple records for each selection (the nested part). I then...
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...
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...
