Search results

What is the actual error message? Edit : ignore the above, somehow managed to miss where you posted the error message. Try this anyway: MyRecordset.Open MySQL, CurrentProject.Connection

The best way (I personally think) to learn is trial and error, not someone doing the work for you. I haven't personally used the code before so can't offer as much help I'm sure others can do here. But looking at the code you can see similaries right away. strFolder = TrailingSlash(strFolder)...

http://www.allenbrowne.com/ser-59.html

Unless you upload a version compatible with Access 2007 I can't check the database. Someone else will help I'm sure.

What version of Access are you using? I can't open the database in A2007.

This thread might be some use to you regarding this: http://www.access-programmers.co.uk/forums/showthread.php?t=148802

I'm confused over what you want, can you take a screenshot to show which part?

UPDATE Ports SET Ports.STATUS = "Working" WHERE ((Ports.PORT) = (Customer_ID.Port)) It will be something like this.

It's just a simple update query. Add the appropriate fields / tables in the update query, check the two fields for matching values in the criteria then in the update to under status put "working".

http://support.microsoft.com/?kbid=839371

It should be only the current database.

I'm not sure about Access 2010 bit in 2007 this is how I have done it before: http://www.pcreview.co.uk/forums/startup-want-only-show-main-form-and-not-ms-acces-t3483208.html

You need to add validation to the buttons eg. If you're on the last record the next record should go back to the start. Or just do nothing as you said. I can't really help without seeing your button code.

Probably wont affect it but I would of wrote it like: DoCmd.SearchForRecord acDataForm, "frm1", acFirst, "[Names] = ""John"

Oh, I thought you needed help too, was going to describe how I would solve your problem myself. LookingforK there should be enough here to accomplish what you want, need further help just ask here.

What's your objective? It depends on what you are trying to do.

Not sure if CurrentProject.Name will work or not.

Where are you closing the workbooks? I'm probably wrong but I thought you can only check the active workbook, if you have more than one, you close the active workbook and check again.

1: Would need to see your code for this, you probably didn't select the one record. 2: Again need to see you code I have no clue what it's doing but you must have asked for an input from the user. 3: DoCmd.OpenForm "your form name here" 4: method depends on your version of access eg. 2003, 2007...

Re: Opening xls in 2007 with Access 2003. (computer is installed with both xls 03 & 0 Not sure if this will help: http://windows.microsoft.com/en-GB/windows-vista/Change-the-program-that-opens-a-type-of-file You could just uninstall 2003?