Recent content by AccessTexas

I found a way to accomplish the task. It is crude but works for my needs. I put a text box in the header that prompts for the starting check number minus one, and property of no for visible. In the detail I also hid the textbox that has the running sum. Next to that I have a text box that...

Need a sequential number on report. Have an unbound text box and set it to list a running sum over group. The twist is that I'd like to have it start with an assigned starting number [Starting Number] and then add 1 to each subsequent record. It works for the first record but then the next...

Thank you.

We have a year end inventory where we want to take our scanned data in a .txt table in Access and change the data to match a 50 character format that will upload directly into our count file and require no manual keying. There are two variable fields that would need differing leading zeroes...

Thank you, it was very helpful. I used to do this in Excel so the process is usually turned around a bit in Access.

I have a report where I would like to show YTD Sales in comparison to the last seven years by the current month in each year. March Company A Company B 2001...

Sorry about the code missing. What you said was right on the mark though. I changed the inputbox to take the typed in value sandwiched between the single quotes and it works as intended. Thanks for your help.

I have an inventory entry form with 3 controls on it. One is the area counted, the second is an item number, and the third is the amount counted. When the form is opened it prompts for the area counted which then changes the default value so you don't have to enter it again. The problem is...

I have a task where I transfer an item number out of one warehouse and into the other. I'd like to drop it in one table that would list the warehouse, item number, quantity(plus or minus) as a mirror record other than the quantity. Is there a way to have the form create both records or do I...

That was what I was missing. I had tried both the bound text box and the form AfterUpdate and DataChange but didn't think of the Current. Thanks for the quick reply and taking away a lot of frustration.

I have a form that calls up an employee that also lists their hire date. I have an unbound text box that calculates the years of service by DateDiff(). It works for the first record but sticks for all the subsequent records. I've tried an afterUpdate or Change on the bound Hire_Date text box...

I made a duplicate .mdb and instead of linking, I imported. I then stripped out most of the 10's of thousands of records so I could put out the stripped out version. Well when it was large it didn't work but now that it is small it does. There are 4 tables joined that create a huge amount of...

My SQL looks like this when it works WHERE (((informix_po_hdr.poh_nbr)="53874") AND (([informix_po_ln]![pol_nbr]=[informix_po_ln_desc]![pol_id]) Like -1)) ORDER BY informix_po_ln.pol_vitem_cd; When I put in [What is your PO Number] is when it bogs down. I'm new to most of this but if I sent a...

Thanks for your reply. I still haven't got it solved. I think the linked table which says it is text still isn't recognized by the parameter. I've tried Str() and a host of different things but to no avail.

Parameter I've tried the parameter before and I tried it again - [Enter PO Number] and using Text as type but it alway hangs up and the "Program doesn't respond comes up". Is it possible to do it in SQL where you change it to a string? I've tried it but I'm not sure I have the syntax...