Search results

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

Thanks. Thats some good reading. Cheers jaz

A toolbar you say?? That sounds like an excellent idea! Could you point me in the right direction as to how to accomplish this? It would be greatly appreciated. These are not restricted reports but need to be sent on an idividual basis once filled out. thanks again Jaz

So in using OenReport, is there a way of viewing and emailing all at the same time? Such as report opens with a request for emailing message? (i.e. "send message to email now?") Cheers Jaz

Hello everyone. I am having a little difficulty in finding out exactly where I went wrong with this script. Everything works...sort of. The idea of it was to email a Single record. When clicking the button it wants to send All the reports. I am able to generate a report showing only one...

Hello I am working on a project in which I would like some fields autofilled on the form. The attempt is this...when the person selects "Day" or "Night" shift from a combo box, I would like the start and finish times to automatically fill in (i.e. 0700 and 1900 for day shift and vise versa)...