Search results

its not, should it be? this is a database Iv taken over as the chap that complied it left, now Iv been task with making some changes

The first line (Me.Text505 = Nz(DMax("MyCounter", "tblAttributesGA")) + 1) doesn’t run until the user has clicked in a field so the second line has no data. Text505 is bound to MyCounter, txtGADrawingNumber is bound to GADrawing in table tblAttributesGA Let me put it another way, when a form is...

Good idea, but all I get is #NAME? in the txtGADrawingNumber textbox.

Hi Im using this VBA code to insert a drawing numbers for our engineers. Private Sub Form_BeforeInsert(Cancel As Integer) Me.Text505 = Nz(DMax("MyCounter", "tblAttributesGA")) + 1 Me.txtGADrawingNumber = Nz(DMax("MyCounter", "tblAttributesGA")) + 1 & "-01" End Sub At the moment the form will...

I have the query below working but I need to modify it to only calculate fields where the Approval field in my table is null or empty, I have tried adding the Approval field to the query but the DSum just ignores it, I think the Approval field has to be part of the DSum critiera RunTot...

thanks guy, worked a treat.

I have a select query that sums the yes/no data from a table by month and year, Im only interested in the yes (-1). Now I need to use this data in a chart but as it sums, all the numbers are negative giving for example -7 for june and this makes the bars on the chart go down. How can I get it...

How did you fix it?

oh, "walks away and bangs head on wall"

lagbolt I tried your Dcount code, works just how I want many thanks. But my company is looking to move from XP to windows 7 soon so I would be interested in what Boblarson mentioned

Bob sorry but Im not understanding how youd use this VBA.Environ("username") Im using Environ("username") in the code now.

Hi Basically Im using a table with users login name for permissions on a form, if the user name is anywhere in the table they have permission. the id number is not really all that important, just so long as the user name is in the logon field The Dlookup is in the forms load procedure. I have...

How can I rewrite this code: If DLookup("[logon]", "Employee", "[id] = 1") = Environ("username") _ Or DLookup("[logon]", "Employee", "[id] = 2") = Environ("username") _ Or DLookup("[logon]", "Employee", "[id] = 3") = Environ("username") _ Or DLookup("[logon]"...

is that why the dsum is not working?

thats not what I ment, I ment dont be to scaving about the mess I'v made of the form, query. Im sorry you feel I ment your previous replys.

Don't be to scaving..

Theres not a problem with adding the fields they all have "0" default. the code works for the first record only, thats my problem.

How would that work with the select case? some months has 5 weeks and some 4 weeks, it's different every year. I could do it with a form and query for each year, but Im sure theres a better way.

I’m creating a database of time spent weekly on a project by an engineer. I have a multiple items form “frmhrsweeklyinput “ with bound textboxes from a query "qryHrsWeeklyInput" in the detail section of the form ”task” “week1” “week2” “week3” “week4” “week5” then at the end I want to add these...

Ok who are your solicitors.