Search results

I wrote a simple code to check for three values of three different fields in a form and find a record in a table if they match - I did it by using the findfirst method and checking for three criterias connected with "And". So for example if fieldA = x, fieldB = y and fieldC = w, open tableA and...

I'm not sure if this needs vba but I haven't found a simple answer on google... maybe a wrong choice of keywords I have a combobox where I want to get its values from five different columns in one table. I can use an SQL query to get it but it's displayed in 5 different columns in a big table...

I stormed google searching for a solution for this and found nothing. I want to use the .findfirst\next\last method using a criteria that uses a string variable AND a "begins with" wildcard. I don't understand how to write it at all. Basically it should say something like this: In recordset...

My database is used by a few users on a shared drive in "read-only" mode so they can't change any data. I set a scheduled task to copy an updated version of the database (which I edit) every morning. The problem is that when the users forget to close the database file I can't overwrite it. For...

Hey I'm new to Access and VB but I managed to write parts of what I want access to do.* By tweaking a code I found on the internet, I managed to write a small Subroutine that allows the user to click on one of the fields of a record in a report and then Access opens the form on that specific...

Hey, I have a form that has a dropbox list and I want the values of the form to change according to the value in the dropbox. For example: When the dropbox contains the value A, The form would display x=1, y=2, z=3. When the dropbox contains the value B, The form would display x=4, y=5, z=6...