Tables :: Database For Recording Visits - File Number For Each Day

Dec 17, 2014

l have a database for recording patients visits in a hospital,in addition for "serial" field I want to make "fileNumber" field which represents a continous serial number changes everyday but of course all visits in the same day have the same filenumber as in follows..

Ser-----Date----------FileNum
===========================
1-------17.12.2014------1
2-------17.12.2014------1
3-------17.12.2014------1

1-------18.12.2014------2
2-------18.12.2014------2
3-------18.12.2014------2

I cannot depend on date (I think) in the desired code because I want to skip weekend and holidays so FileNum continues after weekend (Friday) from the last number as follows..

DayOfWork----FileNum
===================
Sat---------------1
Sun--------------2
Mon--------------3
Tue--------------4
Wed--------------5
Thr---------------6
Fri---------------off
Sat---------------7
Sun---------------8

View Replies


ADVERTISEMENT

Recording Visits To A Form

May 31, 2005

Is there a popular way to show when records are updated, with something like a text box with Now(), please, Gurus?

It needs to be automatically enacted. (A box that they complete themselves gets quickly forgotten.)

Then if the Client refers to records changed on such and such a date, I can find them instantly.

View 10 Replies View Related

Recording Database Changes

Aug 17, 2006

Hi all
I have seen some functionality in another database and would like to add it to mine but I have no idea where to start. I was hoping someone would be able to point me in the right direction to a tutorial or sample database that could help me.
What I would like to do is record when changes are made to specific tables. For example, in a vehicle table, if the vehicle is changed from active to inactive for example, the date, the value that was changed and who did the change would be recorded somewhere. I'm guessing another table.
Can anyone point me in the right direction.
Thanks
Craig

View 2 Replies View Related

Tables :: Recording Multiple Dates?

Apr 24, 2013

I'm creating a database and wanted to set up my table.

It is for a service with clients where we need to carry out a review every 6 months, so I need to create a way of entering a date every time a review is completed, then ideally a field that automatically totals the number of reviews that have taken place, and another field that automatically generates the date of the next review due - based on 6 months after the last review date.

Is that possible? It seems silly to keep adding fields for potential reviews as most will only have between 1-3 but in theory it could be as many as 20, which would be a lot of wasted space and fields for most people!

View 1 Replies View Related

Tables :: Recording Log In And Out Times By User

Mar 24, 2015

how I record user log in/out times in a table with Access 2013.

View 2 Replies View Related

Tables :: Recording Training Attended By Staff

Jan 25, 2014

I have a database of staff members. There is a table with the details of staff; name, dob, address etc.

I need to set something up that will record the training that staff attend and then be able to print a report of who attended the training session and also a report of training sessions individual staff members attended.

I need to set up fields in a table for date, topic and presenter and then I need to somehow mark off staff members who attended.

View 5 Replies View Related

Tables :: Using Default Value For Calculation And Recording To Table

Nov 19, 2013

I shouldn't normally record calculated figures into my table. I'm willing to buck proper procedure here for ease of use for referencing in reports; also, it's just one data point that will be calculated only once and not changed.Anyhow, I have an IIF statement that calculates a total price based on a table of costs. I set this as the default value and it calculated properly - but once I set my text box to have a control source, it no longer calculates my cost.

I was hoping to set it so it calculated the cost and then write that total cost to my table.should mention that my calculated control is in a subform.

View 2 Replies View Related

Tables :: Column To Autofill Based On First Digit Of The File Number

Dec 26, 2012

I have a datasheet with 7 columns. Two of the columns I'm working with are listed below.

File # Region #
2DE2-12345 2
3DE2-@@@ 3

In data sheet view I would like the Region # column to autofill based on the first digit of the file #. So, if file # entered = 3DE3-@@@@ then 3 would auto fill in Region Column. (data is entered in data sheet view)

I have used Left ([File #],1) to get value but cant make it auto populate the Region # column......

View 6 Replies View Related

Export Tables To Zip File When Database Closes

Apr 14, 2008

Hi,
I want all the tables of my database to export to a zip file when the users exit the database. this will serve as a sort of a backup of the data. Is this possible? if so, how?

Piet

View 4 Replies View Related

Modules & VBA :: Code To Count Number Of Tables In Database?

Jan 17, 2015

creating the VBA code to find the total number of tables in my database.

View 2 Replies View Related

Tables :: Import Some Information From Excel File Into Access Database

Feb 2, 2015

I'm trying import some information from excel file into Access Database but I need have imported information formatted in specific way.

Import file is looking like:

City - Week / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8
London / 3 / 1 / 4 / 5/ 5/ 9/ 1/ 3/ 4
Chicago / 2 / 1 / 4/ 8/ 3/ 3/ 2/ 1 / 5
Paris / 9 / 4/ 1/ 7/ 8/ 9 / 1 / 1 / 2

And i need table in Access looking more like

City / Week / Value
London / 1 / 3
London / 2 / 1
London / 3/ 4
London / 4 / 5

and so on for each city.Is there any option that this can be done within DB or It would need be some kind of macro to transfer this into other format?

View 1 Replies View Related

Forms :: Auto Generate File Number Based On Number Of Records In Year

Jan 21, 2014

I have a form [IUDATA]

I have a add record button.

I have a date field [DATEIN]

I have a text field [DRPNO]

If the [DPRNO] field is empty, I would like the user to have the [DPRNO] field be automatically populated after the user enters a date.

I'd like the format of [DPRNO] to be "dpr YY-XXX"

Where:
YY is the year of the [DATEIN] field and
XXX is number of records in that year.

So for example, if it was the 4th record with a 2013 date the [DPRNO] would be dpr 13-004.

View 12 Replies View Related

Calculate Visits Per Month

Jun 28, 2005

Hi All.
I need to calculate how many visits per month. What formula in a query I need to use to calculate the same value of DATE field.
Thanks.

View 5 Replies View Related

Calculate Visits Per Month

Jun 28, 2005

Hi All.
I need to calculate how many visits per month. What formula in a query I need to use to calculate the same value of DATE field.
Thanks.

View 1 Replies View Related

Outstanding Visits...(Help With Report)

Jul 17, 2006

Oh my gosh, how frustrating! I'M TRYING (so desperatly) to create a report that will show me how many outstanding inspection visits to a business. I don't know if i'm going in the right direction but, i've created the report with a date range form. the main purpose for this report is to show me how many visits I'm behind by typing in a date range. For example i want to know how many outstanding i have between 1/1/05 to 1/1/06. Visits are done annually. so i need for it to pull up the ones that weren't done. it's complexed for me to elaborate on it so i've attached it..

View 4 Replies View Related

Huge Report With Visits Per Customer - Get Information Of Last Visit

Dec 2, 2013

We have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.

I want to create a querry that exports a table with 3 columns:

1-->customer
2-->date of last visit
3-->average of out of stock products on the LAST visit

I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.

How to handle this in MS access 2010?

View 2 Replies View Related

Queries :: Huge Report With Visits Per Customer - Grab Information Of Last Visit?

Dec 2, 2013

we have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.

I want to create a querry that exports a table with 3 columns:

1-->customer
2-->date of last visit
3-->average of out of stock products on the LAST visit

I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.

how to handle this in MS access 2010?

View 9 Replies View Related

Tables :: Consecutively Number Table Rows With User Determined Start Number

Jul 13, 2014

I have an Access2007/SQL Server 2012 system with 20 users for an insurance company. The company does most of its business via a network of vehicle dealers around the country. If someone comes in to buy a motorcycle, boat, or recreational vehicle at a dealership they need insurance to take it home, and our dealers send the quotes to us.

The dealers, in turn, receive payment from us each month for their efforts. Some are paid a % commission on the premium, some are paid for each quote they send regardless of whether the policy actually sells or not, and some are paid a set amount per sold policy. (Yes, that is relevant information!)

We already have reports that tally the amounts due each dealer based on their payment scheme, but last month our bookkeeper had to write about 650 checks manually because the check writing is not automated. She'd look at the report, and then enter name, address, and amount (in digits and words) into Quick Books and print the checks from there, a horribly tedious process. I've been asked to print the checks from Access. Basically one click would print all 650 checks.

I've opted to use a Make Table query to move the commissioned dealers amounts to a single location, and then to run two append queries to add the records from those paid per quote and those paid per policy. At the end of the day, one table contains all the information necessary to print the checks...except one.

The check number.

I need a way to sequentially number each record in the new table with a user generated starting point, the first check number.

By the way, the check blanks are on standard letter sized paper, three to a page, with tear-off perforations to separate them, in case that information has any relevance.

I think the best way to accomplish this is from the report itself. I've created a blank field on each record for the check number, and what seems most logical is that the sequential number is generated on print and written back to the table, rather than just generating all the numbers at once. That way, should print ever be interrupted, it will be easy to take up where we left off.

View 14 Replies View Related

Tables :: Procedure To Restrict / Stop Auto Number Increment For Certain Number Of Record Count

Mar 16, 2014

I would like to know if there is any procedure to restrict/stop auto number increment for certain number of record count (say 50), then increment by 1 for next 50 records.

View 8 Replies View Related

Modules & VBA :: Naming A File - SOW Number

Oct 23, 2013

I'm currently working with Access 2007 building a way to create PODs to clients. I have most everything laid out, one problem I can't seem to get around is naming the file the SOW #. Below is the code:

Function Run_all_PODs_01()
Dim myPath As String
Dim name As Object

DoCmd.OpenQuery "Q5 SOW bill requested data points all", acViewNormal, acEdit
DoCmd.OpenQuery "Q5 SOW bill requested All 01", acViewNormal, acEdit

[Code] ...

I can't seem to get the name to equal the SOW number.

The table that I'm trying to reference is "SOW bill requested data points" it is a basic table one row with a column header as SOW #. I'm not sure how to tell it name the file that data point in the column.

View 4 Replies View Related

Recording Which Reports Been Ran

Oct 27, 2005

I have created a data base inwhich a user can run 6 reports. I then have a manager who has a administration form which i want the manager to see what reports have been ran and what day.

to run the reports the user hits a button in another form, which then exports a qry to excel.

All the buttons have been named and each report has its own marco name.

Is there a way i can do this simply??

View 6 Replies View Related

Recording Payments

May 17, 2007

I have a database with 10 properties which I want to record details of weekly or monthy payments. I have a table for properties, one for tenants details and one called payments. I then have them on a form. I want to open the tenants form and insert a command button to open the payments form and record payments as the occur but i can only enter one - it is giving me an error message as I am duplicating a record. The tables are linked with a property reference which I have set as the primary key. I have obviously done it wrong. Can anyone advise me of a way to do this please.
Thanks Tracey

View 1 Replies View Related

First Recording Not Importing

Apr 1, 2008

I am using access 2003. I've setup an import specification for a text file to import into a table. It's importing but leaving off the first record. When I setup the import specification, I did so as fixed width because the fields were not defining correct when I used delimited. Could it be that it's thinking that the first record include the field names? If so, how do I rectify this?
thanks

View 3 Replies View Related

Recording Changes To Queries

Aug 4, 2007

Hi All,

Some annoying sod at work has been changing queries and i've been getting into a hell of a lot of trouble due to it!

Is there any way to record changes made to queries?

I have an audit trail to record changes to the data displayed in the forms but I really need to catch this SOB before they cost me my job?

Any ideas?

Ta

Dante

View 5 Replies View Related

General :: Importing Txt File With Large Number

Feb 11, 2014

I am importing a delimited .txt file that has a number field. A value for a record coming in is 36,767 and Access is not accepting it. If I redefine the field as long integer or as double, I can manually update the record, but as soon as the file containing the record is imported, the field reverts back to integer.

How do I format the field with VBA so that Access will accept the value and not revert to integer?

View 3 Replies View Related

Recording User Useage

May 19, 2005

Any help most appreciated!

I have a Access 2003 database I am developing which has a table called "tbl_users" in which I have the fields:
user name(text), network id(text), status(yes/no), long on time (date/time), log on date(date/time), log off time(date/time), log off date(date/time).

When a user logs on my autoexec macro calls a prodcedure which sets that users status to "yes" or ticked and stamps the log on time and date. Is it possible to call this procedure even if they bypass the autoexec by holding down the shift key?

In reverse to this when they click the "Exit System" on the Main Menu form there is a call to a procedure which unticks there status field and stamps the log off time and date. Again, can I trigger this procedure even if they exit the database without using my "Exit System" button (ie click the "x" to close the database)?

Regards,

Dalien51

View 6 Replies View Related







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