Search results

On my machine, my access forms display and runs correctly. However, when I run it on other machines, one of the forms do not even open at all. I notice a very small rectangle in the corner of the screen. It looks like the machine has a problem displaying the entire form but can only display an...

I have already customized the quick access toolbar on my Access file for my machine. When I copy this file onto other workstations, how do I ensure the same quick toolbar settings are applied to other machines? Once I am on their workstation, do I have to copy Access.qat using the Office...

I added a hyperlink object to my form. I referenced the link in the "edit hyperlink" screen to http://www.google.com When I try to click on it, I get the error "Unable to open http://www.google.com. No program is registered to open this file." Am I required to reference hyperlinks in a table...

Not if TextBox contains text.

In an "embedded macro" under the "condition" column, how long can an expression be? I have the following expression that always gets shortened. I need this conditioned process before triggering an action. If I can't change the length of the expression set by Access, is there an alternative...

I do have a form bound to the Transaction_Detail table. Can you bound two forms? Ideally, I'd like to update two tables at the same time using a unique identifier.

I have two tables: Master_Transaction & Transaction_Detail; this is a one to many relationship. When a new row is added to Master_Transaction, the autonumber field creates a unique identifier. Immediately after Master_Transaction gets updated, I would like to retrieve that new unique...

You are absolutely right. After creating a new db, the routine worked. Hopefully, only the form in the original DB is corrupted. I can simply recreate it.

Still getting the mismatch issue I used the following code: Private Sub Form_Unload(Cancel As Integer) If MsgBox("Are you sure that you want to close this form?", vbYesNo) = vbYes Then Exit Sub Else Cancel = True End If End Sub I still get the error 13...

When the user presses the "close" button on the form, I want a a msgbox with the following message to pop up: "You will save data and form will close. Do you still want to close?" Yes - will save and close form. No - will keep the form open. I keep getting Error 13 "datatype mismatch."...

In the OnClose event, I added the following code. I want to prompt the user with a Yes/No question. I receive an run-time error '13' on the 3rd line. How do I get rid of this line. Private Sub Form_Close() Dim myReply myReply = MsgBox("Are you sure?", vbYesNo) If myReply = vbYes Then...

I have a main form with a subform. On the main form, I have a list box with rows of data. When a user clicks on a row, I want the value that's bound to the list box get passed into a subform. The subform allows the user to scroll through a table of records. However, I would like one of the...

Duh. It works now. Wonderful.

When I set up my datasource to an SQLSERVER, I input username and pwd and successfully tested the connection. After I open up a linked SQLSERVER table in access, I get the SQL Server Login box prompting me to input a password even though I had done that while setting my datasource. I do not...

If I enable a text box when the user select "Y", I would like the user to comment or elaborate his response. I also want to record his steps for reporting purposes. Is it best to pass the values of his answers from one question to the next. Then commit the values after he reaches the last...

Is it possible to design this in Access. I envision a user to open a form that will ask a Y/N question. If user selects"Y" and clicks "next", a different question is asked on the next form. If a user selects "N", user gets routed to a different question. So the idea is to have a user answer a...