Search results

Hi, I was wondering if it is possible to filter the results of a query by selecting one record, then only showing records that preceed it alphabetically. So if you have these names in a database: ALBERT BOB CARLA DILBERT EDWARD FRED And you choose to filter results from CARLA to EDWARD you...

I want to filter a report by vendor. The user types in the name of the vendor in a text box, and then the code does the following: DoCmd.OpenReport stDocName, acPreview, , "[vendorcode] = " & text1 However, I get a prompt for some reason. For example if I enter 'GEORGE' into the text box, when...

I have a form that lets the user select sorting and grouping options for a report. The sorting part was easy. However, I am not sure how to do the grouping. I am guessing I need to create a groupheader in run-time, based on a field the user wants the report to group by. Any ideas?

i am trying to use the orderby property of a report in microsoft access, but i just doesnt seem to have any effect? i have set order BY on = true in the settings dialog in design mode I have a form which allows the user to select a field by which the report will be ordered by. in code i am...

Hi. I have a report spec. which requires customers listed from top to bottom, then product colours they have ordered across the top of the page horizontally. then the qty they have ordered should appear lined up with the relevant customer and colour. like a matrix i think? So if customer 1...

Anyone that has had to reverse engineer an existing database should know that it can be a difficult and complicated task. Especially when you are dealing with a database that has been made in a less than desirable fashion (eg, poor relationships, no commenting, wierd tablenames and field...

This seems like an easy question, but i have no idea how to do it... If I have a field for the [costprice] and [soldprice], I can work out the profit by calculating [soldprice]-[costprice]. So, if costprice=60, soldprice=120... profit=60. In this case the profit margin was 100% of the...

Hi.. Was wondering if it is possible to make it so you can save or copy the text from the immediate window into a text file or somewhere else in code???

Is it possible to format a number field so that a positive (+) symbol appears before a positive number, just like a negative (-) symbol appears before a negative number.

I have two combo boxes on a form. one is products, the other is colours. products looks up all the products from the products table colours looks up all the colours that are related the the selected product. I set the row source for colour like this: SELECT colours.colourID...

Has anyone used or encounted a program called Fashion Sense 2000? It is a front-end written in delphi that uses microsoft access as a back end (for the tables). We currently have a client who are using this software and are having problems with record-locking. When using the system across a...

This is a common and simple problem many people (beginners like me) seem to have... but i couldnt find anything to help my specific problem on the forums so.. I am using an SQL statement in a form's code like this (simplified): SQL = "UPDATE tableName " & _ "SET date...

For some reason, the database has began complaining about 'Form1' being missing when coding my forms, even tho I'm not using a form1 anywhere. I get the following message: "The form name 'Form1' is misspelled or refers to a form that doesn't exist. If the invalid form name is in a macro, an...

I want to display all the products in a products table, and then display the sum of the quantity of these items that are on the order table. However, if a product thats in the product table is on no orders (that is there are no related records in the orders table), it will not appear in the...