I'm using Access 2003.
I'd like to have two levels of users that can access my database. Ones that can read/write the data, and ones that can read only.
I have a network drive with a location that is accessible only to the read/write users, and a location that is accessible to all users.
I...
I have a small database and I'd like to put the user documentation for this database on a form in the database. I was hoping to insert some sort of textbox like object, but fancier than the standard access text box. I'd like the ability to format individual words in a text box, the ability to...
I used a method similar to what you described to select the info. But it seems I'm unable to update it with a query. I supposed I can do it with the help of some VBA code.
I know it seems like a strange thing to do... actually we go though and edit the chosen sample on a case by case basis...
I have a table, each record is information about a sample. Each sample belongs in one of several different groups. I want to mark the sample within each respective group that was taken most recently, and I want to do it by modifying a yes/no field using an update query.
Attached is a...
Thanks missinglinq... good to know that it works properly in Access 2003.
vbaInet, I am using a FindFirst to select a record based on my listbox. In my database I am sometimes selecting a record using a listbox, and sometimes selecting using a combo box. After I navigate to a new record, I...
?? When you click on an item in the list box, your selection stays highlighted ??
I'm NOT talking about if you select using the navigation arrows at the bottom of the form window. In this case I agree it works fine.
I'm using Access 2007. How about you?
Hey again,
I isolated my problem with a much simpler database example.
I attached a database. Go to form1 and compare the behavior when you change records using the listbox... vs when you change records using the navigation bar. See how the value you select in the listbox becomes...
Call RefreshImage is calling a subroutine that I created.
[EmployeeList], [NameCombo] and [NumberCombo] are references to my list box and my combo boxes.
[AccessID] is the primary key field of the recordsource of my form.
Hope that makes it a little bit clearer.
I have a form that is bound to a table. One can select a record using combo boxes or using a list box. Each time I change the record I want both my combo boxes and my list box to reflect this change.
Things work properly when I select a record by using a combo box. However when I select a...
FYI
If Dir(strDirectoryPath)="" then MkDir strDirectoryPath
Did not work properly for me in Access 2007, even if the directory existed, it still returned ""
However,
If Dir(strDirectoryPath,vbDirectory)="" then MkDir strDirectoryPath
worked properly.
I was thinking of using a subform in datasheet view to allow a user to select records on my form. I'd like something similar to a split form, but I'd like to have control of the shape and location of the data sheet part. I could also use a listbox, but I'd like to have all those sort and...
Five years later I had the exact same challenge and this is one of the first threads that popped up when I searched for help.
I will attach my code for solving this problem... I hope it is pretty self explanatory.
Private Sub DeleteImageButton_Click()
On Error GoTo ErrorCode...