|
More site info...
|
|
Forum profile page for General on http://www.access-programmers.co.uk.
This report page is the aggregated overview from a single forum: General, located on the Message Board at http://www.access-programmers.co.uk.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "General" on the Message Board at http://www.access-programmers.co.uk is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on General:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
210
|
564
|
1,549
|
|
Post:
|
808
|
2,271
|
6,134
|
|
|
General Posting activity graph:
|
Top authors during last week:
user's latest post:
Multiuser problem
Published (2009-11-25 13:09:00)
Quote: Originally Posted by eric1066 How do I make it a trusted source, See here Quote: or better yet how do I turn this thing off? Sorry, that isn't an option.
user's latest post:
Entity Relationship Diagram
Published (2009-11-26 08:28:00)
IMHO, it is better to put in sample data into the tables. This will help you see if you have your data properly normalized. For someone that knows nothing abut your project (your fellow AWF memebers), it is hard to tell by just seeing field names if the fields are properly normalizing the data into the tables. At first glance, I saw that you have multiple tables with people in it. People are People. They should all be in the same table! TIP:...
user's latest post:
Re: Front End VERY slow
Published (2009-11-24 02:24:00)
Quote: Originally Posted by RuralGuy Good luck with the project. Thank you .
user's latest post:
Find (isNull) field from IF...
Published (2009-11-21 06:44:00)
Right now I have : =iff(IsNull([qrymodulesremaining].[modules_remaining]),DLookUp("qty_modules","tbl_invt","regen_number =[combo13]"),DLookUp("modules_remaining","qrymodulesremainin g")) saying: if the field "modules_remaining" in query "qrymodulesremainig" is null, then lookup "qty of modules" from...
user's latest post:
Help me understand primary and...
Published (2009-11-26 13:26:00)
Quote: Originally Posted by Mljohn What is the difference between using the "company" field as the primary key and a "Company ID" field with the auto number type data? the difference is basic normalization and devlopment standards. i am willing to be that everybody who develops in access uses the autonumber as a primary key in most tables. I know I do, simply so I don't have to track whether or not...
user's latest post:
Running Access without Access...
Published (2009-11-25 03:13:00)
its not quite about the runtime a set of access tables can be read by numerous applications - such as Access, VB, C, Delphi etc. SO if you decide to use a programming language, then you have to write code for any functionality you want that is not provided by the language itself. This may be fine - it depends on what you want to do. Now, if you use Access directly, then you get many useful tools that probably mean you dont need to write code...
user's latest post:
User Level Security Management
Published (2009-11-26 01:51:00)
Quote: Originally Posted by crschrock What happens if the user forgets their password? If I don't set it initially and keep track when they change it, I have no way of accessing their password, do I? Assuming it's stored in a table, and you as developer have access to that table, then yes, you could see everyone's passwords (even if they are masked in the table design - because that's only a cosmetic measure). If you...
|
|
|
|
Latest active threads on General::
Started 17 hours, 31 minutes ago (2009-11-27 13:26:00)
by Banana
I'm sorry but that question didn't make sense and I'm not sure what exactly you are looking for.
But to provide an anecdotal point- it's common claimed in programming world that 90% of program's lifetime is contained in 10% of code. Does that then makes the 90% of the code useless? Certainly not. Just having a feature that may be accessed by a program only 1% of time may be considered a big ...
Started 3 days, 15 hours ago (2009-11-24 15:04:00)
by speakers_86
What? A plug-in for what program?
Started 3 days ago (2009-11-25 06:39:00)
by mcclunyboy Registered User
Right guys.
I have created a workflow database - its not complicated, at least I created most of it so it can't.
I have a form which displays details of what needs attention by admin. Once the admin has done the work they email the originator back with a report which includes all the records needing their attention. This query requires a parameter of the originators username. It ...
Started 2 days, 15 hours ago (2009-11-25 15:25:00)
by ajetrumpet
take a look here:
http://www.access-programmers.co.uk/...highlight=d ays
that code is fairly complex, but if you know VBA, you can modify if to suit your needs.
the other thing you should know is that your 3rd field in this table should not be there, as it is not considered SOURCE data. it is CALCULATED data. anything that is calculated from source data, like these working days belong...
Started 1 day, 18 hours ago (2009-11-26 12:42:00)
by georgedwilkinson
Numbers are faster to index than text fields. It is assumed that a number key that has absolutely no meaning to the user will never change. If you change a text key, you have to go to all the places that text key exists to fix your data. This is a significant problem in the IT world.
It is almost always best to use a surrogate key (i.e. NOT the text key that has meaning to users) as your ...
Started 1 day, 8 hours ago (2009-11-26 22:33:00)
by Galaxiom
I would strongly advise you to rework your database input to use two separate fields.Then you would have a very simple query.
Is the job number a fixed length?
Left([fieldname], 4) will get the four characters on the left of the field.
Started 1 day, 23 hours ago (2009-11-26 06:58:00)
by mcclunyboy
Hi, things nto note.
We just upgraded all our PC's from Office 97 to 2007.
Most databases worked fine however the 2 biggest problems I had were
- new filename - accdb instead of mdb
- complicated VB often had errors (generally deleted the function or renamed)
Does your company have an IT policy? Will they upgrade their PC's soon ?!
Started 3 days, 19 hours ago (2009-11-24 11:01:00)
by HiTechCoach
I would use a form to collect the password.
Set the text box's input mask to: password
This will make it display an * for each typed letter.
I will see if I can find you an example.
Started 1 day, 2 hours ago (2009-11-27 04:25:00)
by MStef
You can't enter a record in the table on side many, if there is no record on side 1.
Look at Relationships.
Started 1 day, 1 hour ago (2009-11-27 05:07:00)
by namliam
Make the column your primary key or put a unique index on it...
|
|
Hot threads for last week on General::
Started 6 days, 17 hours ago (2009-11-21 13:23:00)
by speakers_86
Quote:
Originally Posted by christakis
It is so bad I am thinking of having two back ends (one at each site) and synchronizing them. Do you have any other suggestions?
I believe that is what the more experienced users will recommend.
Started 1 week, 1 day ago (2009-11-19 08:45:00)
by boblarson
Quote:
Originally Posted by christakis
Hi guys,
With your help I have reached the final stages of my database design. The database is now aprox 6MB. Around 15 users will be using it (rarely at the same time) The database is in one mdb file and stored on a shared drive. Do you think its worth splitting it into a front/back end or ...
Started 2 weeks, 3 days ago (2009-11-10 08:20:00)
by hardhitter06
I have a linked table to a Notepad document in Access 2003.
I need to add an additional field (an autonumber) and change the format of a time field, but I cannot since the table is linked.
Is there a way for me to make these changes while the table is linked or is it possible to unlink the table, make the changes, and then relink it back to this notepad document?
Any insight would ...
Started 3 days, 19 hours ago (2009-11-24 11:01:00)
by HiTechCoach
I would use a form to collect the password.
Set the text box's input mask to: password
This will make it display an * for each typed letter.
I will see if I can find you an example.
Started 1 week, 3 days ago (2009-11-17 22:44:00)
by Galaxiom
The spreadsheet looks straightforward. You would not import COMPCODE9D as it is derived from the other columns.
When you wish to display the combined code, concatenate the fields.
The control source would be:
= SYS & "-" & ASY & "-" COMP
However with 82 tables in your database it is very unlikely to have been optimally designed.
This impression is supported by the statement that you ...
Started 4 days, 19 hours ago (2009-11-23 11:18:00)
by arichins Registered User
Anothing thing you might want to consider is hiring your own IT guy. If you are a manager (you seem to be), why not take the technical burden off your shoulders? The IT guy would also be able to perform tech support for your staff etc....
Started 3 days ago (2009-11-25 06:39:00)
by mcclunyboy Registered User
Right guys.
I have created a workflow database - its not complicated, at least I created most of it so it can't.
I have a form which displays details of what needs attention by admin. Once the admin has done the work they email the originator back with a report which includes all the records needing their attention. This query requires a parameter of the originators username. It ...
Started 4 days, 2 hours ago (2009-11-24 04:01:00)
by Poppa Smurf
In your query add another column and add the following in the field
checksum: nz([f1]+[f2]+[f3]+[f4]+[f5]+[f6]......[f30]), then in the criteria add >0.
[f1] ... [f30] is the name of your skill fields. If any field is NULL then a 0 is assign to that field to give a total depending on the value of the other fields. Now is ALL fields are null then each field will have a value of 0 assign to it ...
Started 4 days, 23 hours ago (2009-11-23 07:12:00)
by Lightwave
OK read it a bit closer - and it doesn't say anything about access to the front end.
So while it does indicate access to tables and queries says nothing about the front end which I am thinking is 3/4 of a database often!!
So technically yes you have contact to the engine but not to the prettification..???
Feel free to correct me if I'm wrong
Started 1 week, 1 day ago (2009-11-20 06:50:00)
by mafhobb Registered User
I need some insight on how to do this.
I have two independent databases for two different groups of people. One is regarding product development (PD) and the other product support (PS). Both of them have a table with info based on SKU number (for example ABCD1234).
I am trying to find out how to create a button in the PD database, that basically opens a table in the PS database so that ...
|
|
Size: 1,517 bytes
