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

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

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

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

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

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

Hello everyone, I current use the dir() feature to find out whether a file exists, but I would like to be able to find out when the file was created or modified. The file would be a pdf file, etc. Does anyone have a suggestion to retrieve this kind of data and pull it into an Access form...

I wasn't sure how to title this, but here is what I was trying to do: Let's say you have a form with 5 fields. The query behind the form has 10 fields. One of the fields in the forms is either a Y or N representing if the invoice has been paid. Is it possible for the ControlTip Text to popup...

Hello Eveyone, Is there anyway to specify a different "application icon" for each report/form in a database. I know if you go to Tools/Startup you can say, Use as Form and Report Icon, but can you pick a different icon for each form/report? Thanks, Randy

Hello everyone. I have been trying to figure out how to set our database up to be able to apply payments to multiple invoices. Here is a screenshot straight from Quickbooks. Right now I have a table that has the invoice, date of invoice amount of invoice, customer number and a few other items...

I currently have the following code in my form: Private Sub prname_AfterUpdate() Me.PRACT_ = DLookup("[LNACT#]", "tblPCSLicensees", "[LNNAME] ='" & [PRNAME] & "'") If Me.PRACT_ Like "1001" Then RO = "O" ElseIf Me.PRACT_ Like "1003" Then RO = "O" ElseIf Me.PRACT_ Like "1006" Then RO = "O"...

I currently have a query that uses the following in the criteria field (1001 Or 1003 Or 1006 Or 1182). If possible (this seems fairly easy but I can't figure it out) I would like to reference a table instead. So for example, if I had a table with one field and four records, I could change 1003...

I currently have a form with two subforms. You select a customer and the first subform filters all their invoices and the second subform filters all their late fees. This form is used to apply payments as they come in. So, I have a field where you type the check amount and a field that tells you...