Search results

I have a form w/a subform based on a table which shows individual employee training records, In the subform, there is a column "Hours". Each ee must have 40 hours a year in training. I am trying to just place a text box in the main form which will show the user what their current running...

I have a table called "AssetNumbers" and will be given a batch of about 10-20 of these numbers at a time from Accounting (they are not in any sequential order and I never know what I will be getting). When the user selects "get new Asset Number" from the menu, I want it to automatically select...

Thanks for your reply-I have my db on a shared drive which opens through a link on our intranet home page (through a .bat file). The db opens to the main employee form and this is the only form that is opened when I am trying to exit-the exit db button is on this form. Prior to this problem, I...

All of a sudden I get the following error message when exiting my application through the command button: "Microsoft Visual C++ Runtime Library Runtime Error! Program: C:\Program Files\Microsoft Office\MSACCESS.EXE abnormal program termination" My command button code: Private Sub...

I have scoured the forum but can't seem to find a solution that works for this. I have a main form with a subform. On the subform I have a text box that sums the total "Hours" for each employee for training. This is named "TotalHours". Below is my code for the text box on the main form...

I have a form with a combo box and "notinlist" event. The "notinlist" event opens a 2nd form to add the new document. When I click "Save" or "Cancel" closing the 2nd form and returning focus to the 1st, the dropdown box is already opened on the 1st. I cannot figure out the code to keep it...

I can't seem to get my brain around this: I have a simple calendar that, of course, I found here, that I want to use on three different forms. I have it working on one as long as I just want the dates to be entered on that particular form, but am assuming that, in order to use it in multiple...

I finally got this to work using the code you posted-Thanks! But, do you know why, when my NotInList message appears, I click on Yes, the message automatically pops up again for some reason, I click Yes again, and my new form opens correctly- Any ideas??? Toni

Thanks guys! I took out *.* and changed "md" to "cd" and here is what it looks like now-at least it's shorter :) C:\WINNT\Profiles\thart\Desktop>cd "c:\my documents" copy v:\Project\Materials\ PurchSQE\Training\MaterialsTraining.mdb "c:\my documents\" The filename, directory name, or volume...

When I open my database on the shared drive using the .bat file, it opens fine (a little slow) and works with no problems, but I was wondering if anyone knew why these error messages were showing up in the cmd.exe window. C:\WINNT\Profiles\thart\Desktop>md "c:\my documents" copy...

I cannot figure out on which event to place my DoCmd.Close acForm, "Add Records" code. I want the form to close upon the opening (via NotInList event) of my NotInList form after carrying over the Employee ID to the this form. I have put it on every event I can think of and, since it is still...

Got everything to work except that when I save the record in my NotInList form and it closes leaving just my main form open, I click "Close Database" and my original message "Document does not exist-Add?" comes up? I click yes, then I get the Close action was cancelled" msg again. I have...

Thanks for the fast reply-I also had my Add Records form set to Pop up so that's why it stayed on top, but here is what I am getting now: On not in list event- My Msg comes up "Document does not exist-Add? Yes, No. When I click Yes, the new form opens on top of the previous and my same Msg...

I have tried everything and cannot get my form to close upon opening another. The new form just opens behind the form I want to close. My code is in the "Not In List" event of my Add Records form. The new form is called NotInList. Can anyone see where this is not working? I have it coded so...

Yesterday, all of a sudden two of my forms became corrupt and I created a new DB (importing the forms, tables, reports, queries) and it worked fine until now. I exited out of the DB and now it won't even open-nothing happens, not even the hourglass. Any ideas!!!!! Thanks! Toni

"The text you entered isn't an item in the list." "Select an item from the list, or enter text that matches on of the listed items".

I have been unable to get DoCmd.SetWarnings (False) to work. I am using it in the "NotInList" event of a form in which I have it opening up another form to add the new items. It comes up with the message I created and then, when I click Yes to add the new item, the Access warning message pops...

Thanks for the response, however, this erases the Employee ID as well and I need it to remain on that EE until they close the form. I tried to leave in this code: stLinkCriteria = "[EmployeeID]=" & Me![EmployeeID] Forms!Employees![Combined Subform].Requery But this doesn't save it either...

I have a main form and subform, with an "Add Records" form opened by a command button on the main form. I want the user to be able to add a record, click on my "Add another record" button and continue until they are done, then hitting the "complete" button which returns them to the main form...

I have a mainform with a subform. I have a field "DateCompleted" that, when it's clicked a pop calendar opens, the user clicks the date and it drops into the "DateCompleted" field. I want focus to be set to the adjoining field after this but for some reason it will not work. I have tried...