Search results

That worked awesome Bob. As always, thank you for the help. Eddie.

Hi, The attached data base has a report I'm working on called "The Book". I am looking to get subtotals after each grouping but I can't get it to work. I can get the grand totals to come in but not the subtotals for each groupings. Any thoughts on why it isn't working? It seems to me like it...

Hi, This was something I was working on and got pulled off to do some other stuff last week. I can start playing with it again. I'm new to access but trying all the time to get better. Stopher below kindly posted a query I should replace my current query with. The problem is I'm not sure...

Thank you so much for your reply. I'll answer your questions one at a time: 1-However, I have concerns about your database design. Tables "Container_Vendor_Information" and "BOL information" don't have Primary keys. There are three pieces to this puzzle (maybe they can be combinded into less...

Hi, I'm just starting to design somes reports and have run into a problem. The attached database has a report named BOL information. It pulls data from various tables. If the data in one of the fields is blank the whole report is coming up blank. Any thoughts on why this is happening? I...

Wow, that was easy. I'm not sure why that was even coming through as a list box. I'll have to do some digging. I thought I had everything set up as text or combo boxes. Thank you for you help. It was exactly what I needed. Eddie.

Hi, I am putting together a report. It is on the attached data base and called "Test". The field VendorInvoiceNumber is not pulling through onto the report for some reason. It is coming up blank. Any thoughts? I know the report looks all sloopy. It's the first one I designed and I'm...

Thank you for your quick reply Bob. I see your point. That makes sense. Eddie.

Hi, This problem has to be easy but I can't make it work. The attached database has a table name BOL information. Inside that table are the two columns I'm having an issue with. I want ETA Date to be 30 days after BOL date. I have been screwing around with the Dateadd function and can't get...

That is EXACTLY what I need. Thank you so much. I was missing a "-" in my coding. I knew it was something like that. Again thank you so very much. Eddie.

Hi, I've been banging on this problem for a week and I just can't get it straight. I know this has to be easy but I can't get the coding or whatever perfect. I have attached a database. There is a form called BOL_information_entry. There is a command button (Add Record). I don't want the...

Thank you so much missinglinq. That worked. Eddie.

Thank you so much for your reply. I'm glad to see that it will work. However, if there is a better way I'm all open to it. If you were me and you were setting a form to enter data off of what would you to make sure that someone wasn't scrolling back and screwing up any old data? I am more...

I want the BOL information form to a form where only data entry takes place. After I enter a few records, close the form, and reopen it the older records are there. When I open the form I want it to be blank and ready for entry of the next record. Thanks Eddie.

Hi, I'm trying to get my forms to open to a new record. According to access help and various others sources of information I need to go to the form selector and set Data Entry to Yes. The problem is I can't find the form selector. I have attached a copy of the database in case anyone wants...

Thank you for your help Bob. I'll see if I can get it to work. The Unique # is being generated off another form. We will not entering on this form for several weeks until after we fill out the first form. I'm using the Unique # to follow the data through the tables so I can run my querries...

Thank you for your quick reply. I made changes in the tables so the names do not have the special characters as you suggested. Thank you for your advice. I have attached the updated zip file. This has to be easy and I don't know why I can't make it work. It is a simple division formula. Is...

That is what the field name is. I will make the change you have suggested.

Hi, I build a database (attached zip fiile) and I'm having an issue with the expression builder. The form Broker Information has a field named % Freight. I want it to divide the two fields above it but it doesn't seem to want to work. The expression builder looks like it has the right formula...

Yes IF [Cartons] <> [Carton Count Subtotal] should work but I'm not sure where I would stick in it my code in order to make it work. I'll kick it around now. Below is the current code that I have for the command button. This updates the records: Option Compare Database Option Explicit...