I have 2 tables in my Access 2007 database...
"XLS USGS Roster" (local access table)
"dbo_USGSEmployees" (odbc linked SQL server table)
They basically have the same fields. I'm trying to...
I have a field in Access that contains file numbers - they are in the format xxx.yyy; however, there are random numbers of places for the "x" portion and the "y" portion. For example, one mig...
We have a table with approx 10 million rows. For non-SQL users, they do regular searches on this table through Access. So the database is on a SQL server and in Access a link to this table i...
I need to calculate two fields together that are formatted in "time". The attached code snippet is the append button code that I am trying to use to add the current stop watch value with the s...
I knew I would be back sooner or later
I have this SQL code:
SELECT manpower.FirstName, manpower.LastName, manpower.nodpnd
FROM Pepsi INNER JOIN manpower ON Pepsi.Salary = manpower.Sala...
Hi Experts,
Does a .mdb made w/access 2003 run w/ Vista 64 Bit, a client says it won't open on his Vista 64 bit pc.
I personally don't use vista, so I'm not sure if it will or not.
Thank...
I have a MS Access 2003 MDE frontend on each client and backend on a server. While updating a record from a form, I received the unrecognized database format error 3343. When this happened in ...
In a MS Access I was able to add records easy by using AddNew() and UpDate(). Can you use AddNew() and UpDate() to add a record in a database that is Excel based? If so please show code. My ...
Hi experts-
I'm building a small access program that cycles through an email list table and sends emails/attachments using the CDO Message object. A small sample of the code I wrote is below:...
Hi all.
I have an access query with the following data:
1. ItemNumber
2. TotalQuantitySold
3. FormattedDate (YYYY/MM)
4. Current (YYYY/MM)
The end user enters a parameter (Current)...
I have a form and subform.
On the subform, I am trying to get the current record number and total records for that subform to show up in a textbox- txtCount.
I am using the attached code...
I have a subform called MySubForm in a form called MyForm
MySubForm has a record source of query1
I want to change the record sorce of the subform without closing the form to query2 and ...
We are running two servers with Windows 2003 R2 SP2 using DFSr. We are replicating a large number of folders between sites. I am well aware of how DFSr replicates and the sharing violations th...
I am trying to create a txt file of the contents of memo fields.
When I use the following command in MS Access 2000 the text in memo fields appears randomly truncated.
DoCmd.OutputTo acOutpu...
I split my database, now i am testing in 2 computers, in the original computer everything is working perfect, i set the database to work in both computers, in the other, i got 1 error when i m...
Hi.
I have an application that I am planing to build it and sell it. So, I am thinking of the best DBMS that will work with. But, must be working in multi user environment, and I need it simp...
OK, I'm a bit embarrased. Despite the warnings of others here urging me to please attempt to understand the basics of database design, I chose to dive in head first.
So having finally rea...
How do I get the current date and time into a field when I click on the field - i have gone to even OnClick but what now?
I have a form that will not retain its size when opened a second time. The main form (MainForm) contains a button (edit order numbers) that opens another form (AddNewReq_AddOrders) for the us...
IIf(IsNull([Forms]![frmTestAnswers]![City])," Like *",([Forms]![frmTestAnswers]![City])) is in the Criteria of the Query. I'm trying to return ALL records in the City field if it's left blank...
I am trying to create a drop down in a form that will limit the fields based on the currently selected record. The following query lists exactly what records I need however when I try to use i...
Have used this function many times and it has worked great. I am using it just a little differently and must not be doing something right. Hope someone can see what I am doing wrong.
I have...
I have a listbox on a form I populate with the files from a selected directory.
I would like to SORT the filenames in reverse order once populated.
Possible??
Private Sub Form_Load()
...
Hey,
I have a SQL 2005 server and i have linked the tables into an Access 2003 database which I am using as a front end for this project.
Now I have some other software that works with thi...
I have an application that has been distributed to a number of users who all seem to have slight variants in operating system and MS Access and I am having ongoing trouble trying to keep the a...
