Can I convert a text value to appear numeric in a query? I then need to use the query value as a child linking value in a subform where the matching parent value already is numeric. The chi...
The Microsoft Jet database engine could not find the object activedir_20071113.txt.
Command it is getting the error on:
DoCmd.TransferText acExportDelim, "ActiveDirectory Export Specificat...
I am populating a workbook in Excel and drawing 30 or so graphs via Access.
Everything is working fine except I get an error exactly EVERY OTHER time I run the function. 438 "object variabl...
How to get the MSACCESS.EXE path?
I have created a macro that sends information from my access database in the form of excel spreadsheets to users. However, I would like to be able to send just the entry that is being viewed ...
I am using msaccess 2007 and I want to hide my tables and forms and queries from users. I also want a form to pop up when they initialize the application. I did it with ms access 2003 but with...
I have a super simple database (ID, date, name, comment) and I have created all the views and displays I need except one. I need to put the data into a monthly calendar format. Very similar ...
good day!
On a form, I would like to check to make sure that an entered value IS NOT in another table. What is a good way to do that? I tried to use the validation rule under properties, b...
I am trying to split a tabe in access 2007 and I get an error message saying "File sahring lock count exceeded. Increase MaxLocksPerFile registry entry". My question is how do I do this.
I have a table full of strings i.e. RGB(255,0,0)
which when I use them in
Me(fLineNo).BorderColor = rgbcolor
which I get
Me(fLineNo).BorderColor = "RGB(255,0,0)"
when i need just
Me(fLi...
I have a legacy Access 2003 application that I'm trying to run on a Vista PC that has both Office 2003 and Office 2007 installed on it. Everytime I alternate between one of the versions of Acc...
I am using access 97 to create a csv text file from a table using the following function:
Private Sub NewDD_Click()
Dim FileName As String
FileName = "C:\database\DDNewInstructions.tx...
In vb, I am creating an access db table and I would like to be able to specify an "identity" column like I do for table creation in SQL Server
In SQL server, I can use the syntax:
index...
I want to compare the data in similar tables in different databases, but within Access. I don't have a .NET development system here, only MS Access. I could easily compare two tables within th...
When we have more than one application open. Using code, I want to
SendKeys "{Alt + Tab}" to debug.print the name of the application it is currently on. And then loop through using SendKey...
Is it possible to pass a variable value from Access to Excel? I have a
function already written in VBA in MS Access. I want to execute the function
from Excel and pass the result to Excel.
I open a modal form to populate a field in another form. It works well. I want to go backwards and append the data in the field in the main form to the field for the modal form. How do I?
I am trying to change the recordsource of a subreport through code but cannot get the syntax corrent.
Here is the code I am using:
Private Sub Report_Open(Cancel As Integer)
Selec...
Hi
A quick Access VBA question. Firstly Im programming a fundraising/contacts database using Access 2003 SP2. My database has 3 forms:
Switchboard Form
Contacts Form
Financial Sub for...
For MS Access 2002, what is the cleanest way to lock a 'record' in a table without doing a recordset using VB for a multi-user environment ?
Also, in the instance where I have a one to x (o...
Hi all,
The only way I can access data is via the website due to some restriction in my company. Eg DATA.XLS
I have linked my access database tabe to DATA.XLS. I have another workbook eg...
Similar to:
Public Property Get wb() As Workbook
'global workbook variable
Static swb As Workbook
If swb Is Nothing Then Set swb = ThisWorkbook
Set wb = swb
End Propert...
I have a weird problem. I use the following code to change the port to which a particular printer is attached:
Private Type PORT_INFO_1
pPortName As String
End Type
...
Hi guys 'n gals,
Friend of mine is having some VBA problems, she has a nice little program, which she's just about finished, but now run into a wall. Basically, one form (out of all the one...
Hi All,
I was installing an application on a 2003 TS SP1 and picked the the wrong setup.exe from the CD when browsing through add/remove programmes in control panel.
Basically it tried ...
