Search results

Hello, I attempted to write a code to change the background color of a textbox when data is entered - The color starts at yellow and I want it to change to white when someone enters data. The code I used was: Private Sub Form_Open (Cancel As Integer) If fldOverallClassification.Value Is...

I created the database, but I am obviously doing something wrong. I attached my creation if you wouldn't mind telling me what I did wrong. :o

I'm a real newbie and ignoramus at Access... I created a test table and form with button that has the code you provided in the "on-click". But after that I'm completely lost. I kind of understand your last quote.. But not enough to know how to accomplish the task. Sorry if I'm being a bug.

Sorry, I'm a little confused... If I wanted to have the form generate a folder each time a new entry is made, can I also have that new folder have static subfolders?... i.e. entry 1 --> c:/program files/access database/folder 1/subfolder A c:/program files/access...

Hey Thanks! I have one (maybe two, or three) more question, though. Is there a way for the code above to add predesignated sub-folders with specific names within that folder?

Hello, Is there a way I can have new primary keys (entered by the user) generate a folder by the same name as the PK onto a specific location on the local drive so that attachments associated with the PK are automatically inserted into that folder for future review?

Hey P. Thanks again for your expertise

thanks for the help. I knew it was an easy fix

Thanks for the help. I knew it was an easy fix.

hello, I have a form with a txtbox named ID and a report button. I have a report that displays all records. How do I tell the report to only display those records that is currently displayed in the form's txtbox?

How do I get paths to images from a table to display the image in a report?

Hello All, This may be an easy answer, but I have a number of tables with one field name that is consistent across all of them (not a primary key, though). My database is a personnel tracker. One table is general information, one photographs, one employment history, one address history...

Hello, How do I create a cmd button to open a browse and enters the path of the file I select in the browse into a txtbox on the same form as the browse button?

I'm not real good with writing code...How would I write VB to set the record source for the listbox? The Query I wrote for the listbox is... SELECT tblB.fldB FROM tblB WHERE tblB.fldA='" & fldA.Value & "' ORDER BY tblB.fldB;

Yeah, I'm pretty sure we're on the same page... I like that you use different colors, let me try that and see if we are... frmA has a control textbox called fldA. frmA displays records from tblA which has different fields, the first being fldA. In frmA is a listbox that displays records from...

Yeah, I tried that and it didn't work either. Is there a way to cause the listbox to return all records from tblB where fldA equals the value displayed on the form in fldA?

Hello, I have been having a little bit of a problem figuring this one out. using 2007. I'm trying to add a listbox to my form that only displays records from a table where the 1st field has the same value as the record currently displayed on the form. For example, if the record I am looking at...

Hello, I created a database using 2007 and saved it as a 2003 mdb file. However, when I run it on a computer with 2003, none of the buttons work and some of the forms come up blank. Did I waste a lot of time or is there a simple fix?

that was it! thanks! Is there another way to enter a code, though, that pops up a error msgbox if no information is entered? xxxxxxxxxxxxx Never mind. I figured it out! Thanks once again for all the help!

I ended up not needing the standard module for the last issue. I removed the 'delete " AND " off the end' code, and was left with this: Private Sub Command400_Click() On Error GoTo Err_Command400_Click 'Button filters out records depending on the criteria entered in the search fields Dim...