Search results for query: *

I have an MS-Access database project (.ADP) linked to SQL Server (MSDE). Before migrating to SQL server, I had a Front-end/Back-end setup of this database. I had a drop-down field to lookup a client_code (row source) from "client" table, and the control source gets stored in a table called...

I have an MS-Access database project (.ADP) linked to SQL Server (MSDE). Before migrating to SQL server, I had a Front-end/Back-end setup of this database. I had a drop-down field to lookup a client_code (row source) from "client" table, and the control source gets stored in a table called...

I have the following string for which I create a querydef to be used in a report. Unfortunately I can't seem to make it sort by "autonumber". Although if I paste the sql statement into an access query design view, it works. Anyone got any idea? SELECT * FROM [order details] WHERE [order...

I have a macro recorded which I need to autorun when a specific cell in the spreadsheet changes (dropdown box). Unfortunately I cannot find a method to run this macro automatically when the cell value changes. Anyone got any ideas? "All is not as it seems"

I am developing a stock system and one of the forms contain a multi-select list box for picking the stock out of the warehouse. The end result is that the system creates a transaction with negative quatity value presenting the number of items to deduct from the stock for that specific selection...

I've recently installed an ISDN system with an email/proxy server (602Pro LAN Suite) and Outlook Express, and in an attempt to cut down on the paper used for printing all emails, was approached with the following 2 questions by my client: 1. Is it possible for a copy of all emails received by...

Hi, how do I go about creating a seperate table extracting all the login users details (system.mdb). The passwords are not a requirement. "All is not as it seems"

Hi everybody, My aim is to return a count on the number of records returned from a table, matching the user entry on a form field (the value for which I pass from the form field "preorder_no" to the variable "var_preorder_no" and then include the variable in the strSQL...

I have constructed a select query in VBA as follows: Dim invcounttypeqdf As QueryDef strSQL = "SELECT [PreOrders details].preorderdet_invoice_no, [PreOrders details].preorderdet_type, Count([PreOrders details].preorderdet_type) AS " & [Counter] & " " _ & "FROM...

Hi, this may sound like a stupid question, but something for me to learn. How do I find out if our Win2K server has a firewall running, because I'm not sure if "Win2K Server" has it built-in? "All is not as it seems"

I have an instance where the majority of users can access the backend without a problem. They have FE's created with the Office XP packaging wizard. The one user has a full copy of Office 2000 in her machine and I just copied the FE to her machine and it went well the first time (after selected...

I have an invoice report (generic/text only). How do I get a new line in the detail section of the report based on a field's value in the previous line. Here's an example of the detail line: qty grade type description 1 3CR12 PLATE...

I have a Access XP (2000 format) DB with a FE and BE. I have an invoice form which has a subform (for detail records), and I noticed when the user enters a record only with a description (in the description field) such as "*** certificate ***" it would then move this to a different...

I Have a FE, BE database (Office XP - DB is in 2000 format). Upon opening a form and selecting a certain account, I require that the control source of selected fields changes to a different source table. In the form's query property, the relevant fields are selected, but I get the following...

I have an Access XP (Access 2000 format) DB which has been converted to a runtime version on a Win 2000 machine. The end product is deployed on a few Win 98 machines. How do I get the runtime version on Win 98 to keep the printer settings. I have setup a generic printer and a custom page size...

Hi, I am using Access XP Developer although the database is in 2000 format. I have a Win 2000 machine which I develop on but the final program will operate on Win 98 machines. I am trying to setup an invoice report on A4 pre-printed stationery. The paper is 4-part cut sheet and fed into the...

I have a make-table query where the new table requires a primary key on one of the fields. Can I manipulate the make-table query (the SQL statement maybe) to set this or would the VBA approach work? If so, how would I do it? I'm looking for the easiest possible solution. Thanks.

I have a DB with a switchboard and a form to reprint an invoice. I execute the "reprint" form, select the invoice number and submit the print with the VBA OpenReport command. An sql query retrieves the corresponding data and then I execute the OpenReport command on four seperate...

I have a public variable called "str_invoice_type" and before I run a report from a form, I assign a value to this variable and would like to pass it to a text box called "invoice_type" in the report. I have set the controlsource of "invoice_type" to...

Hi, I require code that will execute an automated import of a paradox table at a certain time of each day, without sacrificing the CPU usage, In other words, is there an efficient way to execute this without constantly checking the system's time? Much appreciated.