Search results

I'm no expert here, but here are my thoughts on the security issue: Set up your DB so that the table data is filled in via forms - probably one for confidential info and one for non-confidential info. But all of the data should be in one place. Also set up your report. Make sure security is...

I'm still learning this stuff, but could you set up an update query to do this, and have your button just run the query?

OK - thanks for the advice. Since it was the formatting of the primary key field that was causing the trouble, I put in a workaround that seems to be working OK. And at least I understand why it isn't working. I appreciate the help - as I said, I'm very new to this sort of database creation...

Let's try this again... The "Register_Form" is the one that's giving me the trouble, although it is basically a copy of "Register_New_Factory_Order" which is the one that I was originally working with. I created "Register_Form" from scratch to try to fix the problem. It is printing...

I'm having some trouble posting it - probably has to do with my company firewall or something. I'll upload it tonight or tomorrow from home. Thanks in advance for all of the help - this has been driving me crazy for the past week.

Now it opens the "printing box" but them immediately prompts me to enter a value for Primary_Key - like the field name is really a parameter. I tried referencing it as [Forms]![Register_Form]![Primary_Key] but it didn't like that either... I think we're getting closer - I appreciate the help...

Thanks for the info on the record saving - I haven't used that function before. I didn't play with either the close or the save function yet - I didn't want to change too many things at once. But I did change the print command to: DoCmd.OpenReport "Process_Sheet_Report_Generic"...

I'm not an expert around here, but I've done this a couple of times. 1) Your address field should be a combo box. 2) Go to the "Row Source" property and hit the button to edit it. It will bring up a query window. 3) Bring down the address field (I'll call it "Address") and name field...

OK, this one is bugging the heck out of me. This worked fine until two days ago, and now it just stopped and I can't get it to work. Basically, I'm trying to do a couple of functions with a button. I want to: Populate a couple of fields based on data that the user entered Save the record Print...

OK - quick update. It looks like the print preview works fine if I hit it from From view, but it looks like the printout (blank spaces) when I hit it from Design view. Hopefully that helps....

Hey all. New to the forums. I've done some basic stuff in Access before (mostly data mining an queries), but I'm relatively new to forms, reports, and VB so please bear with me. My problem is this: I have a form that I want to print. The form has some data up top, then a subform that...