Search results

I see what your talking about Mr. Hartman, as a matter of fact I just ran across a similiar post after many hours of searching and you happen to provide the same answer there. This should solve my problem, thank you very much

I tried that structure at first. The unique pin column changes in the third table on a random periodic basis. I would join the first two tables into one but not every employee is assigned a unique pin. The reason I would need to delete the employee data is if they no longer worked for us. If...

I currently have three tables. The first table contains Employee ID, and Name of Employee Second table contains Employee ID, and an autonumber The third table contains an autonumber and a unique PIN The 1st/2nd table are connected by Employee ID, the 2nd/3rd table connected by the...

Gemma, I'm not sure how to store it globally or in the registry. I understand the risk I take storing it in a table, however I've put a password on the function that changes the flag so only one or two people should be able to change the flag. This should prevent the casual user from...

Here is my query, I'm sure it looks pretty ugly: SELECT masterList.organization, offPRP.actionTaken, masterList.SSN, masterList.EAL, masterList.NoCode, masterList.AuditTrail, masterList.name, forecastedMECSQ.indexNumber, issuedMECSQ.indexNumber FROM ((masterList LEFT JOIN offPRP ON...

Thanks Doc Man, I have an idea of what your talking about but its still pretty far above my head. I think I will stick with using a single table to store said flag and use a dlookup to reference it. This seems easier for my access understanding.

I have a query that joins three tables. The first table being the master list with all personnel listed and the other two are tables containing information about a specific record. When I run this select query it allows me to add/edit information. However if I add a fourth related table, it...

ghudson...what is this global string you speak of?

So use a table to store a single value and then use an update query or some other way to change the value as needed???? mmm.....that sounds like a good idea. I'll have to think about that. Thanks.

I need a flag(indicator) for my database. This flag would be read by many different functions and depending on the value of the flag, would do one of two things. Example: If the flag is "A", when I click a button in a form it does "C" function. If the flag is "B", then in case of the previous...

Thats exactly what I'm trying but I can't figure it out.

Anybody???

Not sure if this is possible but I figured I'd ask. I currently have a form/update query that allows me to change a persons last name in a record depending on the value I enter in an unbound text box on the form. Is it possible to make this query dynamic so I change field names on the fly...

I feel silly Ok..now I feel silly. After looking at from Craig's POV, it was silly to begin with. Thank you gentlemen for being patient enough to show me the error in my logic. Next time I think it through a little better. Thank you

Doc Man, thank you for the input. The problem is the date the change is made may not be the date its requested. I know it sounds pretty goofy but the date put it could be either today our yesterday. I'm trying to get the 'client' to let me just use the current date. In regards to the...

Hello out there in the world. I am seeking an answer to a problem. Ok, not really an answer but more like looking for a better way to do this if possible. Scenario is this, I have a table with several fields. When a record is deleted in this table, I have an append query that places three...

Sorry it took so long This is the field that pulls the text value from my form and then converts it to a date... RTDDate: CDate(forms!masterListQ.OffPRPsubform!DATE) Of course I'm sure there is a better way to do this but this worked for me.

I'm trying to prevent use of the scroll wheel in my subforms but allow for it in the main form. I've looked at the "mousetrap" posted by gHudson. I'm not trying to prevent changes as I am trying to prevent a blank or new record from displaying if one already exists. Any Ideas on how to do this?

thanks but got it... Just used CDate() function and it worked like a champ, it only took 4 days and 8 reference books but...dang it, I found it.

I have an unbound text box with a medium date input mask. In the afterupdate event of this box I have it run an append query. This query appends several pieces of data and I'd like it to pull the date from this unbound textbox. Yet it doesn't. If I format the textbox as standard text it will...