Search results

That's perfect! thanks so much Bob, I really appreciate your time. It works perfectly now, thanks.

Hi all, I have a form used for a couple of parameter qrys, what I'm trying to do, is hide some objects on the form, but on the On Click of a button, I'd like to make a few more objects visible via VBA. I've tried; me.txtDate visible = true and forms!frmReportParameters!txtDate visible =...

Hi, I have a form for Reports and on it I'd like a dropdown that displays the reports that are available (or maybe queries, I don't know which yet) so users can hit the dropdown, select their report, enter some parameters (just dates) and then I've just got a button that runs the report...

Hi, My db tracks job numbers and who is in them. I have a form with a job number and two options; the 'owner' of the role (substantive occupant) and the 'current' occupant (if someone is on leave, or acting in a second role). I have a cbo to a query based on tblPeople to get the occupant's...

append query Mike375, that's perfect! Exactly what I was looking for. I created the queries and stuck them behind the check box, it works great, thanks for the advice.

Hi, my db has a view data form frmJobsView. When I am done with a job (the db tracks jobs and workers and manages the status of a job) I would like to open the view job form and have a check box that on update to true, sends that job from the tblJobs to the tblJobsArchive. Does anyone have...

Adp Sorry mate, I don't have much experience with .adp stuff. You may need to ask around at a sql site or similar, sorry.

Criteria in a query As capsula4 said, I'd create a form with either dropdowns if that's what you want or just txt fields, then reference that form and txts in the query criteria like below -> Forms![frmyourformname]![txtyourtxtfield] then have a cmd that runs the query (or report if you want)...