Search results for query: *

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

I have ta table with a memo field. I want the memo to display in a listbox. The memo could contain a lot of characters. Is there a limit to what can display in a listbox item. I am not seeing the whole field in it.... Thanks

I have a list box that is displaying 2 columns that are 254 character length text boxes. They display on one line in the list box...isn't there a multiline in the textbox. I cant seem to find it... Thanks

Heres the code Public Function GetTeamLead(strID As String) As String Dim db As Database Dim rs As Recordset Dim sSQL As String Set db = CurrentDb sSQL = "Select * from [SCMC_SCMCIDTB] " 'Where clk_id = '" & strID & "'" Set rs = db.OpenRecordset(sSQL) With rs...

I was previously using access '97 now using 2003. How can I pass the value from the function.... For instance I used to assign a return value to the function name. How do you do it in '2003. Thanks

I just used a switch statement in a query. Its really powerful feature. Its better than stringing along an IIF statement. What do you guys think?