Search results

I have the following code which won't work DoCmd.RunSQL "UPDATE Points INNER JOIN DataWater ON Points.Id = DataWater.Point_Id " & _ "SET DataWater.Locked = -1, DataWater.Passed_To_Accounts = -1, DataWater.Last_Update = Now() " & _ "WHERE...

I have the following data in a table Invoice_Number 619915233807 *619915233807 *619915233807 *100099830014 100099830014 IN065356 1215 1115 27SIN012947 200848 *27SIN010092 And I need to remove the * from all records which contain it the problem I have is that * is a wild card Does anyone have...

Here is some code I use to output a report in Snapshot format and then attach it to an e-mail DoCmd.OpenForm "Please_Wait_Message_(E-Mail)", acNormal, "", "", acReadOnly, acNormal DoCmd.RepaintObject acForm, "Please_Wait_Message_(E-Mail)" DoCmd.SetWarnings False...

Thanks for that Pat, I have it working fine, the only thing I would like to change is that if there are bad links I would rather specify the file location in code rather that the user trying to find them the 2 BE will always be located at G:\E&S\Energy\em\EM_UoM_ENData.mdb...

I have the following code for synchronising the current db Dim repMaster As New JRO.Replica repMaster.ActiveConnection = CurrentProject.Connection repMaster.Synchronize "G:\E&S\Energy\em\EM.mdb", jrSyncTypeImpExp, jrSyncModeDirect What I need to know is how do I specify the Replication master...

Thanks everyone for all your help, I have now sorted it Thanks Geoff

I have a front end which is connected to 2 BE G:\E&S\Energy\em\em.mdb G:\E&S\Energy\em\em_data.mdb the first BE is an A97 db which is actually where all the data is stored for a VB App the second BE is an A2K db where additional data is stored I currently have code which I am uble to use to...

hi, I'll be scanning via a document feeder Thanks geoff

no windows 2000

I'm missing the help file imgocxd.hlp, if anyone has it could they please download here. Thanks Geoff

Fizzio, Thanks for your reply, I managed to find the attached sample database, I have played about with and it works fine except for the fact That I can't scan more than one page at a time, any ideas you have would be appreciated Thanks Geoff

I want to scan documents into access using a button on a form, I want the document to be scanned and the file name of the file to be stored into the table record. I am using a twain compliant, hp scanjet 5400c scanner. Any help with this is appreciated Thanks Geoff

I've sorted it now the problem I was having was with long file names Thanks

thanks for your reply I had seen this but it just didn't make any sense, if you could put it in more basic terms I'd appreciate it Thanks Geoff

I have a database which is run on my local hard drive, as i am the main user and the only one who makes changes to it and can't afford for the network to go down. there is a copy of this which is stored on the network and a dozen or so people have access. What I need to do is copy the version...

Thanks I don't know whats wrong with me today, I've just gone thick Thanks Geoff

I have the following criteria in a query but can'y seem to get it right IIf([Forms]![Report_Criteria_Selection]![Type_Selection]=19,[Date_TaxPoint]) Between DateAdd("d",25,[Forms]![Report_Criteria_Selection]![Start_Date]), [Present_Date] Between...

I HAve the following code which should in turn open up a report depending on the selection made in three combo boxes but for some reason it won't work stDocName = DLookup("[Report_Name]", "Report_Config", "[Report_Group_No] = " & Forms!Report_Criteria_Selection!Group_Selection & "'" And...

I found the solution Microsoft Knowledge Base Article - 194374

I really need some help with this All my queries and reports which calculate or show a date don't work it tells me it can't find the funtion, even =Format(Date(),"Long Date") & " " & Format(Time(),"Long Time") Which I have in a report page footer won't work, I've reinstalled Access '97 but...