Recent content by joltremari

I have running a talent show for several years now. First I kept all records on paper, then moved to spreadsheets, now I am moving to a database. I have it "useable" but I feel it could be better. I have many questions but I will ask the important one now. I am using 2 tables, one holds...

When I tried this code to loop through the records to clear the data, it added about 3,700 records to the table, now I don't know how I'm going to get all those records out, but more importantly I don't not know why this code is not working. If someone could take a look at it and maybe figure...

I have been trying to create a shortcut key for filter by form with no success. Has anyone else done this and/or can it be done. Any help or insight is greatly appreciated. JO

Just a little note: the Access equivalent of VB's App.Path is... Application.CurrentProject.Path

I've seen comboboxes before that by typing the first letter of the word your looking for it will go to the first word matching that letter, but then by typing that letter again it will go to the next word starting with that letter: Such as in a "Choose Your State" box by typing "M" it selects...

That's great - thanks for the advice - worked great

what if not found when Finding a record [Resolved] I am using this code to find a record. I type the info into Text54 and press enter and it finds the first record where the field Age matches the info in Text54. I need a way to display a MsgBox when there was no record found. I have tried...

Yes that is it! I am using 2002 but it worked fine. That is exactly what I've been trying to do. I hit all around it but never quite got it. Thanks-a-gig JO

This database keeps records of Transformers (like on a power distribution pole) and we are required to keep track of everytime a transformer is moved. So the main form keeps a lot of info about the transformer that different people need to access, but each time that transformer is moved we have...

I have a Main form in which lots of info is keyed into, there is a subform that we use as history records. The history records only needs info from a few fields on the main form. What I want to do is make a command button that will, after keying in the info to the main form, click and it will...

Man did that do the trick! and it's much easier!! Thank you, JO

I have a table with 6 fields in it Catagory Name State City Comments Rating On a Form I want to have my first combobox (Combo1) populate with the contents of the field -Catagory- this is done When I select an item from Combo1 I would like to run a query that would populate Combo2 with the...

Can I make a query that will only query the last record of a field. This is so I am getting the last entry. ex: As we update our maps we enter into the "Last Updated" field the month and year of the update, so as to have a running history at the same time. (by the way these are subrecords of...

I have a form with 2 subforms that are all relational: Table1 = Form Table2 = subform1 (subrecords of Table1) Table3 = subform2 (subrecords of Table2) I am trying to write an sql statement to add records to subform2(table3) based on a record in subform1. (unsuccessful so far) something like...

I have a Form with SubForm1 and Subform2. SubForm2 holds sub-records of SubForm1 - - - and SubForm1 holds sub-records of the main Form. I would like to have a combo box to look up a record in SubForm1 and display the related records in the main Form and SubForm2 The tables in which the forms...