Search results

A person can have multiple employments. During each employment, they can work in multiple departments. The way I normalize the data is with 3 tables to maintain a complete history. 1) People - Name, DOB, etc. 2) People_Employment (many side to 1 People) - Start Date, End Date, Status, etc...

I agree with namliam. If at all possible, use linked tables to read the data you need. If you have access to the other front end (/mdb/.accdb) or non-split database, then you could import the object (forms, query, etc) needed to display the required data. Linked tables would allow the...

DITTO. (y) I use this method and would recommend it since it works in all versions of Access. Fast to set up and copy between databases. I find the QAT is best used for things that are not specific to a database., but only Access functionality that applies to any open database. FWIW: I do...

Tim, Not sure you need a subquery. That sounds link a simple join between tblDecisions.DecisionMadeBy and tblPersonnel.Personnel_ID where tblPersonnelDecisionMaker w = 1

Access by design does the following with Bound forms 1) When you move from the main/parent form to a subform control, the Parent form's record is automatically saved by Access. 2) In a subform, records are automatically saved by Access when you change records in a subform control. You can ask...

In Access, a subform control is used to embed a form into a Parent form. You do not open subforms. They are loaded automatically with the Parent (main) form loads. The code from Allen Browne is designed to work with a form that has subform control on the form, It sounds like you are open...

I agree with theDBguy that you need to create a report to print In the command button on the form, open a report with the form's filter. Private Sub cmdOpenReport_Click() If Me.Filter = "" Then DoCmd.OpenReport "rptCustomers", acViewPreview Else DoCmd.OpenReport "rptCustomers"...

When the new renewal is due normally has no impact on the penalty calculation. Whenever the renewal is paid, it is still for a full year up to the next due date. The renewal due date should not change. Thre is only penalties add for renewing late.

I am with theDBguy on this. Keep it simple. Copy the Front end from the server to the local PC every time they open it. No need to check for a version, They always have a fresh and current copy. Coping the front end every time is really important is you are not compiling the front end into a...

If you are editing an existing record, then your check for duplicates must filter out the record you are editing. Your current code: DCount("*", "[t_Organization]", "[Organization]= " & Chr(34) & Me![Organization] & Chr(34)) > 0 Then is including the record, you are editing. So yes, there...

There are two parts to the calculation: 1) If it is paid 23 or more days after the due date add 10% of the renewal fee 2) for each "month" past the due date, less a grace month, you add one month's fee (1/12 of the annual) Public Function CalcPastDueFees(DueDate As Date, DatePaid As...

If you are needing to export the data to excel, then I agree with Eberhard (ebs17). Use a subquery to filter the records work reallyt well. This may help: Subquery basics

How are you using the data? If it will be on a report, you can easily do this with a subreport. The subreport's record source would get the Top 1 comment by date sorted descending by date.

Without any more details about what your database stores, I will assume you are already storing a transaction record for all activity. This is critical to getting the statistics you want. Learning the Structure Query Language (SQL) will serve you well. Access queries use SQL to retrieve data...

I have run in within a Remote Desktop session and it worked fine and solved the issue. I use a .cmd file to run the commands.Including the NET stop and start

Keven, Thanks for letting us know that worked for you. Glad we could assist.

Kevin, It looks like you are trying to use a WHERE condition within the select part of the SQL statement. .If you want to get a count of the tickets whare Resolved=1 then try this: The way I do this a lot is idea is to create a column called ClosedTickets that is calculated as...

zeroaccess, I understand your concerns as a hardware/network person. They are valid network concerns. With databases and data, the number one priority is protecting the data. To do this, all the front ends MUST be keep updated to the currently deployed version. This does not mean we do...

Thanks for the update. Glad you got it working. kirkm, great job! (y)

FYI: The Form.Move does not work the same as MoveSize. Me.Move 1, 10, 100, 1000 the above code positions the form relative to the Access document window (below the ribbon and right of the Nav Pane)