Search results

Hi All, I have a form with a duplicate record button to allow records to be copied. I used this code (I think from Allen Browne), but it only copies the last record in the recordset? Any ideas? Thanks If Me.Dirty Then 'Save any changes Me.Dirty = False End If If Me.NewRecord Then 'Check...

Hi All, Trying to use some code to 'Select All' from a 'Check Box Drop Down' Multi Value Field . The table field size is long integer. When trying to ‘Select All’ the code returns a RTE 3163 “This field is too small to accept the amount of data you attempted to add. Try inserting or pasting...

Hi All, I have a form which is used on its own standalone and is also used as a subform. I want to make it read only when opened as a standalone. It’s opened from a command button using DoCmd.OpenForm "frm Vendors Secondary", acNormal, , "[EquipmentIDFK]=" & EquipmentID, , acFormReadOnly...

Hi All, I have a search form which uses the Allen Browne code from here http://allenbrowne.com/ser-62.html. The data I have linked to my form which the above code is using is from an Union query and the search generates the correct results. I have used code from here...

Hi All, I want to open a report with the results from a filtered form. I want to use a similar format to the attached Allene Browne search2000 as the base to filter the records initially, but not sure how to get the filtered results into a report and the most efficient way. All help much...

Dear All, For some reason on initial opening of the main form (frmProducts), the bespoke record counter shows 1 of 1, despite there being more records? If you move to a another record the counter corrects itself and is then okay? Bizarrely, if I make the Access navigation buttons visible the...

Hi All, Have been looking at various methods using hyperlink and shell and I am a bit unsure which method or route to take. In a record, I want to have a text box which displays the file path to a .pdf or .doc, docx file. If you double click in the text box the file within the text box...

I have a label on a main form which I highlight/un-highlight to mimic the on-dirty (pencil) and on-undo (back to triangle) of the record selectors. But can’t think how to un-highlight the label background when the pencil switches back to a triangle when the autosave happens, when you move to a...

Hi All, I am running up against an error ‘Index or Primary Key Cannot Contain Null Value’. In the dialog box it doesn’t give the RTE number just the description, OK & Help buttons. After some searching the description matches RTE 3058. I have identified why it’s happening and through a...

Hi All, I have a RTE 94 happening due to a piece of code running on a subform current-event which looks at a text box on the parent form. I understand this is due to the order of loading of the forms initially and all works fine when moving to other records once all are opened. How can I...

Dear All, I have an Equipment Form with a Supplier subform. The Supplier subform also has a subform, Equipment Pricing Records. I have the ability to change the Supplier via a combo box, but Equipment Pricing Records become orphaned. What I would like to do is when a Supplier is about to...

Hi All, Can you have a saved (unsorted) query as a row source for a combo and then add some code to enable the combo to sort the list? Reason is, I want three combos to use the same query for finding records in different ways, but need the query to be saved, not a query built by the query...

Hi, Anyone got any ideas why Access says the engine doesn't recognise JunctionID as a valid field name or expression? Have tried numerous ways to re configure the srtCriteria line with no success? Thanks Dim ProductID As Integer Dim JunctionID As Integer Dim strCriteria As String...

Hi, Following pr2-eugin's comments below, I have re jigged this thread to hopefully make it a bit easier to understand. The essence of my problem is summarised in the summary directly below and the attached DB example. Main Form (Products): The user needs to choose a Product from a combo...

Dear All, I have been looking for a solution to an issue we are having. Looked at the following sites and tried a blend of them all, but with no luck. I am sure the solution is a variation of one of them or a combination...

Hi, I am trying to create some additional records in an existing Access table by copying (Ctrl C) the data from the excel rows and pasting into the table using paste append. All that is happening is Access is creating the additional auto number rows, but the data I want copied over does not...

Hi, Could someone please post a copy of the Northwind Database from Access 2003. I am trying to use some code from Allen Browne who uses this in his demo. I only have Access 2010. I can't find a copy of the 2003 version on the net. Thanks.

Hi All, Anyone got any ideas about this? Access 2010. I have a form with a duplicate record button. Sometimes when duplicating a record the duplicate is created but the form remains in edit mode (small pencil in the form margin). I also have a manual record counter on the form which...

Hello everyone, I have struggled all day with trying to find a solution to a problem I'm having with a combo box and a duplicate record command button. When using the command button, I get error 2237, "the text you entered isn't in the list". It keeps highlighting "Me.Bookmark = rs.Bookmark"...

Hi All, The code below is behind a combo box on a sub form. I need this to change some formatting on parent form when certain changes are made to records in the subform to alert the user. The code for the formatting changes is in current event of the main form, so the code below is used to...