Search results

I need a little help with some list boxes. The VBA I am using is supposed to display information from a query when you double click an entry. A form is supposed to pop up and let you edit the table the data originates in. The code for List20 works but the code for List6 pulls up a blank form...

I need a little help to finish this database off i uploaded. If you click on the reports button then final selection you can see that I have duplicates highlighted. What I need to do is highlight those two entries on other forms. If you hit the back button it takes you to another form (20...

Thanks for the help. I'm going to give your ideas a try and see if they can get me closer to my goal. Even if it doesn't work exactly he way I want I think it will push me in the right direction. Let me know what you think about this. I run a create table query to take all of the "True"...

I'm trying not to side track you here. That is why I did not give you the forms. The check boxes on the forms control the selected column on the tables. The typical rules for a database do not apply to what I need to do ass far as duplicate records go. I realize that the entire record is not...

These two tables are a randomly selected sample of a larger group of data. As you can see I have a list of 20 and a list of 10. I am going to add some conditional formating to the forms these two tables are linked to that will highlight duplicates in the AUTH column. The user will then be...

Sorry about that. Government computers are picky about how you do things. Lets try them from a .zip file.

Here are the tables I am working with. I keep forgetting you can upload files in here man my brain is mush. Anyway... Using the "selected" column I want to build a query that will pull results from both tables where the value is equal to true or -1. It changes (the value) depending on the...

Hello again, I am trying to query a like field on two table and make one table. The field is a simple check box and i need the query to return all values equal to -1 (checked). It is frustrating because I can see what i want for an end product I just can't figure out how to get...

Do you have an example?

I need a little help with some conditional formating. This may be a case of i've been staring at this database too long. As you can see in the attached files I have 2 reports. They both have conditional formating to show me duplicates on each report (they show in red). There is additional...

I'm having a case of writers block. I have a database that I upload data into and it randomly selects 20 items and 10 items creating a new table for each. So, I end up with two different tables of randomly selected items for a total of 30 items. I have reports for each table that highlight...

Got it to do what I needed. SELECT TOP 20 AccyAll.ID1, AccyAll.ID, AccyAll.[Part Number], AccyAll.Noun, AccyAll.Name, AccyAll.DLC, AccyAll.DDC, AccyAll.JCN, AccyAll.[Serial Number], AccyAll.Int, AccyAll.Auth, AccyAll.Status INTO tblRandom FROM AccyAll ORDER BY Rnd([ID1]);

Hello All, I have run into hurtle on a project I am working. I am trying to create a query that will make a new table with the next 10 records from another table. let me back up. I have query A that creates table A which is a randomized version of two other combined tables A1 and A2. Then...