Search results

Yes, overwritten meaing deleted then added. I don't want the whole record deleted. If a user is replacing an item with a specific equipment #, I can capture when the user deletes or adds the equipment #. However, when I type over an existing equipment number I cannot capture that event as a...

Is there any way that I can restrict a text box entry from being changed? I am working on a tracking system and presently can capture when a text field entry is added or deleted. I can't capture when a text field entry is overwritten. Therefore I only want the user to delete the present...

I. The two issues I am trying to address is to see if there is simple code that can be used to make a command button flash. II. I need to show in a small pop-up box users that have expired licences. When the main License form is first called to open, I would like a smaller pop up box or...

I am using Docmd.sendobject to print a report to Outlook so that I can e-mail the report. The method used to work. Outlook would open, I'd elect my recipients and could click the send button to e-mail the report. Now the send button is disabled once the report shows as an attachment in...

Can the form “employee training query subform” be set up as single query? If so, with this datasheet setting, how can I create a parameter/search form to see what training was attended on a particular date? I would also like to query which employees took a “particular” training on a particular...

I have a table for job seniority. If a new person is hired, their seniority becomes the next number up from the last seniority number (25, next is 26, etc). If a person leaves the seniority number shifts up in rank and down in number. If I am 25 on the seniority list and someone leaves, my...

I see the diffences. Originally, I had only yes/no boxes. Can you direct on how to reflect the date in a subform. I am trying to show the employees training history on the subform with dates. I know I can produce it on a query and report. I would like to see an employee's training history...

I am tracking training for employees. I have a database that keeps track of the dates a particular training was taken. Employee training is ongoing from year to year. I have an Employee Training with a subform showing only the specific employee's training. I need a help with a few things. I...

I have a database that will be used by a few users who are not very comfortable with Microsoft Access. I have a login screen and a introduction/splash popup. I was wondering if it is possible to bypass the Microsoft Access pop-ups that ask the user if they want to "block unsafe code.." or The...

I have a form that records when a user edits a record. This change is only recorded when the user clicks the "update record/save" command button. What I need help with is capturing the changes made when a user edits the record in any field and doesn't click the save button upon closing the...

I am using the following dialog box to ask whether or not the user wants to print the report in the Close event of a report. I really need help finishing the code. As the user presses "X" to close the report, I would it to be that if the user says yes...the report prints. If the user says...

I have a report that opens from a command button on a form. The settings on the report are set to pop-up and modal to keep the focus on the report until closed. I like the settings as they are but I need to print the report once it pops up. As the settings go, I cannot access or use the...

I have a report that opens from a command button on a form. The settings on the report are set to pop-up and modal to keep the focus on the report until closed. I like the settings as they are but I need to print the report once it pops up. As the settings go, I cannot access or use the...

I have the following code that I am using to enter an date created and date closed for a record. I am using the vbCalendar pop-up to enter in the date closed date... Private Sub dtmdateclosed_Click() calend2.Visible = True calend2.SetFocus If dtmdateclosed < dtmdatecreated Then MsgBox "The...

I have two date fields that I am using a form to show the open and close date of an investigation. The opened date field is controlled by a textbox elsewhere on the form, but the date closed is controlled by the vbCalendar control. What I am trying to do in coding is to evaluate whether or not...

I have two date fields that I am using a form to show the open and close date of an investigation. The opened date field is controlled by a textbox elsewhere on the form, but the date closed is controlled by the vbCalendar control. What I am trying to do in coding is to evaluate whether or not...

If I would like to enter 000555 in my query parameter box and it recognize the entire number. Can it be done. So far when I enter 555 it will give me 000555, but not when I enter 000555. The query shows no value. How can i get it to recognize the entire zero string.

I have a database where the primary key is a field for pass numbers. Many of the pass numbers begin with zeros (example: 0023456). I changed the table property for the pass numbers to text so the zeros would be recognized. However, I have a form based on a query to search this pass number...

Thank you. I really am learning Access as fast as I can

I am trying to understand the modal property and how it relates to pop-up windows. If someone can please help clarify how the two work or don't work together. Thank you. I also wanted to hide my database window after a user logs into the database. Is there a simple docmd string to do this...