Search results

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 can use Access 2002-2003 or Access 2007.

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

Hallelujah! It works. Thank you!!

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

I have Service Pack 3. I'll let you know if I have any luck with that hotfix.

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

Ahh okay. I was stuck because I thought that in order to reference data in my table I had to use Form.Recordset![FilePath] But I see from your code that this is unnecessary and I can just use [FilePath] Great, thanks.

I have a form that is bound to a table. On this form is an image control. The picture property of this image control is set to a path which is a field in the table. When I navigate to new records, I update the image using the following code. Private Sub Form_Current() If...

The expiration table is because I need to somehow keep track of when an employee is due to take a course again. For example some courses need to be taken every six months. Also, sometimes a person needs to take a course that they haven't taken before, so I set the expiration date to yesterday...

Hey, I'm not totally sure, but is this diagram representative of what you were suggesting? One thing... an employee may attend a given class multiple times so i changed that in the diagram. Also, would you recommending making a separate class for Expirations? I know you are supposed to...

I'm having a hard time deciding how to set up my class diagram for a database that keeps track of employee training records. I need to keep track of when employees attended certain courses. I also need to keep track of dates by which employees are required to take a course. Its also very...