Search results

Hello. First of all cool design of the message board. Anyway here is my question I am trying to do the following SQL in a query: Select count (distinct Requirement_Number) from Quality_Control Where Status_Number = '3325' But I keep getting a syntax error trying to run this query. I know...

When I was not doing an print preview before the OutputTo, it was showing everything on the table and not what I wanted printed. I can't get filters to work on the OutPutTo process If OutputTo had the ability to use selection critieria string it wouldn't be an issue.

Question about closing a preview window on reports Hello again. I was wondering if there is a command to close a preview window on reports like there is a form. In my process I am creating a report and sending it to an RTF file. After it is printed the form is closed and I go to my menu...

Hello again. I am trying to send a report to an RTF file. My report has data in a table format with rectangle and divider lines and such. So I have my OutPutTo statement: DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria DoCmd.OutputTo acOutputReport, "Misc Meeting Agenda Print"...

Hello its me again. :rolleyes: More headaches with Access 97. I have a form with one command button where the intention is to save the record and close the form. I also have a couple edit checks in the BeforeUpdate event. My problem is that even if I hit the errors and set Cancel=True it...

Hello again. What event is triggered when the user clicks on one of the record selector buttons? I want to add an edit before the user clicks to the previous or next record or end of recordset but not sure where to add it. Thanks plenty ;)

I tried opening the query and updating record and it allowed me to do it. So obviously it is something in the form layout. I replaced the me.Dirty phrase with "DoCmd.RunCommand acCmdSaveRecord". I put a breakpoint in the Update click. Right after I execute the RunCommand I get the...

That problem was driving me crazy until I saw this unzip file and it works great. I don't understand how it is working but it is. Thanks for the file. :D :D But I do have a question. How can I put this process in my entire application instead of adding it to the Load and Unload events of...

Okay I changed the recordsource to a query. But when I tried to update a field on a particular record. I get the following error: The setting you entered isn't valid for this property. What I usually do is add a command saying " If Me.Dirty then Me.Dirty = False" so that the process...

Hello again. :) I am trying to sort records from a form in ascending order by Status Number (which is a non key field on the table). But it keeps sorting by the autonumber Meeting Number key field. I set the "Order By" on form to Status Number. What is going on here.

This is probably a dumb question but is it possible to change the processing or layout of a text box field so that when you put in 1:30 it automatically sets it as 1:30 PM instead of 1:30 AM. For the purpose of this application: 12:00 - 8:00 will always be PM. If not I can just tell the...

Well I know why the tab thing wasn't working (sort of). When it was on the last field in the main form; it triggered the beforeupdate and afterupdate events. I thought I could get around it by putting Me.Misc Meeting Topics subforms.SetFocus at the end of AfterUpdate but that hasn't worked...

Hello again. For some reason I can't tab from one field on the main form to the first field on the subform. I have the subform TabStop = yes. In the subforms data section I have the Data Entry property set to Yes. Have no idea what is going on. :mad:

Hello again ;) I have a form that contains a frame of 10 checkboxes. The first checkbox contains an "All Reports" check and the other 9 checkboxes contains each individual report. What I would like to do is to add an edit where the All Reports checkboxes would be deselected if the user...

More issues. Here was the test I have a problem with: User starts entering information. As soon the first field is populated the AutoNumber key is created. If the user clicks the Exit PCS button or the Return to Main Menu button instead of the Add Meeting button that record shouldn't be...

Sorry for the constant questions but I have another one: If I change my keys for the Meetings and Meeting topics table to an autonumber field; how do I connect the Status Number, Scheduled_Meeting_Date, and Meeting_Type from the main form to the subform? I still want (or think I still...

I am totally confused. What or where would this "time" field be used for? :confused: And for the block of code, are you talking about the processing in the Add button when I say 'Do you want to add another record?" If so then an Undo command wouldn't work because I want to save that...

I finally figured out the #delete message. I had code in the AFTER update event from the previous version that was screwing with my data. :rolleyes: But I still had some questions: 1. Once you are in the subform, is there a way to allow the user to tab back to the main form? It looks...

I need more smilies to describe my feeling on this right now :mad: I am still getting the #deleted on the fields in the main form when I tab to the subform. I am not sure what I am doing wrong here. I created a relationship between Meetings and Meeting Topics with links to the Status...

The reason I prefer the "Add Button" format is that it is familiar with our account's system. A record isn't added until you say you want it added. Yeah I understand that it isn't the way Access. I am using bounded forms. The bounded forms is tied to the Meeting table. The subform is...