Search results

i dont know what i done clear the data compact repaired added fresh data to the test db and now works fine thanks arnelgp :D

now no syntax errors found owner_name was Owners_name on one of the tables but now its not updating it runs but not updating any off the fields also notice duplicate when run the query in datasheet mode thanks shane

missing operator on this line FROM tblMain INNER JOIN tblExcelImport ON tblMain.key1=tblExcelImport.key1

HI arnelgp , this now say's im missing operator ?? thanks shane

hi really sorry but still getting a syntax error defo doing something wrong lol [CODE]UPDATE tblMain (Room,Owner_name,Building) SELECT tblExcelImport.room, tblExcelImport.Owner_name,tblExcelImport.building, FROM tblMain INNER JOIN tblExcelImport ON tblMain.key1= tblExcelImport.key1[/CODE] the...

i used this think its right data looks good lol INSERT INTO tblMain SELECT tblExcelImport.* FROM tblMain RIGHT JOIN tblExcelImport ON tblMain.key1= tblExcelImport.key1 WHERE tblMain.key1 IS NULL; oh thanks for help much appreciated CJ only thing is aswell when i add the data to history table...

all, it really long shot can't seem find any code spinets to get me started or if its even possible. Right..... i have 3 tables Main table "Main table holds the current data " History table "history table holds old data from main table " excel Import table "temp table that holds data import...

Yeah that makes sence Cronk cheers shane

hi cronk database A holds Job card information and database B is a stock control data base its show which parts have been booked to that job card. The user using database A will not be updating database b its just for information. for database A user. see above my procedure to open DB B...

you have completely lost me Lol here is how i open database b DoCmd.RunCommand acCmdAppMinimize Dim objAdb As Object Dim appAccess As Access.Application Set appAccess = New Access.Application appAccess.OpenCurrentDatabase ("C:\Users\sspreyer\Desktop\DATABASE B.accdb") 'Optional, if App needs...

[ Yeah I understand procredure to open the dB but problem like you stated the dB is still open :/ that’s my problem wonder is there way to call say restore window database A from database b Thanks Shane

hi , currently have some code on (database A) to open a form in (database B). cant seem to work out how to return from database B to Database A without having to click the task bar to open the db window is their any way i can have some code on say database b form to return to database A ()...

finally got it lol!!!!! abit of a slow moment If FileExists(path1 & "\" & Dir(Trim(.SelectedItems.Item(1)))) Then MsgBox "already exists" Exit Sub End If FileCopy .SelectedItems(1), path1 & "\" & Dir(Trim(.SelectedItems.Item(1)))...

sorry can't see how that will help me. i'm just check if a file exists not the file i selected. E.G i select file from the picker (the path could be anywhere the user likes) i need to check the .selected (1) item is not present in the file directory path1 = "C:\Users\ss\Desktop\Test Folder" if...

hi ,all i struggling to check a directory see if a file exists current the code i have the user selects the file from the file picker it then copies the file to another folder to stop people linking it to there personal drive, but the issues is i need to check that the file they are selecting...

Thanks, Uncle Gizmo Sorry for the late reply. good news i found solution might not be neatest to some of you guru experts. This what i come up with... and it works!:D Private Sub Form_Timer() Dim MediaFormatTime As String Set MW = "YOUR CONTROLNAME".Object MediaFormatTime = Format("YOUR...

hi , all i have google' d the hell out of this haven't manage to find an answer here what i'm trying to do. i have window media player on a form i wonder if its possible at certain time say 20sec in to the video @00:00:20 call a procedure to open another form or PDF etc... just curious if...

Sorry for the late reply Thanks Pbaldy debug.print cleared the matter up. It was obvious once checking in the Immediate window it was written correctly in the first place :banghead: there wasn't anything matching the criteria because i was searching the wrong date field should of been...

I have gone down the root Cronk was saying thanks alot everyone for the help much appreciated ;)

hi , all i have check box called invoice. if the user makes invoice check true then i would like to show all the blank records with invoice date field is null If Me.[invoice] = True Then If strWhere <> vbNullString Then strWhere = strWhere & " AND " End If...