Recent content by buzzbait9

Wow, Sorry, Thank you for responding. That went way over my head. The reset that I was trying to do is when the loop gets to the end of the row, it reads the next row values and then populates the check box values as it reads the new rows of values. I wasn't sure that when finished, the new...

Hello Ya'll :banghead:First Part: I have been trying to use to a record value and choose a checkbox. Sat, Unsat, N/A are the 3 boxes. I used the control name and tried Nesting first and then made it simple. If a.Value = 1 Then Check68 = True Check69 = False Check70 = False End If If a.Value...

The data Base is designed to create Maintenence on equipment. When the equipment arrives it is added to the data base and assigned Maintenence services. Each service is assigned with a frequency. every week for 156 weeks, every 2 weeks for 78 weeks, etc. The Services, called events, are...

The services(Event) are maintenence. they are all generated as soon as the equipment arrives. When they are no longer required, they are cancelled. The EventDate is the date generated for the service. When they are cancelled, they are ID'd by ISCANNED and the value becomes -1 which is only a...

Query for First cancelled (ISCANNED=-1) event date. SELECT MyTable.TagNo, First(MyTable.EventDate) AS FirstOfEventDate FROM MyTable WHERE (((MyTable.ISCANNED)=-1)) GROUP BY MyTable.TagNo; Delete query using above query DELETEMyTable.*, MyTable.ISCANNED, MyTable.EventDate...

Hello World, I seem to be confusing in my posts so I'm going to try this one in steps I have a cancelled service that gives a -1 to an ISCANNED field for each EventDate after the date the services are cancelled. Now I am permitted to Delete all of the cancelled records except the Min()...

Thank you so much for that Sample. It is not what I needed but I can see using that in the near future. Let me Try once again. This data base is a master database. it is sent "empty" to each user. Only that user will use it by adding their own records. It is not linked to any other user's...

Thanks for the quick response. The database is unique for each user. This is not a front end that is used by everyone, just a separate duplicate front end distributed to each user. Each user will fill out the Project form with the information, for there own project for the header and...

Hello, I built a form that will allow each page header to take the info needed depending on who is using the data base. I seem to be having a problem having the Logo uploaded so that it can be used. Since I am new to Access, my only example would be like a web page. use the location of the...

Thank you for your reply. The numbers calculation is the only option that works. The problem I am having is the information between dashes is not always the same number of characters. some times it has an A,B, or C at the end and sometimes not.. I was looking for a formula that read...

Hello World, I have to query a record with 2 of the same static characters. "-" I can get the left function with the first " but I can't get the rest up to the second "-" Example: B-4352B-PXP02W01-10 TagNo: Left([EventInstanceID],InStr([EventInstanceID],"-")) Brings me the first char...

Thanks for the quick reply. I started typing more information but the thinking process allowed me to make it work. Actually answer my own questions. The append query was joined to the table query ID to Table ID. When I changed it to the query tag number to table tag number, it worked. Tag...

Hello, I've been reading through the Key errors but I'm not understanding how they apply to my application. I am appending records into a table from a main form and a sub form. I can append twice and then I get the key error. Can't append all records in the append query. Type...

Awesome! Thank you

Hello, Me.DateIssued.Locked = Not IsNull(DateIssued) I used this code to lock a date box in my subform. the item was already issued in the table. If it wasn't issued, it would have kept the field Unlocked. Now when I change the main form to a different record that has no issue date...