Search results for query: *

Hello MVP's, Your code works excellent, it will now bring up the newly entered record in the report. It makes total sense access never had a chance to save the record to the table so the report showed no data. You MVP's are the best!! AS you MVP's can tell my VBA skills are 0, I kinda no...

Hello Pampers, Thanks, I'll just need to be me more aware of my wording. I did notice one minor thing that I'm trying to figure out, when I click the print button on my form which runs the code you genioursly gave me it will not bring up the newly entered record that is in the form the report...

Thanks Pampers, Your Code works excellent. I appologize if I came across as being dis-respectful, by asking for help in the following manner: (I need to make) I should of thought to reword it more respectfully. My bad. I really do respect all the Tek-Tip programmers and your time, in the...

Hello Pampers, Thanks for the suggestion, I'm not sure how to check to see if my screen capture is in color. I made a report and it printed in color, but I don't know how to have my report print from my form. My forms name is invoicefrm its record source is a table called invoicetab, my...

Hi, I have 5 forms that I print, 3 print in color and 2 do not. I can not figure why the 2 won't print in color. I'm using a macro (printscreen) in the on click procedure of a command button, which is the same macro for all five forms. Any suggestions on why this is, would be greatly...

Hi, I have some code that is suppose to run when the database is opened, I'm hoping it will copy a form from the database that is opened into an existing database on a clients machine, It will over write there form with this new form both forms have the same name. I don't know where to place...

Hi, I have an access 2003 program that I’m currently working on that I intend to place on the Internet for sale. I plan on selling it with the option of upgrades / add-on forms My question is what would be the best way to insert these upgrade/add-in forms into their remote database. One of the...

I figured out what was causing this error,I had Norton script blocking enabled, Once I disabled this every thing was fine. Thanks HandsOnAccess and PHV for all your help, I appreciate it.

Hi PHV, Yes I just tried it, and it gives the same error. (A problem occured while MS Access was communicating with the OLE server or ActiveX Control) Close the OLE Server and restart it out side of Access, And retry operation again. Reinstall OLE to make sure it is registered. It says to...

HandsOnAccess, I did get it to work on 2 other computers, but for some reason I can't get it to work on my main computer or my laptop. They both give the same error (A problem occured while MS Access was communicating with the OLE server or ActiveX Control) Close the OLE Server and restart it...

Hi HandsOnAccess, I did as you said except when getting out of design view and going to normal view, I recieve and error saying (A problem occured while MS Access was communicating with the OLE server or ActiveX Control) Close the OLE Server and restart it out side of Access, And retry...

Hi, Can I place an MS Word .doc document into an access 2003 form? If so please explain how? Thanks--I appreciate all help.

Hi, Can a Filter By Form Macro be converted to a VB Module code and then the converted code be placed in onclick event procedure of command button in place of where the macro was that was working fine and have it work like the macro did, in Access 2003 Reg mode, Not Runtime mode? If so I sure...

Same results as the 97Qbf.exe I even checked the DAO as readme instructed in visual basic editor. Thanks PHV--I really appreciate you trying, I may have to out source this, I'm not real good with SQL or Code. But at least I have a couple of example ways it can be accomplished. I appoligize...

If I was to pick lets say (client) and (address) as the 2 fields to apply a filter to and lets say the user selected client and entered the clients name or chose it from a list using a parameter query, and clicked it and then clicked a command button called filter with a sql statement or code...

Hi PHV, This will not work in my case, I just tried it. It gives error after error, on all forms in my DB. Maybe because its made for Access 97 and I'm using Access 2003. Thanks any ways PHV--I really appreciate your help. Do you have any other suggestions, otherwise this will stop me dead in...

Sorry, It brings up a little box that says the (runcommand action was cancelled) I click OK and it brings up another small box that says (OK) so i click Ok and it brings up another little box that says (Resume with out error) I click OK and it goes back to the same blank little box again, it...

Hi PHV, Sorry about the late response, Yes I have Access 2003 Installed, but not office 2003. I think I'm going to spend the money and use SageKey MSI Access 2003 Wizard, I've heard this is the easiest and most stable way. I have been told I need to convert all my macros to Vb code modules, for...

Hi, I appologize about the late response, Hi lupins46, you mentioned that filter by form is not available in Access Runtime. Is there an alternative way for me to filter to the record I need, which will run in Access Runtime. Hi MichaelRed, you stated the conversion does not necessarily...

Hi, I'm testing my database in runtime mode, I came a cross a macro that gave an error so I converted it to a module heres the code it generated= Function Find_Applicant() On Error GoTo Find_Applicant_Err DoCmd.Echo False, "Please Stand By" DoCmd.Hourglass True DoCmd.RunCommand...