What line does the compile error happen on. I really don't see a problem with the code. "georgiaboy" wrote: Almost I think Yes ProjectNumber is a text...

The compile error is "Method or data member not found" A Blue highlight on .Text17 in line '" & Me.Text17 & "'" When I click OK the arrow is on Private Sub...

Easy question I am sure...I am a very newbie... When I clear the relationships window, does it delete the relationships? I ask because when I saved the...

Check the name of the control to make sure it is correct. It is saying it can't find Text17 "georgiaboy" wrote: The compile error is "Method or data...

I appreciate your patience.... I deleted Text17 and added a Combo Box The error message and compile error is the same with the following code: Option Compare...

You said earlier that ProjectNumber is a text field in the table. Is your form based on the table or on a query based on the table. Be sure it is actually...

Combo20 is Row/Source Type: Table/Query Row Source: TBL-ProjectTracker No subform. Be sure it is in the form recordset? "Klatuu" wrote: You said earlier...

I am having a major problem..a newbie!!! I have designed a table and when I attempt to save it I get an window with the message "Could not find field...

it is an embedded feature of access build a Form using Form Wizard off a table or query..... give the Form a header, then add a combobox to that Form's...

hello ppl i would like to know if i can use the null value as the defualt value in a "number" data type field and how i can do that...and if i want to make a...

Sorry, I don't know what to tell you. The code looks correct and from what you have been telling me, I can't see any other problems. "georgiaboy" wrote: ...

I am a rather new user of Access and am having trouble understanding the use of formulas or as I believe access is calling them expressions. I have fields...

Null is the default value for all fields regardless of data type as long as no other default value is specificed either at the table field level or at the...

Using Access 2000 I have created a control panel which opens mazimized on_load. Some of the forms its command buttons control are small. I open...

Hi Pammi, To open a report using code, have an behind the On Click event of your button. Use the following: docmd.openreport "REPORTNAME",...

Hi, I have two linked tables with a one-to-many relationship. TABLE1 Model Number (primary key) type Comments

I have an orders table that I have the customerID field with a one to many relationship to the CustomerID (primary key) field in a customer table. I want to...

Hi Matt, You say that you want the data to store in the Item record... this means that an Item can only ever have ONE item type... To handle multiple Item...

I've logged onto Microsoft Access online to learn how to use Access. I downloaded a template but I don't get any further than the extraction; I can't open to...

If I understand correctly, you may need to find the file in Windows Explorer and right click it to view the properties. Then click the Unblock button. --...