Search results

Gosh Harry I don't know. You might try searching the net to see if someone has a copy of the program for sale. I myself haven't heard of the program so I can't even begin to tell you where to search. After you find a copy you will probably have to input that data into Access if you are able...

Hello Harry, I don't know if this will work but have you tried to read the data in Excel and then you can export it to Access. Might be worth a try:) Carolyn

I use ctrl +' to copy data from a previous record into a new one.....it works well for me. Carolyn:)

Thank you Leonard! I can see where I will be able to use those in future projects. Feel free to share anything else you might find. Carolyn

Thank you ghudson and Pat I think I actually understand!:):) Carolyn

Hi Pat, Thanks for the information I find your knowledge to be very valuable. Please tell me where do I put Lookup Docmd.RunCommand acCMDSaveRecord? Thank you for your time:) Carolyn

I occasionally have problems with my network doing the same thing. Is your DB split? If so, I believe it is likely a problem on your server. Carolyn

Hi Fizzio, Yes please provide and example. Your assistance is greatly appreciated. Carolyn:)

Hi, Could someone please explain why I can't search and auto number field? I need to be able to do this and understand that I might have to change to a text field. My field format is 00-0000 and need the value increased by one each time a record is added. Any assistance will be greatly...

Thank You:) Carolyn

Hello, Is there a way (97) to change the Report Print Preview to default always to 75%. It's just one of the little annoying things I would like to change. Thanks for you time:) Carolyn

Thank you ghudson, I like that idea a lot. I did search the archives and found that if you hold down on the shift key while opening the DB it bypasses all the startup options. Whew! Have a great day:) Carolyn

I guess I should mention that I put this code on the switchboard and so it has effected all the forms. reports, EVERYTHING! I'm not sure how I am going to make changes to the DB without them. Thank you. Carolyn

ghudson, Oh MY Gosh! How do I get them back? Carolyn

Hi Rowena, Have you tried a macro? I like yourself do not have a lot of VB knowledge and I have been able to accomplish many tasks by using macros. Your command button could run the macro which would open your query and report. You might give that a try. Carolyn

Prao, I understand. I wish I had that knowledge to help you but I don't. There are plenty of Access magicians on the forum that will be able to help you. Good Luck:) Carolyn:)

Hi Prao, Have you tried creating a report. You can use the report wizard to create it for you in the format you desire. I frequently make reports and then email them by simply right clicking on the report in print preview and select send. This sends the report to Word and then you email...

Thank you Alex and Rich. I saw your post after I posted the solution. I appreciate all your help. This is a wonderful forum for people like myself that need the assistance. BTW thanks for the compliment "Lady"........I do my best:).......Kind Gentlemen:) Carolyn;)

Hi, I found the answer and it actually works! Screen.PreviousControl.SetFocus SendKeys "{tab}a{tab}a{tab}{tab}click" DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 Exit_Command70_Click: Exit Sub Err_Command70_Click: MsgBox Err.Description Resume...

Thanks Alex, I had already checked that out but it doesn't seem to provide the options that I want to change. I guess I should mention that I am using 97. Perhaps 2000 allows use to change the defaults there but 97 doesn't get specific enough. Any other ideas?