Search results for query: *

Hello All, I use SQL databases and Access front ends mainly connecting through ODBC. Is there an easy way of tracking (auditing) changes made in the system? What I want is basically User A changes table B on date, old value is, new value is. I have a method that can do this using a...

How can I have the current Windows user login automatically entered into a field on a form?

I have a user with what appears to be a local setting issue. On her computer, logged in as administrator all works correctly. Logged in as her, reports will not display in any Access application. Furthermore, I can not even create a report or go into design view, only from her profile...

I am looking into a problem with a small database that some one else created some time ago (there are many programming errors, but that is another issue altogether). There are a couple of users of this database (it is in a network folder that is shared). One user has an issue and the others...

Is there a way on a form/record to check to see if another user currently has focus on that particular record? Basically, I want to see check if the record is currently being edited by one user when another user navigates to this record. The reason why is that if one user creates a new record...

I have a search form where criteria can be entered and when ok is clicked a continuous form opens displaying all records that match the entered criteria. The user can then drill down on this form to get details on the specific record that they need. If no records match the criteria I want to...

Is there any way that I can set the mouse wheel to scroll within a field (for example a field with vertical scroll bars) instead of the default scroll to new record?

Ok, here is a challenge... I have a search form where various criteria can be entered... The results are listed in a form for review and the user can click on a record to open the work order on that particular record. All works fine. What I would like is if there are no records that meet the...

There is an option in Access that is set for each individual computer. I would like to have my application change this setting and even better restore the original value afterwards. Under, Keyboard, Behavior Entering Field, I want Go To Start Of Field Any ideas?

I am trying to create a new record in a subform when a certain event happens in the main form. I would then like to transfer data from the main form to the subform (such as department number). I have been able to transfer data from the main form to the subform, however I have not been able to...

Does anyone know how to turn off the message about an item not being on the list in a combo box. The SetWarnings = No macro function does not work on this message. What I am trying to do it this: I have a ComboBox and I have Limit To List turned on so that the Event OnNotInList works. What I...

I am using the SendObject function (macro) to e-mail from a form. Is there any way to insert a value from a field on the form into the To: slot in the e-mail. I have tried the usual [Forms]![FormName]![FieldName] and an error stating that it is not a valid e-mail address occurs. I have tried...

1) I am trying to open a form from a variety of queries depending on values in another popup selection form. I know I can have duplicates of the form based these variety of queries and have a macro determine which one to open from the popup, however, I would prefer to have only one form...

Hello All, I have a different situation. I have a very involved form that has many popup links and other forms can be opened from within it. This form can be opened from a main menu, labeled as create a new record, or from a seperate form that is displaying a list of records that were...

Normaly in an Access MDB I could use the statement [Forms]![frmSystemsEdit]![frmSystemsSoftwareSub].[Form]![SWKey] to refer to the [SWKey] field in the [frmSystemsSoftwareSub] subform on the [frmSystemsEdit] form in a SetValue macro, however in ADP it returns the following error "The...

I have been programming using Access MDB front ends connected to SQL Server utilizing ODBC for some time now. I have used popup forms for users to enter criteria for opening forms or reports on many occasions. I would use unbound fields on forms and then use the statement Like "*" &...