Recent content by bceo

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.