ChipR
Last Activity: Feb 26 '16, 05:30 PM
Joined: Jul 17 '08
Location: Maryland
-
You may want to start here: Default gateway -
So different records require different lists of options in the same field? Otherwise you could use a combo box on the main form, instead of a text box. You can even call combobox.DropDo wn on enter to display your list when they tab into the field. The user can then click an item on the list or use autocomplete.Leave a comment:
-
My combo boxes extend over subsequent records in continuous form view. Are you using Access 2007?Leave a comment:
-
Why not hide/close the form on exit of the textbox that caused it to open?Leave a comment:
-
What's the purpose of the form? When does it open?Leave a comment:
-
You haven't adequately described when you want the form to close. Unless there is an event that you want to trigger the closing of the form, you would use the timer to determine how long it had not been used.
Why not let the user open the form modal if they need it?Leave a comment:
-
Your declaration of the strSQL variable is fine, but you seem to have a typo at
I don't think that MsgBox line will compile (when you get there). Just take out the part in the parenthesis for now.Code:srtSQL = ...
For building your string, you will need to match up the quotation marks. Take a look at this post which will explain everything:
Quotes (') and Double-Quotes (") - Where and When to use them...Leave a comment:
-
In that case, I would join the tables on the date field, and only show records where they were equal and the times conflicted.Leave a comment:
-
You can design a query using the same input table/query twice. The query designer will automatically add AS TABLE_1 to differentiate them. Then you can query for MyTable.StartTi me BETWEEN MyTable_1.Start Time AND MyTable_1.EndTi me. Or something similar.
I'm concerned, though, about how you determine whether these events are on the same day of the week or month if they are recurring.Leave a comment:
-
Here is an example so you can see the syntax. You want to build a string with the values from your form, then run it. This example takes the values from txtBoxes.
...Code:Dim strSQL As String strSQL = "INSERT INTO MyTable VALUES (" & txtNumber _ & ", " & txtAnotherNumber & ", """ & txtString _ & """,Leave a comment:
-
So for each record in one query, you want to check whether its beginning time is between the beginning and ending times of each record in the other query?Leave a comment:
-
Then again, perhaps you just need to add:
Code:Forms.FRMClaims.ClaimsDisplaySubForm.Form.OrderByOn = True
Leave a comment:
-
It turns out if your underlying subform has its recordset defined including an order by clause, you can't override it.Leave a comment:
-
Have you tried using the .Form.OrderBy property? I don't see what the problem could be at the moment, but this may be a good idea anyway.Leave a comment:
-
When you open a database with VBA code in it, you will get a Security Warning if it is not in a trusted location. Click Options..., Enable this Content, OK.
To set the location of the database so that it will be trusted, click Office Button, Access Options, Trust Center (Left), Trust Center Settings..., Trusted Locations.
If your permissions allow, check "Allow Trusted Locations on my network" if necessary,...Leave a comment:
-
To refer to a control on a subform with code on the main form, try this syntax:
Make sure that you replace Subform1 with the name of the subform control on the main form.Code:Me!Subform1.Form!ControlName
Leave a comment:
-
Try this syntax to refer to a control on a subform, which is on another form:
Forms!Mainform! Subform1.Form!C ontrolNameLeave a comment:
-
Depending on how your query is set up, you can for example use a (hidden) text box on your form as the input instead of the actual combo box. Either on the after_update event of the combo box, or just before the query is run, grab the combo box value. Copy it to the text box, but if it is 'All', write '*' into the text box.Leave a comment:
-
You can find a lot of what you need on Microsoft's reference websites, in this case: DLookup Function (http://office.microsoft.com/en-us/ac...288251033.aspx)
DLookup(expr, domain [, criteria] )
So I was just being lazy, referring to the criteria and not wanting to retype the rest. This function is particularly useful, so check out that page thoroughly and let us know if you still have problems.Leave a comment:
-
Hi romes. It shouldn't be necessary to upload your database. I would not be able to download it anyway.
I suspect that your ProofID field may be numeric. In that case, the DLookup criteria should be formatted as
The extra quotes are only needed for delimiting string fields.Code:..."ProofID = " & ProofIDComboBox)
Also, if you created the prodecure manually, you still need to go to the combo...Leave a comment:
No activity results to display
Leave a comment: