Recent content by wrightie

Managed to sort it. Apologies if I wasted anyones time. I changed the query section to below and now works fine. Set QD = db.CreateQueryDef("Qry_By_Period_Entered", _ "Select * FROM Qry_By_Ccy where [PeriodEntered]= " & [Period_Combo] & ";") wrightie

Hi, I'm hoping someone can help. I'm pretty sure I've missed or done something silly here. When I use the code below I get the message "Run-time error 13 type mismatch" . I'm not sure if it has anything to do with it being a numerical field or not. Any help is much appreciated. The second...

Hi, Yeh of course I've tried it I'd much rather figure it out on my own than ask for help! What I've tried doing is creating a total of PremiumA and then dividing that by the rate. But obviously the rate field differs so it doesn't total properly and I've tried =[PremiumABal] but it only...

Hi, I'm hoping this is possible as it's going to save me a lot of time. On my report which is based on a query. I'm using these two fields for a calclation. Name: PremiumA ControlSource: PremiumA Name: Rate Controlsource: Rate Now for the calculation of field. Name: PremiumABal...

Hey Ray, I've taken your advice. Many thanks wrightie

Hey thanks for the replys. I'm still stuck though, but I'm trying. I've got the code below but like you say Bob as soon as you get as far as the subform it looses focus and when you close the Mainform it still saves the data. If you only input data on the mainform (current form) then it works...

Many thanks JR. I thought it had to be something simple. cheers wrightie

Hi , Could someone please help me with the VBA code behind my post button which is on my mainform. What I want is to check that the following controls have been populated. The first three work fine (Title, TransactionDate and Username) but as soon as I try the subform it doesn't work properly...

I am hoping that someone can guide me in the right direction here because I am wandering around lost! :confused: What I have is a Main form and within that a subform. The users input into these forms and the data goes straight into 2 tables. On the Main form I have a Save Record button and a...

Ah hell what was I thinking ..... far too much by the looks of it! :o Thanks so much MStef. Should of sorted it myself. Friday afternoon and the little old grey cells want to be in the pub. cheers wrightie

I have a form with a combo box for the name and an Ok button which runs the code below. The code works fine as long as the name doesn't have an apostrophe in it. If it does then I get this message Syntax error missing operator in query expression Private Sub SearchForInfo_Click() On Error GoTo...

Oh my god. What a fool I am. Cheers for that vbaInet you've saved me a headache.

Yeh in the table the credit and debit fields are set to Number , Field Size: Double Format: Standard Decimal Places: 2

Thought it was the Fix function but its not that ... damn I have standard as the format in the Grand Total text box and decimal places 2 Cheers

I’m stumped on this one. I just don’t understand why it’s doing it. :confused: I have a subform which is for inputting debits and credits. At the end of this subform I have two totals =Sum([Debit]) and =Sum([Credit]) which both work fine. I then have a Grand Total =Sum([Debit]+[Credit]) which...