altesse33
Last Activity: May 2 '08, 03:31 PM
Joined: Oct 2 '07
Location:
-
Never mind, I fixed it. I was referring to a field as "ClientID" when it was actually "Client_ID" (with an underscore). -
Using a "where condition" with DoCmd.OpenForm
I am trying to open the form "frmClients_Mai n" to the record that is specified by the end user. Here is the code:
----------------------------------------------------------
Public Function IDSearch()
'This function allows the user to open the main form to a particular client record.
Dim stSql As String
Dim stInput As String
'InputBox prompts user to enter client ID for the... -
Use results of a query to open corresponding records on the main form?
Hi,
I have put together a reference library of journal articles and other citations. There are various queries that prompt the user to enter a search term (such as a keyword) and return all article citations that contain the keyword that the user entered.
We want to add a feature where the user could click on any part of the citation info returned from the query, and be taken to that same citation's record in the main... -
refresh subform after adding records to related table
I have a command button on the main form of my database that allows users to add new records. But, even though new records get added to the sub table when I click on the button, those new records aren’t immediately reflected in the combo box that is on the subform (whose record source is a junction table).
Do you know of any methods I can add in an event procedure to update the subform? I added the following code based on a suggestion... -
Thanks Luke! This clears things up. :)...Leave a comment:
-
VB question
Hi,
Not sure if I am posting to the right place --
I am trying to create a calculated field that has a specific URL as a constant: \\MyNetwork\MyF older
- when the user clicks on the field, they can add to the constant, e.g. \\MyNetwork\MyF older\NewFile
- this completed URL then gets stored someplace useful
here is the code I have so far. I'm getting errors at the last line:...
No activity results to display
Leave a comment: