Search results

It worked. Now if only I hadn't created all those forms...ugh. LOL.

Thanks! I'll check it out now.

I've heard about 'cascading' forms, or subforms, but what I need to do is open the same form twice or more times, on the same terminal, where each instance of the form inputs data for a different production line but still stored in the same table, and any instance can be closed without closing...

Hello, can anyone tell me how to copy a record and save it with a different name? The primary index field in the table is Text-formatted but contains the sku numbers of a list of products. The table holding the records contains a lot of fields, 82 ti be exact, and one sku can vary from another...

Thanks. This works. :D

Does anyone know the code to display the date as Julian in the format: yddd, using the system clock? I have tried variations on the 'Now() function but I'm missing something...thanks.

I was using the code below to display a text string on a form. It worked fine until the new year, now instead of getting the day of the year to appear in Julian format (today is "005") I'm getting "5Su". example: on the form, txtJulDate displays"540105Su20". Should display "5401000520"...

Oh. Hell. That was easy. Thanks.

Can anyone tell me how to make a popup form appear in the middle of the screen? Thanks.

The excel spreadsheet is an ever-changing "temporary" production schedule. If I link the tables, then the data disappears when the spreadsheet is altered. I need to be able to store the data permanently in an Access table. Then that data will be displayed on Production Forms to record the...

I am importing data from an Excel spreadsheet to a table and overwriting the same table each time the data is imported. I have another table, with identical structure, field names etc., that I want to transfer the new imported data to, however, I want to check if the record already exists in the...

Hi. My name is Dirk. I'm a Quality Assurance manager in a food manufacturing plant and I use MS Access for many of my record keeping needs.