Search results

Sorry...didn't mean to do it, just realized I had forgotten to request email notification. I deleted as soon as I could get back to it.

Thanks vbaInet! I knew it could be done, but had just forgotten.

Ladies and Gentlemen... I haven't been in the forum for awhile and am interested in view all of my previous posts and their replies. I know this can be done in other forums, but can't find a way to do it here. Does anyone know how to do so? I would really appreciate the help. I have a problem...

Thanks Uncle Gizmo. Actually the program being used by my friend is Approach ... the Lotus database. The friend called me because of my knowledge of Access and wondered if there might be similarities. I told her that I didn't think there was a way to trace a particular entry to a specific...

This is a very unusual question; one to which I'm not sure there is a satisfactory solution. There is a database on a server that is being accessed by a dozen people. One or more of those people are changing entries that end up causing erroneous reports. Is there any way to trace an actual data...

Bob... Thanks for your reply. I feel like an IDIOT! I just figured out what I was doing wrong. I wasn't "Running" the query; I was just previewing it.:p

I have an Access database in which I need to update a "Payment" field. The problem stems from the fact that a blank in the Payment field results in faulty results on a report. I need to update the Payment field to zero (0.00) when the "Date Paid" field is "Null". I created the update query to...

Thanks Paul...but where exactly should I put that expression? I assume it would be in the properties dialogue box, but where? Also, I've read that people have had some problems with Access rounding even integers up and odd integers down with the "Round" function; is that likely here?

I have tried to search and find a similar problem and solution, but have so far been unable. In an invoice form, I have a control that is the sum of several others (no problems), but then the control is multiplied by a tax rate and displayed in "Currency" format and 2 decimal places ... still no...

Thanks Boyd, but the problem is that there is NOT a one-to-one correspondence between payments and invoices. However, I have come up with a solution that I think will work for this instance. I am going to simply use the current "Invoice" form and put a designation "Payment" in the details...

I have a task I need to get done and need some guidance as to how/where to start. I have a database on which Invoices are created. I need to create an “Accounts Receivable Ledger” which contains for each customer a list of his invoice numbers and totals, and a list of payments (credits) and the...

Have you considered formatting the field as 0.000 so that even up to 999 duplicates would be handled? Then your original would be 12.000, then your first duplicate would be 12.001, next 12.002, etc. The sorting would work fine also. If you went into the properties of your field in the form, you...

Bob... The database is split and the back end resides on one of the older Dell computers. The two new computers are HPs. Pat... Unfortunately, I are the network people. :eek: No, actually I have another person who is dealing with the wireless networking of the computers and network printer. I...

Ladies and Gentlemen... I appreciate any help you can give me on this problem. I'm not even sure it's an Access problem, but it seems to happen exclusively while in Access. First, I am using Access 2007, networked on Windows Vista computers. The program has been installed on 3 computers for...

Thanks Thanks Bob. I've never actually used the SQL view of a query. This worked great! I'll have to look at that more often.

More Guidance Thanks Bob. However, I don't have a clue where to put this code. I was hoping there would be a simple function that could be put into the query criteria field that would cause the record to be returned. What I'm wanting to eventually do is put a command button on a form that would...

Hi, folks. I'm trying to do something that seems very simple, but I've never tried to do it before. I've searched the forum with many different search criteria, but can't find a solution. I want to create a criteria in a query that will return one record. That record will be the one in which...

Solution The "Sticky" at the beginning of the forum contains the information that will resolve the problem with Access not opening on multiple shared computers at once. The following link will take you to the exact spot that contains the registry fix. I followed the directions and my program...

Keith... No, there are no error messages, just a "working" symbol that never completes. I may have found a possible reason for my problem. I hadn't noticed that a post at the beginning of the forum entitled "Important Message For Vista Users" seems to indicate that when using Access with Vista...

Ladies and Gentlemen... I have had this in another Access forum ... without a resolution. I am pulling out what little hair I have left, so hopefully someone can help me. I have created a program using MS Access that a small business will use to enter service contracts and invoices. The...