jaxjagfan
Last Activity: Oct 21 '08, 06:06 PM
Joined: Dec 12 '07
Location: Jax, FL
-
Post the SQL from your query and I will modify and repost.... -
BTW - QB and QB Pro were most likely done using Visual Studio using VB or C#. Both have a lot of custom controls not available in Access including dynamic resizing. Some apps and/or functionality can be reproduced in Access.Leave a comment:
-
Whatever gets entered into [Fiscal Week] will be 2 characters.Code:Right("00" & [Fiscal Week],2)
This should work for you by putting all entries into a 2 character no matter what your end user enters into [Fiscal Week].
I assumed you have a textbox called "Fiscal Week". If not just change the code snippet....Leave a comment:
-
I prefer using DateDiff to specify numerical differences in dates:
SELECT 2007 AS YR,
EMPLOYEES.SECTI ON, EMPLOYEES.DEPT, EMPLOYEES.DOB,E MPLOYEES.LAST, EMPLOYEES.FIRST , EMPLOYEES.MIDDL E, EMPLOYEES.[Adj LIFE SALARY],[Adj LIFESALARY]*0.00003 AS ADDRATE,[Adj LIFE SALARY]*0.000162 AS LIFERATE,
DateDiff("y",[DOB], CDate("10/31/" & [YR])) AS Age,
iif([Age]>100,"Older Than Dirt",iif([Age]...Leave a comment:
-
Is your organization using Outlook and Exchange as your email. Setup each location as tho it were an Outlook user and schedule meetings against those users as well as attendees. This will show users (rooms) availability and will be reflected immediately throughout the organization. I have worked for several Fortune 500 clients and that is the way it is done for most of them.
This works for meeting rooms, classrooms, and other organizational...Leave a comment:
-
There could be 2 events that occur here. An update and an add.
First step is an update query which will update tblPers so that any data changes in tblPersAdd will be reflected in tblPers. Make an update query and link the name fields. Include all the fields or only the ones the end user can update.
If the name field is set to be unique (no duplicates) then the 2nd step is to append tblPersAdd to tblPers. This will...Leave a comment:
-
In your case I sometimes drop the report and page header/footer and use group header/footer. I even create a "dummy" column to group on in some cases to allow for a bit of creativity in the report layout.
With that being said heres some VBA. I have a table which lists all my reports by their Access name, Descriptive name, description - lstReports. I have a "Parameter" table - data in lstParam.
...Leave a comment:
-
I agree with Missingling's assessment. What I normally do is build my logic into the afterupdate property of each required control. The form appears normal (standard colors) until the end user leaves a control null, incorrect data, or incorrrect format. It's at that moment I change the label color and/or control backcolor along with a message box telling them what they are doing wrong. If the enduser isn't screwing it up, no need to display a...Leave a comment:
-
1. Is your company on a network?
2. Do the contract companies have access to your network?
a. If so are you already sharing data and/or files with the contractor?
b. If not does your company have the ability to give the contract companies VPN access to the network.
3. Have you considered data and network security issues?
This should probably be an EDI project. The contract companies would send you...Leave a comment:
-
Easiest way if you're not familiar with VBA
Change the report datasource so that the parameter is table driven, link to the paramater table, create a group for the parameter and have the report do a page break on the parameter group.
The parameter table could have a yes/no field that you could use to toggle the parameter on and off....Leave a comment:
-
Normally values are only available to a single form for use within that form for its functions and not available outside of that form. We need to make the value (In your case a string from FormA) a public value for use thru-out the app.
If you have a Module in your database add a public variable. If no module then add one.
Public vlbl as variant
On the AfterUpdate Property of txtAttirubte1 on FormA....Leave a comment:
-
Look at the rowsource for the combobox. If it is a query that is used elsewhere then make a new query as the rowsource. The prompt is most likely in the criteria of the table or query you are using as a rowsource.Leave a comment:
-
Within the criteria of your reports datasource you need to use BETWEEN.
If the report is based on a query the sql would look something like this:
...Code:Select qryHistoryRpt.* WHERE qryHistoryRpt.MyDate BETWEEN #1/1/2006# AND #12/31/2006#
Leave a comment:
-
Your problem can have various causes - here are a few.
Make sure your combobox is bound to the correct field and that field is not an autonumber or not locked.
Make sure the data source for the form is editable - if you use grouping in a query and then use the query as the data source then you can't edit the data.
Make sure the form is open for data entry and not read-only....Leave a comment:
-
If you have 2 identical datasets the easiest way to get both into a single list is use a Union query. The datasource for your combo could be something like this:
Each of the queries could have its own criteria but each must return the same number of columns with the same datatypes....Code:Select qryEmployeeTrades.* Union Select qryContractorTrades.*
Leave a comment:
-
I use Scott's method but try to avoid writing any VBA if possible.
This will change your text to "Quater 1" but no iif's or case's required. It will also group and sum the data to the Quarter le...Code:Select "Quarter " & DatePart("q", tblMyData.MyDate) as Qtr, Sum (tblMyData.MyValue) as TotVal From tblMyData Group By DatePart("q", tblMyData.MyDate)Leave a comment:
-
Make sure on the 3rd one and on you specify those as "Expression s" vice "Group", "Sum", Etc. You can also put a formula
Sum(tblOrders.O rders)/Count(tblOrders .Orders) in the column....Leave a comment:
-
You will need a user table and a user group table. Each user will belong to a group you will establish for your app.
tblUser
UserID, Login, Name, GroupID, Password (Set format of password field to "Password" so it is displayed as "******"). Login will be their user login (IE rrabbit)
tblUserGroup
GroupID, Group
A module with a Public variable - Public iGrp as Integer....Leave a comment:
-
Minimize the number of table joins in a single query. Several small queries building up to eventual data you want is often faster than one massive query. If the data is analysis data (read only) then you may want to create some temp tables which groups and stores the results of your queries. This make s for a better end user experience as they get their results faster.
I truncate and load data analysis tables every day. Minimal...Leave a comment:
-
You can't edit the same record at the same time from 2 instances of the same form. Access will lock the record.
It looks like you should have Columns for:
Room, Line, Time, Reading1, Reading2,...Rea dingX
You might want a multi-tab form with a tab for each room. Once you design your data entry form save it 9 times (once per room) and set the room defaults. The data can exist in a single table but the data being...Leave a comment:
No activity results to display
Leave a comment: