Search results

I would create a query that I can output to Excel STEP 1: create and save a query, something like "SELECT <YOURFIELD1> AS CODE, <YOURFIELD2> AS NAME, <YOURFIELD3> AS TITLE FROM <MYTABLE>" STEP2: output the query to Excel DoCmd.OutputTo acOutputQuery, <yourqueryname>, acFormatXLS,, -1 CODE...

Try this: me!<yoursubform>.setfocus me!<yoursubform>!<yourcontrol>.setfocus

What is the size of the pictures? Reducing the picture dimensions does not reduce the picture size. Try to have the pic size as small as possible, probably around 20k. That should speed up the display

use the printer object. In your case I think it would be Printer.PaperBin

First, you cannot put the code on the detail section because it applies to all the report sections. What you need to do is to have a "blank" picture that you will use to replace your watermark. Then, on the report open event, put something like this: Me.Picture = "C:\yourpath\blank.jpg"

How dis you insert the watermark in the report. I just tried by inserting a picture. The visible property hides/shows the picture

Try this: if [yourfield]=1 then me.detail.forcenewpage=1 end if

What is the size of your pictures? Reducing the dimensions does not reduce the size. I have worked with reports that show 15+ pics (around 20K each) per page without problems.

Yes, that would be the easy solution, but the user has restrictions on the form size. Moreover, they can add and remove fields to the list, modify the column order, sort, etc. I already have the logic that handles the horizontal scrolling, I just need to hide the scrollbar that appears...

Amazing. So, you only see the name and part of the address? Is there any way see the remaining columns?

I just created a form that show the listbox with the horizontal scrollbar

Yes, it is a listbox. I think the horizonatl scrollbar is related to the number of columns. If all the columns do not fit in the list, then you get the scrollbar. I am using Access 2003 Professional.

I need to remove the horizontal scrollbar from a listbox. I have tried code that uses API and the .hwnd method, but I get the error "Method or Data Member Not Found". What would be the right approach to accomplish this? Thank you.

You need to specify a field name in your WHERE clause Form_View_IT_Asset.RecordSource = "select * from IT_Assets_table where <YOURFIELD> = '" & GCriteria & "'"

If the student ID is not on the verification table, then you have no records. You cannot "MoveFirst"

I would use the Datediff function. However, if you have the case of an End date being before the Start date, then reverse the order (to get a positive number), count, and then multiply by -1

I don't know how do you loop thru the recordset, but try creating a function that receives a parameter (such as cutomer ID) and makes the calculation you need. Insert a textbox in your report and set its control source to "=myfunction(parm)"

Yeah, it has to be a listbox. There is no way to do it with a combo box. In my previous posting I was thinking on a listbox. If mwcrepeau is using a combobox then that code is useless.

docmd.Close acReport, "RMA_Label"

The selection is boolean, so if one item is selected and your want it deselected you should do Me.cmbComboCox.selected(X) = False