Search results

Here's my code, can anyone determine my I am getting an error that says "Compile Error: Loop Without Do" Yet I am sure I have tied up all the Loops with ending statements... Function Calculate_Fees_part_2() Dim db As DAO.Database Dim rs1 As DAO.Recordset Set db = CurrentDb() Set rs1 =...

Apologies for taking so long to back, couldn't of asked for better help you little stars you. Many many thanks.

Hi there, This will hopefully take someone only a minute to answer but as for me I'am a bit of a beginner and have searched quite hard but cannot find an answer. I have a table with a number of columns, for arguements sake its a simple customer details table with ID, first_name, surname...

Hi, I have a form that has a few texts boxes that have conditional formmating on them. When check boxes are ticked certain text boxes are hightlighted using the conditional formmating. The problem I have now is that I want write code that records which text boxes are highlighted. I have tried...

the above code works, sorry, but it was taking a while to update and the form displaying th results needed refreshing. Ty.

Quick update on the code I have so far: 'declare database, recordset, columns, fields as objects Dim dbRequests As Object Dim recordsetItems As Object Dim fieldColumns As Object Dim fldEnumerator As Object 'set up Database, recordset...

Hi, I have code witch Sets up everything for my Database Access but I am having trouble being able to retieve data. My codes looks like this: 'declare database, recordset, columns, fields as objects Dim dbRequests As Object Dim recordsetItems As Object Dim...

thankyou, knew it was simple...lol Private Sub Command145_Click() Me.lblUserName1.Caption = ReturnUserName() End Sub

God I feel soo think :mad:...I am beating all round the bush to do this, I have forgotten how to do it thou...here go's: I have this code in my module, called 'Module1', as below: Option Compare Database Public Declare Function GetUserName Lib "advapi32.dll" _ Alias "GetUserNameA"...