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...

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 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...

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...

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...

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...