Search results

create your query. use the form wizard to generate a form based on that query use the toolbox to put a command button on the form to create a 'search function' if you want to be a bit clever and regnumber is the usual search criteria, add regnumber.setfocus* to the forms 'on load' or 'on...

have you looked at this: http://www.access-programmers.co.uk/forums/showthread.php?t=115281

No you haven't...do you think i'd be asking for it if that link worked? For someone who's getting other people's time and advice for free, you have a strange temprement! I've already written the code for you...I'm out of here

why dont you just post your database - stripped of data, up here export your table without data and your form to a new database and post it here

sounds like you need to check your table's for correct data types

go into the vb editor: ALT+F11 find the form and dbl click on it... Private Sub Form_Current() dim intValue as integer intValue =([1]+[2]+[3]+[4])/4 [NameOfFieldtoStoreCalculatedResults]= intValue End Sub paste in the code with the correct field name

Thankyou, that's exactly what I thought. However, I need to filter the (ListBox) query based on a criteria of the current record Private Sub Form_Current() Dim strSQL As String strSQL = "SELECT * from qryWarrantyAncillary Where [AHUuniqueID] = " & Me.AHUuniqueID & ";""" List38.RowSource =...

Thankyou Seth. Dave... look in the properties of the form, not the control, you'll find it

put this in the on current event of the form: dim intValue as integer intValue =([1]+[2]+[3]+[4])/4 [NameOfFieldtoStoreCalculatedResults]= intValue

first answer the question... why do you want to store the final sum amount as opposed to working it out on the fly? if the initial numbers change in your table, then you would always need to recalculate your average using that form to store the correct value. best practice is not to store the...

can you please explain what me.requery does? sorry...still learning

Hi I have a form which displays records of our products, on that form I have now put a list box which displays the ancillaries to the products. both the form and the list box run off queries. I have the same unique identifiers in both queries. I need to filter the listbox by the unique...

Ahhh Haa...you beauty!!! Thank you so much... Dlookup is now the new president of planet Battenberg!

Hi I want to have a table of 'database defaults' in my DB each of the defaults is a setting that applies to all of the DB how do i relate this table to the rest of the relationships or more simply how can i pull in one of these default settings into a calculation? Example: I am trying to...

Hi, I am putting together a parts database for our products. I want to use cascading combo's to select all the availible parts for any derivative of our products. I'd like some advice before I start, If anyone can help and forsee any problems down the line... I imported a parts catalogue...

Hi I am trying to open a new form in code using the linkcriteria to select the correct record, this is after a click event on a particular field. The two fields that i am trying to match are the parent and child ID fields defined by the table relationship. I cant get it to work and I was...

Thanks Keith, this may sound stupid, but how do I check for compile errors in my code? I get no runtime errors! is there a way to batch test???

create a form (frmDateRange) to input your date ranges: have two text boxes txtStartDate & txtEndDate in your query,that the report depends on, under the 'date' criteria use: Between [Forms]![frmDateRange]![txtStartDate] And [Forms]![FrmDateRange]![txtEndDate] you can then assign whatever dates...

Hi, I've been trying to create an MDB file of my database with litle luck. when I try and click the make MDE, the computer locks up and the processor goes into meltdown! I have to quit Access through TaskManager to bring it round. I previously exported every element of the database one at a...

Thanks for your reply, One thing that was puzzling me was where to aim the information in the first instance, Adding it to a new database opposed to a query in the existing makes sence. The CSV import will be in responce to a user clicking a button and then selecting from his directory...