Search results

I'm using that module for hiding Access, but a side-effect of this is that the DB itself doesn't show up on the start bar, so if you alt-tab into something else it disappears and it's quite easy to forget you've even got it running as you can only get back to it by alt-tabbing. Is there any way...

Thanks for that, that's great. The only thing is, these listboxes have more than one field in! I need the tooltiptext to display the entire contents of that row in the listbox. EDIT - figured it out myself.

I have a series of listboxes where the data goes off to the right and out of the box (too big for the control). I'd like the user to be able to hover over the listbox and have tooltiptext come up that shows the entire value of the field. Is there any way to do this? Thx

How do you import data from excel using fields that already exist? In other words, I need Access to append the data to the records rather than try and add it to the recordset and throw a tizzy when duplicates are created. Thanks....

With the above code, is it possible to have the database visible on the taskbar? As in, Access is hidden but the database itself shows up on the taskbar?

It's an Access 2003 database which I want authenticated web users to be able to write new records to. I don't think a Data Access Page is the right way to do this, is it? If something else, e.g. ASP could someone possibly point me in the right direction with steps 1, 2 and 3 :D

How? Already had a load of requeries in the form's current event. Doesn't seem to work!

Hey all, I have a number of listboxes in a form who gather data about the main field in that form, so they are bound to queries etc. The thing is, I have a routine that allows users to create new records, and in that instance the following code runs...

Phil - thanks very much, you've sorted it! I was confusing fields and controls. I owe you one.

Tried it and it won't even let me unlock it -- "object doesn't support this property or method". Any other ideas?

Hey all, I have this code on a number of difference forms: [Forms]![Care Packs].Customer.SetFocus This is executed by an event in another form that loads the new form and starts dumping in values. For some reason I'm suddenly getting "Object doesn't support this property or method. 'Object'...

Thanks a million Shane - that's sorted it!

Dim stDocName As String Dim stLinkCriteria As String stDocName = "Logins" stLinkCriteria = "[ID]=" & "'" & Me![lstLogins] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria This code is on the doubleclick event. lstLogins is sourced from this: SELECT Logins.[ID], Logins.[Login...

Hey all, I need for a listbox to look in a folder and populate itself with all files in that folder, and then open the file the user dbl-clicks on. Does anyone have this to hand? I found a thread referencing another thread with code for listing a directory, but that thread was invalid (not...

Doesn't work :( Any other ideas?

Hello all, I have combo boxes populated with all values in a particular field, then shunt the form onto that record (standard combo box for selecting records from a list in other words). Problem is, these boxes seem to stop working if I leave the form for another and then return to it. Here's...

I have this combo box: ---------------------- Private Sub Combo33_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Customer] = '" & Me![Combo33] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark...

THanks. What do I need at the end of the above to kick the user back into the previous form? And I did search for that, but found nathing :D

I have a form tied to a query, but I want some code in the Load event that checks whether there's actually any data in the form (i.e. has the query returned matches?). Is this easy?

Thanks chaps. :)