Search results

Thanks Trevor, it works great now.

I am sorry for taking so long to reply. I tried your script and the first part worked just fine. When I tried to set up the command button using the same script I got an error I did notice that when I set up the button on the switchboard and went to the properties and than set up the same code...

Thanks very much, I will give it a try and let you how it comes out. Once again thanks for your help.

I thought as much. I am not a programmer and I have no idea how I would do it, is it possible you can give me a clue on how I would write the code.

I have a number of databases in my system and I created a database that only has a switchboard form in it. This switchboard form has links to all of the various databases I have created and opens their default input form. This works fine but now I wish to place a button on the switchboard to...

Thank you very much your suggestion works perfectly. :)

Thank you for your comments and it is obvious that I need more research in these areas. Until then, I have re-built the sample database and have attached it. It still does not want to work, but I have taken your many suggestions into account during the rebuild. Each of the dbs has an ID auto...

I have attached a copy of the db in your format

Obviously this is harder than I thought, it most likely because I am not a programmer, but I am still having a problem. I made the changes in the db layout as you mentioned in the previous reply. I assume that the StaffID field will now hold the staff names that were in the first and last name...

Thank you for the information. I have a question. In the main table I have FirstName and LastName fields. If, as you suggest, I delete the two fields in the new table and add the StaffID field, how will it find the information, the field names do not match. Can I use the lastname field...

I did not have an primary key in the TBLLicNo table. I have set up one as an ID Auto Number field. I have the exact type of primary key in the db that has the data in it that I wish to append from. It had no effect on the results. What sort of re-structuring do I need to do to Lic # field?

I have taken your suggestion and have read up on Append Query and I do not see my problem. When I bring up my query window and selected datasheet view I see the 2 entries in my sample DB, which tells me I am doing something right. But when I check the new table there is no entries in it even...

Yes TblLicenseNumber is the original table with the license numbers in it. I have added Is No Null to the criteria line under the Lic #1 field as you suggest in your last post and click the RUN icon. It still does not want to work.

I created a new table with the Names and License Numbers fields. (TbleLicNo) I created a query based on the TblLicenseNumber table using only the Name fields and Lic #1. I click the Append button and when ask where to append to I put in the new table (TblLicNo) and click on Run. I then opened...

If this helps I have attached a simple database with sample data and the queries I am now using.

I assume the regNo (text) is the license number. If so does that mean I have to entered each licence number as a separate entry into this new table?

ConnorGiles I all ready have a query set up to search each Licence Number field, but if the number is in the 3rd field, I would have run the query 3 times. I only want to run the query once. The fields are TblLic #1, TblLic#2 and TblLic#3 DavidAtWork If I understand your suggestion, you...

I have a database that records information on the staff working in the building (over 400). This information includes the licence number of any vehicles (up to three) they might be parking in the parking lot. I have created three fields in the table to record the licence numbers of the...

My query now works exactly like I want, as always thank you to everybody to help solve this problem. Sorry it took so long.

I am still having problems getting what I want. To recap In the field line (top line) I have entered `TblDate` In the Group By line I have entered `Where` In the Criteria line I have entered `Format([TblDate],"yyyy - mm")` When I run the query I am not ask for the month or year I want and I...