I have to process zipcodes in large numbers. I use Access to get a count of the number of people per zipcode. I only need the first three digits of the zipcode. A friend who works with Orac...
Run-time error '3051': The Microsoft Jet database engine cannot open the file C:\Program Files\MBRMS\xxfile.mdb. It is already opened exclusively by another user or you need permission to vie...
ERROR: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
I have a service tracking DB which is divi...
Access 2003 vb
What I need:
In the code below I need to check for lengh of cArr(x)
if it is 3 or less goto Next
Do Until rsCust.EOF
i = 0
If rsCust("fldDescription")....
I need a way to display the images that are stored in an ImageList on my form. The ImageList absolutely must be populated at run-time.
One of the ways I have tried to do this is to create a...
I am running Win XP Pro with IIS5.
I have a ASP shopping cart setup (or not) and when i try to write information to the access database i get the following error.
Error Type:
Microsoft ...
I have a form that has several text boxes and combo boxes on it. There are 2 buttons on the form - the first one stores the field data in a table. The second one I have not completed yet & n...
Hi everybody,
that might be a newbie question but I am simply not able to
find the solution ...
What I want to do is to create a piece of VBA code which
uses GetObject to start and instancia...
Hi,
there is one MDE file, but unfortunatly we lost the original MDB file. is there any method to open an MDE file?? please help
I am using this :
-----------------------------------------------------------------------------------------------------
Set MyLogin = Server.CreateObject("ADODB.Connection")
ConnStr = "DRIV...
I have to calculate the average cost of a particular item
When the user open the form "buy" it opens on a particular item. On the form I have calculated field that calculates the average co...
Hi,
I get this message a lot in Access because I use hyperlinks. Is there a way to disable it? Thanks.
David
hi experts,
I am creating a table from C#, asp.net .This is my code:
DbOpen();
string strStatement = "CREATE TABLE MyNewName(PersonID COUNTER PRIMARY KEY, FirstN...
I built a DB that has a form used to input data. The fields on the form are not bound to any tables. I am creating code to capture the data from the form and upload it to a table. Below is ...
The following VBA code creates a new field that is a counter for the number of times an ID appears in a table:
Modifications on the following "While" loop in VBA are appreciated:
Do Whi...
What is the maximum amount of characters for a memo datatype on an Access Database?
This is a "Just For Fun" type of a database. If it works, then I am sure it will be something that is very useful to my fellow co-workers.
At the Chemical Depot we work the Dupont Shift Wo...
Hey folks,
Im working on a dynamic website using asp and ms access . in the database I created I have a field in one of the tables with the data type date/time and the. I want the date in ...
I have packaged my progamme with Microsoft Office Access Developers Extensions. When opened by the user a message appears that the "project contains missing or broken reference to the file mso...
I'm kinda new to forms in Access, so I need a little help here.
I have a form called [frmOpenCompany] that is used to select a company to edit. On this form there is a combobox with multis...
what command code do I use to copy a file from one directory into another
COPY SOURCE into DESTINATION
Is easy way to import a excel file to Access 2003 table instead of right click in table -> import-> select excel file -> choose the fileds and name -> choose table.
I have a .ldb file that cannot be deleted. It says that
it is open by another user and it lists my workstation.
It is not opened by anyone.
Need assistance to get rid of it.
Hi,
I have this question regarding autoincrement. I know Access already has an autoincrement option for a number field but the problem is that if I delete a record then when you add another...
I use the TransferSpreadsheet method to export Access data to an Excel Template file (.xlt) worksheet called 'DataSheet': Cmd.TransferSpreadsheet acExport, , "qry1ForTandI_FormExportToExcel", ...
