Search results
-
K
Using the information inputted in a table as a table name
Hi, sadly im using Access 97 which does not have this function. :S -
K
Using the information inputted in a table as a table name
Hi the original size was only 8mb now its 348mb! dont know how that has happened? -
K
Using the information inputted in a table as a table name
Hi, i think i have eventually sorted it, Do Until select_part_rst.EOF num = num + 1 SysCmd acSysCmdUpdateMeter, num dbscurrent.Execute "DELETE * FROM markup3" StrSql = "" StrSql = StrSql & " INSERT INTO... -
K
Using the information inputted in a table as a table name
I cant run another query like that, it will slow it down too much, this thing is searching through 120,000 parts, and another 50,000 customers etc etc... and isnt a local database. select_part_rst is the sub function which finds what part the loop is onto, thus select_part_rst!part is the... -
K
Using the information inputted in a table as a table name
Hi the sql i wrote at the top was just an example... But in my actual one i have the If else working, and have tested it. however to get the correct StrStatus for the If else statement, i need to use 3 different Dlookups. StrPartgrp = (DLookup("price_group", "part", "id =' " &... -
K
Using the information inputted in a table as a table name
For statement? sorry i am unfamiliar with this... i have a do until... loop -
K
iif statements... then the WHERE clause? help!
Hi, i cant send you the data, they come from various ODBC databases and else where. and they are in seperate tables because of the complexity of what gets done to the information. e.g. a part number gets referenced and a customer gets referenced, each of these have codes, then these codes are... -
K
Using the information inputted in a table as a table name
Hi thanks i do understand that. However, the query is a loop, and thus the customer type will be different for each result. therefore im not sure how the Dlookup will work :S -
K
Using the information inputted in a table as a table name
Hi David, yea still struggling, The SQL i wrote in this first post was just an example, i am still using the same code i was in the previous posts you helped me with. and got it working, except for this problem with the WHERE clause. I dont really understand the above; "Select * TOP 1 from... -
K
Using the information inputted in a table as a table name
hi, that query was just made up off the top of my head. the actual query is far more complex than that. Also i have no control over the databases, and never will be able to change them. Also a union is out of the question because this would mean creating a union of over 150,000 records from ODBC... -
K
iif statements... then the WHERE clause? help!
Hi, i already have the field which defines if it is fixed or not. it is the where clause which won't work properly. even if all the information was in the same table it wouldnt work correctly, as the where clause would still need to look at either one column or the other column depending on if... -
K
Using the information inputted in a table as a table name
Hi, I was wondering if anyone could tell me the correct syntax, or even if its possible to do the following, please remember that this code wil be written within the VB code... not in a query... sqlstring = " " sqlstring = sqlstring & " INSERT INTO markup SELECT TOP 1 Customername AS... -
K
iif statements... then the WHERE clause? help!
Hi, here is my query which runs within the VB code... queryString2 = "" queryString2 = queryString2 & " INSERT INTO markup SELECT TOP 1 JDE_Customer_No AS [JDE Customer No]," queryString2 = queryString2 & " Custom2.Customer_Name AS [Customer Name]," queryString2 = queryString2 &... -
K
SQL problem within Access
Hi, i have found that access had not frozen, it was just taking ages to run. and it came up with results. but multiple results. i am assunming this is due to the "union" statement. Do i need to use this? can i not just run the query without the union, but pull both fields i require into the ms... -
K
SQL problem within Access
Hi David, I have done what you asked, took out the Where statements, and sorted it out until it started workin. and added the where's one by one, and had to input certain variables which are usually inputted from the form. but got it working. I tried to put it back into the VB code, and ran it... -
K
SQL problem within Access
I'm still not getting any further :S. it appears i have combined the two methods, made a union as a query then tried using iifs in the VB query. I am still not gettin any results. it seems like it is not picking up the information from the VB query, to look at the union query. ?? sorry for the... -
K
SQL problem within Access
Hey i think i mite have combined your method mailman and Davids, I do not know how to join tables. Also, yes there is a query called QryPrices, and yes it does hav a column called "BasePrice", although i have now changed its name to "IntPrice" because of the similarity with "Base Price". But... -
K
SQL problem within Access
Hi I printed it into the debug window, and stripped out the insert etc. When i run it from the query window it asks me to input the value for "QryPrices.BasePrice" and the results it comes up with show the 1 in the "Use_fixed" column, So to me it seems the Iif mite not be working properly...