Search results

Private Sub SearchBox_AfterUpdate() DoCmd.Requery Me.RecordsetClone.FindFirst " CompanyName = '" & Me.SearchBox.Column(1) & "'" Me.RecordsetClone.FindFirst " FirstName = '" & Me.SearchBox.Column(2) & "'" Me.RecordsetClone.FindFirst " LastName = '" & Me.SearchBox.Column(3) & "'"...

Ah thankyou. It is access showing a failing condition, basically my list is full of contact details... and though we mainly work with companies, we do deal with some single people, so it's not abnormal for a contact to not have a company name. It's bad data entry when some of them don't even...

Basically if there isn't a "company name" it will error "Could not locate []"

I keep erroring around this piece of code: DoCmd.Requery Me.RecordsetClone.FindFirst " CompanyName = '" & Me.SearchBox & "'" If Not Me.RecordsetClone.NoMatch Then Me.Bookmark = Me.RecordsetClone.Bookmark Else MsgBox "Could not locate [" & Me![SearchBox] & "]" End If End Sub I have been...

A list box uses the query "Query1" to list data filtered through a search bar, below it is a group of text boxes with the same fields as the query, they are also sourced from the same query. The idea is to click on the list box when the search has been filtered and it will fill in the boxes...

:) I can't take credit, I've seen it been used many times before... I just cant seem to refer to the right control to use it properly.

In Short: How do I refer to a listbox instead of a textbox on the same form? In detail: On the form: "Search" There is a listbox names: QuickSearch which is linked to "Query1" Below which there is a bunch of text boxes relating to the same query. the idea is to click on an item in the listbox...

I have noticed my stress free evenings are more frequent after being able to do the most simple tasks now, and make them work... even with microsoft being a pain in the backside... the reason... I learned VB! Mainly taking tips from posts on this site, but I found doing things VB instead of...

Just curious - but how big is too big?

Does anyone know of a good guide, perhaps on the internet or you can just give me some tips or something, on reducing the file size of my database? I'm about half way through making it, and I'm still tinkering around, but what was 13mb became 50mb and its now 130mb!? (and thats when Ive...

hmm... sounds very messy?

this is impossible as the combo box would be HUGE!.... the field is entered manually because there are too many different combinations of things to charge for on an invoice... thats why we only need a few things to auto correct. One customer will need NCR invoices, whilst the next has as some...

Autocorrection is probably really easy but I havent found the tool to a) enable it or b) edit it... for example, the staff that will use this system are quite lazy and will simply put d/l on an invoice, which is a chargeable fee for downloading, I need to be able to add d/l to an auto correct...

Graphic 1 is an example of my order details form, with some calculation totals attached... as you can see it's quite chunky. Where as I prefer graphic 2 which shows it without the totals... is there a way where I can keep the layout of graphic 2 and have an option to view totals for that one...

I am having a tonne of trouble opening a from through a button or otherwise and lin king it to a certain field. it seems to only want to do it if the next form has the same source (e.g tblCustomer)... it doesn't work if i use two forms from two different sources but have the same fields...

you are all too clever :) Thanks for explaining the flaws of using autonumber, I am confident now to attempt a Dmax version... Its also interesting in using a seperate table to create the counting... this made me laugh, because I need to filter some data into a seperate table anyway. The...

Thanks for that, but it didn't really answer my question I've exhausted DMax and it didn't really work, so Im using autonumber, but it doesn't want to count. I know the purpose of Autonumber is to link tables primarily without receiving duplicate numbers but I thought it would double as an...

Firstly i find it annoying how autonumber doesnt begin from the beginning if you delete all the records and start again... is there a way around this without recreating a brand new table. Obviously alot of testing will create alot of deleted records. Also, I need autonumber to to be 4 digits...

I've been playing around for some time and can't seem to get the hang of either. Basically all I need it to do is to count how many "Order Types" =1... then to add 1 to it (and order types = 2 etc) (Note: Order Type 1 = Invoice, Order Type 2 = Quote) So basically Im filtering through for...

its funny you say that... that was my origonal method but it was complicated to add data to it. For example, an order wasn't truely unique to the customer for some reason. I was trying a wizard type method of filling in an invoice... this way nothing gets missed out either. Then at the end...