Search results

an additional comand button did the trick I had to add a command button to save the datas of the subform. the user need to print the report in 2 steps click on the save record and then on the print note. wanted it to be a 1 step but 2 works. Thanks

I have a command button to print the note from the open record. I am using the code stDocName = "Reproduce progress note" DoCmd.OpenReport stDocName, acPreview, , "[PNID]=" & Me![Text2] this works however in another location in the database I have a multi-tabed form that on the last tabed...

I have built a form that has a listbox driven by a query. query asks for last name the list box displays a list of first last and customer numbers. the design is such that you click on one of the customers and then on a button that opens that customers record. to accomplish this I added a text...

Did the trick Thanks FOFA your suggestion did the trick J

Hi I have a table with the following listed {ClientId], [Effective Date], [Lapse date],[Contract] This lists each authorization record for each client. The info is imported from another system which is not capable of filtering so I bring the data into access to run several queries and reports...

Where did you place the msg box in th code Hi David I am finding that I can get the process to run but when I go to look in the Folder I see a slight second of a file and then it disappears I am wondering if I need this pause you are talking about and where it would be placed. \Thanks J

Thanks Paul that works but now i need a sugestion to change the content of the text box on my switchboard with out having the user go into the design of the database. Anyone have an Idea on this thanks J

Hi I have created a database that keeps sports stats. each season I clean out the database to start fresh I would like to automate that. I know how to setup the clearing of the tables. what I need an assist with is this. there are multiple reports and forms in the database that have a heading...

Thankls All for the assist I was able to create a new db and inport as Andy suggested. and things seem to be good again. Thank God for this forum. It worth is inmeasurable!!!!!!!!! J

Thanks Andy i will try that. I have used repair and it said it was successful but still cant access the DB window. J

I have built a database and have hidden the DB Window at start up. Knowing that I can get at it via f11 or holding down the shift key at start. while I was working on the programming my keyboard on the laptop had a key combination that locked the number pad on the keyboard it took several...