Recent content by fireman_gcfd

hello all, it has been a long time since ive been on here but I am back into building another database and stuck on what seems to be a very simple problem. I'm sure there is a thread out there with the topic I'm inquiring about and a redirection would be appreciated. What I have is a single...

You are absolutely correct!!! Thank you. I used the "If IsNull" and rearranged my True and False and it works great. I appreciate the help.

My logic reversed?? Could be...I may be looking at this from the wrong angle. Where do you see it reversed?

OK, so I successfully disabled the button with the suggested code but I am having a little trouble with getting it enabled even with populating the other field. Here is what I have in the Form_Current: Private Sub Form_Current() If Me.PlatoonChief = Null Then Me.IncidentBtn.Enabled =...

Hello All, I have been surfing the forums and have found many ideas/paths to follow for what I am looking to do. I am just hoping for some clarity and hopefully simplicity. I am trying to lock down (for lack of a better term) a field "Incident", which is populated by a button that adds to...

Pbaldy Wicked advice! Works great! Appreciate it. Jaz

Hey all, I have a command button that opens a report from a record. The idea behind it, it to open a report and select the current record. The criteria is based on the "Incident" number. Now for what ever reason I am getting an error about mismatched criteria yet if I select the field of...

John Sorry for the delay. I have been away. That is EXACTLY what I was looking for. You're a life saver man! Thank you so much! Jaz

Here are the 2 separate sample DB's in their original downloads.

OK I have posted a DB. This is not a functioning DB! It is a hybrid mish-mash of 2 different sample DB's I came across. To those that are going to view this, here is what I am looking to do with it: 1. Have the form function based on query just as this one does with the info autofilling...

There will only ever be one user at a time. So that scenario isnt a concern for me. If anyone has the same idea of using it, then there could be issues for them.

Is there a code that anyone knows of to assign a number to a form via command button as opposed to having access assign it? To clarify, once the form is complete, the user will click the command button which will assign the number (e.g. 2010-001) to the form, save and close. Then the next user...

Thanks for the quick reply. I will pick through that and get back to you in a little bit. Cheers

Hello all, It has been sometime since I have posted on this forum as I have not had much to do with database creation for awhile now. I am working on enhancing our database at work and want it to do certain things but need a gentle nudge as to how I should proceed with things. I will...

Hello Everyone I am looking to build and Overtime tracking form and have been pondering on the design of it. Here is my idea and not sure how I should go about doing it (straight forms and tables or queries). I would like to select my employees in a combobox and have their information...