Forms

Load Access From Default Drive?
Hello all, I have a multi-user database that I want to send to others so they can try it out. The problem I noticed though is the drive letter access looks for is the one I created the database on which is "G". Is there a way to tell Access to use the current drive (whatever the drive letter is) to load wh... 4 Jul 2008 23:18

Case statement Problem Compile Error
Compile Error Expected Expression if I put ? Debug.Print Left(Me.Combo28.Column(1) & "", 1) in thr immediate window Also I get an error that the Value of the Combo Box is not set yet.or not calculated. I used to be able to use the immediate window very successfully. Please tell me if I am doing something wro... 5 Jul 2008 02:21

List box formatting
Is there a way to do conditional formatting in a listbox? i.e. row different colors according to criteria? I have Access 2003 Thanks, Sam ... 4 Jul 2008 17:11

Help with Dates
I have a form with several unbound text boxes. txtSTART_DATE txtEND_DATE txtTOTAL_WORK_DAYS txtCURRENT_WORK_DAY I've used the following code to find the values of the first two text boxes, but I can't come up with anything to give me the last two. Me.txtSTART_DATE = DatePart("m", DLookup("[INV_THRU]", "tb... 4 Jul 2008 19:13

Command BUtton Caption on continuous forms
have a continuos form with a command button that I would like the caption of that command button to change depending on the transaction type of the record. For example, if the first record displayed is transaction type "123" then the caption should be "display report for trans 123". If the second record is t... 5 Jul 2008 22:43

Command Button Caption on Continuous Form
I have a continuos form with a command button that I would like the caption of that command button to change depending on the transaction type of the record. For example, if the first record displayed is transaction type "123" then the caption should be "display report for trans 123". If the second record i... 5 Jul 2008 10:28

how can i play a 'wav' file in access 2007
does anyone know how to play a 'wav' file in access 2007. All i want to do is play a 'wav' file when two conditions are met? ... 4 Jul 2008 16:09

Help Problem with form coding in Access 2003
Hi Hope you can help. Im building a purchase order form within Access 2003 and i would like the form to auto fill in the supplier details from another table once i have chosen the supplier from the unique id drop down menu on the form. Im stuck at the moment, so the any help would be great. Cheers Simon... 4 Jul 2008 21:16

API Call
Is there an API cal I can use to get the operating system? Thanks -- Shell ... 4 Jul 2008 13:05

Select Subform based on Current Data
I have a form that show various insurance claims; WC, MVA, GL, PL. I have a subform for each type of claim showing various details of each claim. Is it possible to have only the corresponding subform show depending upon the type of claim the current record is? If it is possible, where would I put the event p... 5 Jul 2008 13:32