Search results

In the criteria box under the CustomerID field you would put - Like [Which Customer ID?] Then the report would print only the report for this ID Dave E

Hi again, I'm a bit concerned that you say you want the combo on the Instructors mainform to select the classes for different instructors in the subform, while displaying all the instructor's details on the same mainform. When you change the combo, the subform will update but the mainform...

Or the IIf() function. Dave E

OK Tectech, There are 2 things here - 1. Making a field up to show the days for the courses 2. Selecting classes by instructor I'm not sure if you want to hold several semesters data, but I'll ignore that for now. 1. Combining days of the week Put 6 (UNBOUND) check boxes on the form...

Congratulations! It's always better finding the solution yourself in the end - much more satisfaction! Spaces in any access names is bad practice. But now that you've got them, just ensure that you always put them inside [] brackets before using them in code. Changing them now will give you...

OK - plan B I've saved the page for printing and I'm going away to read it thru quietly and see if I can't solve this one. I don't give up easily. I'll be back - I'll bet it's easy really!!!!!!! :-)

Path, Can you copy the database, remove all but a few records in each table (to cut down on transfer time), compact it and post the database, either to the forum or to my email address? 'I think it's time (the Walrus said...)' to have a look at the forms and work it out from there. As long as...

Path, (odd name, but I guess you know where you're going- ;-) On the form where you want the data displayed use a crosstab query to combine the tables and show the fields you want. You could delete the JobName from the WorkOrders table, but still have it on the form - taken from the Timebook...

Stephanie, I used Access 97 at home and at work. I used WinZip to zip the database and sent it to myself at home where it opened fine. I will post it again, but this time I will not zip it. When you download it, it will be called DB.zip, change the .zip back to .mdb and try opening it again...

Somebody in Canada with a UK date problem? I was driven nuts too for a while.....until I spoke to our IT guys about windows dates issues. To get over it, whenever I need to input a date into the database and use it in a search routine I use the FORMAT function...

I may have seen you in such things as....."Under the table in Access" ;-) Now, I did something like this a while ago for archiving records. In the maintable I added a Checkbox Yes/No field called "Arch" It was visible and checked when the user wanted to archive the record. A command button...

I would agree with Pat. If there's only one selection of JobName for a given JobId, there's no point in having the second combo. Also, why is JobName in both tables when JobId is there as the linking field? Relationships are the core of these databases. Get them right and they work well. Get...

I have created a small db (see attached) which illustrates the process of - 1. Opening a 2nd form using criteria from the 1st form. 2. Demonstrates how to get the link field autofilled, even if there is no record in the 2nd table. I am, of course, assuming that the link field is the one...

Hi Gayle, I think a possible solution to this is - Have a table containing your facilities (say, called 'Facilities'" Have a table with all the records (sa, called ('Records') Create the form (say, called 'FormName') Create 2 combos on a form 1. called 'Facilities' and, 2. called 'Records'...

How about using the OnGotFocus on the JobId combo to clear the JobName combo so that re-entry is required again. It doesn't matter when a user enters the JobId the first time around since JobName is Null anyway, but if they return to the JobID and change it then it Nulls the JobName and problem...

OK, this is how I would do it - Create a form, no underlying tables or queries. Create text boxes for as many types of fields as you to search on. These will be UNBOUND text boxes. In the AfterUpdate property for each of these text boxes write a piece of code like - DoCmd.OpenForm...

Have you tried - Dim MyField As String MyString=DLookUp("[Version]","[VersionTable]") Since there is only one record in the table, it has to find it. (Haven't we done this one before?) Dave E

Do you mean something like - On the button to open the 2nd form - DoCmd.OpenForm "Form2", acNormal,, "[System Number]=_" & Me![System Number] Provided that Form2 has an underlying table or query with the right data, then it will open Form2 and display the relevant record. The example above...

Try putting your validation and processing code in the OnClose property. This works no matter what method of closing is used, short of switching off the PC. Dave E

Does the field that you are having problems with get its data from elsewhere. I have had problems like this when I use code, say in the OnClose property that assigns a value to the field before closing. If I try to type in data directly, I get the message you describe. There are probably more...