Search results

Running out of time and getting desperate. Please forgive me for posting in tables forum also. I am trying to do a parameter query and I am getting this SQL error when I run the report off the query. The query works by itself. Here is the error... The specified field '[LAB ID]' could refer...

Hi, Yet another problem, big surprise. I am trying to do a parameter query and I am getting this SQL error when I run the report off the query. The query works by itself. Here is the error... The specified field '[LAB ID]' could refer to more than one table listed in the FROM clause of your...

Can a datasheet from a table have many sub datasheets? I have a project number that can have up to thirty tests performed on it and I would like to show all the tests listed under the project number as a sub datasheet. I was thinking a query might be better but I wouldn't know how to do this...

Hello, I have two tables which are linked together by the Client ID. One is a Clients Information table and the other is a Project Details table. When I try to save a new record to the Project Details table it gives me this error: You cannot add or change a record because a related record is...

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!

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...

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...

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...

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...

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...

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...

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...

I am trying to figure out how to display the scientific notation in a different format t than access uses. Access uses 1.815 E 6 I would like to display it as 1.815 x 10 supercript 6 (but not the actual word superscript of course) Does anyone have a clue how to do this? Thanks

I am very new to access. I am trying to make a form to start a project. I have a CUSTOMER who brings a PROJECT for me and each PROJECT has many SUBPROJECTS. My PROJECT-ID and SUBPROJECT-ID are both autonumbers. I am trying to 1. open the form 2. pick a CUSTOMER from a list box. 3. Push...