Search results for query: *

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

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

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

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

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?

I need to compare an address field in two tables. They want to see the differences, is there a good way to to this... Thanx-- they want to eyeball it for now...but some of the addresses are reasonably close. FOr instance, sometimes they have a floor or a suite# while the other table does not...

Its easy to export a query to a new spreadsheet file, but how can you get it into an existing worksheet...for instance a workbook tab...I would like to add it to an existing workbook with its own tab... Thanks

In the following routine, I am getting an error message..."There is no object in this control" on the txtDateOn = recServices!DateOn Can someone shed some light here.... Private Sub LoadControls() ' If the file is not empty load up If Not recServices.BOF Then '...

I have an access 97 database that loads fine in 97. When I try to run it in 2000, I get the following error. Not sure about how to join the workgroup that defines the user accounts used to access the database.

I was wondering if its possible to create a subquery within the qbe. If so...how is it possible. Thanks -- are there any links on how create advanced sql on the site?

I have a stored procedure that I can run with no problem from query analyzer. However, I have a crystal report that uses that stored proc, when I run it from the application, I receive an EXECUTE PERMISSION DENIED on OBJECT error.... So I can run it interactively...but not within the report...

I am working with a sp that contains a where clause that is concatenated like so... Set @wherecmd = ' WHERE ' @addwhere I need to add a piece of logic to the mix... AND Matches.Status <> 'x' I am having trouble with the syntax because of the apostrophes... Can someone help with this.... Thanks

It seems that my report footer values overwrote the group footer values on my report. I changed the report footer to print at the botton of the page. I can't test this right now because of production data different than test data. But will the report footer and the page footer clobber each...

I am trying to understand what the recordsetclone is all about. CAn someone explain why its used, when its used and what its good for. Thanks alot...

I need to create a report that groups on week number. How can i do that in crystal. Thanks