Search results

I have the following code: [Forms]!components.[Serial Number] = [Forms]![serials]![Serial Number] and get the attached error when it runs. Why? The error is totally useless. I've checked my control names and everything is fine.

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

I have a listbox that uses a query to reference a value in the current form. The problem is for some reason Access is trying to fill this listbox before even showing the form, so I get prompted to manually enter the query criteria when it should be picking it up from the form. This is bizarre...

I have a form that opened perfectly before from a click event with a standard link criteria lookup function, and...it's suddenly stopped working! Before the form opens I get a small query box asking: Forms!support!fault ref In other words it's asking me to enter the value it should've got from...

If you have a fairly complex web of forms with functions going on all over the place, can the upsizing wizard redirect all the queries and control sources? Is it possible to continue using the same VBA front end with a database that's been migrated to SQL Server?

I have listboxes sourced from a table with string entries that are 255 chars long, and I've found that if the entry contains a carriage return then it can't open the form with the listbox. stLinkCriteria = "[Note]=" & "'" & Me![lstNotes] & "'" DoCmd.Close DoCmd.OpenForm "Notes", ...

I have the following code: Asset = DLookup("[Serial Number]", "Serials", "[Serial Number]=" & "'" & Me![Serial Number] & "'") ...but the problem with this is it finds a match even based on partial data. E.G. if I have a serial number CK99901, and someone enters CK999... then the above...

Better still, any way of inversely numbering them from top to bottom?

Is there an easy way to have Access format all values in a particular field with the hyperlink data type to add the mailto: prefix so you can just click on the links to email someone?

I have an 'associated' button on one form that jumps to another form and shows the associated record via the common field. However, that data may not necessarily be there - in other words, it'll be in the first form but the matching data may not be present in the other form, meaning it opens...

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...

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....

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

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...

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'...

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...

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...