Hi experts,
I encountered the run-time error 3211:
The databse engine couldn't lock 'TempTable' because it is in use by another person or process.
Currently, I built in the function in...
Hi all,
I have a subform called frmEvents with a Main Form called frmRegistration. The subform is in datasheet view and already has a double click event to open another form and that all wo...
Hi,
I want to be able to use one field [GivenNames] and work out the employee's initials based on the data input into field [GivenNames), eg [GivenNames].value = David Micheal Anthony, ther...
I'm using Access VBA to open an Word document (doc1), copy the entire words, and paste into another Word document (doc2). Then close doc1 and save doc2 into the local drive.
My problem is I...
I want to import information from a textfile. I wanted to see how I can setup the specification name (schema.ini) to import the file correctly. Below you will see a sample of how the data I wa...
I have a form with a list box that populates from a query when the form opens. On the form, I have several controls (combo boxes, text boxes) to filter the list by several of the fields. I'm...
I am not a beginner with Access, but I am a beginner when it comes to VBA code. I learn code as I need it and I am normally successful finding what I need on tech boards. I am on my 3rd day of...
Hello,
I would like to run a macro based on the results of a query The query I run will give me a date. If that date is equal to today then I want to run the macro, otherwise not. In the con...
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 ...
I have to insert a table in the body of an Outlook 2003 email with vba. The table will use an MS Access query for data. Can anyone please help with the relevent code.
Thanks in advance...
I am using a subform which I bound to an SQL string to display a filtered datasheet of records for a specific client. I am using the code shown below to bound the form to the SQL. The tbl-pe...
Hi I have developed a simple function that work perfectly with Access-Outlook 2000, but not with Access 2000-Outlook 2003.
It does everything but does not embed the image I would insert in pr...
Ever wondered if it can be done? It can.
The idea came one day where I wondered why SQL Server presents a time resolution of 3 ms while Access/VBA/JET only offers 1000 ms, both using the sa...
How do you calculate a field based on the results of an "autoincrement" field
I want to auto calculate a field using the character "X" plus the value of ID (autoincrement)
Hello experts, I've created a VBA function (below) that is giving me a complie error "sub or function is not defined". Could someone tell me where I might be going wrong or suggest a better wa...
Hi,
Does anyone have a simple syntax for the DoCmd.OpenReport VBA command? Ive looked online but most have very complicated long syntax's and I have not been able to adapt it very well.
...
I get invalid use of null error on this line t = rs.Fields(ast).Value
The field can be null or contain text. any idea how to get around this.
Hi Experts,
I've picked up some code (originally for excel) to zip a file. I'm attempting to create a procedure that will copy some tables into a new mdb file and then zip and email it. I...
Hi,
I have a login form which ends with the following code:
If CurUserSecurityLevel > 3 Then
'This is where my Ribbon call would go
Else
'And here
End If
I'm tryng to call ...
Hello Everyone,
I recently wrote a code that loops though a report and sends each individual report to a printer. The printer realizes that each report is its own entity, but it will not ...
Please help me identify the error in the attached snippet.
When I split the original DoCmd with a IF/ELSE, I get an error on the new (longer) line.
A "Enter Parameter" dialog pops up, asking...
Ive tried another solution on this site but it causes my database to get the error message that says the system has encountered an error and needs to close. I want to force the user to use th...
I have a multi-tab form with several pages. In every page I have a button which I am trying to assing an onclick event procedure at runtime. For the name of the buttons I established a naming ...
trying to run these two strings but its not working
Dim varConsumeDate As String
Dim varChargeCodeID As Integer
sqlStrConsumeDate = "UPDATE [" & varTmpTableName1 & "] SET [Consumed...
I have attached a file (Excel). This is a sample file of an regular download from SAP. I run that Job on a daily base and save the results as an .xls file, but the Data is almost like "throw...
