Search results

DEPT_WARD is the name of the subform? Or is it the name of the combo?

Sorry, can't help you out on that one. Hope someone else can! Seth

What code are you using? Not many good ones go around on the net. I have one, we use it under WinXP and it seems to work fine. I do not take credit for this code, someone else made it (Can't remember who...). If you're interested: 'Public Sub SendNotesMail(Subject as string, attachment as...

This last question was solved in the VBA-section of this forum. Click here.

Don't quite get it, you want to total the hours per business and then let the user overwrite that value? Please give us more ;-) Seth

No, it will only load the orders of whom the agents correspond to the selected location. It was my pleasure! :-) Seth

Here you go! Seth

Can you upload the database? i'll show you what i mean. Seth

Nice! Didn't know that one yet! :-) Thx! Seth

If I understand you correctly, you have for example a project with ID abc123. This project-ID is stored in a field with the name txtProjectID. All your project-folders are under the same path, for instance Z:\Projects Then try this: Dim ProjPath ProjPath = "Z:\Projects\" &...

Create two forms, frmSearch and frmResults. In frmSearch, place textboxes for the search-fields. Create a query that filters your results based upon the values the user inputs in the frmSearch form. In the querycriteria below each field, place similar codes: Like...

That also was an option indeed! Glad you figured it out :-) Seth

Try this: Your fieldname is in this example txtField In your VBA-code: Me.txtField.Value = UCase(Mid(Me.txtField.Value, 1, 1)) & Mid(Me.txtField.Value, 2, InStr(1, Me.txtField.Value, " ") - 1) & UCase(Mid(Me.txtField.Value, InStr(1, Me.txtField.Value, " ") + 1, 1)) & Mid(Me.txtField.Value...

Ah I see! You'd like the options to be turned on or off. In that case, those option-buttons do seem like a good idea maybe. Anyhow, I hope you're back on track now! :-) Greetz, Seth

I mean that you should make a listbox, containing all the locations you have in your database. Name it lstLocations. In your query, in the criteria of your Location-field, you have to place a reference to that listbox on your form. That way, the query will only return the records where the...

Create your form and place an extra field with the locations in your header-part. Then create a query containing all your table fields. In the query-condition of your Location-field, place a reference to the top-most location-field on your form (ie [Forms]![Form1]![lstLocations]). Use this query...

Make a textbox and set its Visible-property on False so that it's hidden. Now, create your buttons and for each button, create an OnClick-event. Make it so that when a user pushes the button, access updates the hidden textfield with the value of your choosing. Then requery the form. Make sure...

Maybe I'm thinking too simple, but why don't you just set the Modal-property of the form on True? That should keep it focussed until it's closed. Or do you want to keep the entire access-app ontop in windows?? Greetz, Seth

This is how you have to do it. Clear what you have typed in the AfterInsert property. Then double-click on it so it shows something like '[Programcode]'. Then push the button next to the field (right-hand) with the '...' on it. Now you're in the VBA-editor and you'll see something like this...

I'd guess the properties of the listbox weren't set right. Check the Rowsource, see that it is set on 'List of values'. Also check the 'List Only' setting, maybe that one causes it. What is the recordsource for your form, is it an editable one? What is the controlsource of your list? Does it's...