Search results

Hello, how are you. Hey new smilies cool :D Anyway is it possible to convert a field with a type of OLE Object to a text or memo field? I tried just doing a regular update query with a new field to type 'MEMO' but the data was mostly junk.

There is a user in my application who keeps getting a "Automation error" message every time they click a check box in one of my forms. Yet when I try to use it on my system I don't get any messages. What does 'automation error' mean? Why would I get the message when clicking on a check box...

Hello again. :) I have a report that consists of 2 subreports merged into one. Each report uses its own query to get the data. I just ran this report for a month and one of the subreports showed data but the other showed blanks in the fields. The reason for the blanks is because the query...

I have 3 tables that have the same definition and layouts. Is it possible to merge these tables into 1 complete table in Access 97? Thanks

I am trying to create an export specification for a transfer text command in my application. I am trying to take a query and export to an text file. Here is the query: SELECT A.Release_Number, C.Status_Number, C.Status_Description, C.Current_Function_Points AS Function_Count, C.Project_Type...

Hello again. :) My account is planning to upgrade the Access they use from 97 to 2000. But my boss wants to know what the impact would be to my database system that was created in 97. I was wondering if there is a document or web sites that shows all the changes between 97 and 2000. Or...

Hello again. I am trying to create a query and here is what I have currently: SELECT Count(*) AS Count_Action_Items, Sum(IIf(Actual_Completion_Date<=Target_Completion_Date And Actual_Completion_Date >#1/1/2000#,1,0)) AS Sum_On_Time, Sum(IIf(Target_Completion_Date < Date(Now,"mm/dd/yy") Or...

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

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 ;)

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

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

First of all sorry for all the questions. Trying to figure out this process that they want quickly. Anyway: Is there a way to prevent a form from hitting the 'AFTERUPDATE' event when switching to a subform? I want to create a meeting screens and one of the things I need is a list of...

This is probably difficult to explain what I am trying to do but here goes. Is it possible to use a string value in the Me property. In one of our processes at work we can create a "question mark variable" as it is called. Which that question mark variable we can put that anywhere like at the...

Hello again. :) I have a table called Meetings. I want to create a field called Topics that contains the topics discussed in the meeting. I would love to be able to create an array like field that allows me to enter multiple topics for one meeting. Is this possible in Access 97? I didn't...

Hello again. :) I was brainstorming an idea for one of my screens in an application. I want to create a combo box of names and a text box. Whenever the user selects a name from the combo box it adds to the text box. The user can select as many names as possible with each one being added to...