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

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

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

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

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

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

Hello all I am attempting to fill a report with the current data inputted on my form. I want just a single record selection so when the user finishes inputting their details they can generate a single report for printing. In browsing the forums I have come across many codes which open the...

Hello I have placed a Print button on a form. Using the RunCommand and Select record to grab the open record, then the Printout action to follow. Everything prints just fine but the database feezes up with the "now printing window" still visible. This is in Access 2000. Can anyone help with...