Recent content by T13v0hz

I have a mailing address subform embedded in a customer form. When I type in the subform, an error pops up saying: This property is read-only and can't be set. However, the form, subform, query are all not read only, everything allowed, not locked and all the rest. I have no trouble entering...

I added the DoCmd.Runcommand acCmdSaveRecord. Tried it again.. Still blank. One Page. No data. ?? I don't get it I have 140 records there when I bring the report up normally, and they are definitely all saved. Do I need to specify all the data to go on the page because I have more data on the...

Problem solved, Thanks all the same.

I get the error on one of my forms which has two subforms embedded, which all run the same primary key. I keep getting the error: The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'Jobs." Jobs is my main table and I can't get a...

I tried with square brackets and with me.Jobs_Job_No and I get the report to pop up but it contains no information. Now what can I do?? Also, should I get rid of all these spaces between names, and how will that afffect the rest of my tables, forms, etc etc etc??

I have tried this with my code: Dim stDocName As String stDocName = "Service Report" DoCmd.OpenReport stDocName, acPreview, , "[Job No] = forms!Service Job Card![Job No]" However, I get the error message: Syntax error (missing operator) in query expression '(Job No] = forms!Service...

How would I make a report that only shows one page of information based on a query?? Can I make a query that can only display one row of data at a time then have a macro that requires the user to select the row (based on the primary key) that can show on a report? Could I create a button on...

I need some help with my macro. I currently have 80 seperate jobs which will grow to 450 by the end of May. I have created a macro to select print or print preview of these jobs, but I'm having trouble bringing up only the job selected from a lookup table. It always brings up the first job in...

Thankyou, I'm sure this will help.

I want to be able to select the jobs for one month by selecting the month not the date (currently "Between [Enter start date] And [Enter end date]"). The year is important. Is it possible to say 'y = now' or something similar? I don't want last years "April" coming up with this years. I have...

Is it possible to have a select query that looks up by the month selected? ie. in a parameter query. Should I make a lookup query that has a list of months because access always needs to have a full date not just a month or year? or Should I make 12(!) querys, one for each month? What do I do...