Search results

My husband is a policeman here in CO and our city's PD/FD got free tickets to a preview screening of World Trade Center and we went. Everyone I talked to after thought it was very well done - basically just the story of these two Port Authority cops that got trapped and were rescued. No over the...

Wow..I posted this so long ago, I've changed jobs since then! :D I did fix this problem, and if I remember correctly I had to access the front end on a machine with XP/2002, recompile the code, and then everything worked fine for both the XP users and the 98/2000 users. And like ghudson said...

At least in A2K, go to Tools...Options. Click on the Edit/Find tab and uncheck the box called Action Queries in the Confirm section. This will turn off ALL action query warnings so be sure that's what you really want to do!

Is this for a report? If so, check out the MS Knowledge Base Article 208532 it might help. I've used this and it works great. Carmen

Hi All, I have a database that tracks documents received for translation. The request is logged via a form and assigned a Category and Subcategory (which correspond to folders on our server where the translator will save the completed document). When the document is complete, the translator adds...

I've searched the forum and have seen several references to this problem but no real solution. I have developed an Access 2000 front end (.adp) on a SQL Server 2000 db. The front end resides on the same server as the SQL server. I have created a read-only user group for the db. Some of my users...

Hey WWG!! Been there, done that!! Glad you got it figured out. And it's never a waste of time to try and help. I know this forum has saved my butt a time or two!!!! :D

Let me ask you this..... Is GVLLayout the name of the subform control as well? You may need to do this if they are different: Forms![MainFormName]![SubformControlName].Form![ControlName] PS: I won't tell anybody if you change the names! ;)

OK, this might be a stupid question but is ReportQuery the name of your Form or is that the name of a query?

My fault--I left out a part!!!! Sorry! Try this: Forms![MainFormName]![SubformName].Form![ControlName] See if that helps......

Try this: Forms![MainFormName]![SubformName]![ControlName]

It sounds like you want to add a Combo Box to your form using the Wizard, and when you get to the screen that asks what you want the combo box to do, choose Option 3 which says something like "Find a Record on my Form based on the selection in my Combo Box" and follow the rest of the...

For your textbox in the Report Footer, have you tried =Sum([TextboxInYourInvoiceFooter]) instead of =Sum([Item_VAT])?

In the On Format event of the section of the report your field is in put your code, something like this: If IsNull(Me.MyField) = True then Me.MyLabel.Visible = False Else Me.MyLabel.Visible = True End If HTH Carmen

Hi Adam, I see your problem. This might not be a great way to solve it but I think this should work......... Let's say your subform's RecordSource is a table (or query) called "Person" (sticking with our example). Make a new query using all the fields from this recordsource and put the filter...

Anytime Adam! Glad I could help........ Carmen

Going Home! It's not even Noon yet! :D Hope you had a good weekend and You're Very Welcome, but maybe don't thank me yet til you see if my advice works! Please post back and let me know......... Carmen

I use something like this before deleting a record from a button: Private Sub Command2_Click() On Error GoTo Err_Command2_Click Dim continue continue = MsgBox("This action will delete a record. Are you sure you want to continue?",vbYesNo, "Warning!") Select Case continue Case...

Adam, If I'm reading you right, using your Family example, you have a continuous form that has a list of people, ex. John Smith, Mary Smith, Adam Smith, Next Family's Records, etc.... and each with a command button. If you click on the button on any Smith record, a main Smith form opens with a...

You know in my example I used Column 2 when you said you are using Column 3--my typo! Sorry about that....could that be the problem or did you change it already?