Recent content by TomL

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

Boyd, Thanks for all the input, I'll give your suggestions a try. Regards, Tom

First, thanks to everyone for all the help and suggestions. The problem was resolved by changing the db update to a sql update statement and adding the doEvents. I also saw the wisdom of HiTech's suggestion and moved to use a local variable, figuring that not only might it help, but also...

Here's the code for the database update. As I mentioned I can step through the code without problem. Upon returning a value of true from the function I call the report. Public Function UpdateExpenses() As Boolean Dim sqlStr As String On Error GoTo ErrorCheck If Not GetConnection Then...

The UpdateValues and UpdateExpenses are calls to two procedures, the first does editing and loads class values the second, UpdateExpenses is a call to a procedure that updates the database table. As I mentioned if I step through the code and the report is loaded the values are in the report and...

Yes, I have a button on the form, which calls the report. Tom

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

Thanks for the reply. I'm going to go back and give this some more time and see if I can find out what's happening. Tom

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

Many thanks for your help. Tom

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

Thanks for the information. Alas after applying the hot fix nothing has changed. I'll try to go to plan B as soon as I find it. Tom

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

HTH, Good thoughts. I'll look at both suggestions for my solution. Regards, Tom

Thanks for the reply. I got the height value from moving the detail bar to the height I wanted and looked at the height value, which was 1.4". That said, I went back in and set the value to twips, ran the form, but without success. I think you're probably correct in as much as; if there are...