Search results

I have a small database application that seems to work fine and now the question is how to deploy the application. I have split the front end and back end and the question I have is can I set up the front end so it's not running within the Access development environment, that is to say when the...

I have a report that, when the report is run from the form it's missing data, yet when I run the report from the IDE the report works fine and the data is present. I'm thinking it might be a timing issue, that is to say, if I step through the code, where the database is updated and the report...

I'm having a problem dealing with a recordset closing. The problem occurs when I got an error message. "Operation is not allowed when the object is open." So I get the bright idea to test if the recordset (rs) is open as in if rs.state = 1 then rs.close end if But, when it executes this...

I'm having a problem doing an update query using vba inside an access program. I have an unbound form and ran into a problem trying to do an up date of a table data. I tried to use a copy of code I found on the web, which first does a select query of the record based a primary key. The code is...

Can someone tell me why, at certain times, the background color of one of my combo boxes is missing, that is to say it appears gray, not white. The combo box seems to function correctly and if you just drop down the selections and return the background is once again white. I have attached a jpg...

I'm trying to set the height of the detail section of my form at run time. I have a number of fields that I set visible property to false and want to expand the size of the detail section and set the fields to visible = true, when the user clicks a value on a option button. I tried to set the...

I have a form which, when displayed in form view shows the detail segment of the form much larger then it appears in design view and wondered what the cause of this is. The form has both a header and footer, so why doesn't the form, in form view, show the same size as in design mode? Thanks, Tom