Search results

On my form I need to choose and compare the primary keys of two tables. As I select each table and field a textbox COUNTSOURCE builds a SQL statement (basically a duplicate query). If I pass this statement to a como box all the records are listed, in my case 72 records. How could I actually...

Does anybody know if MSCAL.Calendar.7 can be set so that Sunday shows as the first day of the week instead of Monday.My company uses a timesheet with a week begginning on Sunday. Thanks

Hi I run a bit of VB on the click of a command on my main form, the last instruction is: Me![frmLoadOLE].SetFocus Me![frmLoadOLE].Form![cmdLoadOLE].SetFocus This is to set the focus on a command button on a sub form. The commands on focus then runs more VB. It is a bit messy but all...

Hi I have a list box on a form where I can select any table in my database, the onclick event puts my selection into the rowsource of another listbox. Private Sub lsttables_Click() tblsamp.RowSource = lsttables.Value tblsamp then acts as a sample view for the selected table. At the moment I...

Hi I am trying to use a form to update a field in a table by selecting all the values on the form and passing them into a SQL statement. I select the table name [Points] on my form from a list box 'lsttables' which uses MSysObjects as row source to show all the tables in the database. The On...

Hi I am trying to use a form to append data in several tables to one main table by mapping field names and feeding them into SQL. My data is supplied in one format but the column order will always vary. On my form I select a table name [Points] from a list box 'lsttables' which uses...