Search results

I have an append query to a table that has an autonumber as a primary key. Usually it works fine but sometimes it gives an error message says that X records could't be appended becouse of key violation, and evry time the X recordes is different number. After 10-20 attempts the query appends all...

This is my table Date Shift Type Code -------- ----- ---- ---- 03/05/09 1 A 1 03/05/09 1 B 4 03/05/09 1 W 9 03/05/09 1 W 19 03/05/09 2 A 15 03/05/09 2 B 5 03/05/09 2 W 6 03/05/09 2 W 12 04/05/09 1 A 2 04/05/09 1 B 4 04/05/09 1 W 3 04/05/09 1 W 13 04/05/09 2 A 17 04/05/09 2 B...

Hi I tried other forms and got no help. I want to give the users to choose an e-mail address from Outlook AddressBook. This table can be linked only to the local Outlook, and when the user get the .mde the connection fails. Is there another way to do it? Or - how can i link this table...

I'm sure its a problem for a many of us, but couldnt find an answer. Try to prevent from the user to enter a wrong date like "29/02/07" and since Access knows better what it means it turns it to "07/02/29". this expression: IsDate(format("29/02/07","dd/mm/yy")) gives true. Now to the question...

Hi I have this code to build a report in Word from Access, my problem is that evry time i run it, it opens a new Word instance. Is there any way to open new Word only if it's not opened? Set qdf = CodeDb.QueryDefs("Comp") Set rst = qdf.OpenRecordset() Set objword = GetObject(""...

Hi Tried it in another forum and didn't got an answer. I'm transfering a record from Access to Word with this code: Set objword = New Word.Application Do Until rst.EOF With objword .Visible = True .Documents.Add Template:=("\\Server\a.dot") .Selection.GoTo...

Hi everyone I have a query. The parameter to this query is forms!FromName!Field that contains a number. The value is built from code. Now I want to use this query to retrieve more then a number like: 1 or 2 or 3 In this case no record is retrieved, if I take the string from the field (1 or 2...

I sent this message to couple other forums and didn't get any answer, hope to get some help here. Have a report with a listbox based on a query. When send it to Word (Publish with Word), the listBox doesn't appear. Is there a way to pass the query, or better to say, the listBox to Word...

Hi I try to send report from Access to Word. The Report has one unbound field that his row source is a crossTab query. The data from the query is shown in the Access report but not in Word. Is there any way to fix it? Thanks

Hi I used to link Oracle table manualy to Access DB, but somtimes the table becomes read only when the app is moved to another PC, so I want to refresh the link through code evry time the user open the app. My string connection : strConn = "ODBC;DSN=test;PWD=MyPass;DBA=W;" if the table...