A Simple Solution Overlooked?

Mar 7, 2007

My database contains documents which are entered randomly (i.e. - not in any particular order). But then, for my reports, I must show these documents in “Document Number” order, once I have gotten them in the order I want (usually by date or other criteria).
In Access 2003, (in query mode) all I had to do was enter the number 1 in the first “document number” field, then number 2 in the second document number field. Then, by pressing and holding the “down arrow” key, this field automatically filled in the document number consecutively from 3 through whatever number of documents I have in my database. Very quick and efficient. I’ve had Access since the very first edition (1996 I think), thus I don’t remember how I was able to get the “Document Number” field to “self-fill” in the query mode, but have been doing this for years.
Now, I cannot get Access 2007 to do this, no matter what I do, thus I am forced to manually enter the number for each document.
Question: How can I get the “Document Number” field to fill-in the series automatically (in query mode) by pressing and holding the ‘down arrow’ key? As I said, the information is entered at random and has to be sorted later by document number, thus I cannot use a Primary Key or AutoNumber for this.

View Replies


ADVERTISEMENT

Simple Solution Needed Please

Jan 1, 2007

Hi the specialists.

I do not want security on any of the files in my computer.

I'm placing this in "general" because I'd like a direct and practical answer, please. And if there is none, please say so. Computers are immensely complicated and I am just a little bit tired of people superciliously refering the uninitiated to "Microsoft's FAQ's" That source is to most normal humans as obscure as the software programming itself.

I have also searched this source and Google for hours, without getting an intelligible answer.

This is my problem:

I am the only user and administrator on my computer.
I have a back-end file which is easily accessed through the front-end.
.... but
I cannot open the back-end to access the tables directly.
I get the following error message:

You do not have the necessary permissions to use the 'C:Documents and SettingsAll UsersDocumentsAccessThingsWORKLOG_be.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

Of course the person who created this back-end is me, but I have no clue what I did, because it is at least two years since I created it.

Could someone please help?
I have tried to use the "shift", click method. It does nothing - just gives me the same message.

Pierre.

View 4 Replies View Related

Simple Date Solution...

Oct 3, 2006

Hi all,

Please forgive a newbie that asking the stupid question.... i just wonder is that anyway to set the date format to short date with instead of mm/dd/yyyy to dd/mm/yyyy to let the user to keyin?

Thanks alot.

View 3 Replies View Related

DMax Vs Autonumber - Simple Solution?

Mar 7, 2005

I'm reading lots of threads about various problems with autonumber, and I encountered a corruption in a very beginning database myself, using the autonumbered field as a sequential file number, my primary key. So, my question is.....how is the very most simple, NOVICE, way to use DMax (step by step on what to write and where to put it) to create a sequential file number, starting from 00001 and ad infinitum until I go out of business :)

I simply want a field called "file number" that will effectively auto-number, without the dangers of autonumbering crashes etc.

Thanks for your suggestions!

View 3 Replies View Related

Long Question, Simple Solution!?

Jan 31, 2005

Hi

I was wondering if anyone can help me.
I am trying to build a database as part of my IT A-Level coursework, but I have little experience with Access. Although I have built the main part of the database, I am now stuck with something which I am sure is quite simple, if only I knew how to do it!!
I have got four tables at the moment, Suppliers, Category's, Products and Orders. From these I have made a form which will be used to put in new orders, and it works so that when it is filled in, the "order" is automatically entered into the Orders table.
My problem is that in this form I have drop down boxes for category name, supplier name and product name, which are looked up and taken from the respective tables. I want to have it so that when I select a category from the category drop down list, it automatically limits my choices in the suppliers list, and offers me only the suppliers which supply products in the category I have chosen. Then the products list should only be the products from the selected supplier.
I apologise if that makes absolutely no sense at all, it is very difficult to explain by writing it down... my teacher can not help me, she appears to know even less about databases than me, and I have had to teach myself the very little I know! I know this must sound very pathetic and trivial, but I just can not make it work! Any help would be greatly appreciated!
I also have another slight problem in that I can get my form to calculate the total cost of the order, by taking the price and the quantity, but then this value does not appear in my orders table.
Thanks for taking the time to read this and helping me if you can!! I am really grateful!

Charlotte xx

View 3 Replies View Related

Bug Tracking Solution

Feb 12, 2008

Hi,I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.It may or may not be commercial software.If anyone knows of such an available solution, please let me know.(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)thx

View 5 Replies View Related

Need Solution For Calculations

Jul 26, 2007

Hi,

I haven't worked with Access for a while, now i'm working on a project and just can't handel with a calculation. I have somewhere the solution for my problem, I had use it other times, but now i just don't know where to find that sample database.

I have 2 tables: tblProjects and tblCosts

tblProjects
ProjectID
ProjectName
ProjectValue
...............

tblCosts
ProjectID
CostName
CostValue
................

What I want is to calculate the Benefit=ProjectValue-CostValue.

I know it is possible, in other cases I have used some union queries, sum calculation and I had my results very simply. But now, as I said before, can't find that piece of SQL. :(

Any solution is appreciated.

Thank you

View 3 Replies View Related

Bug Tracking Solution

Feb 12, 2008

Hi,

I'm looking for a bug/issue tracking solution done entirely in MS Access. Does such a thing exist?

My requirements are that it must need only Access, and be accessible in a shared environment solely by opening a .mdb file from a shared folder. It must support various issue lifecycle related things, and the stuff those tracking systems do in general.

It may or may not be commercial software.

If anyone knows of such an available solution, please let me know.

(And yes, I've searched on Google, and haven't found anything worthwile, so that's why I'm asking here now.)

thx

View 4 Replies View Related

Label Printing Solution

Jun 8, 2005

I need to try and create a simple form that a user enters data into and then hits a print button and the text they entered is printed in a particular way.

i.e. they type in someones name, job and company into 3 fields and then hit a print button and this then prints :

PERSONS NAME
JOB TITLE
COMPANY

We also need the print to be formatted a particular way but that is another issue

This is for a small exhibition we are trying to run and we need something to print visitor badges with

Has anyone got any ideas that can really help as we have been let down by someone who was going to do this for us

View 3 Replies View Related

Dealing With Checkboxes - A Solution.

Mar 14, 2006

This is for anyone who has made a form with a lot of check boxes and wants to make a report out of them thats decent.Hopefully this simple example file is enough to assist people.Keywords:Checkbox Checkboxes report check boxes box

View 1 Replies View Related

Solution - Problems When Deleting A Row

Jul 8, 2005

Link to the original thread (http://www.access-programmers.co.uk/forums/showthread.php?t=89557)

I have realized what I was doing wrong and thought that I would post the solution in case anyone else does the same trying to implement security. First off thanks Pat Hartman for the input. You were right on there needing to be a cutoff and now one is added that ensures they can't edit punches after payroll has started.

I had the right idea with the many to many relationship to get a list of buildings. What I was doing wrong was joining the resulting table to the shifts table. Instead the correct way (well, it works anyways) is include WHERE Building IN (SELECT ....) in the sql where the select statement gets the list of buildings numbers that I have access to.

Now the list is limited to the buildings that they have access to and when you delete only the shift table is affected because none of the other tables are joined.

View 1 Replies View Related

Difficult Problem, Is There A Solution?

Dec 23, 2005

Hi Everybody. I've been nosing around here because I have this difficult problem with a database design. I modelled my program in UML so I have a class diagram. Now I want to create an access database out of it, but this is too hard for me.

It's about a school project for flowers. Every year, they make a cross plan. This cross plan contains crossings. Many crossings. And every crossing exist from 2 genotypes. A mother and a father. With this crossing several new genotypes are created. How on earth do I realize that in a database? A plant is male as well as female so you don't need to indicate which sex it is.

Further more I want a genotype to be judged on his characteristics by a user as much as he wants to.

Well...I hope someone can help and if you have questions about it don't hesitate to ask.

Thanks in advance!

Gr Billy

View 4 Replies View Related

Forgetful Users - A Solution Anyone?

May 12, 2005

Good afternoon all,

I have a A97 Db. On one of my forms (see attached screen pic) I have a field "Payment type" for either Cheque, card of Account. There is no code or functions behind it, it just stores a value.

Trouble is my users keep forgetting to fill it in!

My first (and easiest) solution would be to make "Payment type" a required field. However. The field will only be filled out under certian conditions.
That is if the "Status" field value = "X" (drop down box holding two values "X" and "Y").

What would the code be? I presume it would be in the Form "after update" field? Would read somthing like:

if [Status] = "X"
and
if [PaymentType] = "Null"
then
mssg box "Please enter payment type"

I have a vba book on order to start learning, but as you have probably guessed, I have not received it yet! :)

Any pointers or info would be much appriciated. Many thanks :)

View 1 Replies View Related

Append Query, Or A Better Solution?

Jun 29, 2005

I need a little bit of advice on this one.
I have 2 tables that are used for different things, one table, denial data, is used for tracking all requests. It is updated with the form, Daily PAs. On the form are 2 buttons, each running a macro. One button exports the data to Excel by running a query to specify the date range. The second button is my problem. It also has a macro, with an append query, to append only requests that have been denied to my second table, Denials, to be later updated with additional information. The append isn't working because I am getting three different errors, a "type conversion failure," "key violations", "lock violations" and "validation rule violations." Now, I know I can begin working out these violations and get it working, but I'm sure that involves a lot of time and coding. I would really appreciate any other suggestions to accoplish the same tasks. I need to keep the approved requests seperate from the denied requests for auditing purposes. Thank you for your help.

View 7 Replies View Related

Solution For User Scheduling

Dec 30, 2004

Hello All
I am in need of a lot of help. The situation is as follows I have a table with users that have certain classes that they have to take and in another table I have the dates that these classes are offered. My problem is I want to find a way to map all the students to their required class by scheudling them into the required classes taking into account date conflicts and classes required before taking a certain other classes. I guess my question is if there is any possible to do this in access without me phyically having to schedule each users required classes to the correct time making sure there are no date conflicts. Any help would be highly appreciated because we are talking about 3000 users that need to have schedules and that is extremly time consuming if I have to sit here and do the schedule for each user. Thank you in advance for your time

View 5 Replies View Related

Eval() Dosen't Seem To Be The Solution?

Mar 19, 2006

I want to use a counter increment so that I can loop F1 to F3 I don't want to create 3 (actually I'm trying to avoid creating 50) If/EndIf blocks of code. Can someone help me?

' Initialized memvars
F1 = "PO_Num"
V1 = "0001"
F2 = "Vendor_Num"
V2 = "0002"
F3 = "PO_Num"
V3 = "0001"
TableName = "MyTable"
QueryStr = "UPDATE " & Tablename & " SET "
mCtr = 1

Do While mCtr <= 3
If Not IsNull( Eval("F" & Trim(Str(mCtr)) ) Then
QueryStr = QueryStr & Eval(FValue & " = '" & Eval(VValue) & "';"
End If
mCtr = mCtr + 1
Loop

The way that it works:
Do While mCtr <= 3
If Not IsNull(F1) Then
QueryStr = QueryStr & F1 & " = '" & V1 & "';"
End If
If Not IsNull(F2) Then
QueryStr = QueryStr & F2 & " = '" & V2 & "';"
End If
If Not IsNull(F3) Then
QueryStr = QueryStr & F3 & " = '" & V3 & "';"
End If
mCtr = mCtr + 1
Loop

View 1 Replies View Related

Update Query Solution

Aug 18, 2006

I need help on an update query. Case is an automatic letter generation for particular document which has revisions like 00 or 01. So when this is done, on click, open an update query to update date and letter no in main table against that particular document. I made the query but does not work and says result should be an updatable query. I am posting SQL below.

UPDATE [MDL-10], TRANSMITTALGEN, [Transmittal Record Query] SET [MDL-10].[REV 00 SUBMISSION] = [Transmittal Record Query]![MaxOfTransmittal Date], [MDL-10].[REV 00 SUBMN LETTER] = [Transmittal Record Query]![MaxOfTransmittalNo]
WHERE (((TRANSMITTALGEN.REV)="00") AND (([MDL-10].[Select])=[Forms]![TransmittalGeneration]![Text2]));


Please help

View 1 Replies View Related

Log Table Solution Needed :(

Nov 4, 2006

I have almost finished my current database but I was asked to create a log table/log file that would list changes made to every record. Now my current database don't allow duplicate records, so any advice pointing me into the right direction will be helpful. I have ran through the search area and found nothing that I can use. Can any one help me out in this specific problem. I picked up a few books and none of them give examples of such things. Thanking you all in advance...

View 14 Replies View Related

Protecting The Database - What Kind Of Solution?

Oct 11, 2005

Hi there,

I have built a Access solution for a music school, It was installed on 3 machines.

I'd like to protect my database from installing onto another machine without my permission.

I did install database as a mde file so they cannot see my codes. However, if they copy the database to another machine (esp. another machine in different school) they can use my software without my permission. How can I prevent this? If they copy the mde file into unauthorized machine, database should work as a demo version (such as limiting the number of records in tables to 10). How can I do this? What should I check, hd id, mainboard serial or what? Is there any ready solution (at least modifiable) for that kind of problem?

regards

View 14 Replies View Related

Updating Existing MS Access Solution

Mar 7, 2006

I have searched the forum but have failed to find the answer to my problem. I have a front end ms access 2000 solution that I distribute to user PC's with an MDE back end data base on a server.
I now need to release a new version that includes changes to forms, queries and tables.
However there is data in the original mde data base I need to retain. Is there an easy method to migrate that data to the new data base. I have changed some relationships but this should not affect data integrity - most change is related to adding new fieldsto existing tables or new tables (no previous data).
If I create a new empty mde will I be able to import old data into it from previous mde?:confused:

View 2 Replies View Related

Unable To Find Solution On Query

Apr 29, 2008

I have unique situation not sure how to achieve this in Query.

For understanding I have attached mdb has following tables
'PR_RPT'
'SYS_RPT'
'TIME_RPT'
Final_PR_RPT

'PR_RPT' and 'TIME_RPT' has unique ID called as 'PTUNID', My Final goal is Final_PR_RPT.

I have created a Query1, which Look into 'PR_RPT' and 'TIME_RPT' and does a match on 'PTUNID' and populates all the 'SUM HR' Field Values from 'TIME RPT' table to matching 'PTUNID' in Column 'SUM HRS' similar to Final_PR_RPT,

In Addition to that what I am trying to do is

1- Look for PTUNID from PR_RPT to TIME_RPT if that doesnot match then
2- take Unmatching 'PTUNID', Look for which 'Project LEAD' owns the 'system ID' From 'SYS_RPT' Table then
3- Populate the unmatched 'PTUNID' 'SUM HRs' from 'TIME_RPT' Table against that 'Project LEAD' which Owns that unmatched system and has same ProjectID in PR_RPT in new column as Wrong SUM HR and WRONG SYS ID

Final_PR_RPT, shows how the result should stored.

I tried using IIF Statement but I believe I am not doing it right.


Thanks
Niri

View 4 Replies View Related

A Solution To Manually Processing 'Entry Forms'

Mar 2, 2007

Hi Guys,

I've been pondering over a problem for a couple of weeks now - We receive around 1000 paper entries to our competition, and these all need manually entered into the access database in a one-er.

Is anyone aware of any ideas of how this could be made easier, and more automated?

Thanks.

View 3 Replies View Related

Error Message While Starting Up Packaged Solution

Jan 30, 2008

Hello,

I made an application in access 2007 wich runs perfectly on my computer.
But when I package it and distribute it to a user he gets the following error message on opening:

"A potential security concern has been identified

Warning: It is not possible to determine that this content came from a thrustworthy source. You should leave this content disabled unless the content provides critical functionalitiy and you trust the source.

Filepath C:/program ....../myapplication.accdr

this file might contain unsafe content that could harm your computer. Do you want to open this file or cancel the operation?"

I have set the security level for macros tot enable all.

View 2 Replies View Related

Need Solution To Read Data In Both Capital/small Letter

Nov 13, 2006

Hi,

In one of the column of a table of my SQL Server contains around 500 employee names. Some of them are written in capital letters and some are not. Some of them with first character capital and rest all small.

I am using FE as MS Access. When user search the record thru a normal textbox (behind which I put small bunch of code to get the desired data in sub-form) user must enter searching name in the textbox in the same fashion the actual data available in the table.

e.g. let us say the employee name is John

User who searching John’s record must enter first letter capital otherwise it will not search. Why like this if table in on server.

This doesn’t happen when table is local in access. What is the solution to this?

All the suggestions are welcome.

With kind regards,
Ashfaque

View 3 Replies View Related

Simple Question For A Simple DB

Dec 29, 2006

Ok I am right now making a simple Vendor/Product database to create a line sheet for some sales folks. I have 3 tables: Vendors, Products, and an associate entity Vendors_Products to relate the two. I have a form currently that draws the Vendor Name (primary key) from the Vendor table and the Product Name from the associate entity. This allows me to create new vendors and select current product types from a drop down box. The problem is that the drop down box is too long and it is tiresome when 1 vendor has 10 product types.

Can anyone tell me how to resolve this? I thought it would be better to have option buttons and display all available products. Then you could just click all of the option buttons that apply to that Vendor and it would create the relationships...is this possible?

View 1 Replies View Related

A Simple One For You All

Nov 22, 2005

Hi,
I have looked at some of the threads here and it is clear that many of you are working on a much higher level than me and with a high degree of familiarity with the programme.
I am hoping that someone here is able to give me some advice as I don't find the MS help files digestible.
The task I have is to join 2 databases and produce a table from which I can run a mailmerge.
I have managed to join the 2 databases and I used a customer ID as a common link. (my apologies if the terminology is incorrect)
I now have all the data I require in one table.
THE PROBLEMs I have multiple entries for some of my customers and would like to reduce this to single entries (which is understandable). Please tell me how to do this if you can, and keep it as simple as you can please.

In anticipation I thank you very much.

:-)

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved