Developing A Table Using The Calander Function

Aug 8, 2007

I am working on developing a time table for my mothers day care to include payments due, total payments for the tax year and a few other items. The issue I am having is developing the table to track when the children are present. I would like to use the built in calander function in which I can click on the days of the week the children are present and store this into a table as a yes no for each day. Once the data is stored in a table, then I can convert this information into a billing cycle and then go from there.

Thanks in advance,
Mike

View Replies


ADVERTISEMENT

Need Help With Developing Table Structure

Dec 20, 2007

HI,
I've been banging my head on this, and I just can't seem to find a good way to create my tables.

They want a selection with a sub selection, and then allow the user to fill in data depending on that data. I'm not sure if I should make a new table to hold the data for each sub selection? Or should I make 1 larger table with columns for all the sub selection data fields, even tho they won't all get filled in for each record.

Option #1
Option #1 sub choice
Sub Choice 1 Sub choice 1 fieldsDates, field 2, field 3
Sub Choice 2Sub Choice 2 fieldsDates, Sub Choice 2 fields

Option #2
and same structure as before, just different options.

this is so hard to explain, not even sure I should post this.

View 14 Replies View Related

Updatable Active X Calander

Mar 9, 2005

Is there a calander that I can put on my form that will update to current date when I open form

Gary

View 2 Replies View Related

Calander Control W/ Scheduling HELP!

Aug 1, 2005

I have never used the calander control in access I am Very new to Access code as well. But I am Learning.

This is what I am trying to do

I have a Customers tbl and a Salesmen tbl

I would like to have a calander that I can use to set appointments for multiple salesmen in a form. I have looked at the calanders posted here and now of them do anything like what I am trying to do. Is this possiable to do?

Thanks in Advance for helping a newbie
:confused:

View 2 Replies View Related

Popup Calander In Subform

Aug 19, 2005

Greeting
i'm kind of a rookie with access : )

i'm using the attached popup calander in my form and subform ,,,
it works perfect in my form
but when using in the subform, i get an error saying "the specified form can't be found"

if i open the subform as a form it works

so my question, is do i have to change anything in the calandar code so it could open in subform as well ??

if yes how ?

thanks in advance

View 6 Replies View Related

Popup Calander Problem

Sep 29, 2006

I have a popup calendar which works perfect on my form but will not work in an imbedded sub form.
If I go to the sub form itself it works perfect both in datasheet view and Form view. But if I go to the main form which this same sub form is imbedded (datasheet view) it does not work. The calendar appears on double click but date does not update when clicked.
The code in on dbl click is =opencalendar("")
Anyone know what I am doing wrong please ?
Rgds Roc

View 2 Replies View Related

Help With Developing A Calculated Field

Nov 3, 2007

It's a Bed and Breakfast. There are two Access Tables in the query. No
spreadsheet. The Reservations table has RoomNumbers (some of which repeat because different customers rent the room during different time periods), CustomerNumbers, Check-inDate and Check-out Dates. The Rooms table has RoomNumber, FloorNumber, PricePerNight fields. The calculated field that I have developed to figure the money generated by each room is Total:([Rooms].[PricePerNight])*([Reservation].[Check-outDate]-[Reservations].[Check-inDate]).

This makes my result look like:

Room Number Total
3 $960.00
7 $540.00
3 $480.00
1 $300.00
4 $280.00
4 $280.00
3 $240.00
2 $225.00
2 $150.00
4 $140.00
1 $ 75.00
6 $ 60.00

How do I use a Summation function to aggregate the amount of money brought in for each room, so that the result looks like

Room Number Total
3 $1,680.00
4 $700.00
7 $540.00
2 $375.00
1 $375.00
6 $60.00

Any help would be appreciated.

Thank you

View 1 Replies View Related

Developing A Interview Database

Aug 18, 2004

Background:

I currently work for a large healthcare system as a Nurse Recruiter. We have had the need, fro quitre some time, to have the ability to track all interviews. I have recently developed a database that will allow us to do this and much more but have run into a few snags. I hope someone will be able to help.

Problem:

I would like to create a "pop up" query on one of my forms. I would like to have the ability to type in a date in the pop up box and and thus generate a report that allows me to see all interviews scheduled for that day/date. I have tried several things but cannot seem to get anything to work. I cannot even get the "pop up" box to work corrctly.....any suggestions?

The other task that I am trying to accomplish is not to allow people to schedule interviews at the same hospital for the same time on the same day/date. Ideally I would like an error message to pop up if this occurs. Any suggestions on how to build this query?

My DataBase:

It is a very simple database utilizing only one table, a few queries, a few macros, and 4 forms. I have attached a picture of my table so that yuo may view all available fields.

As you can tell i am relatively new to this but am very anxious to learn as much as I can so that I may improve! Any help is very much appreciated!


View 4 Replies View Related

Developing An Existing Access Database

Jun 29, 2006

We are a SME with a 4 year old access database which is in need of updating with new tabs and various other new spec. We are struggling to find an access programmer who is right for this project.

Does anyone know someone who could have a look at this project??

We are in the Greater Manchester area at present but will be rolling out on a regional and then national scale with this in the next 12-18 months

View 1 Replies View Related

Developing A Customer Satisfaction Survey In Access

Oct 8, 2004

Hi -- my first time here...
Has anyone ever had to develop a survey (e.g., customer satisfaction survey) in Access? Does anyone have any advice?

View 1 Replies View Related

Tables :: Developing Related Multi Level Child Parent Tables?

Jan 14, 2013

I have created a table that acts as a header for my data and a second table that acts as line item data. What I need to do now is add a second child table that uses the line item data as its parent table and stores associated line items for each record. Is this possible?

This is a skeleton view of what I'm going for:

Master Table:

tlbAuditReportHeader
- AuditDate
- AuditArea
- Auditor

Sub Table:

tblDiscrepancy
- Discrepancy
- CorrectiveAction
- ActualCompletionDate
- VerifiedDate
- Notes

Sub table to Sub Table

tblFollowUp
- FollowUpDate
- AssignedTo
- SpokeWith
- EstimatedCompletionDate
- Notes

Sometimes tasks change hands or are pushed back depending on work load. It would be nice to be able to track something like this.

View 1 Replies View Related

DLookup Function To Load Information From Table To Another Table Using Subform

Mar 22, 2013

I have 3 table table; Invoice table, Product table and Sale_product table. Sale product table records all sale from the product table

Invoice table has these fields
ID
TOTAL
CASH_TENDERED
CHANGE

Product table has

ID
CODE
QUANTITY
NAME
PRICE

and Sale_Product table has these
ID
PRODUCT_CODE
QUANTITY
PRODUCT_NAME
PRICE
SUBTOTAL
INVOICE

I did main form from Invoice table and sub form from Sale_product table. I want to use DLOOKUP function to load the name and price, quantity and calculate subtotal automatically from the product table based on the product code entered. i have being trying hard and i keep on getting "Name? error"

View 1 Replies View Related

Table Lookup Function

Mar 21, 2005

Hi,

I have a table with the following 3 fields (these are the ones i'm having the issue with but there are others).

ID, Country, City

The ID is an auto number.

The Country Field is a lookup with the following lookup properties

Display Control: Combo Box

Row Source Type: Value List

Row Source: "England";"Spain";"France" etc


:confused: Now the problem...

I also want a lookup in the City field which changes to reflect what was selected in the Country field.

E.G

If in the Country Field Spain is selected then in the City Field I should have the option of selecting Barcelona, Madrid, Valencia etc.

Is this possible in the lookup of a table???


Thanks. :)

View 4 Replies View Related

Modules & VBA :: SQL Table Valued Function

Jul 5, 2013

i'm trying to connect to a table valued function on sql (2005) but keep getting the following error: argument are of the wrong type, are out of acceptable range, or in conflict with one another.here's the code

Code:
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Set cnn = New ADODB.Connection
cnn.ConnectionString = "DSN=mydsn;UID=myuser;PWD=mypw;"
cnn.Open

[code]...

View 4 Replies View Related

Function Code To Log Field Changes Into A Table?

Jan 21, 2015

As you can see the purpose of this function code is to register into the TblLogChanges every single record exclusion or record change made in any form field of my project when the form is active. In other words if the user changes for example the value of the field Color in the form FrmX from Yellow to Black, the TblLogChanges will have added a line indicating: FrmX, type of change (record change or record exclusion), RecordId (in my case CADID), Current User, Date, and a complimentary string showing Field Color old value=Yellow --> Field Color new value=Black.It works fine when the field "old" value is populated (not null). However, if the feld old value is null, meaning, if the field value is originally null, or yet if the field is originally empty, and I fill it up with some data, then the code does not add an indicative line into the table TblLogChanges.

See function code below.

FYI the function is called in both Before Update and Delete events of the form with the following syntaxes: =logChangeFrmCadastro("E") for record exclusions, and =logChangeFrmCadastro("A") for record changes.

I have failed so far to make it happen. Reason is I'm able to read and understand most written syntax but still not good enough to create my own codes since I do not know to use the range of VBA commands and syntaxes available yet. This is a knowledge gap I'm doing my best to fill in.

what function code changes are required so the function be able to add an indicative line into TblLogChanges when the user changes a form field from "empty/nothing" to something?

Code:
Option Compare Database
Option Explicit
Function LogChangeFrmCadastro(strTipo As String)
On Error Resume Next
Dim db As Database, rslog As Recordset
Dim frm As Form, I As Integer

[code]....

View 5 Replies View Related

Save Result Of A Calculation Or Function Into A Table

Apr 1, 2006

Hi there,

I've read through the forums on saving the results of a calculation into a field is a bad idea. I somewhat understand the reasoning for it. But I don't think such situations arise for everyone.

But I have gone with the suggestion and created an updatequery, which simply goes through and updates the calculated value into a table. Now each time the updatequery is run its asking for permission as to the fact if I'm sure I want it to be run. How do I turn this option off. And should I call this updatequery afterupdate or beforeupdate?

Thanks

View 3 Replies View Related

How To Obtain A Table Summary Using QUERY Function?

Jun 21, 2007

Hi..(",o) anyone can HELP?

I'm currently using MS Access 2000...
May i know how can I translate the following TABLE

Doc# Team# Status
D1 TA Done
D1 TB WIP
D1 TC WIP
D1 TD Done
D2 TA Done
D2 TB Done
D2 TC Done
D2 TD WIP

to a QUERY reflecting in the following format?

TA TB TC TD
D1 Done WIP WIP Done
D2 Done Done Done WIP


Your help will be greatly appreciated!

View 2 Replies View Related

Tables :: Like Function Elements Residing In A Table

Sep 10, 2013

I am trying to find a way execute various "like / is not like" commands on a field within a table. Rather than build 30-40 different "like / is not like" commands to execute on this specific field, I would prefer to have one "like" comand and have it's elements listed in a reference table that I can call into the "like" commend or function.

In this way I can change the "Like" statement filtering criteria by simply adding or deleting filter elements from the reference table rather than have to modify the "like" command's hard coding.How to do something similar, perhaps using a different function or macro?

View 3 Replies View Related

Queries :: Replace Function In Query With Sub Table

Feb 14, 2014

I am running a query for an apparel manufacturing facility. In my query I have a table called 'OrderForm' which is where the orders are put in. There are more than one type of fabric that can be a part of an apparel item, so as a result, there are multiple fields pulling from the 'FabricType' table. In order to get this to work in my query I created 'SubTables' for the different fabric fields. For example, I have tblFrontfab, tblbackfab, tblsleevefab, and tblcollarfab which are just extra copies of the 'FabricType' table. The actual question is that when I want to replace characters like ,./& in the fabric field but I can't use the replace function. It says that it is too complex to calculate.

I used this notation
Frontfab: Replace([tblFrontfab].[fabric],".","")
and the error was that it is to complex to evaluate.

View 1 Replies View Related

Modules & VBA :: List Fields Via Table Info Function

Nov 5, 2013

I a trying to list all fields from ALL tables in a certain DB.I am using the tableinfo function. However, because the output of the immediate window is limited to 200 lines, I can only see the last 200 fields. Is there a way to export this in another way than the debug.print procedure, so I can bypass this limitation?

Code:

Public Sub showtablefields()
Dim db As Database
Dim tdl As TableDef

[code]...

View 5 Replies View Related

Forms :: Refreshing Table Form Through Search Function

Apr 7, 2015

I am having some minor issues with my current database. The way it works currently is having a MainMenu where you can either go to customers/ ProductList/ Product OR ProductList straight away. I have a CustomerT and a ProductT. I have made a Query where I link the two tabels to have the feature showing the customer to the specific product with the criteria: "Kunde: [CustomerName] & " " & [Subsidiary]" on the form I have a txtsearch (Textbox) connected to a button with this coding:

Private Sub Kommandoknap49_Click()
Dim strsearch As String
Dim strText As String
If (Len(txtsearch.Value) > 0) Then
strText = Me.txtsearch.Value

[code]....

This allows me to search for text in each of the boxes with information on the single product(s) for example searching for Kunde (Customer in Danish) or ProduktNavn (Name of product) HOWEVER when I do this the "Kunde" turns into "#Navn?" c..If i reopen the Form it will show with the right information. I also tried to code the "Byactivation" to

PHP Code:

Forms!ProduktListeMainMenuF.Requery 

View 2 Replies View Related

Updating A Table Field In A Form Using Public Function?

Nov 13, 2014

I have created a Public Function that would get a new Production Instructions number based off the [PI Number] of Tbl_Production_Instruction table.

I have a form that people will put in all information but the PI Number, then when ready they will click a button to update the PI Number. I place an unbound txtbox that will be hidden, with the control source to =NewPINum(), but when I tested the see if the unbound txtbox was populated with the new PI Number it was blank.can't figure out what I am doing wrong.

Code:
Public Function NewPINum() As String
Dim vNum As String
Dim strYYMM As String
Dim getnextPI As String
strYYMM = Format(Date, "yy") & "-" & Format(Date, "mm") & "-"
If strYYMM = Left(DMax("[PI Number]", "Tbl_Production_Instruction"), 6) Then
vNum = Right(DMax("[PI Number]", "Tbl_Production_Instruction"), 3) vNum = vNum + 1 getnextPI = Format(Date, "yy") & "-" & Format(Date, "mm") & "-" & Format(vNum, "000")Else
vNum = "001" getnextPI = Format(Date, "yy") & "-" & Format(Date, "mm") & "-" & Format(vNum, "000")
End If
End Function

View 4 Replies View Related

Table Field Not Accepting Data From Form Function COUNT.

Oct 7, 2005

Table Field not accepting data from the Form function, count.

On the Form with the properties displaying the field, in the Control Source I have the following formula; "= count([OccupantName])

Now this does calculate properly except that the data in not saved to the table field.

Is the above count statement wrong?

Or does this need to be done another way? If so how?

Does anyone know of another way to have the computer count information on a Form that can be saved to a table field?

View 2 Replies View Related

Modules & VBA :: Creating A Function That Counts Records And Use That Function In A Query

Dec 11, 2013

So basically I need making a function that will count the number of records from another table/query based on a field from the current query.

View 2 Replies View Related

Forms :: SUM Function Produces Error From Calculated Function

Jan 30, 2014

I have a project at hand and it's been a predecessor of mine and client has asked me to do some work on it and extend functionality - but I have not really delved into Access before and I have had to worked my way through to this final snag :/

The Main Form has one sub form. This sub form allows the user to add multiple order items i.e. qty, stock, description from records within the system - fairly straight forward.At the last column of each row is the sub total of those particular items i.e.

Qty Unit | Item ID | Total
-----------------------
2 | 1234 | 80.00
------------------------
1 | 43526 | 20.00
------------------------
> | |

So the total is a function of =[Qty Unit] * [Unit Price].Then in the Footer of this SubForm is the Sub Total

=SUM([Qty Unit] * [Unit Price])

All fine and well..... However, the additional functionality kicks in.

Lets add the additional customer_id from the Main Form. Each Item bought is dependent on the customer_id i.e. they get special prices depending on who they are.So a New table is made which has the Item ID and SpecialPriceID (of a table to define as a specialPrice) and the Price linked to this Item and Special Price category. So say that there are two groups of users "wholesale" and "nonwholesale" these would be SP_1 and SP_2 and each client is defined either one of these, and each stock item has a Price for each SP_1 and SP_2. Hopefully I've explained myself there.

Back to the SubForm. So now the Total needs to calculated differently with needed the external customer_id from the Main Form.

Code:

Function CalculateSpecialPrice(ItemID As String, CustomerID As String, Unit As Integer)
Dim SPSelect As String
SPSelect = "SELECT Price FROM [Items_SpecialPrices] WHERE"
SPSelect = SPSelect & " ItemID = '" & ItemID
SPSelect = SPSelect & "' AND SpecialPriceID = (SELECT SpecialPriceID FROM Customers WHERE customer_id = " & CustomerID & ") "

[code]....

its the sub total I just keep on getting #Error on. I have even watched (using alerts) that the correct return variable is the same as the individual rows. This is the equation I used for the SubTotal within the footer.

=SUM(CalculateSpecialPrice([Item ID], [Form]![FormName]![CustomerID], [Qty Unit]))
#Error

View 2 Replies View Related

Forms :: How To Save Result Of DLookup Function (used In Unbound Text Box) In A Table

Oct 17, 2014

I have a form based on query. On form i am retrieving data from another table using DLookup in a unbound text box. So I want to save the result of DLookup function in another field/table on same form.

View 8 Replies View Related







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