Queries :: Database Of Apprentices - Increase Wage As Age Increases

May 13, 2015

I have a database of apprentices, so there are a lot of wage increases, as a lot of them are on minimum wage, which rises as they get older.

I want to run a query that automatically updates based on their current age, how to do this?

Rates are:

<18 - £140.23 per week
18 to 20 - £189.81 per week
21+ - £240.50 per week

All of the employees work 37 hours a week.

View Replies


ADVERTISEMENT

Wage Query

Oct 22, 2005

I'm just started learning Access. Just wondering what is the basic salary for a access programmer these days?

Please let me know. Thanks.

View 2 Replies View Related

Using Most Current Employee Wage Rate

May 18, 2015

I am setting up a time tracking database which will track employees maintenance times. Several employees spend X number of hours each day maintaining machines from different categories, such as mowing, snow removal, etc.

I am trying to figure out if it is possible to set the tables up in a way which will not require adding an employees wage rate to every time tracking (listed in the time tracking table below) record. To somehow have the table pull data from the most recent wage record for that particular employee. As employees get raises I would like to retain the old rate in the time tracking table along with the new rate for current data.

The way I have the tables setup right now are as follows.

Employee table
EmployeeIDFirstNameLastNameAddress, Phone, etc

Maintenance Categories table
MaintIDMaintName

Wage table

WageIDEmployeeIDDateEffectiveCurrentWage

Time Tracking table

TimeTrackingIDEmployeeID (lookup from employee table)MaintID (lookup from maintenance table)WageID (lookup from the wage table)DateOfMaintenanceStartTimeEndTime

All of the tables have relationships in the time tracking table.

View 3 Replies View Related

Frontend Size Increases Heavily

May 10, 2006

Hi,

I got a question related to a database with a frontend and backend.

It seems that every time I make a minor adjustment to the frontend its size increases.

i.e. My frontend was about 2 MB. I made an extra report which I later removed. I quit access and look at my frontend database, the size is now allmost 6 mb!

How is this possible?

View 7 Replies View Related

Emailing A Table Increases File Size

Apr 4, 2006

Hi,

I am trying to send a "EMP" table in an excel format using "SendObject". User clicks the "Send Mail" button to email the table in excel file. The user then clicks on the "Exit" button to exit. This wipes out the data in the table "EMP" as was expected. Every thing goes fine..... but the size of my database increases by more than 100 MB. (Note that the table in the data has been deleted & the data is around 59 MB).

Any suggestions on what could be causing this increase in file size.

Thx in advance,

Jatz

View 5 Replies View Related

General :: List Box Count Increases By 1 If Include Headers?

Mar 15, 2014

Am I right in thinking that the a listbox.itemcount increases by 1 if you include headers.

ie - the headers are counted as a row?

View 1 Replies View Related

Increase The Time By 1 Second

Apr 28, 2006

Hi,

I have a question.

I want to make a action on every 2 hours on the form.

On form time interval, I set 1000

Private Sub Form_Open()
a = "00:00:00"
End Sub

Private Sub Form_Timer()
On Error GoTo Err_mess
timelabel = CDate(a) + cdate("00:00:01")

Err_mess:

End Sub


I want to start 00:00:00, and then add 1 second on every time interval=1000.

eg.
00:00:00
00:00:01
00:00:02
00:00:03
...
...
01:00:00

How can I make it? Thanks.

View 1 Replies View Related

Increase Amount Of Columns

Nov 8, 2007

Hi

Is there any way i can increase the amount of columns in a table before importing data? I am importing data from a notepad doc that needs abt 300 columns but i can only get abt 100 columns.

Thanks for any help

View 8 Replies View Related

How To Increase Memo Length

Sep 24, 2013

I have created a table in which there is one column of type memo. When I copy the content in this column it is allowing me to enter only 255 characters. How to increase the length of this column type memo?

I have a query with GroupBy. Is it causing me the damage? How to overcome this situation.

View 5 Replies View Related

Add New Day Number Record And Increase Value By One

Apr 19, 2014

I have a table, tblEvents, which I use to store information about a meeting, training session or field trip, including the [StartDate]. I also have a table, tblEventDays, which I use to store the [DayNumber] 1, 2, 3... At the moment I have to enter the day numbers in the subform frmEventDays manually, but I would like to add button controls to increase/decrease the number of days for each event (i.e. add a new record where [DayNumber] is incremented by 1, and delete the last record if I have added too many day records).

I have added button controls to my EventDays subform and managed to use the macro builder to select and duplicate the last [DayNumber] record, but cannot figure out how to increase each successive [DayNumber] by 1.

1. Add a day...

Option Compare Database
Private Sub AddDay_Click()
?
End Sub

2. Remove a day...

Option Compare Database
Private Sub RemoveLastDay_Click()
?
End Sub

View 4 Replies View Related

VB To Increase Record Update By 1

Jun 13, 2012

I have a form with multiple fields on it. We will call them SLO

They are text boxes and there are 6 of them named SLO1, SLO2.....SLO6

What I want to do, is use VB to update each as a string to a table individually. But Id like to only type the code once, and use a DO WHILE and increase the value by one. Example.

Current Code looks like this:

Private Sub UpdateButton_Click()
Set rstNewInventoryDataRecord = CurrentDb.OpenRecordset("Select * FROM MetricData")
Set CurrentForm = Screen.ActiveForm
Dim Counter As Integer
Counter = 1
rstNewInventoryDataRecord.AddNew
rstNewInventoryDataRecord.SLO = CurrentForm.SLOT1.Caption
rstNewInventoryDataRecord.Update
MsgBox "Update Complete"
End Sub

What I want to do is use the counter to increase by one after each loop and stop after 6. So...Do while Counter < 7

And increase the CurrentForm.SLOT1.Caption by one each time.

I've tried

rstNewInventoryDataRecord.SLO = CurrentForm.SLOT & Counter.Caption
and
rstNewInventoryDataRecord.SLO = CurrentForm."SLOT" & Counter.Caption

As well as a few other ideas all to no avail. Is this possible?

View 1 Replies View Related

Drastic Increase In Response Time

May 15, 2006

I have an 18.8MB Access application consisting of the following:
140 tables
410 Queries
67 Forms
5 Macros
26 Modules


It's not a lot of data storage, but is very computationally and mathematically intensive. As we continue to develop and expand the application, I noticed last week that we suddenly experienced a massive falloff in performance. Access is taking an incredibly long amount of time to traverse the querydefs collection, find objects, etc. It seems that the object collections themselves are not indexed, meaning that it takes a much longer amount of time to run a compiled and saved query than it does to simply build the SQL string and execute from within code. I continue to hunt for coding bottlenecks and any other efficiency problems I can find. Has anyone else experienced this? Is there a "critical mass" for the object containers?

View 5 Replies View Related

Increase Field Text Limit (255)

Sep 15, 2006

Please help if somebody knows the way to increase the character limit of field from 255 to max. possible.

Thanks
Navkesh

View 4 Replies View Related

Tables :: Increase Field Size From 10 To 50

Dec 25, 2012

How to increase field size in a certain table from 10 to 50 from Database (programaticaly).

View 1 Replies View Related

Possible To Increase Number Of Columns In Access 10?

Nov 13, 2013

Is it possible to increase the number of columns in Access 10?I upgraded MS Office because I knew Excel no longer restricted you to 256 columns. I often pull data from a data base that uses as many as 800 columns.When I try to open these files I get a "too many cross tabs" error prompt.

View 2 Replies View Related

OLE Object (thumbnails Of 4kb) Increase .mdb-size Extreme?

Jul 12, 2005

Hi!

Do you guys think the database will get small in size if i have like 200 records and each one of them have a 4 kb thumbnail as OLE object?

I know that putting big images in OLE objects gets very big but a small thumbnail is ok and doesn't increase the size of the .mdb so much? (130x98 pixels)

View 1 Replies View Related

Can Remark / Comment Lines Increase Db Size?

Jul 22, 2006

Hi,

Can someone tell me that more remark / comment lines in VBA might be one of the reason of increasing the db size?

Because now a days I am removing the queries from my db and started to use VBA code lines behind each forms and keeping some remark / comment lines to know what a particular set of code line means and what they are doing. So I put everywhere some remarks / comments line. Now my forms are faster than before but the over all size of db become heavy.

Are comment lines one of the reason in increasing db size?

With kind regards,
Ashfaque

View 2 Replies View Related

Sub Form Increase In Size Depending On Data

Sep 29, 2006

I have a main form with a few imbedded sub forms.
Sometimes these is a great deal of data in one of the sub forms & non in the others.
Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks for little data)
The way I have it now is that each sub form is always the same size and a scroll bar appears when these is extra data. This is OK but I need to see all data in sub forms at once if possible.
Can anyone help with ideas please?

View 2 Replies View Related

Forms :: How To Increase Width Of Columns In A List

Sep 10, 2014

I have created a list that has 5 column. Data is filled in list using a query. I know how to remove 2 columns, but I do not know how to increase the width of columns.

View 2 Replies View Related

Forms :: Action Buttons Increase In Size 50% To Right And Down

Jul 7, 2013

It has been a month and I'm still 'stuck' on my Microsoft Access lessons due to a peculiar error. I have a video of the error, but it won't let me post a link until I have 10 posts. When I create an action button and then scroll at all, the button jumps in size 50% to the right and down, but this extra space can't be edited. Clicking on the 'extra space' is like clicking the background.

I have tried

1. Reinstalling Office 365
2. Reinstalling my graphics card drivers (Using a GTX 560ti SLIx2)
3. Manually entering the size for the buttons in the button properties (still increases in size)

I have a project where the schedule calls for a web-enabled database for 100+ users to merge five separate systems into one. If I can't get past this problem, I can't continue my lessons.

View 11 Replies View Related

How To Increase Value In ODBC Connection Time Out Property

Oct 28, 2014

I am using MS Acsess 2010 and some time I am getting ODBC Connection Error. How to increase the ODBC & Query Time Out property in MS Access?.I am using 32 bit version of Access 2010 on a 64 bit operating system.

View 1 Replies View Related

General :: Invoice Number To Begin At 256 And Then Increase Incrementally

Jan 7, 2015

I just came across a problem that I didn't recognize before. I had an invoice table and corresponding form that had an autonumber for the invoice number. The problem now is that I would like the invoice number to begin at 256 and then increase incrementally, because I had some previous invoices from my books. How to go about doing this.

View 5 Replies View Related

General :: Return Max Number In A Field Then Increase By 1 For New Record

Oct 23, 2013

I'm using Dmax() to return a max number in a field which I then want to inc by 1 for a new record. Dmax is returning 999. I believe Dmax therefore thinks it's a text field. So where do I change this to a number field?

View 2 Replies View Related

Tables :: Add ID Number That Always Increase By 1each Time Add New Record To Table

Jan 23, 2013

How can I add an ID-number that always increases (by 1) each time I add a new record to a table (using a form)? I want to always use some info from the record that was added last to fill in a different form. The reason for my question is that I heard that the autonumber does not necessarily increase each time a new record is added...

View 1 Replies View Related

Forms :: Increase Maximum Characters Allowed In Expression Of Macro Setvalue Action

Apr 23, 2013

Is there a way to increase the maximum characters allowed in an expression of a macro setvalue action ?

I have an expression in a macro setvalue action that adds multiple form textbox values. I need to change the form name from "RATING ENGINE 2" to "E RATING ENGINE 2". When I do this, I exceed the maximum characters allowed in the expression. Is there a way I can rename "RATING ENGINE 2" without this problem. The expression is as follows:

[Forms]![RATING ENGINE 2]![Excess Liab Premium 6]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 7]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 8]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 9]+[Forms]![RATING ENGINE 2]![Excess Liab Premium 10]

View 6 Replies View Related

Queries :: Quotations Database - Queries Showing Too Many Records

Jun 25, 2015

I have a database that is used to create Quotations. After all of the information is entered the queries that hold the calculations must be run. I have lots of calculated that rely on other calculated fields. When I need to Sum all of the calculated fields in one field I must create a new query. I currently have a QuotationID, PartID, and MetalID all linked together. The first of the calculations are done per Metal, and these are working fine. I run into a problem when the calculations need to be done by part. My Queries are creating a record for every Metal and this is throwing all of my numbers off.

View 1 Replies View Related







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