Search results

Hi all, I've created a form, frmTechniqueAllocate that displays data from the query qryTechniqueMasterFilter On the form I have 4 unbound text boxes, the idea behind these is to allow the user to progressively filter the results to find what they need: Unbound text boxes: CustomerFilter...

Hi all, As per the subject I'm attempting to make Text104 mandatory if any of a series of other fields contains a value. So far I have: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim addlength As Integer addlength = Len([Text106] & [Text108] & [Text110] & [Text112] & [Text114] &...

Hi Everyone. I have an ongoing issue where related records are not found by the users. To stop this, I'd like to try and display related records in a datasheet view sub form on our main form. So, I have the following table: MainTable with fields: PKfield (unique autonumber) JobNumber...

Hi All, I'm using this function: Public Function WorkingDay(StartDate As Date, NumberOfDays As Integer) As Date WorkingDay = Excel.WorksheetFunction.WorkDay(StartDate, NumberOfDays) End Function To find x number of working days from a date entered. I need this in a few places, one of...

Hi everyone, I have a bit of code that checks a number of fields in an excel sheet before finally saving it and creating a pdf of the file. I've had to amend the code slightly today in order to cater for a new clients requirements. However, when running the scripts, it stops after changing a...

Hi All, I'm trying to work out some invoice due dates. I have the following code: DUE DATE: Format(IIf([account terms]="30 days EOM",DateSerial(Year([TaxDate]),Month([TaxDate])+2,1),IIf([account terms]="60 days EOM",DateSerial(Year([TaxDate]),Month([TaxDate])+3,1),[TaxDate])),"Short Date")...

Good afternoon, Apologies for this being excel and not access, I was hoping someone could point me in the right direction. I'm trying to break up a save and create pdf module to check for the existence of the file it's about to create. I've managed to get a cell to display TRUE or FALSE if the...

Good morning all, I've had large amounts of help on here to further develop our badly designed database :-) The next stage I'd like to include is a match and enter pricing details. We get a lot of repeat work that is entered onto our system, due to the nature of the work we do each item is...

Morning all. I'm trying to place an if statement in an afterupdate event on a form. the code I have is If [Customer] Like "BRO001" And [Inv No] is null Then [Job_Price] = [Shots] * 27.5 this gives me a run time error, object required and highlights If [Customer] Like "BRO001" And [Inv No]...

we have a calculated field in an append query Line_Cost which eventually creates a purchase order. We have to have a minimum order value of £1500.00, so, we need to total the values before running the append query. best way?

Morning all, I'm trying to get my head around something. I understand we should not store calculated fields. So on our purchase orders we have a price list, where the totals are calculated on the report. We have a form which shows historic purchase orders and the prices paid at the time. We...

Hi all, We have a table, JobRegister that people enter information on using a form, FrmOrderEntry I would like to run a check when a serial number is entered in the field SerialNo to see if the same serial number exists where CompletionDate is null. this would stop duplicate open orders being...

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...

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...

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...

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...

Good afternoon all, We have a large split database with 3 users on a single site. We will soon be increasing this to 6 users across 2 sites. One of the fields in the main table is "report number" where a line is given a unique number. Not every line is given this number, as it depends on the...

Good afternoon, We have an extensive library of specifications that are all in PDF format. We allocate an internal number to the documents and the pdf files are names accordingly. The database side of this system controls revisions and acts as a library listing, making it easier to find the...