Search results

Not AFAIK. You could just build a normal query, then in criteria put [Forms]![frmYourFormName]![TheFieldOfYourPK] in the field [TheFieldOfYourPK] to make it select the current record.

Just wondering, is it better to have Access write the code for you, or to write it yourself? Case in point: Quit button. Mine: Private Sub cmdExit_DB_Click() DoCmd.Quit End Sub Access: Private Sub Command60_Click() On Error GoTo Err_Command60_Click DoCmd.Quit...

Select the record using Record Selector, and then File > Export to *.xls. That will do what you what. I assume each record has a unique ident. In which case you could have a WHERE function in your SQL statement. SELECT <blah> FROM <blah> WHERE = [<unique field name>] Hope that helps, if not...

Isn't there an option to hide the form in OpenForm arguments in the macro settings?

Try without the brackets?

Just tried this piece of code and it works perfectly :cool: Thank you very much. I will now attempt to understand how it does what it does :confused: Still not sure why missinglinq's code didn't work as expected. It detected Saturdays and Sundays correctly, just that the MsgBox was a bit drunk...

Ah thank you for that! I prefer to learn this way, instead of nicking someones codes and making no attempt to understand it. Thank you for that. Just tried it and while it does what I want, something isn't correct. If I enter 8/11/08 (Tomorrow which is Saturday) - The MsgBox says ... If I...

Been googling for a while now, and I can't find any examples of what I want. I have a form (frmBookings) and on this form there is a field (txtDateOfBooking) where a date is entered for whenever the person requires our services. Now I need to check whether the date entered falls on a Saturday...

Change it to (in Query Builder): TheFieldNameYouWant: query1.data eg TotalDue: query1.data In SQL View it would be: query1.data AS TotalDue eg <caculation> AS TotalDue

You need to JOIN your tables. Use Query Builder to do this easily. Just add all the tables to the Query Builder you need. Then drop whatever fields you need into the Query Field selection and do all your calculations there. FYI, there are different types of JOINs;inner, outer, right and left...

In the qry the rpt is based on, under the field where the dates are stored. In criteria put BETWEEN #01/04/07# AND #31/03/08#, then sort that in Ascending order. More of a quick work around, than a proper solution (proper solution - see pbaldy's post) @pbaldy: God I wish I had known about that...

Yeah, I could do that too. But I've set it to enabled = no untill a value in cboOrg is selected, for now. I would hide it like you've suggested, but some of our EndUsers aren't very technical, and I'm pretty sure they would come running when they find that "a thing has gone from the computer".

Thanks for that John. But it doesn't work, plus it breaks some functionality in the database. It's not a big issue, just a personal annoyance, that the cboDept remembers the last available options - this is soon cleared when the EndUser selects a value in cboOrg, besides cboOrg always comes...

John you will have to enlighten me on how to do this. I'm completely new to the VBA side of Access. I know where to put it, just don't know what to put there. Would it be an if statement in OnCurrent?

IIRC you can still you setwarnings = off in Access 2007, but you need to enable "show all macro operations".

Details of what the macro steps are would be a start. My guess is you have accidently stated that both the open form and report should be printed.

I guess. Basic structure would be: tblCourts tblDivision tblSeason tblTeams tblGames I would start with lots of sheet of A4 and pens. Draw it out before you start doing anything. How does he currently keep track of all of this?

The cbo remains permantly blank (depending on where I add it), even when I select a value from the drop down list. It resets after my selection. Where would you add cboDept = null to? Ahhh noted. Cheers again. I'm off to bed now, I promised myself I wouldn't bring work home with me. Yet here I am!

I did it, had a brainwave just playing about with the code, today at work. Cheers for all your help John. I would have never of got there if it wasn't for your help. I'm very grateful. THANK YOU! Yeah thats what I was forgetting. "Dept X" comes under "Org X", so in order to have "Dept X" show up...

Taken from Access help... So you are trying to open the same record but on a different form? If I understood that correctly?