Search results

Yeah, fair point. Its just one record, the current record. THanks

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, Thanks for the help. With a bit of tweaking got the code below to work. Regards Mark Private Sub cmdSelectAll_Click() Dim SelVals(), i ReDim SelVals(0 To lkupAssignedTo.ListCount - 1) For i = 0 To lkupAssignedTo.ListCount - 1 SelVals(i) = CLng(lkupAssignedTo.Column(0, i)) Next i...

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

Ahhhhhh!!! Thank you, thank you

Hi, Thanks for that. However it falls over at the line in the attached file? Does this suggest the recordset doesn't exist as the code would normally expect to see it? Is the filtered recordset not stored in the same way, therefore the export code doesn't recognise it? I don't have...

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, Actually, searching for strWhere has pulled up some code which seems to work for what I want. Didn't know how to pass the filter to the report. DoCmd.OpenReport "rptReport1", acViewPreview, , Me.Filter Thanks for taking the time to help. Regards Mark

Apologies meant to attach!!

Okay, not entirely with you, but have had an attempt. I have created a qryDynamicSearch which I can get to launch frm the form filter button and show the records, but they are not limiting to constraints set by the forms filter, just shows all records. There is a srtWhere string which holds...

Hi, Bear with me on this, reports are not my strongest point. When you say 'same as the forms record source', which is the Client table and not filtered. Once I apply the filter in the form I want to launch a report and see only the filtered records. I have tried to create a query with...

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

Thank you both, I just tried to get Me.NavigationButtons.Visible = False to work utill I read your new posts Me.NavigationButtons = False has done the job. Didn't actually know you could hide the nav buttons that way (should of thought, still learning). Regards

Downloaded the DB, but no change, still shows 1 of 1 on first opening?

No luck with the above. Still the same?

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

I can't believe I didn't spot that, what a fool!! Thanks pr2-eugin

Hi, Have found this. http://bytes.com/topic/access/insights/741095-how-programmatically-create-hyperlink-form Have tried to get this to work but errors out giving; Run-time error ‘-2147467259 (80004005)’: Method 'FileDialog' of object '_Application' failed With...

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