Search results

Preface this with thanks in advance for any assistance in resolving this matter. I have a form with a command button that is set to print an invoice report on the on click event. Code as follows: Private Sub cmdPrint_Click() On Error GoTo Err_cmdPrint_Click DoCmd.RunCommand acCmdSaveRecord...

See if this helps. Enter the serial number data on the "Serial Entry" sheet.

I have a table that contains specific customer transaction data. In this table there are the following fields: Document Vendor Vendor Name Units Value There are instances in which multiple records could exist for one document number. Such as: Document-----Vendor-------Vendor...

Works like a champ. Many thanks!

RG, Attempted to utilize code, however receive compile error after event update. I have created a sample DB that contains the basic info similiar to what I currently use. Currently utilizing Windows 2K Professional and Office/Access 2K. Thanks for the assist.

RG, thanks for the information, however I need some assistance with the code to arrive at the point of playing sound. Once the scan occurs, a piece of code should run that looks for the value 'YES' (based on product id) in tblManifest and if that is present, then the wav file is played and a...

Help with scanning and sound. By utilizing the search feature, I have discovered issues that are somewhat relative to what I need assistance with, however nothing specific. So here we go… 1. I have a table named tblManifest. Within this table is a text field named PRODUCT and a text field...

I have a table that stores records by "return date". I would like to create a delete query that removes all records that fall outside of the date range entered on a specific form (frmMainMenu). I can deleted the records that match the form criteria, however that is not what I need. The...

I have a form that contains a list box with 11 separate options. Within this list is the option named "None". My desire is to have a message box displayed when any option is selected other than "None". I have searched various threads, however I have been unsucessful nailing down my issue. Thanks...

Can someone offer guidance here? I have a table that stores liquidated inventory records. I want to design a make table query to dump selected records into a new table. Some of the more important fields in the table are as follows: Vendor Location Units Type 9998...

Thanks for the help Rich! I continued to toy with this upon posting the initial thread and I was able to obtain the solution I was looking for by utilizing the following within a query: FieldX TimefromPreviousRow: IIf(IsNull(DMax("[Date Time]","tblEmplProduction"," [Date Time]<#" & [Date Time]...

I have reviewed several threads relative to custom background designs within forms and have retrieved some great information. My question is such: Is there a way to apply a MS PowerPoint presentation design template as a background design within a form? If so, I would be appreciative of...

Good evening! With all the knowledge contained by individuals monitoring this site, I am confident that someone can offer advice to my issue. Basically, I have a table that contains productivty performance by user id. The table also houses date & time stamp (hh:mm:ss) data as it relates to each...