I need to reset the AutoNumber Key in the table, please is there a way to do that???
I have a linked MySql table in my access database. The access database stores russian strings but it appears ok. I think it uses unicode to store them. However, the mysql database stores the d...
Hi,
I'm trying to create a form so that we will be able to select specific information from our tables when we want it. It seems like this should be really easy. I know of a simple way to q...
I get an error -2147217900 (80040e14) run-time error. The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relat...
Does anyone know of a way to automate sending messages from Access 2000 via Outlook EXPRESS, similar to the following in Outlook?:
Dim strRecipient As String
Dim strSubject As Stri...
When I run
DoCmd.OpenQuery "q520S1C3_b"
it works fine; but when I run
CurrentDb.Execute "q520S1C3_b", dbFailOnError + dbSeeChanges
I get this error: Run-Time Error 3061 (Too fe...
I have a query in MS Access querying Linked tables returning data as follows:
Query 1:
Col1 Col2 Col3 Col4
AA 1/2/08 AA Title1
AA 1/2/08 AA Title2
AA 1/2...
I have the following:
=IF(DATE="","OK",
IF(DATE<25,"MONDAY"
,IF(DATE<35,"TUESDAY",
IF(DATE<45,"WEDNESDAY
",IF(DATE<75,"THURSDAY"
,IF(DATE<88,"FRIDAY"
,IF(DATE<92,"SATURDAY"
,"WEEKE...
I am running Windows 2000 and Access 2000. I have built a database that resides on a shared location on a novell server. For some users, the database runs as efficiently for them as it does ...
Hello,
I have a function where a query is exported by a user but one of the fields is a memo field and only the first 255 chars are making it into the Excel document. I am just using the st...
I am trying to run a pass-through query in access with a variable that a user enters in a form. I can't seem to get this to work. Can somebody please help? The variable should be where the 121...
There seems to be no default way to not display any ribbon (you can hide all except the home ribbon using the access options) in Access 2007.
I don't have the time just now to learn how t...
I want to copy all the data in a sql server table to an access table. i can do it using a recordset, loop thru it and insert the records in access table, but it takes time, i want to do it fas...
I'm trying to use a date picker on an Access Form. The problem is that this control ("Microsoft Date & Time Picker") is not in the controls list. I'm using Access 2003.
Can anyone tell me w...
I have 6 excel files, that are in the same format, that I have to import into Access each month. Can I write a macro to import all of the files into Access as individual tables or even as a m...
Hello ~
I'm receiving run-time error: 3027 - Cannot update: Database or object is read-only on line 122 of the attached code: "rs3.Edit", attempting to edit a record in rs3. (marked: '<<...
tblScrapTickets:
ScrapTicketID, AutoNumber, Primary Key
ScrapTicketActivityType (linked to an ActivityType table)
ScrapTicketDate
ScrapTicketShiftNum
tblParts
PartID, PK, AutoNumber
P...
Hi,
I asked this question previously and the solutions did not help. I really need an answer on this. I have a database with many queries that provide counts on responses. I need to put th...
Experts, please don't answer this Q, this is being posted as a general tutorial question, but please feel free to add your comments and suggest any additions!
Q. We want to create a form fo...
I was just able to successfully add an appointment from access to outlook using the general instructions here:
http://www.access-programmers.co.uk/forums/showthread.php?t=31517
However, ...
I have a table containing a lot of text, contained within the text is ASCII coding, I am looking for a way to update the ASCII code to its string value
E.g. change [ to [
Hello -
I am trying to open an ADO recordset using a parameter query and am having problems getting it to work. At this point, it is becoming apparent to me that I need another set of eyes t...
I'm getting:
"microsoft access cannot open this file. This file is located outside your intranet or on an untrusted site."
Sure enought, the file is out on a shared drive, but How do I make...
I have 2 databases; one called Employee1 and the other Employee2.
They both contain the same fields: FirstName, LastName, EmailAddress, and Center
The same record might exist in both databas...
I would like to take all the values of one field and combine them with all the values in another fields into a third field in a Microsoft Access table:
Field 1 Field 2 F...
