Search results for query: *

Ok... To help you out would you be able to give me the details of the field name you use? It is something like... [Employee's] EmployeeID, Name, etc... [HoursWorked] HoursWorkedID, EmployeeID, Date, Start, Finish? In your subform, where you click to enter the date, you could have a onClick...

Hi, in brief, the code will be along the lines of.... [Forms]![Formname]![subformname]![fieldname] = [Forms]![Formname]![othersubformname]![otherfieldname] Repeat as much as necessary. You could put this code in the OnLoad property of a subform. Or even behind a button called Copy. Hope this...

Hi Tony, thanks for the reply. Yes, this would allow me to enter a name and search for it, which is what I'm after, but what the combo box does right now is go straight to that record when the Go button is pressed. I'll show you a cut down version of the combo box.... ID Name 1 Bob 2 Dave 3...

I would, but its quite full aready, and I'm not too keen on having two "Search By Name" fields. Surely if must be possible to have some sort of a If statement alon the lines of... If Me![name] is an item in list Then open view details form Else Open search search results Any...

Hi, thanks for the quick reply, but this doesnt help my problem. The problem is, the combo box contains say 3000 names. Instead of the staff scrolling through them, they want to be able to type in "Smith" and click go to view all Smiths. Even though the Go button is set to open the...

Hi, what you should do it in your query it will be in the format of something like this.... Select table.field, table.field2 etc etc From table Now, after your select statement add this.... INTO temp-contactsTable so it'll look like this.... Select table.field, table.field2 etc etc INTO...

Hi, I was wondering if the following was possible, and if anyone could help on it. Basically, my database holds details of nurses, where on the search screen users can search by course, specialism, status, personal tutor, and name. In the name box, users can only select items in the list, and...

Hi, Did you put this code in a module? Or simpy in a text box somewhere? What to do is, go to the Form Properties, and go to the Event Tab. Now, click on the "On Load Box" and then click on the "..." button at the end of it. This will open the forms module, and start an...

Hi, I had problems with trying to set up mail merge before, and to work around it I used update queries. Ok, in my database, which holds Nurses details, the users can view a Nurses Details, and on that form there is a Button called "Send Letter". All this was required to do was Open MS...

I used a similar piece of code for transferring details of people from one form to another.... here goes :) 'First open the form DoCmd.OpenForm "form2" 'Now the form is opened, put in variables! Forms![form2]![value1] = Forms[form1]![value1] Forms![form2]![value2] =...

What about simply having multiple Yes/No fields (checkboxes)? To do this, add all the required fields into your table, then add them into your form. This ensures they are actually saved to the table too, rather than an unassociated Option group. Hope this is of help, David

Hi, put this code in the Load property of the form.... DoCmd.Maximise Thats the quickest and easiest way :) Hope this is of help, David

The easiest way to do this would be to go to the form properties. Then go to the Data tab at the top. There will be a field called "Data Entry", now turn this to yes. This will ensure every time the form is opened it is in Add Record mode. Hope this is of help, David

Hi, thanks for the reply! Works perfectly, now it means I have to change about 60 forms... ARGH! But, since converting to XP and Enabling the DAO reference again, my database is running so slow.... shockingly slow infact, at least half the speed it was on Access 97. My PC Spec should be up to...

Hi, Thanks for the reply, however, the problem is Still there. All checking the Box for DOA 3.6 seems to do in my database is severly slow it down. Any other suggestions as how to get rid of it? David

Hi, I was wondering if anyone could help with the error I am recieving. Upon running the following code behind my Delete and Cancel buttons, I get the following Popup. Complile Error : Method or data member not found The code used behind my Delete and Cancel buttons is listed below: Dim...

Hi, thanks for the reply! I figured out a way to work it, by creating Make Table Queries, which simply take the results of the query and store them in a results table. (Front end of the database is stored locally). The mail merge is then run off of these. This seemed to me the best option, as...

Hi, thanks for the reply. I'd already done that, heres the code I'm using incase anyone else is interested... 'Turn off warnings DoCmd.SetWarnings False 'Run Query DoCmd.OpenQuery "Mail Merge - Selected Student - Main Menu" 'Turn on warnings again...

Excellent, you've saved my life! A well deserved Star for you my quick replying fellow!

Hi, Is there a way to stop the dialog boxes appearing when a query is run? What I'm trying to achieve is to run a query which puts all its results in a table, which is then used for a mail merge. The problem is that I get 3 popup dialog boxes asking me to confirm this action. Is there a way...