Search results

Apologies, I was attempting to simplify the dismal naming of the items within our database. I'm hoping my follow up response made more sense?

Haha ok that's a fair comment. Let's say I have two tables that similar information is entered into. Quotes & Orders When a customer sends in an enquiry we usually get a copy of the drawing. so We record all the information relating to the drawing number in the "Drawing No" field. This will...

Afternoon all, We have a form with a field Drawing No from the Table Job Register I want to be able to take the first part of the drawing number and display all matching items from the quote details table. Aesthetics I can sort later. I've created a query Item History. My...

Genius. Thanks :-)

I've actually tried that, but can't figure out how to get it to work.. Private Sub Customer_AfterUpdate() If Len(Me.[InvoiceNumber] & vbNullString) = 0 Then Me.[InvoiceNumber] = (DMax("[InvoiceNumber]", "[tblInvoiceNumber]") + 1 & format([InvoiceNumber], "00000")) DoCmd.RunCommand...

Afternoon all, I'm trying to get an invoice number field to auto generate the next number, keeping the format as "00000" this is what I have, which gets the next number but drops the leading 0 Private Sub Customer_AfterUpdate() If Len(Me.[InvoiceNumber] & vbNullString) = 0 Then...

Indeed the design is flawed, but we have to work with it. We've solved the issue by using an append query. Thanks for your response.

Hmm.. yes, but that's not entirely essential.

Hi and thanks for the reply. Yes, I need to duplicate the information. We review a standard, and create an entry for it in the standards table. the standards detail table contains the variables depending on what the customer orders. The orders table is where the order processing is done, and...

Good morning all. We have a database where we are trying to limit the amount of data that users need to input. We have a form, which contains order information. Where a customer has specific requirements, we add those requirements to a separate document review table MasterSpecification...

Good morning all, I've hijacked a simple audit trail from techrepublic and implemented in our main form. the code is as follows: Option Compare Database Const cDQ As String = """" Sub AuditTrail(frm As Form, recordid As Control) 'Track changes to data. 'recordid identifies the pk...

Looking at that, no it doesn't need to be in the table. Although, we would be using this field for analysis across a range of reports and users. Wouldn't I need to make sure all users knew how to add the field into the query they create for any existing / new reports? If that's the case, for...

Morning All, I'd like to further automate our invoicing system and need a field which has the last day of the month an item was completed. Currently we have a field in the table called [Date Done]. I'm planning on adding a further field [Tax_Point]. I'd like the field to select the [date...

Morning all, I've had a lot of help on here recently automating fields in our database to enable me to share it across our new VPN. This is now up and running however we are now seeing massive performance issues with our everyday form as it pulls all 84000 records directly from the table...

Got it working, many thanks! When I tab to Customers, although its a drop down, pressing down arrow moves to the next field. Any way to stop that? Sorted that one too. Thanks for all your help here guys. Absolute Legends!

The format is different though? report number has 4 digits and job number has 5, will this not matter?

Works a charm! Many thanks! Next one.. The Job No field is a unique number for each record, again using the format yy/00000 I'd like this to be generated on entry. I've adapted the module code: Public Function nextJobString(ByVal njsFieldName As String, ByVal njsTableName As String...

Yeah I know about spaces and correct table naming. I've inherited this database as you can probably guess. It's fun... :o

The table "Job Register and Report log" is the record source for the table, however if I change the field "Report No" to "ReportNo" in the table wont that make a mess of all my other related stuff?

I thought Me.ReportNo relates to Me.ReportNo = nextIdString("Report No", "Job Register and Report Log", strPrefix) as apposed to the filed name?