Search results for query: *

Hi, I have a simple bit of code that makes a calculation (see below), then rounds it to 2 decimal places, but it always rounds it up, I need it to round down. I've looked through here and I'm sure it's simple but cant work it out! Any help would be greatly appreciated. Thanks, Dim intBPS As...

Hello all, I have a situation where i am trying to check a recordset, the recordset will only have 1 record in it and I need to loop through say 12 fields and check that at least one of them has the value "-1" in it. Is there an easy and quick way of refering to the fields as a set and looping...

Hi there, I am trying to refresh the recordsource on a subform - my code is below. When you click the add button once it doesnt refresh, when you click it twice it does - can anybody see what I am missing here. Thanks, kt Private Sub Command10_Click() Dim db As DAO.Database Dim rs As...

Hello there, I am currently using DAO to open a recordset in my database which is working fine, however when i go to run the code a second time i get the following error message. Run-time error '3734' The database has been placed in a state by user 'Admin' on machine 'W00497' that prevents it...

I have a form which is used for searching, i am using a field called "txtMatterName", in this field, for example i want people to be able to type "turner", and the code will find anything in the field with "turner" in it, for example "Ray Turner". I am doing this by opening a record set with a...

Hello, I am not sure if this is possible in Access - hopefully somebody out there can help. At the moment I have a single form which searches for a record, then performs a calculation on the information in that record and changes the back colour of each control accordingly, ie. assigns a status...

Hello, I am trying to create controls on a form from the items selected in a list box on a seperate form. At the moment, my code only reads the first item selected in the list box, then jumps out of the If...end if statement, I am sure it is obvious, I just cannot seem to work it out, have...

Hi there, I've got an automatic export running off one of my tables into excel. I have recently added a field called "Detail", the field type is memo, when this field exports to excel it cuts half of the contents of the field out. Can anybody suggest the most efficient way to get around this...