Search results

Had to make a minor adjustment because the ADD record was still filtering the form when it opened if an EDIT has been previously selected (and I don't believe you want that). I now have it close, then reopen before it goes to the new record.

Three of three solved now. Just needed to tweak the stLinkCriteria statement in the studentsearch form.

Private Sub CmdOpenReports_Click() On Error GoTo Err_CmdOpenReports_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "YourFormName" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.GoToRecord , , acNewRec Exit_CmdOpenReports_Click: Exit Sub...

Doesn't that violate the 8th Commandment of Access? :) "Thou shalt not copy and paste other people's code without at least attempting to understand what it does."

The fe is linked to the be and the usual permissions to the WG files apply. (which the administrator sets up). So if a person has a copy of the fe on their system but does not have permissions to retrieve the be, they would just sit there and spin their wheels - so to speak. The administrator...

Look here, this might help. http://www.access-programmers.co.uk/forums/showthread.php?t=104881&highlight=move+selection+list

I had the same problem on a form that I was working on a few weeks ago. Your solution is exactly what I needed to do to get it to change the visible property of the control. And it makes sense - the property won't (or shouldn't) change when the control has the focus.

That's what I meant to say - He could either refresh the entire form or requery the individual control. Thanks for the clarification.

Yep, images are a tricky subject depending on what you are trying to do.

Two of three problems solved. :) I'll work on it some more later.

Normally an [Afterupdate Event] for the control that lists the available rooms. "Me.requery" or "Me.refresh" This should work as it will update the combobox upon update of the other control. I use this in a form that accepts a new record, and on the last field being completed - updates the...

The easiest way to receive help on this one (since you have a number of issues) is to upload a stripped down version of the db and let some of us take a look at it.

I tweaked it a bit and now it is working as you wanted. Please see my PM for additional information.

If "SalesTable" is the query or Table for the record source, then the above should work as long as you have the same fields listed in your report. I use the following to open a specific report (as determined by a combobox in my form) on the ON LOAD event of the report. Just change the names to...

When you call the report (from a button on your form I presume): DoCmd.OpenReport "Name of Your Report", acViewPreview It will use the query named in the report as the record source. To add the query as the recodsource in your report - open the report in design view, right-click and choose...

Use an OR AND statement in your query for the Record Source like: This will allow you to filter the record or ignore nulls. That way the report will print either all the records or a filtered set.

That's true, so that's why I thought it best to assign it (the query) at run time in the ON OPEN event.

You could also use the ON OPEN event for the report to assign the appropriate query or dynamic query at run time.

The query should have one field that is the name of the invoice date from your table and a second field that is the name of the ending date. That is an unbound field (not in the table, but the name of the textbox from your form) The textbox that holds the ending date should be UNBOUND (no...

Create a query for the record source of the report that looks something like: SELECT YourTableName.* FROM YourTableName WHERE [YourInvoiceDateField] > Forms!YourFormName!YourForm_UnboundFieldFor_EndDate ORDER By (Whatever order you want the data to appear in) Then just call the report when...