Search results

Can someone help with this problem? I created a database for another department that I split and configured the FE to point to the BE via an IP address on my server at my office. It worked perfectly. The department moved to another location outside of our building. I placed the database on...

Please help ... what did I not do correctly? When modifying a form in the administrator mode - I can modify the design of the db without problems (I modified an 'Add' button on a form) and it works! I've copied the .fe, .be and .bak to the live directory. But when a user logs in and accesses...

Please help ... what did I not do correctly? When modifying a form in the administrator mode - I can modify the design of the db without problems (I modified an 'Add' button on a form) and it works! I've copied the .fe, .be and .bak to the live directory. But when a user logs in and accesses...

I have attempted to setup security for another database almost 6 to 12 months ago. When I attempted to setup security for a totally different database, I still see the old security settings for the previous db. What do I do? I there an easier way to setup security for each system that does not...

How do I add security for a datasheet for one user only with a click of a button? The other users will use a form that does not require security. Thanks!

I'm modifying an existing db that has a field in the table named "city". To reduce errors, I have created in the form a dropdown field for the city. In the dropdown menu, the city field is blank. I also created an update query to update all records with the city named "Sardis" . I'm getting...

I created a password in a database that I created last year on my laptop. I copied a totally different database onto my laptop and tried to open file and it thinks it's associating the old password to the old database with this one. Help. I looked into the registry and *.mde files and...

How do add a specific form in the documentor under "Analysis" in the pulldown menu? I see all of my tables and queries, but not my forms. Thanks,

Please help me with an issue that an end user has described: If we are on any tab other than the first one ("provider-training location"), and we scroll to a different record, the next record defaults back to the first tab. In other words, there appears to be a set focus on the first tab. This...

Here's a problem from my end user. Can you assist me with problem: Whenever we add something new (i.e. a new record or new course code), the existing records are "scrambled." Instead of being in numerical order according to provider code, they are rearranged in order according to course code...

How do I clear all transactions, even edit checks from all fields on a form when the "cancel" or "find" button is clicked? Thanks,

Got a question: What is the best way to view an archived table and form within the existing db? I do not want the end-user to modify the table/form as well. Only view it. Thanks,

I have an existing table that has a date entered field. The outcome of this task is to add the autonumber field in the sorted table according to the date entered field. The earliest date should have #1 as the autoNumber, not 906. So far I have not been successful ... Please help. Thanks,

I added a button "previous record". Whenever I click the button to go to the previous record(s), it only advances to the first previous record but will not continue. I don't have that problem with the "next record" button. Here's the code. What went wrong? Private Sub...

How do I create bookmarks on an Access form, specifically not bookmarking a record, but bookmarking a title within a certain section on a form for easy access without using the scrollbar?

How do you create 2 forms (without using tabs) that is linked to the same record? Example, instead of creating 1 long form, I would like to create 2 forms, having a button that opens the 2nd form and staying on the same record that you were in on the 1st form. i.e. if I were on record #20 on...

How do I update the BE with a new table that I recently added? Should I unlink the FE and BE and re-split the db?

How do I advance to the top of a form from within a form. I want to program a button at the bottom of the form to go to the very top of the form. Thanks,

I have the following code to validate data to ensure it's correctly keyed in and not a duplicate. I have keyed in the county code of 014 and I get a run-time error of 3464 - Data Mismatch. Why? Here's the code place in the "Before Update event: Dim MyVar As Variant Dim County_Exists As...

How do I get the form to automatically update certain fields that is pulling data from another table? I have cascading combo box in place whereby the user will select a State. The very next field is the County correlating to the State. Both the State and County pulldowns have a control source...