Search results

Excellent! I'd like to use example 1. I've adapted the module and created the command button. I;ve created the event as below: Private Sub Command269_Click() addNewId End Sub Private Sub addNewId() Dim strPrefix As String, varResponse As Variant If Mid(Me.ReportNo & vbNullString, 3, 1) =...

Your correct this number will be going in the report number field. However this could be duplicated across many lines, ie when multiple serial numbers are on the same report. Also there could be many other variants in the report number field, such as "repair" or "Cut out" so it can't be...

Morning Nanscombe, thanks for taking the time with me on this one. I've added a new field to the badly named table for this use. the table is called "Job Register and report Log" and the new field is called "generaterptnumber" I've now created a new module using the code you supplied...

Afternoon all, and many thanks for the replies! I think I had better explain better... Here's how our database looks: The numbering system isn't entirely as I described before. Yes there can be a null value, or any other text entered. However, what I would like is a more automated way...

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

Hi VbaInet, Thanks for the response. When we receive a new procedure that is a newer revision to one we currently have in our system the database is updated to reflect the latest revision number. The previous file in I:\Specifications & Standards\Current Documents is moved to...

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

Thanks a lot for this, I've finished off the query and report and everything works lovely. I had to use the Job No as the unique reference as the serial no field can be duplicated many times i nthe same table. So, problem solved, onto the next one! Thanks a lot gents.

Thanks for the quick response! Can I explain a little more in the hope of getting a more tailored answer? The form we use is shown here: The data is built from two tables, a customers table and a Job register and report log table. Don't ask me why it's named that way, I have no idea...

Hi everyone. Please excuse my somewhat limited knowledge on this one! We have quite a large split multi user database. It is utilised by a number of forms. What I would like to do is create a report that outputs a page based on the details of a current record within a form. IE I would like...

That works. Strange though! VAT now reads =(Sum([Job Price]))*0.175 and Grand Total reads =((Sum([Job Price]))*0.175)+(Sum([Job Price])) And after closing and re opening access, it still works. Lovely!

Hi Everyone! I have a report that builds a customer invoice. There is a sub total, VAT and Grand total figure. The sub total called txt100 does =Sum([Job Price]) the VAT figure, called txt101 does =(([txt100]/100)*17.5) the grand total, called txt102 does =([txt100]+[txt101]) Which...

Sounds like a plan! So batman, what should we do? :D

[Access 2007 automatically puts the = in I think. Anyhow, this is what i have in the default value field on the Job register form: =Right(Year("Date"),2) & "/" & Format(Nz(DMax("Right([Job No], 5)","[Job Register and Report Log]","Year([Date Rec]) = " & Year("Date")),0)+1,"00000") And I get...

No worries :-) I've copy / pasted that code in to the default value of Job No field in the form and i get #error in the Job No field... The Date Rec field is set to default value date() so it will always contain the date the job was booked in.

don't suppose you had chance to take a look did you? I have staff back in on Tuesday and I'd like to get this one in place. Ta!

Thanks alot: it's 11pm now, heroes has just finished so i'm off to bed. I'll check back in tomorrow around lunch, when your just getting up :-) Thanks again!

Noo dont get me wrong! it was intended more as a sarcastic funny remark. The responses are sharp and the information given is always on a very helpful and well explained way. I know where to come for my access issues from now on! I appreciate all the help you give :)

Home time is 5pm :-) Gotta love the time difference. As you have probably notice my access knowledge is somewhat limited. I don't really want to start messing about with things I dont really need to. The reason I'm doing what i'm doing is thatthe Job No field used to be the primary key, and...

email sent, i;ve gone home for the evening but will check in later on from home :-) Thanks for the help on this one, looks like I really need some more experience with MS Access.