Search results

I had this problem too with a one-user database. It turned out to be because I was making changes to one table at multiple times without saving my changes to the table in between. I think I was updating a table with a recordset using code, and when the form closed it was also trying to update...

Thanks for your response, Pat. I have another question. To get the desired value, I must have a subreport that calculates one value and then adds it to another on the main report. I can't figure out a way to get all the information I need for this report into one query. Therefore, I was...

The answer to this is probably very simple, but I couldn't find a sufficient answer searching the forum, so here goes: I am trying to create a grand total in the report footer by filling in the control source with =Sum([MainTotal]). Main Total (which works) is in a group footer and the control...

Thanks for the reply, David R. I should mention that the combo box always contains a four digit integer, and new values cannot be added. The combo box is big enough to contain the four digits. It is not a show stopping issue, I am just curious why this happens. Any thoughts would be...

Just a quick question - does anyone know why the value in a combo box will sometimes jump over to the left side of the combo box? Everything else seems to be working just fine. I think it happens when the form has been filtered, and then the filter is removed, and a new value is selected using...

Wait...I am so sorry, suddenly it is working, I have no idea why...Access can be so weird sometimes. Thanks for your time, and I guess the lesson to be learned is, when in doubt, reboot.

Well, what I am really doing is grabbing those dates from a form that is used to open the report. The user can fill in whatever date range they want to see, so the SQL will change every time the report is opened. The reason I have dates filled in is that I wanted to make sure that my problem...

In trying to open a report, double clicking on it from the database window, the following error message shows up. I cannot figure out why it is being generated. Error message: The expression on open you entered as the event property setting produced the follow error:. *The expression may not...

I am opening a recordset using an SQL statement. The code is below. I am getting the error message: "Method 'Open' of object '_recordset' has failed." For some reason, the query is failing on one field. If I remove this field from the query, it works. If I susbstitute another field for this...

Instead of: DoCmd.Save acForm, "Customer FRM" Use: DoCmd.RunCommand acCmdSaveRecord I have used this with much success to prevent write conflict message boxes. Thanks to Pat Hartman for providing this solution to me.

Thanks, Jack, for responding, your suggestions helped me to find the problem, which was just an oversight on my part! I had forgetten to add the field to the query that supplied the form. I guess I was a little hasty in posting. Thanks for your time! betsyr

How do you make a check box display the value stored in the underlying yes/no field? I can set the value of the field using a check box, but the check box shows null when I am browsing through the records. Thanks!

I am using Access 2002!

I am opening a recordset using an SQL statement. The code is below. I am getting the error message: "Method 'Open' of object '_recordset' has failed." For some reason, the query is failing on one field. If I remove this field from the query, it works. If I susbstitute another field for this...

I think this is what you mean.... "SQL here..." & _ "more SQL here" Hope this helps. betsyr

The requery works - thanks for your help! The only problem is that the form now points to the first record in the table, instead of the newest record. Any suggestions on how to get back to the new record? Does a bookmark work in this situation?

I am fairly new to VB and have the following problem. I have a data entry form that allows the user to select multiple objects from a list box, which then show up in a subform. I am doing this by setting the record source for the subform to an sql query generated in the form's code. I want...