Search results

i am looking for some advise how to create a query from Bill of material table, bill of material table looks like below FinishedProduct,ItemNumber 64000,7975 64000,7685 64000,7695 64000,6444 6444 is WIP Same table has Work in process (WIP) information, FinishedProduct, Item Number 6444...

I have some reports with criteria and I want these report to save as PDF in different folders on network Currently I am using the button and following code to export report. Private Sub Command1_Click() DoCmd.OutputTo acOutputReport, "Report1", acformatepdf...

Hello Everyone, I need your guys help to start, I am trying to create an attendance database, our company introducing the point system attendance, Called Off (CO) 2 points Left Early (LE) 1 Point Tardy (Tar) 1 point Employee can reduce point if they have perfect attendance...

Hi Everyone need your help one more time. I have a parameter query where user enter the department number to get their info. I want instead of entering the department number, a list box pops up and ask to select department as parameter and run the same query. any help will be appreciated.

Hi guys, need little help, please see the attached MS access database, what I am trying is to make a database, based on our production schedule, we add orders on daily basis and plant scheduler check the order status and ending inventory, and schedule the product. if you check the attached...

Syntax Error Crosstab Query with Criteria I have a following code in crosstab query to bring the result between range of date, will anyone help me out to solve this issue, the only thing I want to give criteria (range of date) to crosstab query PARAMETERS [Start Date] DateTime, [End Date]...

Guys banging my head to wall :banghead: is not solving my issue. There are 2 images I am inserting, I want on the Access form to display the total of row (each row is batch number) in the box after pressing the button in the form. based on Product code, date and table numbers.

I am trying to make bill of lading in access, I am not figure out, how I can add different products in same BOL number. Please help me out, I am attaching the BOL file. Thanks

Hi guys, I want to make a delete query, which delete record between certain dates, I want access to ask user to specify range of date before executing the query. Thanks

Is there any way user can verify the data that its enter correctly, for example I want a button on user form, after every 14 entries when user hit that button it bring the sum of 14 entries. Any help will be greatly appreciated.

How will I make a IIF formula with sum if 3 conditions are are true. I am trying to make a query which sum the Lbs Produce if date, Product Id and location met. Thanks in Advance

Hi guys, I have been away for Access for a long time and having issue with making a query. I have 3 tables. "tablEmployee" has employee ID, first name, last name and sizer ID. "tblproduct" has product ID, Description and rate. I made a new table called tbldata which has date, product code...

Is there any VBA code which delete all tabel, or run delete query after certain period of time? any help will be greatly appreiciated