Search results

I have a combo box with only one value in it (this is because it is filtered down from another combo box. The combo box is bound to a table when I click AddRecord the combo box always appears blank. Is there any way to make this combo box always display this value, or the first value in it's...

Hi Can anyone tell me the syntax to refer to the current form. I have a form that will be copied from time to time to make similar forms. however i've been pointing to them using there names e.g. forms![nameofform].[combo_acombobox].value and i would like to be able to use a more generic...

Hi does anyone know how to point to a combo box correctly in SQL i have a few tables and a for with one BIG list in a combo box. to save having to keep scrolling down the list i created an unbound combo box, to give the user the ability to kinda lock the other one (which is used for adding...

I'm trying to create a report with a list box to select different parameters for a report. I've created a form with a list-box and the report works fine (after 4 years of re-formatting the report wizard's attempts :D ) however whenever I make the list box multi select the report doesnt work...

Cheers, your right, it does work. I must be going crazy :p

Hi I'm trying to create a report that list stuff between 2 dates in the query i have a line like this _____________________________________ in 'critera' of a field called DateWorkDone ">=[Earliest Date] AND <=[Latest Date]" so you get two dialog boxes asking for dates...

re: I need to make a filter by form button Is someone out there that can give me a simple guide on making a couple of buttons When you right click on a form you can "Filter by form" I want to make 2 or 3 buttons 1 Filter by form 2 Apply Filter (You can autobuild this but i don't see why...

i tried using the value of a combo box to return the StaffID value and tried (taking out using variable and entering in a valid ID DoCmd.OpenForm "STATS", , , "STAFFID = {BE78E0B3-B4E6-11D6-8B10-0002A5941B7F}" but i got an error message saying Malformed GUID in query expression 'STAFFID =...

because I don't know how to. can you give me a quick step by step on how to use a query to filter. i can make a query with the STATS & STAFF tables but i can't make a form filter using it.

Hi i'm trying to work out the syntax to open a form with a filter I have 2 tables that are linked with a 1 to many relationship. STAFF STAFFID is autonumber (Primary Key) NameOfStaff is Text UserID is Text STATS STATID is autonumber (Primary Key) StaffID is a foreign key to the primary key...

Ok i've had a rethink. I've got 2 tables I have a staff table with staff name and USERID I have another table which is joined to this (1 to many) to record stats. STAFF StaffID is REPLICATIONID (autonumber & Primary key) nameofstaff is TEXT UserID is TEXT STATS StatID is REPLICATIONID...

Hi Can someone help me. I'm trying to open a form with a filter. I'm fine opening a form using VBA code docmd.openform("blah blah",,'ENTER FILTER HERE') but when I try to use a variable for the filter all I get is some stupid error message) the way that I tried originaly was to set up a...