Search results

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...

I have three date fields. [DateA], [DateB], [DateC]. [DateC] is a calculated field in my query, that adds 2 years to [DateA], and it works fine via this criteria: DateC_2: DateAdd("yyyy",2,[DateA]) However, [DateA] is only used one time, and then all follow up activities are defined in...

Ridders, Thank you for following up. All of the changes have been made and the end users are really satisfied with the hidden fields, and unhiding them with the buttons. I also threw in a couple other minor changes to splash it up a little. On to the next challenge!

Thanks Ridders. I don't get over as much as I like. Some years I was able to go 2 or 3 times, but now I am lucky if I can get over 1 time per year. This year it will be zero. Outside of the tragic consequences of 9/11, it really changed air travel, and the associated security costs tied to...

Galaxiom, okay thanks. Now I understand the purpose of that portion of the code.

Ridders, I travel to London every year or so to see family. I would like to buy you a pint or two to thank you for your guidance! I understand now what you did, and what I should have done from the start, however, I do have one question. In the first part of the code you define "Tg1 As...