Recent content by sk8er1

Yes, but I really don't understand how it works... Can you explain what the following line is doing... DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 Along the top of my access 2002, I have FILE EDIT VIEW INSERT FORMAT TOOLS WINDOW HELP Thanks

I have a menu bar that has an icon labelled "Convert to Adobe PDF. I want to convert my report to adobe by clicking a button. The convert to adobe is on a menu called UTILITY 1. How do you do this in code. Docmd.DoMenuItem ...... Thanks

Hi Alex, The user selects the choice from a list box, and it will appear on a form letter. Can you show me what you are talking about regarding the index.... Thanks

I have a memo field in a table, I entered more than 254 characters into it. I load the memo data into a list box for the user to select it. Then I build an sql statement like this.... strSQL = "SELECT * FROM Questions_Responses WHERE question = '" & lstSearch.Column(1, itm) & "'" Problem...

How would you display the value contained in a memo field on a report. Would'nt you use a text box?? And dont text boxes have a limit of 254 characters???

Oh, I simply did not include the error code. I dont think i am calling it from two locations. I will check, but I doubt it. You are not getting two records.

I have a listbox with two columns that get populated from memo fields. I will need to put these onto a report. The data will exceed 254 characters on a few records. Question is...how do i handle that when I display the data in text boxes on a report....

In the following routine, I add a record to the first table and store its ID. I want to add a record to another table but I want to store the ID from the first table into a linking field in the second table. Whats happening is, the second table is getting 2 records added. 1 has a linkID = 0...

I had a feeling...but was not sure. Thanks for the help.

One last thing... If I open the report this way, do I leave the recordsource property (for the report) blank?

Ok thansk for the explanation, one more thing... I ran thru the code in the debugger, and I'm not sure I understand whats happening in the following line.. stcrit = "Facility in (" & facstr & ")" In my case it would be stcrit = "Question in ( )" What value is held in facstr? Thanks

Hi Thanks for the response. So, on the form that has my listbox, I can create a button to invoke the report. In the click event, I would build code based on your code snippet... One question...what are you doing with this line... stcrit = Left(stcrit, Len(stcrit) - 2) Thanks ...I will try it...

I have a form with a listbox. The listbox contains 2 columns. I would like to run a report with the contents of the listbox. So, I have a query and I would like to filter the criteria with the column from the listbox .... Is this possible in the QBE...

When I start up my PC I am getting a message box about something called WINFIXER 2005. I tried running my tools to remove it, but i cant seem to remove it. How do you remove items from the startup in XP? Thanks

Check the memo field for #deleted. You will have to re-enter the data