Search results for query: *

I'm using access 2000 (couldn't find my Access XP developer CD), you think this is the problem? All is not as it seems!

Did you try it in a project file (.ADP)? I was getting the following error: "Run-time error 2757--There was a problem accessing a property or method of the OLE object" All is not as it seems!

Account" is a field in the "Client" table. I worded it incorrectly as "client_code" in my original post. It is actually "account". I was told it should look something like: client_name = CurrentProject.Connection.Execute("select [name] from client where quote_acc_no=" & replace(client!account...

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...

Hi AlexCuse, thanks for reply. The VBA code in the form is as follows: [code]Private Sub quote_acc_no_AfterUpdate() Let client_name = DLookup("[name]", "client","

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...

Thanks mp9 I did already try it but upon second attempt after your post, it worked, because I previously missed a space before the "order by" in which case it joined the "prompt_order_number" value and the word "order" and gave a syntax error and I automatically assumed that the fixed field name...

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"

You guys are truly KINGS (or queens if you're female :-))!!!! It worked (I always battle with the quote story). Thank you SSECCA, after a lot of playing around, your solution turned out to be simple. :-) "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 tried the recordset method and it worked. What bugs me is that I can pass a variable to the query, but cannot get values back from the queries.... Anyway, such is life. Thanks for your response Jhall156. "All is not as it seems"

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...

Thank you all for your responses, I will be looking at purchasing firewall software. Peterve, thanks for the link, it was helpful. "All is not as it seems"

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"

Once you open the app. (eg. Windows paint) How would you go about capturing the filename from Windows Paint into the database? "All is not as it seems"

I figured out a variation of your solution that seems to work. The code is as follows: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Let cut_size_description.Visible = True If preorderdet_type <> &quot;CHANNEL&quot; Then let cut_size_description.Visible = False End...