Good rsponse Missingl
Failing that why not put an an example of where you are up to on here in ZIP and Im sure one or two will make a little exple of the way out for you yo be anle to move on
G
garethfx
Last Activity: Aug 7 '07, 08:23 PM
Joined: Apr 7 '07
Location: Wales
-
Crosstab it
Looks from yoyur description the way forward
GarethLeave a comment:
-
many thanks Ill get on it as soon as I get back to my office
GarethLeave a comment:
-
Document Control System through Ms access
I've been handed a little task of developing a document control system in ms access. Its require that the "documents" will be in ms word and also pdf formats.
Never having done this before has anyone had to make something similar?
Any guidlines to follow to start the process?
I,m trying to map out what is wanted but like many enduser requirements its a case of well, your doing it.....
I have... -
If on a form try
simply
=Sum(LegalReq+A irImpact+WaterG round+Land+Reso urces+HealthSaf ety+
Community)
in a text box
if a report same option reallyLeave a comment:
-
Go back to the underlying table and look at the input maskd - ensure its set to
99/99/0000;0;_ or 99/99/00;0;_ if you just want the last 2 digits of the year.
Then
go to any input forms and check that the input mask is the same there
that way you'll standardise the user input right through and ensure that anyone keying in maintains the same practice
GarethLeave a comment:
-
We all started somewhere !
If I'm getting this right (and I hope I am) you need to have the text box formatted as a NUMBER
Then you want to be able to type in .123 rather than 0.123?
If this is the case I don't think Access will allow it as it has to have a preceed the point with something to have a the correct format.
even if you format the record in the table properties to DECIMAL...Leave a comment:
-
If you are searching for different criterias then why not either
1. create a table with the params on
or
2. type the params into a search form that the query looks at
either can work and you can set a number of differing criterias as the business grows
GarethLeave a comment:
-
............... ..............
OK Assuming that you know how to build a query through the wizard is best fro pople new to Access.
Having created the query in CRITERIA beneath the Pdate place:
Between [fromdate] And [end_date]
save the query
create a REPORT from the query then when you run the report you'll be asked for the from - to dates you want to interigate. Put in the...Leave a comment:
-
Hi JJ
To make a simple process why not create a query for the data to be outputted, Create a form or report based on the query (or both)
Then set the criteria to look at the form and textbox you have specified. In the textbox properties set the ON CLICK to look at a simple macro to run the query thus opening the the desired form or report.
I know the more experienced in the forum will prefer to use code but if...Leave a comment:
-
Hi Lark
Just a question and a point to make here
Q: why are you looking for a print-preview/print of a FORM? Would it not be better to use a report
Point. Depaending on the forms configuration you can print it BUT it could print EVERY RECORD not just the one on screen at that time - scary when you have hundreds of records.
May I suggest looking at the report option first to save killing...Leave a comment:
-
yahoo dBforums very own Missingling!!
I agree with MIss here. best way is to set up a table with dates that courses will not be allowed. The after update event than can look up the course ID and determine if its allowed to accept the input or not. That way you can add a range fo courses, an array of days (like holidays etc ) that you need to restrict
GarethLeave a comment:
-
Im hoping that Im on the right track to help here as I.m assuming some points
first teh assumptions
You have a flat file database and not a relational
The system you require needs a relational.
The vehicle requires a specific identifier - registration vehicle number (UK) Tag number USA. both these are best used in theri own situation.
The one table carries the vehicle...Leave a comment:
-
I understand the query - no problem
Why not output to a report where you can group on date. Makes the job so simple
and ease to do in second
garethLeave a comment:
-
Nothing - it works in a query if you have places a name before the te statement
IE. Conference_Type :=IIf([Conftype]=41,"Morning Reports",IIf([ConfType]=4,"Noon Conference",IIf ([ConfType]=9,"Grand Rounds")))
If you have just
=IIf([Conftype]=41,"Morning Reports",IIf([ConfType]=4,"Noon Conference",IIf ([ConfType]=9,"Grand Rounds")))
Then...Leave a comment:
-
OK
what criteria are you using to filter out the 4 milliaon records you want in this table as it seems tat what you are putting in for thi is the cause of your problemLeave a comment:
-
Hi Whilst I'm NOT an expert like many of the others I have worked a lot with inventory. Moving the SKU to differing tables is really not require at all and can make more work for yourself.
Locations of stock are best location coded . IE, 01 = Ordered, 02 In storage, this code works with a slot location of where exactly in the ware house the product is, 03 could be dispatch, 04 damaged awating collection, 05 damaged await disposal(waste) ,...Leave a comment:
-
Can you try and go through what you initially have there at the moment, I,m a little confused as to whether you have a table already with 4 million records in and need to "make Table" so that you could then append to ?
GarethLeave a comment:
-
Something the darkest valuts of my mind tells me that I had this issue sometime agao. I had it when tabbing through the fields. When leaving a blank the jet still saw a code in the empty textbox.
I have since used a standard impossible date to be remove the Null situation and also to remove any issues like the one described. The date used as default is 31/12/9999. This allows for <> etc
may be wise to look...Leave a comment:
-
why not use the auto number? simple straight forward and already there you could even set the number to random if you want to have unpredicted numbers
gareth...Leave a comment:
No activity results to display
Leave a comment: