Recent content by gowans07

Is it possible to create a customer format like 0235-ABC Where "235" autoincrements and "ABC" depends on a related record in another table? Obviously it would have to be text format due to the leading zero and once it gets too 999 to bump over too 1000 etc Accepted strings: 0111-ASD 1021-ERW...

Perfect Solved!!! Change a line in a different event for the form to = Null and voila it works! Thanks for your help and speedy responses Bob!

Yes, the subform is requered upon TxtProductRef being updated. So the query ran referecences Forms!Frm_Order.TxtProductRef

That is also another Append Query, it moves values to a temp table for proccessing at a later stage. Changed all to Me."controlname" still same prpblem.

Yeh sorry about that, the ones ending _RecordSave are both Append queries.

d.O Its just weird that it works the first time and not afterwards. I had this working a few months back too.

Hey, I currently have a form with a subform in, used for a simple order proccessing system. The subform contains details about products. When i first open the form details are displayed correctly in the subform, when i click a button which will allow me to add another product to the order i get...

Exactly what is trying to explain, thank you! Will give it a go :)

Thanks for the reply, should of mentioned which version i am using. On saving as pdf code above, if the report is already open and i use the docmd.openreport will this create an error? Also what does the where statement refer too? Tried a variation of this but get the error: This action can't...

Just checked the sql for the Report, RecordSource. There's no JOIN located in there... or am i being thick?

Thanks for the replies, yeh its fine i wish to update all the records within that table, its a temporary table in which when an order is in process it is held in there, once its completed the records are deleted from the table.

Awesome managed to solve UPDATE Tbl_TemporaryDetails SET [News Item] = [Forms]![Frm_NewsSelector]![TxtNewsItem], [Web Link] = [Forms]![Frm_NewsSelector]![TxtWebLink];

Table to be updated: Tbl_TemporaryDetails Fields to be updated: News Item and Web Link Control names in Frm_News: TxtNewsItem and TxtWeblink Primary Key in Tbl_TemporaryDetails: Order Number Cheers

I have a report which has a subreport located within a group header, i'm trying to save the report as a .pdf via vba The name of report when saved will use some of the values located within the subreport. How can i access these values, or atleast move the recordset on by one when generating the...

I'm trying to create a query in which depending on which record is selected in Frm_News it will add that record to an existing record in Tbl_Temporary details. Is this possible? Thanks TG