I need to design a "switchboard" or some kind of interim form which would allow the user to design his/her own query to pull up records from a table. The...

I have a table that SSN is the primary key. On my form i am trying to make it so that after entering a social into the program it immediately gives me an...

Acc2007 I have a main form with TabCtl2 with pages and cboRecord to choose records. PageA has a SubF_01 wtih txtDtBorn to write date born and another txtAge...

I cannot figure out how to resize & move controls?. I was told to use the "Properties dialog"....which I presume is the "Properties sheet"?....but no matter...

Can I implement the Access 2007 split form in Access 2003? Or simulate it? -- Jim

I have a split database with a frontend and backend. Users would like to archive the current data that is in the backend and start fresh for a new year. But...

I have a control on a form. The name of the control is STATUS. If the data in STATUS shows to be “Inactive� I would like a label to be visible. The...

I am trying to use a switch function on my form that reads as follows... =Switch(="1","Yes",="2","No") However, the results to this function always...

I have a form that enters a number into my table. I want the database to tell me if the number I am entering is a duplicate. Right now if I duplicate the...

When I am going thru my records in a form, I get to the end of the records(the last record) and usually it would have a blank primary key. But not anymore,...

I want to input my song times into my subform and have them automatically calculated in a main form control. i.e. type 3:50 in one song and 3:50 in another...

I have a form that I have two fields I want to show or hide based on the value in another field. Previously I had one field that worked OK. Recently I...

I have an Inventory Form where I use a lookup table field to add the User. The User Lookup Table is linked to a User Detail Information table that I am...

I have a set of fields on a form that are bound(using Control Source property) to a table. Everytime I close the form by clicking X, it always add new row to...

Hi, I'm working on what should be a really simple supplier audit database and I thought I had set up the relationships OK until I started trying to create...

Hello All Please Tell Me How Can I Get The Type Of The Control In VB6 In Access We Use The Code For Each Ctlr In Me.Controls msgbox...

Hello NG, is it possible to update code in forms and modules using a vba-routine to replace f.e. everywhere where used, "SumOfDollars" with "SumOfEuros" With...

using Access 2007 Windows XP I'm attempting to insert a default value in a control on a form (frmCashrcpt) the control is CURDATE. On the form OnOpen...

Hi, I have my data grown up enormous, and it is shown in my List Box. There is the problem of that enormous data to view. I like to filter the Field by the...

Hi all, Steve M just helped me solve a foreign key issue, thanks steve. But now i'm hoping i can do a group update. Basically i have an asset register, with...