Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 51
Search took 0.03 seconds.
Search: Posts Made By: oihjk
Forum: General 09-16-2010, 04:45 AM
Replies: 3
Views: 2,822
Posted By oihjk
Re: Can We Open 2010 ade with 2007

Thanks Boyd, that is what I needed to know. I appreciate your clear and concise answer.

Eric
Forum: General 09-15-2010, 02:07 PM
Replies: 3
Views: 2,822
Posted By oihjk
Can We Open 2010 ade with 2007

Simple question (I realize the answer may not be). Is there a way to open an .ade saved from 2010 using MS Access 2007?

I have commercial software written in Access 2007, I am testing the...
Forum: Queries 10-10-2008, 07:11 AM
Replies: 0
Views: 490
Posted By oihjk
Access Data Project Paramaters in sub queries

Hello Everyone,
It has been a while since I have posted here.
I am working on a query to show information from various tables. It's purpose is to show the costs for each job.

I am using an sql...
Forum: Forms 02-04-2008, 03:19 PM
Replies: 1
Views: 522
Posted By oihjk
Figured it out...

This is what I did for those interested.

if Me.NewRecord then
if Me.RecordsetClone.RecordCount > 2 then
MsgBox "Only three entries allowed."
Me.Recordset.MoveFirst
endif
endif

I someone...
Forum: Forms 02-04-2008, 03:15 PM
Replies: 1
Views: 522
Posted By oihjk
Subform help

Is there a way to limit the amount of entries in a subform to a certain number?

I currently am trying to do it using the allowadditions property combined with onCurrent, but I need something to...
Forum: General 02-03-2008, 03:34 PM
Replies: 6
Views: 923
Posted By oihjk
Hey Checker, Thanks for the reply. I have...

Hey Checker,

Thanks for the reply. I have been working on this for so long I need some "outside insight." That gets me going in a good direction. On the same note, once I have that set. I will...
Forum: General 02-02-2008, 12:39 PM
Replies: 6
Views: 923
Posted By oihjk
Just to show you, this is part of one of the...

Just to show you, this is part of one of the queries:

strSQL = "SELECT qryListHoursTime.LaborDetailsID,...
Forum: General 02-02-2008, 12:34 PM
Replies: 6
Views: 923
Posted By oihjk
Advanced Customization

This should be a piece of cake for someone with a few experience years on me. I have a client for which I am building a custom database. They use this for various reasons. One main reason is to track...
Forum: Forms 10-16-2007, 03:43 PM
Replies: 2
Views: 615
Posted By oihjk
Check for Time in Range

I have an apparently unique challenge that I thought would be pretty common. I have a payroll system that tracks payroll per job. The entries are on a time range basis. So on job 2, if an employee...
Forum: Forms 10-03-2007, 06:50 PM
Replies: 2
Views: 2,224
Posted By oihjk
Hey Linq! Chill out... :) Truth is I am not...

Hey Linq! Chill out...
:)
Truth is I am not even an employee here. I am just doing some database consulting and design work. I've hit a road block here and was looking for some insight. Actually I...
Forum: Forms 10-03-2007, 03:21 PM
Replies: 2
Views: 2,224
Posted By oihjk
Calculate Standard and Premium Pay hours

I have inherited a database.

There is one portion relating to payroll, hours, jobs, and time sheets that I need help with.

On each time sheet there are multiple employees. For each employee...
Forum: Forms 01-06-2005, 01:43 PM
Replies: 6
Views: 1,354
Posted By oihjk
The real issue

Pat and Brian, Thanks for replying to my post. I did take your advice and changed the PK to VarianceID instead of a multi PK. Joins are much easier this way. I've also changed all of the...
Forum: Forms 01-03-2005, 11:43 AM
Replies: 6
Views: 1,354
Posted By oihjk
I did it this way so that I can have more than...

I did it this way so that I can have more than one Code of Account entered against each variance. ~edit~I do believe you are correct though. I should have used the PK from the CoA table as FK in the...
Forum: Forms 01-03-2005, 09:23 AM
Replies: 6
Views: 1,354
Posted By oihjk
I created a subtotal of Dollars on the...

I created a subtotal of Dollars on the "CodeofAccounts" subform called "COATotals" and put it in the Footer.

When trying to reference this field from the "Variance" subform using

...
Forum: Forms 12-30-2004, 12:56 PM
Replies: 6
Views: 1,354
Posted By oihjk
Add values from two diff record sources

The layout of the tables are as such:
_______________________
Code of Accounts table:
Proj#/Var#/CodeofAccount/ManPower/Hours/Dollars

Variance table:...
Forum: Forms 06-11-2004, 12:27 PM
Replies: 0
Views: 1,613
Posted By oihjk
Filter listbox by Multiple Combos

I've got a list box that I want to filter by Year, Month and Day of Month. I would prefer using combos containing the values I want to filter by.

In the recordsource of the listbox I'm using the...
Forum: General 02-06-2004, 05:39 AM
Replies: 1
Views: 7,145
Posted By oihjk
Anyone have any ideas automatically sending this?

Anyone have any ideas automatically sending this?
Forum: General 02-03-2004, 08:11 AM
Replies: 1
Views: 7,145
Posted By oihjk
Question Send Email with query data

I've got a database that is tracking work scope variances. There is a tendency to take a while for the engineer to approve the hard copy of the variance (it has to go through interoffice mail etc).
...
Forum: General 10-20-2003, 07:38 AM
Replies: 15
Views: 1,406
Posted By oihjk
Hey folks I appreciate it.

Hey folks I appreciate it.
Forum: General 10-17-2003, 12:17 PM
Replies: 15
Views: 1,406
Posted By oihjk
Mile, What parts do I need to change to make...

Mile,

What parts do I need to change to make this work in Access 2000? It works by itself, but when I try to import it into another DB it doesn't work. I open the DB and it opens the debugger with...
Forum: Forms 09-22-2003, 12:51 PM
Replies: 2
Views: 8,409
Posted By oihjk
Beautiful. Thanks for the insight. Eric

Beautiful. Thanks for the insight.

Eric
Forum: Forms 09-22-2003, 10:41 AM
Replies: 2
Views: 8,409
Posted By oihjk
Use variable in [Forms]![FormName]![FieldName].Property

Is this possible to do?
For example my form name is frmBogus Field name is fldBogus. So normally I would reference its properties like this:

[Forms]![frmBogus]![fldBogus].SetFocus

Would it...
Forum: Reports 08-27-2003, 08:47 PM
Replies: 2
Views: 792
Posted By oihjk
Thank you for the reply. The problem however...

Thank you for the reply. The problem however isn't with the report, It's with the chart. I'm trying to get the chart to filter in the way that you said above. Maybe you're meaning this and I just...
Forum: Reports 08-26-2003, 11:39 AM
Replies: 2
Views: 792
Posted By oihjk
Getting criteria from form into pie chart

I'm trying to get the criteria for a chart to come from a form. In a form the user can select the report they won't to run and the other parameters. Instead of doing this through a parameter query I...
Forum: Reports 04-29-2003, 08:43 AM
Replies: 9
Views: 2,680
Posted By oihjk
Would a smaller font work here? Maybe I'm missing...

Would a smaller font work here? Maybe I'm missing the idea of what you want.

Eric
Showing results 1 to 25 of 51

 
Forum Jump



All times are GMT -8. The time now is 08:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World