I'm creating my database form so it automatically opens and disables in all the 'usual' access controls from the user.
I use the center-form property in the access window, however it doesn'...
I am looking for a way to pass a password ("XXX") programmatically from a password-protected back-end database (ClientData.mdb) to the front-end database (FrontEnd.mde) when linking tables pro...
Easy question
I want to know how to refer to a table field.
I have tried on my own for a good hour now and unfortunately cant figure it out myself!
what I want is to find the value in...
I'd like a control button on my form to close all open forms.
It is possible?
Dear Experts,
when I open an Access 2003 database in Access 2007 and tell Access to hide the navigation pane (see attached file), the pane keeps reappearing everytime I open the Access appl...
I have two tables, however, there is no relationship between them and there is no common field.I would like to merge these two tables. for example first table might have 2 records and the seco...
When coding in VBA (Specifically MS Access 2007) how can I get a list of a folder's security permissions, specifically what users/groups have access to them?
I have a combo box that I would like to access the users' selection and set it to the variable TblSelect as I have attempted below. The combo box that I want to get the selection from is call...
I've set up a VPN and created a mapped drive P:\ where I put the Design Master file for my database. I have computers at several locations throughout New Orleans that have indepdent local ver...
I am getting this error when I try to create an Excel spreadsheet through VBA. The code is:
Set wbXL = GetObject("file.xls")
This had been working in the past but I have been getting this ...
I have a worksheet filled with rows of data. My problem is that I wish to delete only those rows that are completely blank, say for esample I have a worksheet having data from A1:Z1 to A16636:...
Hi!!!
I've been searching this site for about 3 days now trying to get my problem solved. Here's the situation: I have a combo box that I want to populate 2 other text boxes. I got the c...
Hello, I am trying to create a named range in a dynamically created excel document that is created from some VBA that is kicked off through an MS Access 2003 db. Here is the code I am using. ...
I currently have an access 2003 database that automatically creates an email in outlook 2003 using the .htmlbody body function. I have figured out how to format and insert data using html cod...
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 this code which allows a user to select a CSV file to import into the database. I am a little stuck when it comes to actually getting the CSV file imported and named [tbl_temp]....
From a previous question (Relink access table), I received the code below where 2 functions are missing.
ahtAddFilerItem and ahtCommonFileOpenSave
Where can I find the code for those fun...
I'm trying to create a table using the attached VBA code. However, when I try to execute it I get the following error
run-time error
-2147217859 (80040e3d)
The error occurs at line 30 ...
Here's my scenario:
I've created a make-table query that exports a table from one database to another. I've attached this query to a button, and I would like to be able to check if the ext...
How do I get the selected index of a listbox?
I have an Access aplication that was written using Access 2000. There is a billing module in ths application that uses vba code to merge data in a table to a Word document. This billing module...
PIPE INVENTORY TABLE
===================
Pipe ID
ASL #
...Other Pipe ID Details
Two peices of Pipe are welded together and the information is stored....
DOUBLE JOINT TABLE
=========...
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,
As the final command in a For-Next loop I want to export the table I've just made into Excel (and thus export a series of tables into the same Excel file as the loop prgresses).
How...
I have a table where I want to concantenate multiple fields and separate each of them by a comma. The only issue is that some rows have for example 3 fields, and some have 5. See example bel...
