Search results

Hello All, I have searched and can't seem to figure this one out. I have a form with subforms, etc. There is a field on one of the subforms which happens to be an autonumber field. I am trying to run a query that uses that field as the criteria. For right now, I'm just running the query...

Hello All. Bob - the reason the data is like this is that is how our online shopping cart program writes the order to the orders table in the SQL db. I'm just importing the data from our server's SQL db. My client is trying to automate some things on their end (in house) so I was just hoping...

Hello All, I have a field that contains product information in the following format: Amount: ||54.97 Qty:1 SKU #:3001 - Ball. Amount: ||24.95 Qty:1 SKU #:1070 - Shirt There could be one product in the field or more I'm trying to find a way to extract the sku numbers so I can get it to...

Hello All, I currently have a bunch of tables that I have linked to a SQL database. For development purposes (easy of use), I'd like to turn all those tables into regular tables rather than linked so if I take the db offsite, all the data is with me. I realize there will be no updates, etc. but...

Hello All, Per the comment about the DATE field, I just made that up, my table is completely different, I was just using this as an example (I won't use it next time though, good point). Each month we add a new record. So for July, it may be July 3, 2007, and for August it might be August 5...

Hello All, I've searched and searched and can't find anything but it might be because I'm not sure what to search for. Here is what I'm trying to do. (I'm simplifying this to make it easier to discuss) I have a table that looks like this: Company Date Sales 1 5/5/07...

Hi Paul, Right now I have it stored in the table as 1,2,3 BUT, I can store it however is needed to make it work. Please let me know if that answers your question. Thanks, Randy

Hello All, I am having problems re-selecting items in a list box. Let me try to explain. We have an option on a form that allows the user to select the priority code they want to view. They can select one or many options. The data is stored in a table so when they come back days later, all their...

Hi Rich, I've run into the same issue in the past and I always reference this for more help: Access Reference Problems I've done the following things: 1) Re-registered each reference / Compiled - same error 2) Removed all references / Added them back / Compiled - same error 3) Tried running...

I currently have a query that uses the dir function. The exact field in the query is as follows: filecheck: IIf(Dir([filelocation])<>"","Y",IIf([rndate] Is Not Null,"R","N")) This has worked great over the last 2 years using Access 2000 and Access 2002. Recently I upgraded to Access 2003 and...

RPadams, This is a great testing "trick". This will help with the speed on my local computer. Thanks a bunch!! -R

Earlier in the day I posted a thread about local vs. network drive mapping. I believe this is a different question so I wanted to separate the two. Please don't think I am posting multiple threads to get more answers. I do work for a large company that has a computer running Windows 2000 (on a...

Hello All, I have read a lot on the "performance threads" but I haven't really seen anyone discuss this. We have a database that is split up FE/BE. While I am designing the application on my computer, I have all the tables linked directly to the local C drive. Everything works super fast this...

Tim, That did exactly what I wanted it to. Thank you soo much for your help. I appreciate it. Hopefully this code can come in useful for someone else. Have a great day, Randy

Hello everyone, I am trying to find a way to rename 1000+ files. I have a table with the old name and the new name. Here is what needs to happen for example: 1000_E.pdf --> ABC.pdf 1001_E.pdf --> INVOICE123.pdf 1002_E.pdf --> INV9991.pdf I've read about the name function but I really don't...

Worked great. There were 7 dupes that I had to pull out (because they had the same data MC, CB and GDate), but it did the trick. Thanks for the solution!! I appreciate it.

Sorry for not being clear. I am attaching an image of the query (its in excel just so I could highlight the rows). The rows that are yellow are the ones that I would want to keep. Thanks, Randy

Hello All, I feel like this is a very easy query, but I just can't figure it out. Here is some of the data I am working with: MC CB CS GDate A004 C ABCJ973 05/29/01 A004 C DEFI378 03/11/02 A004 C GEG336 08/22/01 B004 D LLL753 04/25/97 B004 E DEA367 04/28/97 What I need for the query to do (in...

Good afternoon everyone, I do all my work at my office and then push it to my client's servers. When I get ready to push the data, I have to change all the linked tables to reference their servers, etc. Is there any software out there that can create a virtual server that links to a folder on...

Hello everyone, I am trying to figure out the correct way to get the following to work (it sure seems simple, but I can't figure it out).... I have a form with 3 subforms. On the main form, there is one drop down box that list the item that is linked to all the other tables (lets just say its...