General

Listbox to open a form (primary key text)
Hi, I have created by ID field to except text. The ID field is a primary key. With this primary key I have created a listbox. Now, through the listbox I would like to select the ID field and open the form for only that ID. However when I am using the code below, it shows a message saying Syntax error in string in query... 19 Apr 2010 10:32

Problem with Combo box on form
Hi, I have built a database that contains a number of tables (a list is below) TABLE: Acorn Data TABLE: Contract Entered Data TABLE: Payment Types I have built an auto form using TABLE: Contract Entered Data as my record source the form is called FORM: Input Contracts. This form has a number of combo bo... 8 Apr 2010 14:02

Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be missing something here. Some data on vendor numbers changed. Let's say IBM used to have a vendor number 12345 and now it's vendor number is 56789. I can identify IBM as IBM, but I really want to use the number, not the name. Should... 8 Apr 2010 14:02

From temporary table to master table and then join this in junction table
On Thu, 8 Apr 2010 06:18:21 -0700 (PDT), moso97ad <nyhusevej28(a)gmail.com> wrote: I now want to join the data in a junction table: [tbl_contractdetails] contract_detail_id contract_id product_id You can't create a (useful) junction table from *just* the contract and product tables. The whole point of... 8 Apr 2010 12:37

From temporary table to master table and then join this in junctio
I don't see how you can since there is nothing in your data that links product to contract. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "moso97ad" wrote: Hello, I have imported two spreadsheets from excel to two temporary tables ca... 8 Apr 2010 12:37

da
fadsfafdfsdf ... 8 Apr 2010 11:05

Select case statement questions
in a Select case statement can i have two statement under one case for example i got Select Case Me.lstSalesPeriod Case ByYear strReportName = "Yearly Sales Report" lOrderCount = DCountWrapper("*", "Sales Analysis", "[Year]=" & Me.cbYear) but i also want this case to do this str... 8 Apr 2010 11:05

Apply changes to existing records
I have a database that has a text field that contains a default file path to a picture folder. I've moved the folder and changed the default value of the text field to point to the new location, but the change only affects new records. How can I apply the change to the existing records? ... 8 Apr 2010 14:02

must select from combobox first
acess 2003 I have a subform called fwarranties with a combobox called UnitNo other fields are changed based on the selection in UnitNo How can I make the user select from the combobox UnitNo before entering any other data on the form? UnitNo must have data first. -- deb ... 8 Apr 2010 11:05

From temporary table to master table and then join this in junction table
Hello, I have imported two spreadsheets from excel to two temporary tables called "import_tbl_contract" and "import_tbl_products". I do this on daily basis and import many spreadsheets. I end up with these data: [import_tbl_contract] contract_number contract_title start_date end_date [import_tbl_produ... 9 Apr 2010 04:32