MV040603.CDX
MV040603.DBF
MV040603.FPT
I tried to open the above DBF file with access and I get an error saying cannot open associated xbase memo file. All the files are their. I can open it in excel, but certain fields (prob those memo fields I need) are scrambled up.
Does anyone know the...
I have a combo box on my form and when I select a record from it (employee name) it goes to matching record in subform. However, i get an error when i select an employee name with an apostrophe in it.
Syntax error, missing operator in expression.
Here is my code..it works fine with all the...
I could of sworn I posted a thank you and gave u a star. Wait I did, look above, I said thanks, it works great.
I have not used the second posting of your code. I will try and implement it when I have more time. They have me doing a million and one things all at once.
Thanks again.
I am trying to set the DTPicker control to current date.
Here is my code:
Dim CurDate as Date
CurDate = Date()
Me.DatePicker.Value = CurDat
The error I get is that the property is read only.
Something like this...
Sub ADOFromExcelToAccess()
' exports data from the active worksheet to a table in an Access database
' this procedure must be edited before use
Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
' connect to the Access database
Set cn = New...
About 5 months ago I saw an access database that showed how to add a file to the database without inflating it. Does anyone know how to do it, or possibly know what site it was located on?
I have a split database on the network, unfortunately it is too slow. Are there ways to speed up the connection??
Some users access it using WAN.
Unfortunately, they will not let me create a SQL Server Database.
What Event would I use to initialize my code right after the person changes the date in this control? I do not see a change event for this control when I look under it's properties.
I didn't think it was possible either, I really rather stay away from renaming all those controls, it makes it harder to go back and recode and errors when you lose track which field = what control.
I presume you can use TAG property and just embedded another if statement in the code? I will...
By the way this is what I have...
Function SendE-mail(controlvalue)
Dim otk As Object
Dim eml As Object
Const olMailItem = 0
Set otk = CreateObject("Outlook.Application")
Set eml = otk.CreateItem(olMailItem)
With eml
.To = controlvalue...
I want to create ONE module that I can call from the onclick event of any text box on my form that will send an e-mail to the value in the textbox.
I have 3 text controls that have different e-mail addresses.
I do not want to rewrite the code 3 times.
Is there a function that could do this...
I would like to return those records where Action = "Change Plan" for 3 months in a row (past three months) for all the users.
These are the users where we have to change their plan because it has been recommended to do so three times in a row.
One record would look like this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.