Recent content by Maldrid

Thanks I will try to mess with that. Thanks for the tip. It is just that this is a huge database and I already wrote tons of code for it that it would take me a very very long time to fix this. I will remember for the future.

I have a query that selects two fields and they must be Distinct, but I want the recordset to come sorted by a field I do not select. Is there a way of accomplishing this doing a sub select? Or some other fashion? Here is my query that I have right now sSQLQuery = "SELECT DISTINCT [Bill...

This is a program that I am working on and that is what I need to do once the user does certain selections from my screen. It is something that I want a user doing manually like you mentioned.

Thanks. That is what I thought I would have to do, I just didn't want to type all the fields since it was like 50 hehe. Oh well thanks!

Copy records with a new AutoNumber [Resolved] I am trying to do the following statement sSQLQuery = "INSERT INTO Test SELECT * FROM Test WHERE [Flight #] = 'LOUNGE'" cn.Execute sSQLQuery This will basicially make a copy of the records that have a flight number of Lounge. The...

Wow I didn't get the email that someone replied to this post til today. Thanks for the information!!

Well that is why I am asking, because I am talking about thousands and thousands of records. I have a field called "User Name" in each of my tables. This way we can keep track of who entered or last modified a certain record. In some of my tables I will only have a few hundred records, but in...

Storage Space [Resolved] When you set up a field as text it also allows you to setup field size. If you set the field up to 20 characters opposed to the default of 50, does that mean that it takes up less hard drive space or it is just a way to control how many character a user can put in?

Hehe I guess you are a member of both forums. Thanks for the reply. :)

This Record Already Exist? [Resolved] Why am I getting a "This Record Already Exist" error when I am just doing a query? 'This query works prefectly and I get the results I want. sSQLQuery = "SELECT * FROM Prices WHERE KitchenID = '" & txtKitchenID _ & "' AND [Customer ID] = '" &...

Sorry, I guess I didn't say what I really meant. What I wanted to say is I don't care if it grabs the first or second record in that particular example. The example I showed is only trying to grab two fields, but in reality I am trying to grab several fields, and if I use Max([Max Config]) it...

I think you have it a little confused. Each class has a max config associated with it. So for every class record it grabs, I want it to grab the max config along with it. But I want it to only grab unique class records. So say if I have two records for First Class, I only want it to grab one of...

Sub Query [Resolved] Does anyone know if it is possible to use the DISTINCT keyword on one particular field, but yet pull up multiple fields in the query? Or another way, where your query will pull up records based on any unique value for a certain field, but also pull up a bunch of other...

Thanks for the replies guys. I got it to work. Thanks for the help!!

Updating a boolean field [Resolved] Anyone know why this does not work? sSQLQuery = "UPDATE BackOutBilling SET Report = " & True & " WHERE [KitchenID] = '" & sKitchen _ & "' AND [Report] = " & False The field Report is set up as a yes/no field.