Search results

Thanks vbaInet, problem is I always get a circular reference error, sorry for the late response.. Just couldn't get to a pc.. Somewhere I must have made a big BooBoo.. Just unable to find where..

Hi vbaInet, thank you for this lesson, usually I would do your suggestion but in my frustration I just tried about everything on the internet. Take into consideration a 17 year old daughter with a baby and I am sure you can imagine what that does to the mind.. I can a sure you that doesn't...

Found that Guinness and Access don't go very well together..:confused: Killed them all, removed the brackets, no more errors, but TxtTurnover stays Blank.. I am in doubt what to put in the Query, Where or Group by at the D_Date column..

Thanks for that, So I have changed this to; =DSum("[DayTotal]","[QryDayPurchase]","[TblDocket.D_Date] =" & [TxtDate]) also tried; =DSum("[DayTotal]","[QryDayPurchase]","[D_Date] =" & [TxtDate]) When I load the form I get error# in the TxtTurnover textbox, probably because no date exist in...

Have done the third argument; =DSum("[DayTotal]","[QryDayPurchase]","[QryDayPurchase]![D_Date] = " & [Forms!frmMakeCash!TxtDate]) Might not have been the right thing, but this I understood, Tried to do the # # in and out of the brackets get #Name? so not yet there. Should have sticked to...

Got the form back by removing the 3th argument, still get the total of all purchases, and sorry to ask but queries are really new to me, how do I get this form to show the Turnover amount for the given day with the date picker and where would be the best place to re-query.. Sorry guys... for...

Did try and now the form doesn't work anymore :confused: But the TxtTurnover box start blinking and showing error on and off.. I must be on the wrong way.. Wasn't stable from the beginning so I must make a mistake somewhere.. The joys of learning ..:)

Thanks for your help, I don't see where I can do this as I use the builder, my knowledge is low so to say. I have it working except changing the day on the form does not do anything, I get a full total in my TxtTurnover field what ever date I choose. When I take the Forms!frmMakeCase!TxtDate out...

Dear Friends, for days I try to work out a way to make a form that will allow for the input of a date(textbox with date picker), a amount of euro's in cash Textbox and then a query to calculate the result of that day from the table, then a textbox that will deduct the query result from amount of...

Thanks Uncle Gizmo, My friend has a weigh bridge that operates with a Bilanciai D410 head and a small docket printer. This setup has no back office and every docket is manually entered into Excel. , I am getting to the stage where I want to read the data of the head into my Access program. It is...

Hi RuralGuy, thanks for that, it comes very close to what I have in mind, however there is on problem.... my programming skills, I will look at it and try as learning is part of the process as well, I would easier understand something closer to Access I think.. Never the less... I will try and...

Hi All, Afraid I am going into uncharted territory here myself, I would like to ask for advise. In my application I need to read a serial port value into a TextBox called TxtWeight, I tried to use one of these programs on the internet but this gives me problems and only one out of every 20...

Busy trying to work out my second access program I really did not pay attention to this section. I was here for the help wasn't I? And boy I did get help, therefore it is my pleasure to write a little in this section as well. Years ago I made an Access application for the school where I was...

Hi vbaInet, thanks for looking and suggestion.. Me.DM is the first check that should be done, it contains the records that are not priced yet, when priced they show up as Buy or Sell.. Will sign off for the night .. Paracetamol was no help.. Coding when sick is not a good idea.. Will try...

Thanks John, this gives some strange behaviour, I think something has to be added to this statement, however I have a splitting headache so I will look at this tomorrow when I can concentrate. Will let you know..

Hi All, Would like to ask for some advise, I have two subforms that I make visible when needed, now I would like to cycle a third form sfrmQryBuyUpdate. This form is depending on Me.DM False or True and should have priority over the two mentioned in the code.. If Me.Sale = True Then...

Guess we ran out of reruns of Man United?? :rolleyes: Should go to bed, didn't sleep for three nights.. There is so much to learn, but I seem to be getting there.. Probably not as it should but he..it works..

Thanks for looking, somehow I must have pasted the code on the on click of the text box, removed that and it works.. See what would I do without your inspiration.. :D

Both are numeral, I checked, from table to fields, ID is AutoNumber as it is an order line and the price is standard number, when debugging and hovering over the txtUpdateID, debugger gives me a value of Null.. But I can't even input a number in the text box.. Strange.. When I don't debug and...

Hi All, Happy Valentine :) On my form I have 2 textboxes named as in the code, there is also a query that shows the current order. All is there except for the price, so I thought to input the price ID number in a unbound textbox and run the Update query below. I was wrong, when I click the...