Search results

Can someone point in the direction of a good tutorial on how to use the Expression Builder. I've never yet written a successful expression user that darn thing.

I have a table capturing project activities with three date fields (opened, started, closed) that is fed by an entry form used by Project Managers. Opened is filled automatically with today's date when the record is created. The other two are supposed to be actual dates (ie already started or...

Someone else told me >Now()-30 Is there a different between Now() and Date()?

I have a query with a closed date field. I want to set the criteria to show me all the records where 'closed' is equal any date within the last 30 days. I'm guessing this has been answered before, but my search of the forum didn't find anything; and Access help is next to useless.:o

There's a bit of everything in here, but most of it relates to getting data into reports. :confused: - means I have question :) Should be enough for everyone to have a go. Overview: In a "Key Activity Form" the user enters an activity (eg. finalise planning layout). The database...

What reasons would there be for "can grow" / "can shrink" not to work? I've turned every grow/shrink I can find to "YES", but still not working?:(

I found a different way of doing it. The search boxes are in the form header, the results are returned in the details as a continous form. Couldn't make the combobox code work, so I just removed it from the search options. Fiddling with formatting now. Can't get my results to 'grow', so the...

I've taken a search form from a database someone else designed, copied it to my database, and then changed fields etc. The form allows you to enter data against several fields and then returns matching records in a subform. Well, the original form returned matching records. I have got it to...

I have no code attached to the combobox; only to the command button. My command button code is: Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmProjectMaster" stLinkCriteria =...

I have a form, with a combo box that picks up a list of projects. The user choose a project from the list, then clicks the button next to it to go a 2nd form showing all of that project's details. (The deal with using a button is so the user has a chance to change their chosen project before...

I have a form with a drop down box and a button. The user chooses a project from the drop down; clicks the button and a 2nd form opens with the details for the chosen project. I would like to put an error message on the button. At the moment if there is no project chosen an error message...

I tried that for days while working on it last and just could not get it to fire. Maybe I was doing something stoopid. While I was away, someone else dumped some code on the button; and once I worked out the "allow edits" it worked! I copied/edited it for similar buttons I have on other...

Figured out the first one. Need to "allow edits" on the form. I can now chose a project; but now I still need to link it to the button to open the 2nd form.

After a week on holidays I now face the monster again :eek:. I have a form (let's called it "FORM1"). On the form is a combobox (COMBO1). Combo1 picks up a list from "tblProjectMaster". SELECT tblProjectMaster.ProjectID, tblProjectMaster.[Project #], tblProjectMaster.[Project Title] FROM...

Realised that when you wrote "YourFieldNameInfrmMasterProject" I'm supposed to just include the field name NOT the "field name in form name" DUH. HOWEVER, even though I have fixed this the code still isn't working. Code is now: DoCmd.OpenForm "frmProjectMaster", , , "[ProjectID] = " &...

Thank you for the welcome :-) (I think) I'm not sure about being chucked in the deep end of databasing, but if my head doesn't explode, all will be well I'm sure. I'm not having a lot of luck with this code. I have just realised that there are other issues, which may be having an effect...

I have a form (StartForm01) with a combo box (ComboBox01), which lists dozens of projects. I want to choose a project, and have another form (frmMasterProject) open with that project showing. I have managed to get the frmMasterProject to open, but not to filter to the select project. I am a...