Replies

So it would be best to create a application through someting like visual basic and then publish it?

Thanks Hans. You are the man!

Yes, I want the first two characters of job number to be equal to txttempyear which is a text box on the form i am using. I believe it is a variable in VBA code.

Thanks HansV, the primary key on the second table was not set. Once again you solved the problem!

Both queries are select queries. Here is the sql for the query that I am having the issues with. I think there may be a problem with the join operation, cause if i take the tblJobNumbersLoc portion out of the code, it works fine.

SELECT tblEntry.[Emp#], tblEntry.[Job Number], tblEntry.[Activity Code], tblEntry.[Week#], tblEntry.Year, tblJobNumbersLoc.[Billing Code], tblJobNumbersLoc.Description, [Billing Code] & [Description] AS combine, Left([Billing Code],7) AS [Part of Billing Code], tblJobNumbersLoc.[Customer Name]
FROM tblEntry INNER JOIN tblJobNumbersLoc ON tblEntry.[Job Number]=tblJobNumbersLoc.[Job Number]
ORDER BY tblEntry.[Job Number];

Thanks HansV. That worked perfectly.

there is no control source because when i put my query in for the control source it still gives me #Name? in the textbox
If I put the following code in the control source or the default value i get #Name? in the textbox
=[quCurVac]![SumOfSumR]

I thought you had to reference the values in the calendar with an underscore. Oops
Thanks,
Nick

i see that, but i couldnt figure out how to reference that in the code. here is what i have:
Private Sub Calendar0_AfterUpdate()
txtdate.Value = calendar0_value
End Sub

i am trying to fill in a text box with the date that i click on

How to I reference the date I click on. The actual date is a value in the properties box, but I dont know how I call it out in code.

Here is my code. For some reason on the striped down version, the form isnt opening in read only mode? Help please!

I will check, if i still have problems, I will post a version of the database.
Thanks

When i put those lines of code in and then select the button, the form still is in read only mode. any other thoughts

Thanks HansV, that worked perfect.
Thanks again,
Nick

Here is a versioin of the database.