Forms :: Track Workload Document Inventory - Prepopulating A Form Field

Jun 7, 2013

I have a Db to track workload document inventory.

I have a data entry form that updates a table - the table tracks workload inventories.

Beg Bal Inventory, plus Received, Minus Processed, equals the End Inventory

Users data enter these document counts every day, click a SAVE button and those counts are saved on the table.

The next day the user wants to open the form for that day's document count for data entry, and wants the End Inventory result from yesterday's record to appear automatically prepopulated in the beginning balance data entry field on the form.

View Replies


ADVERTISEMENT

Reports :: Generate A Report For Items In Previous Sentence Not Completed To Keep Track Of Workload

Jul 29, 2013

I'm completely new to Microsoft Access. This project was thrown my way. I have an accounting database to track payables, receivables, financials, and deliquencies/collections. Is there a way to generate a report for any of the items in the previous sentence that haven't been completed to keep track of workload.

View 5 Replies View Related

Forms :: Unbound Form To Make Inventory Entries?

Oct 10, 2014

I'm trying to use an unbound form to enter single inventory items to my database. As part of the function of this form, I'd like to check new items against the current inventory, and perform the function you can see in the error handling code(Which works fine). Currently, when I try to run this I get an error on the syntax of the 'FROM' clause.

Option Compare Database
Option Explicit
Private Sub btnCommit_Click()
'On Error GoTo errHandler
Dim SQL As String
SQL = " INSERT INTO [InventoryDetail]" & _

[code]....

View 11 Replies View Related

Forms :: Using Form To Update Location Change Of Inventory?

Dec 2, 2013

I have an inventory of equipment that is assigned to different locations. When repair is needed, the equipment is brought in and swapped with a loaner. How can I update on a form the location change from "A" to "Shop" that will show up on the related equipment table? I have "Location" in the table, but don't know if I need something to the effect of "NewLocation" to assist in showing the equipment swap.

View 4 Replies View Related

Forms :: Stock Inventory - Opening Form And Passing Data

Jan 9, 2014

I have a form that displays a stock inventory, one of the fields I use is called [ItemCode].

On the Stock_Inventory form I have 10 command buttons that open other forms to display additional product information.

These were previously sub_forms that sat in a tabbed control box within the Stock_Inventory Form but as it now takes a while for the form to load (lots of queries running each time you search for a product) users are getting slightly frustrated.

So, what I decided to do, was move each subform from the tabbed control into a new form and open that form when it is needed by the user.

OK, when I open Stock_Inventory and search for a product [ItemCode = "ABC123"] and then want to see the Sales_History, I have to open my new form, Stock_Inventory_Sales_History, within this form are two sub-forms, each subform has a field called [ItemCode].

However, when Stock_Inventory_Sales_History opens it asks me to input the parameter [ItemCode] twice, I presume this is because the Stock_Inventory_Sales_History does not have a record source and that the subforms need [ItemCode="ABC123"] to run each query and return the data.

I need to pass the [ItemCode] from the Stock_Inventory form to each of the 2 Subforms that are on the Stock_Inventory_Sales_History form automatically.

View 4 Replies View Related

Forms :: Filter Down To Specific Categories In Inventory - Scroll Bar In Continuous Form

Sep 9, 2014

I've got a continuous form that displays my massive 3,000+ inventory, with the option to filter down to specific categories. Some categories have 5 items, others have hundreds. The design I have used makes it look really tacky once I filter down to one of the categories that has 5 items, because there is no scroll bar.

What I've tried using is:

Code:
If Me.RecordsetClone.RecordCount < 10 Then
Me.Scrollbars = 2 'vertical only
Else
Me.Scrollbars = 2
End If

But it still doesn't display correctly (nobar.png). This is probably my biggest headache right now, and every "solution" I've found, doesn't work.

View 11 Replies View Related

General :: Open Word Document With Corresponding Data Filled From Text Field Of A Form

Jul 10, 2013

I am trying to open a word document with corresponding data filled from the text field of a form. I managed to get the word document but I don't know how to give a variable in word document.

View 2 Replies View Related

Forms :: Opening A Word Document Via A Button Control On A Form?

Aug 5, 2015

I would like to open a Word document using a button control on a form to a file path listed in a field on the form. I use the following code when I want to open a single specific document...

Dim wdApp As Word.Application, wdDoc As Word.Document
On Error Resume Next
Set wdApp = GetObject(, "Word.Application")
If Err.Number <> 0 Then 'Word isn't already running
Set wdApp = CreateObject("Word.Application")
End If
On Error GoTo 0
Set wdDoc = wdApp.Documents.Open(File path here)
wdApp.Visible = True

...but in this case the file path I want to use will be designated by a field on the form. I know I could just use a hyperlink but I don't like the way it looks on the form. I would rather hide that field and have code pull that path when I hit the button.

So how would I change my code to make it so the value in the file path field on the form goes in where it says "File path here" in my code above?

View 2 Replies View Related

Track Field Value Changes. Please Help

Jan 24, 2006

Hi. I have a form with many fields. I want to track changes av 1 field to know the field value has been changed or not. I know about onchange event, but this only works when user inserts or changes the value. My form is being updated by macro/visual Basic. Is there any way to fin out if the value of a field has been changed automatically?

Thanks for any help!
metad

View 5 Replies View Related

General :: Track Changes In A Field With The Date?

Jul 7, 2014

I want a field in my table (called 'ContactTotal') that tracks the total number of times the date was changed in the field 'LastContacted' - through either table or a form, but it should exclude any changes made on the same day.

I'd also like a second field (called 'Popularity') that does the same thing, but multiplies any changes made in the last 3 months by 3, the last 3-6 months by 2, the last 12 months by 1 and anything before that by 0.

View 14 Replies View Related

Tables :: Way To Track Changes Based On Different Field Name

May 13, 2013

All; using Access 2010. I need to have some kind of way to track changes based on different field name.I have a client table with field data like Fname, Lname, SSN, Address, Zip, Phone, DateOfBirth, Current Rate, TotalRate, Status and Importdte. I have an import into the database every month and I update this table with data that is new based on the SSN with an append query. The import also has the names of those that exist in the client table until their status changes. In addition to appending new data every month; I would like to append any changes the existing client has. For ex; If an existing client has an address change, I want to append this data to the table but keep the existing address and have a Change date equal to the Importdte. In essence; I want to build a kind of history table that when I pull up a client; I can have something like a tab on a form with the changes and when it happened.

View 6 Replies View Related

Tables :: Inventory Sheet - Auto Population Of Field

Mar 16, 2014

I have a sheet of inventory I am working on creating. The price for storage for an item is determined by 2 things. 1. the type of material and 2. the size of that material. I have created a table with the material types and sizes. Is there a way that I can have the price automatically populate when I select the type of material and then size?

View 3 Replies View Related

Inventory Forms By Date

May 25, 2005

I would like to know in Acess how to create a Form
Let's say to lookup Products you sold by date in like a month period on a form
To select the items from the list and have it display by that date.
Thanks,

Mike Van Der STad

View 3 Replies View Related

Exporting Field Value To A Word Document

May 31, 2005

Hi.

I'd like to export only email addresses separated by ";" to a word document based on a result of a query.
Query gets build dynamically in VB behind the form as there are many search criterias. so user can eneter one field or many in the form to build the query. Queries work and i can extract and display the email in a report or another form, but now i'd like to export it to a word document or outlook (but i would prefer word).

Can anyone please give me advice how i should approch this issue.

Thank you.

View 8 Replies View Related

Forms :: Design Multiple Branch Inventory?

Aug 14, 2015

I wish to request if it is possible to design an inventory where multiple shops or branches can be accessed from the same place.

or

multiple shops can use the same program with a centralized database, such that every user can only access his or her report from anywhere they login from.

View 1 Replies View Related

Passing Date Field To Word Document

May 16, 2005

Hi,

I have a control on a form which opens up Word and completes fields in the Word document with data on the form. It basically fills in an invoice form.

Everything works ok apart from when the invoice date and order date fields are passed. In the tables and in the forms, the dates are in Long Format ie '17 May 2005'. However, when they are apssed to the Word document, they are in a shortened format ie '17/05/05'. I am required to show the Long Format but am at a loss to find out how to achieve this.

I use bookmarks in the Word document and the code on my form relating to these fields are:

.ActiveDocument.Bookmarks("OrdDate").Select
.Selection.Text = (CStr(Forms!frmOrders!OrdDate))
.ActiveDocument.Bookmarks("OrdDateInv").Select
.Selection.Text = (CStr(Forms!frmOrders!OrdDateInv)

The Word document cannot be changed as far as I can see. I believe the answer could be to change the code above to change the format, but cannot get anything to work?

Your assistance would be helpful.

Thanks

View 1 Replies View Related

Inventory Query In Form

Jul 18, 2014

I've created a database of equipment we keep in a vault. Every so often the boss wants a count of items by model. I would like to create a button on the switchboard that can bring up this count for him.

First I have created a query which will count by model. The SQL of that query is here:
SELECT Count(*) AS Expr1
FROM [Count Query]
WHERE ((([County Query].[Model]) Like "nnn"));

(nnn is the model number I will want and will have a diff query for each model.) Now, I'm trying to get these into a form for the boss to simply click. When I do, I get the #Name? error. What am I doing wrong here?

View 3 Replies View Related

Forms :: Inventory Of Domain Assets - Search Button

Jun 24, 2015

I am currently the administrator of a fairly large network and am trying to keep inventory of all my domain assets. I would like to be able to search for these assets by a number of different ways such as computer name, location name (ie: CEO office, accounts receiveable, or human resources), slot number on my switches (I would like to know whats connected to where), and also what switch it is located on. Right now I am using a combo box to populate these fields but would like to implement a search function instead to be able to search with whatever information I have.

View 1 Replies View Related

Track Form/Query/Report Usage

Jul 25, 2007

Hi

About 10 years ago I wrote an Access application which is still in use. Over the years certain parts have become superfluous and new parts have been added by a variety of users. Thankfully they have stuck to the original ideal and only used macros and queries - and not modules of badly written code.

However, the system is beginning to creak and I have been asked to rewrite the system from scratch with a shiny new interface, cutting the dead wood and incorporating those new features that did not have a half life of one report.

I would like to be able to monitor the use of the system in order to be able to determine just which tables, forms, queries & reports are being used. I'm not interested in auditing who added what to which table, so a 'normal' audit system is not required. Can anyone tell me how I would record which of the above are being used and how regularly?

I have asked the users and (of course) they don't know.

TIA

View 3 Replies View Related

Modules & VBA :: Keep Track Of When Form Data Has Changed

Aug 16, 2014

I want to keep track of when data in a form was last changed.I only need to track this when the form is closed. not every time a record is changed.

View 5 Replies View Related

Modules & VBA :: Scan PDF Document From Scanner And Attach It To Field

Oct 12, 2014

I have hp scanner whose twain driver has the option to scanning in the pdf document.

Microsoft WIA 2.0 have save scanned document only to graphical format.

I want automated (on click any button control) to scan multipage document from glass source or ADF to pdf document and attach it to attachment field.

I'm found VB Module for accessing TWAIN compatible scanner but it is call twain software and scan to bmp format with assigned name of file.

Me need it also only use the pdf format .

View 7 Replies View Related

Simple Inventory Update From Form

Nov 28, 2006

Hello. I'm trying to design a simple database for a bicycle recycling charity. I hit a brick wall when realising that I had never before attempted to update a record. :eek: Until now I've just used Access to add new members to a bus user's organisation.

If the shop takes delivery of 20 tyres, I need to add 20 to the current stock.

Is it possible to achieve a simple Form that adds to or subtracts a quantity from current stock, or do I have to learn some access programming?

I've looked through some textbooks and can't find a simple update solution.

Thanks for any suggestions. :o

View 6 Replies View Related

Report Which Keeps Track Of Data Changes Made In DB Form Fields

Dec 13, 2014

How to generate either a form or report able to show me the history of data changes made by users in the fields of Access Objects. I'm more interested in Forms, since the users will use Forms to change data in the db.

Let me give an example:

My db has, for instance, a form named Frm1 and a form named Frm2. Both were built including several fields such as text boxes, combo boxes, etc.

So, if the user Paul first changes the field Color of the record Id 235 in the Frm1 from Green to Yellow, and then, down the road George changes the field Size of the record Id 14 in the Frm2 from Big to Small, I need to know what changes were made, by who, and when changes happened. Also, it is important to know if a record Id is added or excluded.

My final intent is to have a report/form that shows some sort of user activity log which I think could be like this:

Date--------Time----------User-----Form------RecId------Action------Field-----From-----------To
Dec12,14---15:12:35-----Paul-----Frm1--------235------Changed---Color----Green-----------Yellow
Dec18,14---07:05:19-----George--Frm2---------14------Changed---Size-----Big--------------Small
Dec22,14---09:23:59-----Sean----Frm2--------116------Deleted
Dec23,14---11:07:03-----Paul-----Frm2--------321------Added
etc...

By sorting this output by date, form and field it will easy to check/audit for user processing mistakes.

I know enough to build tables, queries, forms and reports, but don't know how to structure such thing. What kind of form event should I setup?

View 2 Replies View Related

Modules & VBA :: Attaching Word Document To Attachment Field For Every New Record

Jan 12, 2015

I'm trying to work out how to attach a word doc to the attachment field of a table when I add a new Record. The following code work's fine if I add it to the On Load Event on the Form, but the doc is attach'd to the first record. When I add the code to the Add New Record button, I get the error msg: "File already part of the Multi-Valued Field" and nothing in the attachment field.

Code:
Private Sub Add_Record_Click()
DoCmd.GoToRecord , , acNewRec
Me.Description.SetFocus
On Error GoTo Err_AddImage
Dim db As DAO.Database
Dim rsParent As DAO.Recordset2
Dim rsChild As DAO.Recordset2

[Code]...

View 8 Replies View Related

Subtract Number Range While Keeping Track In A Table / Form

Mar 31, 2014

I have two tables (one is a query)

Table 1 (query based)

EMP_ID
Prev_Emp_ID
EMP_ID_DDSK

332-123
1
500

332-133
1
501

332-144
0

332-156
1
502

332-654
1
503

332-456
1
504

332-967
0

Table 2

Res_Numbers
Num_Of_Employees

500
10

505 - after 5 numbers are placed
Will be added for next hire

My goal: to place employee numbers into new employee field "EMP_ID_DDSK" (table 1), Numbers will come from (from "Res_Numbers" field (table 2)

Example: If field "Prev_Emp_ID" = false

Get the next number in line from table 2 "Res_Number" and place it in table 1 field "EMP_ID_DDSK".

Example: if "Prev_Emp_ID" = false for 5 new employees. Take the next set of numbers and place into field "EMP_ID_DDSK".

View 4 Replies View Related

Forms :: File Or Document Link As Attachment?

Sep 12, 2014

how to manage attachments (Document or File Links).

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved