Search results

You could try something like the following. You create a recordset which will specify the names of the queries that you want to output... in this case we will call both the queries and the worksheets by the names of your codes. It will run through... create a temporary query for each code...

You aren't being very specific... but how about you select the form and then press CTL "P" to bring up the print options?

Mercy, Not really. I wish I could be more motivated to do these things when I get home from work. I have 2 pc's. One with a LInux installation (Fedora) the other with Windows XP. I have been having more problems getting these systems correct before I can look at the website design. Trying...

Take a look at this... kept it simple for you. Just open the report and you should get what you want. J.

Hey Fluid... You will need to translate your query into SQL and then place it as the criteria for your recordset. The code steps through a recordset in order to output it to Excel, so you need to keep the same format. Put the query in SQL view then copy that code into the bolded section below...

Smile, I can't help you with anything but Access 97... sorry.

I am coming back to this post because I found another db with an example of appointments and a good means of displaying them with a calendar form. It comes from here (named "calendar"): http://www.utterangel.com/pages/access_downloads.aspx#pagetop I have zipped and attached the db with updated...

Ok... you caught me in a good mood... will do!! It's a beautifully crafted piece of code, so it's only fitting that someone takes some credit. Good job matey ;)

Will have to remove the folloing comment from my copy... 'Credit to Rich, Access-Programmers.co.uk :eek: Sorry mate. :p

Access 97... works really well.

Create a global module In this module add the following: Public gstrUser As String Then in the login screen assign the user value to the global string gstrUser = me.txtLogin.value This should make it available for use after logging in.

I hadn't tried this before, but it seems to work. Create a query that has all of the normal criteria that you want to show in the report. Then add one addition field to the query of... VariableField: [Input your Variable text Here] Then add the variable text field to heading section of your...

Rich, Have stepped through this and think it is absolute Poetry... nice work ;-) J

Jeremy, I also use 97 at work and if I work on a report for a long period of time it can sometimes become corrupt and exhibit similar problems to what you have described. Can I suggest that you take a screen-print of your report, print out a hardcopy and then try to re-create a new one from...

Are you refering to an option button or check box on a form? If so, the syntax for both would be similar... something like the following: If me.optionname.value = 1 Then 'Option button is ticked -- True 'Do these things Else 'Option button is not ticked -- False 'Do these things End If

Suspect that this is because you have criteria of the max of the coaching date. You can't apply criteria to a resultset that doesn't include a value. Make a third query that has an outerjoin from the employee table to the 2nd query that you created earlier.

I think that you should be able to download a vcard?! Anyway... try this james DOT ramsay AT rbs.co.uk replace the capital letters with their respective symbols... don't want this email to be picked up through phishing. J.

Ian, If you post your db in Access 97 (all that I have available at work) I can take a look. Otherwise look up my email address, zip it and email it to me. J.

Ian, No offence mate... but if you have 3-5 tables that all have name,month,hours then you should look into the concept of normalisation. I would suggest that you have table tblEmployee with employee details, and then this is joined to an tblHoursWorked table on EmpId. You shouldn't have the...

Ian, Doesn't look like you should have this information in separate tables. It looks like all of the info should be in one table because it contains the same fields, the same detail and there is nothing to distinguish between them. I would suggest that you take another look at the design of...