Search results

I have a form where I am trying to open a report from a check box. The form has a sample ID and I am trying to run the report from the query for this sample ID. How can I pass this to the report so the report opens for this sample ID then prints, then closes. Thanks!

THANK YOU! It is working!!!!!! Thank you so much for your help and patience!

I am trying to add a new record to the table and the form is not bound to the table. Thanks!

I am new to VB and am having some problems. I am trying to save data into a table from a form. I am getting an error message "can't find the field '|' referred to in your expression" and it refers to the line that reads Table1a.AddNew. Thanks! (This is my first encounter with both Access and...

Ok. I made some changes and can see that I was way off on my code. Here is my new code, is this a bit better? It still doesn't work but am I on the right track here? I am getting an error message "can't find the field '|' referred to in your expression" and it refers to Table1a.AddNew...

Hello, I am trying to use a check box on exit function to open a table, add a new record, save the Lab ID in this new record, and close the table. But when I run it I get nothing in my table. Help please! Private Sub Ctl6_Functional_Groups___Enum_Diversity_Exit(Cancel As Integer) Dim BBCNum As...

Thanks PDX_MAN! Exactly what I needed.

I am trying to print a form on Close if a box is checked. What is the best way to go about doing this? Thanks, Smelly

Hi, I am trying to make a form based on a microsoft WORD "table", but the problem is that I need to be able to pass some values into the cells. I have been designing this table in excel and passing the values in that need to printed on the sheet when it prints up. Is this the easiest way to do...

Wow, Thanks for all the info. I appreciate it!!!

Hi, I have a form where I am passing the values on a click routine to another form. If the fields aren't filled in upon passing I get an error message that the field is null. Can I fix this so the values being passed can be null? THank you for any input!! Here is my code. Private Sub...

Thanks!!

I am trying to pass a value but when the form opens it has the wrong value in the text box. When I open the form again the correct value is in the text box. Does anyone know what is going on? Here is my code... Thanks, Going Nutty! Private Sub Command22_Click() On Error GoTo...

Yes!!!!! Thank you it worked. The error was from my table but the code is working!

Thank you but I am still gettting an error message. I am very inexperienced with this and will keep trying to figure out where the error is coming from. Thanks!

I have been struggling with this for a few days now. I am not a VBA programmer and am trying to write the code to pass a project Number from FormA to FormB. I have a button which I am trying to put the code for an ONClick procedure in. I have tried a couple of things and searched the forum...

I am trying to pass a project number from form A to form B. I have a button which opens form B with a procedure as follows...... Private Sub Send_Number_Click() stLinkCriteria = "[ProjectNumber]=" & Me![ProjectNumber] DoCmd.OpenForm "Practice2", , , stLinkCriteria End Sub but this is giving...

Hi, Thanks in advance for any help! I am trying to pass a project number and a company name from one form to a new form. I have the project number and company name on my first form and when I click the "open second form button" I want the project number and company name fields on the next page...

Thank you! (I am writing my first database and appreciate the help.)

I have an autonumber field for a new project number (the primary key). But I never can actually get the project number to fill in, it says autonumber in the text field at all times, I am trying to have the form open with a new project number displayed in the field. Please Help! THank...