Search results

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

I have a report which is linked to a table which holds order information. Within the report i have included a subreport located within the detail, and obviously it is repeating the detail for as many pages as there are records in the table. How can i prevent this? I only need to read/access the...

Fantastic explanation thank you! Slowly learning how different VBA is from VB6, simple things like that make a huge difference. Thanks again

Like i said i'm new, was trying to reference text boxes directly by setting focus to them then retrieving there .text This then caused the 2950 Error now using Me.ControlName.Value instead, whats the difference between .value and .text for text boxes?

okay finally solved it, changed my code to this: Private Sub Report_Load() Label17.Caption = "Thank you for your purchase order " & Me.PO.Value & " received " Label17.Caption = Label17.Caption & Me.Date_Received.Value & "." End Sub directly referenced the bound fields.

i'm trying to string together the contents of 2 bound controls into a label with some other text inside. Bad coding i know but cant think of any other way, fairly new to access.