Recent content by Smokeeater

Yes, you are correct - that will set the identifier I need. I overlooked that. Thanks.

The other fields are coming from a table, but I want to add an identifier for the piece of equipment tied to the licenses. All of those fields are date fields only - I would just like to add an text identifier for each one. I can put this in a query column - Forktruck[], and then we I view...

Question...and may be a stupid one at that, but do you know how to add a field to a query that is not based on a table? I want to pass a value from an append query to a table, but it is not based on a field located in a table?

I think I have something to work with now! Thank you very much!! And yes, my plans are to restructure this information into its own separate table. I am not a huge fan of inheriting someone else mistakes (poor db design) but I will get it corrected. Thanks again!

It got past the semi-colon issue but is now getting hung up on the end of the expression. If I press OK, it highlights 'ForktruckLicenseExp at the end of the expression. I am only trying one of the license fields until I know I have the code right, then I can replicate it for the others...

namliam I finally got the time to get to this project. I decided to start simple, with just one piece of equipment to be returned in the query. I figured if I can get the correct code for one piece of equipment, then I can replicate it to the others. However, when I run the query, it is...

Mailman - that you for the replace, and yes, to confirm, I have no spaces in any of my fields. I just used that for my example. I will work on designing something along the lines of code you provided. I can see already how that will return the results I am looking for. Thank you!

Bear with me as I try to explain my situation. I have a huge table - don’t ask – I inherited it, and yes, we are making headway). Along with the standard name, and employee ID #, this table contains multiple fields to track license expirations, based on the type of equipment. To keep it simple...

Thanks Pat. I will keep that in mind when developing the code.

June7 - thank you very much for your quick reply. That is what I needed.

I have a combo box on a report menu and want to use the value's for other activities. The combo is cmbReports, with (2) fields: ID Name 1 Red 2 Blue 3 Yellow 4 Green How would I reference a value of blue, in a "if" statement situation? If Me.!cmbReports = "Blue"...

I was over complicating this by trying to do the calculations in the underlying query. What I tried, and it worked, was putting the code in the After Update function for fields A and B. DateA adds 2 years to both DateB and DateC after selecting the date DateB adds 2 years to DateC after...

arnelgp - thanks so much. I am out of the project for today due to meetings but will give this a try first thing tomorrow morning. I will let you know how it works out.

Thanks CJ. I will take a deeper look at the current structure, but we will probably stick with the one table method.

These are used to track the issuance of licenses related to operating powered equipment, such as a forktruck. DateA is the initial date that the person received their license. We want to maintain this date from a history standpoint, so that we know how long they have been licensed. When the...