Getting Started

Why my BE is opening Read-Only
I have a split database that I've been working on a while with just 3 users while in the test mode. I rolled it out to the whole company this week and I've been experiencing something, not consistant and very frustrating. "Sometimes" the BE opens read-only and when it does, no data can be edited. I can hap... 17 Jun 2008 15:14

Refresh List after edits
I ahv a List, and a field that can be updated - how do I refresh the List display after the user updates a field - VB if pos. Thanks ... 17 Jun 2008 10:07

Combo Box changing data in Table ?
I am using a Combo Box on one form to select records from a table to display on the next form. I do not want to update the data, only use the record selected in the Combo Box for the Criteria in a Query. Currently, when I select the record I want in the Combo Box it brings up the next form correctly. However... 17 Jun 2008 14:43

Help with List Rowsource SQL syntax please
I have a List that I am feeding from an SQL statement like; me!ListWhite.Rowsource = "SELECT UID, SalesDate, CSSales, RAMSales, INTSales, CSAddOn, CSSales+RAMSales+IntSales+CSAddOn AS TotalSales ,LabelsGen, Fixed FROM WhiteBoard" I would like to have - SalesDate AS Date - so the column header is 'Date' not ... 17 Jun 2008 11:39

DSum
How can I have the DSum to only calculate de Sum when a field is updated? Because it keeps on adding the same value over and over when I open the form. If the field value is 50, verytime I do a DSum for that field, it's always add 50 even though I only have 1 row. ... 17 Jun 2008 14:12

Database from start
Need help with business order It should be like this example: BUSINESS ORDER Id Order: (ex. MK 01/01, MK 02/01, MK 03/01...) Date: Customer - Name Customer Order - many activity (ex. 1. cutting material, drilling material, up to 10 or more activities) Work hours - (ex. cutting - 2h, sawing 5h, drilling 3h .... 19 Jun 2008 08:33

Duplicate all fields except one
Hello, The records in the JOBS table have 20 fields. I'd like to duplicate the record but change the YEARID field. My wizard built a button to copy the record, how can I modify the code to change one field? Thanks in advance, Paul Private Sub DuplicateRecord_Click() On Error GoTo Err_DuplicateRecord_Click ... 17 Jun 2008 14:12

Scroll bar on a Listbox ?
I see pictures of other peoples Listbox's with a scroll bar - dark blue bar highlighting one whole row - how do I get that on my list boxes ? Thanks ... 17 Jun 2008 08:35

Simple Query Wizard
How do I find the simple query wizard? ... 17 Jun 2008 10:07

How to build a calculation Querry
I have a querry now built but I need to take info from one colum. From that info I need to then select a size in an other colum and mulitiply it by a factor to produce a seperate colum with this new number. Any help in this is very appreciated as I am new to this. ... 17 Jun 2008 14:12