Search results

There is a Help entry for: Create a crosstab report with fixed-column headings Does it do what you want?

Have you tried: "jobNumber = forms!yourform!cboJubNumber"?

You can put a button on the form that would open a blank Outlook e-mail form and fill in the address. I don't know if you can do this with Outlook Express.

Microsoft has a paper on synchronizing combo boxes. It is Article ID: Q97624

You can set the form's Order By property to the field you want by using the On Open event. That way even if someone decides to sort by another field when they are using, when the form is opened again, it sorts using the original field.

You can set the form's Order By property to the field you want by using the On Open event. That way even if someone decides to sort by another field when they are using the form, when the form is opened again, it sorts using the original field.

I need to do more than transfer the spreadsheet. I need to open Excel, run a macro, save the file, then import the spreadsheet.

Can anyone give me the code to open an an existing Excel Workbook from Access. I have tried Getobject following the help file instructions, but all that happens is Excel opens briefly, then closes. Thanks, Neal

If you add a button to the form using the wizard, select "Record Operations" and "Duplicate Record' That will create a new record using the data of the record you have selected. You can change the data as needed.

Perhaps you need to create a subreport. It can have a different record source than your main report.

Did you try datediff? The format would be: Datediff("d",[OneDate],[OtherDate]) The "d" stands for days. "n" would give the results in minutes.

I think this would work: Dim stdocname As String Dim stLinkCriteria As String stdocname = "Project Request Approval" stLinkCriteria = "Dept = Forms![Project Request Approval by Selection]!combo22 and Other = Forms![Project Request Approval by Selection!OtherCombo" DoCmd.OpenForm...

Go to your tables tab. Click on File, Get External Data, Import. That will open a wizard that will walk you through the steps for importing data, including delimited text files. You can create a table with this method, or add data to one.

Generally, you can look in the folder where the db is located. If there is a file with the same name but has the extension .ldb, it means someone has it open. There is a great utility called Modeuser.mdb that is on Candace Tripp's website. It will tell you who has it open and in what mode. Her...

You should be able to set the after update events of qtyadded and qtypulled to: qtyonhand = qtyonhand + qtyadded and qtyonhand - qtyonhand - qtypulled

I had a similar problem with ads that can appear in a newspaper on any number of dates, including every day. Obviously, I didn't want a form with 365 fields for dates. So, I have two tables: one with information about the ads, and one for information about each time it runs (i.e. date, what...

The Microsoft Knowledge Base has an article explaining how to do it. It is Article ID Q97624

Is your mail client Outlook? I think I know how you could do that if you use Outlook.

Why don't you have your user input the parameters on the form rather than the query? Just set the criteria of the query to say: Between forms!yourform!begin and forms!yourform!end That way the user is not prompted twice.

In the date field of the query, set the criteria as forms!yourformname!yourcalendername