Search results

I want to check data before it is saved. I am using the before_update method to have it check the data and will use "cancel = true" to stop the save process if the data does not pass through my criteria. The problem I am having is that when the user tries to view the next record it will go to...

I have a button that is set to delete a record. when it is clicked it asks the user if they really want to delete the record, If they say no it then proceedes to pop up a dialog box that says "The DoMenuItem Action was canceled". I would like to be able to catch this and replace it with my own...

found my problem, it should look like this: OpenReport "RptFull", 2, , "[Student] = '" & Me.Student & "' and [Scenario] = '" & Me.Scenario & "' and [Date1] = '" & Me.Date1 & "' and [Teacher] = '" & Me.Teacher & "'" However I have another problem yet again. I have 4 modal forms that I turn...

Well actually I found some code that looks like it should work. However I am having a problem running it. you can find the code here: http://www.mvps.org/access/reports/rpt0003.htm The problem I am having is that it works great if I just specify the name of the report, but when I try to...

I have a lot of modal forms in my database. The problem is that when I open a report the user can't do anything with it until the form is closed. Is there any workaround that would allow the user to view the report and when they close it have them go back to the modal form?

I guess I always had VBA as a backup plan I just never took the time to try it out. In any case it works great, just the way I wanted it. My final code ended up looking like this: Private Sub Command17_Click() DoCmd.OpenReport "RptFull", acViewPreview, , "[Student] = '" & Me.Student & "' and...

I am trying to open a report that only will show records that meets certain criteria. This is in a .adp database and I am having some trouble with it. I tried creating a macro and defining a where caluse of: [Student]=[Forms]![FrmSubStudent]![Student] and...

but the code in the criteria box is: = N'[Forms]!FrmSubStudent!Scenario' and i don't think that is right

no, it seems to be comming up empty

no, its not allowed

These work individually: [Student]=[Forms]![FrmSubStudent]![Student] [Scenario]=[Forms]![FrmSubStudent]![Scenario] however when I combine them they do not work, like this: [Student]=[Forms]![FrmSubStudent]![Student] AND [Scenario]=[Forms]![FrmSubStudent]![Scenario]

This should have a pretty simple answer. All I am trying to do is open a report and throw multiple where clauses at it. I am connecting them with "and" and it seems to like the syntax but as soon as I run the macro from the form button it chokes. I've triple checked my form names and control...

alright thanks

ya, i've put that in and it works. I was just looking for somthing a little more compact. Any ideas

Ok I know that this question is a really simple one, but i've been fiddling with the code for about 10 min and haven't found a solution. I am trying to make an if statement with many or's in it. Here is the code that I have been trying to get to work: If ((Test1.Value Or Test2.Value Or...

thanks Thank you very much, I had the bound column part but I was not changing the column count to 2. I made the column widths 1",0" and everything works great. Thanks

I am trying to do something that I once knew how to do, but time and lack of using access has got to my memory. What I need to do is have a combo box that looks at a table, I want its rowsource to be column 1 of the table and the record I want recorded is what is in column 2. Basically column...

I have turned off a couple of errors that appeared when it tried to save the current data in the fields when I closed the form and it would say somthing like "insert failed, you cannot insert a null field into ClassTbl" so now on the beforeUpdate() i check for only that error message number and...

I am using a adp database. The record source is ClassTbl the record source qualifier is dbo, the Recordset Type is Updateable Snapshot. I have checked the database and there are no actual duplicate entries but I would still like to have the error message pop up to inform the user that what...

I regret to inform you that I am still having the SaveRecord error message, I guess I just didn't do enough testing.