Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. drazeni

    Dlookup Alternative on SQL Table in Unbound Field in MS-Access Form

    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!
  2. drazeni

    Dlookup Alternative on SQL Table in Unbound Field in MS-Access Form

    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!
  3. drazeni

    Dlookup Alternative on SQL Table in Unbound Field in MS-Access Form

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

    Dlookup Alternative on SQL Table in Unbound Field in MS-Access Form

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

    Dlookup Alternative on SQL Table in Unbound Field in MS-Access Form

    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","
  6. drazeni

    Dlookup Alternative on SQL Table in Unbound Field in MS-Access Form

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

    Create recordset ordered by autonumber (SQL)

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

    Create recordset ordered by autonumber (SQL)

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

    Autorun macro on change of cell value

    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"
  10. drazeni

    Multi-select list box save sselections in temp table

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

    Email Pool

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

    Create login users table

    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"
  13. drazeni

    What's wrong with this recordset function?

    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"
  14. drazeni

    What's wrong with this recordset function?

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

    Pass a VBA select query result to VBA variable?

    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"
  16. drazeni

    Pass a VBA select query result to VBA variable?

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

    Do I have a firewall?

    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"
  18. drazeni

    Do I have a firewall?

    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"
  19. drazeni

    activating scanner from a command button on a form

    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"
  20. drazeni

    Printing a new line based on previous line's field value

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

Part and Inventory Search

Back
Top