Using the following code, I cannot get the detail section to change back to the original color, regardless of the text selected in the combo box. It changed...

I have the following code to step through records in a query and I need help adding a parameter to the query. Public Sub Command23_Click() Dim rst As...

Hi, I'l looking for a way of opening my form with a button and going to a certain tab within that form. Any help would be very welcome.... Paul

Hi All, Can some please tell me what i'm doing wrong here. Private Sub Form_Open(Cancel As Integer) If Form_Voucher_Subform!Expire_Date = Date...

How can i stop /prevent/disable 'Ctrl C' ant 'Ctrl V' in a datasheet form -- Regards Patrick Stubbin

Hi I have just come across something unusual: I was setting up an existing database on a couple of new Dell laptops when I noticed that disabled buttons,...

Hey... Can anyone guide me as to how to setting up a form that allows user to Select a book title from a combobox and then all the books on the searched title...

I have a form that is based on a query (Qry_User_XFDP) which filters records for the specific user. SELECT Tbl_XFDP.ID, Tbl_XFDP.Firms_Number,...

Importing an updated switchboard into another database, get form and coding OK; but the switchboard manager items do not come over. Do I need to reenter the...

I am trying to setup a db that manages a rental operation. I have a main form "Jobs" which includes the subform "JobRooms" - joined with a one-to-many rel by...

***********************CODE** strCboSQL = "SELECT DISTINCT PC.iProductCategoryId, PC.sDisplayName " _ & "FROM dbo_tblProductCategory PC " _ & "INNER JOIN...

I need to check a table for duplcate information as I am entering information into the form linked to the table. Unfortunately, I can not make the field I am...

Hi Everyone I have a table called tblComments where I store details of any updates or news relating to the database. I would like to have a window on the...

I have three pop up forms (which work like a dialog box) that I want to use in another database. How can I export or copy them? I have tried to export them,...

I have the vb code below in my form. On the form I have the date in a field called "Del" I have a textbox called "LP" with the following in the default...

I have a form with the following onopen event where and is a bound yes/no tick option - but I get erratic results depending on which record is shown from the...

Hello. I am trying to get a subform to sort on (2) fields, by Date, and then by Time. The form is linked to the master form by and ID#, etc. I cannot get...

I have made a list box and every time i save the problem from the list, the id is placed in the field in the table. I have tried changing the bound column and...

Very simple - after adding a new record in a subform, I am trying to requery a combo box in another subform but I keep getting the error (You entered an...

Hi, On a form, how can I assign a HotKey (say F12) so that when it is pressed the curser will jump to a certain Field no matter what field the curser is in at...