Search results

sSQL = "SELECT B.BookID, B.BookTitle, B.Book.SubTitle, C.CategoryName, R.FirstName, R.LastName, " _ & "P.PublisherName, B.DateSent, B.DateReceived, B.DateRequested, B.DateReturned, " _ & "B.JournalMonth, B.Reviewed FROM Books AS B " _ & "INNER JOIN Category AS C ON...

Have a combo box at the top of a form with a whole lot of items loaded to it from an access file. What I want to happen is the program user selects an item from the combo box, which then leads to a record read and population of other objects on the form. So far so good, can get that to happen...

Wondering if you can have multiple selection criteria in a .find method sArrayNames = Split(cboReviewer.Text, ", ") sName = sArrayNames(0) fName = sArrayNames(1) ' With pobjADOtable .MoveFirst .Find ("FirstName='" & fName & "' and LastName='" & sName & "'")...

Not sure if this isn't already available, but have a whole bunch of old tutorials and code snippets I built up while doing a complex app a few years ago. Published them on a now defunct Aussie vb site. Will be implementing some of them in an app I am currently writing (vb6), so thought it might...

Have been googling all week and simply cannot come up with anything decent. A couple of commercial products but that's about it :( After some software with an ACP, ability to handle images, and hopefully not encoded as no doubt will want to mod it somewhat.

Excitment has reached epidemic levels in New Zealand with 3rd/4th play off tickets sold out. Just thought I would get that one in before the Aussies bring it up ;)

Been on a bit of a splurge over lunchtime as one of the local shops was having a sale, picked up. The Host (Korean monster movie). Ring 0: Birthday (Alrighty, been meaning to round out me ring cycle). Pulse (J-Horror original about emos apparently). The Simpsons Season 8. Life on Mars...

vb6 connecting via ADO to a DNS reference to a MS Access 2003 database Private Sub cboCategory_Click() ' With pobjADOtable .MoveFirst .Find ("CategoryName=" & cboCategory.Text) If .EOF Then MsgText = "Error on Database Table" & vbCrLf _...

Have a project that basically uses some SQL to extract data from an Access 2003 db file and then present it in a vb6 from. Everything works fine except for a memo field which refuses to show anything? Anyone know of any gotchas with access memo fields? Am trying to load the memo data into a...

Anyone know of a quick way to determine which version an individual PC is running? Have decided this is an issue with one of our apps that works on one PC but not on another.

Okay trying to get at an mdb that I have copied from the live network drive onto my own machine. Each time I try and look at a table in design or data mode it keeps trying to locate the table on the network drive. How do I tell access to look at the copy on local drive? Using version 2003, and...

Vaguely remember in vb5 you had something like "app.path" which gave you the location of the vb program, is there something similar available in MS Access to locate the mdb from the current position? Hope that makes some sort of sense.

Hopefully this is pretty simple. Have an existing app. When I open it from within Access the app seems to go into some runtime mode ... shows a splash screen, menus, etc. Okay how do I go into design mode so I can modify it ? Yeap am a complete newbie with Access and haven't touch since the...

Environment WInXP Pro SP1, MS Access 2003, existing access project that fires on another PC with similar setup. Just installed MS Access 2003 to my own PC. When I try and open an existing project am being informed I need to upgrade jet 4.0 to service pack 8. When I try and install jet SP8...