Search results

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

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

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

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

Hi, I'm struggling with this... What we have is an input form which inputs data straight into a table. One of the fields is a debit field where the user has to enter an amount. Unfortunately alot of the users aren't bothering to put a minus sign in front of the amount they are inputting. So...

Hi Is there any way that I can get a field (Name) to autopopulate once the user has entered data into the AcNo field? What I have is 2 forms, MainForm and EntryForm which is a datasheet and 2 tables, EntryTable which is empty and NameTable which has two fields AcNo and Name and is populated...

Hi, I'm at my wits end with this. So I'm hoping someone can save my sanity! What I have is a form where you can select a Period Number and when you click the ok button runs a query and then opens the results in a report for that period number. Query Code - Code: SELECT *FROM Broker INNER...