OK, I'm Starting Over - DB Basic Help Needed
Oct 2, 2005
Hi
I posted a thread in the tables section but two things have made me decide to try again.
1) No one answered my Question
2) I Asked my question in a way that was VERY confusing.
So I'm trying again here. I have a DB that will be used for invoicing clients. Some of the data is variable between jobs, clients & vice versa. Some of the data is recurring.
I have several tables that I need to link. They hold information that is labourious to enter over & over in a spreadsheet so I thought a database would be the answer.
One table is called tbl_Consumables
This table has data which varies from time to time but not all data is changed (IE the price of an item may change from month to month. This presents a problem because if I use a table to store the consumables data & the table is linked to an invoice via the ConsumablesID field I can't change any of the consumables data without changing past invoices that should show the old price not the new price.
Basically I can get my head around how the basic design should be set up. I have two main problems.
A) Trying to link a days work to an invoice & be able to change data in the future without affecting past invoices and,
B) I don't know how to set up the relationships & tables so info is linked.
I have a copy of the DB here. The tables are only minimal fields & data at the moment as I don't want to go to all the trouble of setting this up & then having to change everything.
Thanks in advance.
Regards
Mik
View Replies
ADVERTISEMENT
Sep 18, 2006
ok, i have been searching on google and the forums for sending forms/reports as outlook atachments.
all the examples i have seen are more complicated than my one.. i have one form.. and i just want to email those details.. in the form are the fields, one textbox where you put the email address, and one send email form button..
i got it working using a long module, that i didnt understand..and then i was told about the DoCmd.SendObject method which looks a lot easier..
i have one request, in the simple database i have uploaded, will someone show me where to put the code.. the db is VERY simple, and quick (one form with a send email button).. and if anyone can spare a few minutes to get this one working i will be very grateful..
View 3 Replies
View Related
Dec 28, 2005
i just had a good talking to. My boss was expecting to show him alot more than I did. Please help me if you can.
I work for a hard drive company. Harddrives are divided up into categories and sub categories. The highest level is "Family." Next is "Model Number," then the lowest is "Product Number." All of these are included in each of the worksheets and they all have different heading names.
The hard drives are stored in many different warehouses that are potentially in 3 different regions (AMERICAS, ASIA, EUROPE)
I am concerned with three excel worksheets that contain all or some of the fields listed above. The different worksheets represent different states of the hard drive: "InTransit" "Customer Shipments" and "Inter Company Shipments"
The goal is to consolidate all of this information into one worksheet.
The other 3 Worksheets represent the data I am pulling from. Ive written a module in access to import all of the excel files into their own individual tables. I've also written some queries to pull the info i need, im stumped though, I'm feeling like I should wipe the slate and start from scratch.
What is the best way to go about this?
View 10 Replies
View Related
Jul 27, 2005
Hi All.
This may be a bit of a strange one, but was wondering if anyone had any ideas.
I would like to create a db which is a bit like the directions bit of multimap.co.uk
As per the attached jpg, i would like a db so I can input a starting box and end box, and it would tell me the shortest distance, longest distance, route via boxes etc.
e.g
Box A as start and Box F as end. Shortest route is via Box D, longest route via boxes B and C etc.
The db would obviously not for measuring distances between boxes!!!....but thought this may explain it.
Does anyone have any ideas?
Thanks for taking the time to read this.
Frank.
View 5 Replies
View Related
Mar 30, 2008
I am new in this and would appreciate any help.
Here is what i have to do.Have 2 tables ,employees and equipment.
People form table1 are signing for equipment from table2.After certain time they turn that equipment and some1 else is getting it.
Should i make 3rd table with only signin and signout dates or something else?
View 1 Replies
View Related
Jun 15, 2005
I want a criteris in access to get the records having field 2 starting with "num". Num is example. I want to do withdifferent letters.
number
numbiur
numg
numds
the first three letter should be num in this example. i want for different words i.e, i need to enter the paramter message box.
View 2 Replies
View Related
Sep 13, 2007
Now I know this has probably been asked before, but the search function filters out the word "zero" and "0", so I couldn't do much good with that.
What I want to know is; how do I start a field with a 0 in Microsoft Access?
This has been annoying me, as my database requires phone numbers which start with a 0, and it has been removing the 0 from every entry.
Thanks in advance.
Edit: Oh darn, I seem to have posted this in the wrong forum. Sorry for any inconvenience.
View 2 Replies
View Related
Aug 25, 2005
Background:
I have the foloowing tables
tblClient:
ClientID (PK)
ClientName
other client details
tblMachine:
MachineID (pk)
SerialNumber
ClientID (fk to tblClient)
other machine details
tblProduct
ProductID (PK)
ProductName
tblReadout:
year_date
month_date(pk fld1)
day_date(pk fld2)
ProductID(fk to tblProduct)
MachineID(fk to tblMachine)
ReadoutAmount
Question:
I would like to build some kind of a form where the user will be able to enter data for readouts (ProductID, MachineID, readoutAmount, year_date, month_date, day_date), but I would like them to only be able to do that, I mean I do not want them to be able to modify any of the other data in the table or even see it, so only adding a record that is it.
Also I would like them to be able to enter the ProductName instead of ProductID , how do I go around that ?
View 1 Replies
View Related
Mar 8, 2006
I made a form (My_form) with subform (sub_form) and when open main form cursor is in the first (tab = 0) field of the main form, but I want that it is in the first (or desired - for example Name) field of the new record of subform .
How can I do this?
Thanks.
View 1 Replies
View Related
May 18, 2005
Hi,
I want to use an incremental number as a reference for records in a database. No probs, I use an autonumber. But the user wants the reference to start from 275.
Does anybody know how to start an autonumber off from a higher number (eg 275), without first creating and deleting 274 records. Is there an easy way of doing it.
Or should I not be using autonumber for this, but rather some other wizzy method which somebody is prepared to show me.
Thanks,
Adam.
View 3 Replies
View Related
Feb 20, 2007
I have a form to enter RMA data. I need to start my numbering at 4000 without using an autonumber. The ID field is text and cannot be changed. The Customer_Order table is a linked table. A letter is going to be added infront of the ID depending what the user chooses from a combobox. The letter(R,A,C) signifies what type of transaction it is. Here is an example -
R4000
A4001
A4002
Currently there are about 100,000 records in the database but none with an ID between 4000 and 10000. The majority of the records have a letter preceeding the number. Any ideas on how to start numbering at 4000?
View 8 Replies
View Related
Mar 23, 2005
When you start access it usually starts at the beginning of the file. How can I make it start at the last entry?
View 1 Replies
View Related
Jun 14, 2005
I want a criteris in access to get the records having field2 starting with "num".
number
numbiur
numg
numds
the first three letter should be num
View 1 Replies
View Related
Feb 16, 2006
Want to use criteria in a date field to query data a week at a time. Open the query and have it ask for week starting MM/DD.
Date input will normally use the Monday of each week and expect data back for Monday through Sunday
View 1 Replies
View Related
Mar 29, 2007
Ok,
I am making a database which has a set of lessons which have been booked for a particular date.
What I want to do is be able to have a pop-up box ask you for a date for the start of the week. e.g. I want to find lessons from the week starting 02/03/2007 for 1 week (e.g. 2nd - 9th), so I type in the box "02/03/2007" and it comes up with records from that week.
I have tried this in the criteria box:
[Enter date]+7
and
=Date([Enter Date])+7
But nothing works. Also, I decided to add a record with todays date, and then use the criteria =Date(), but that didnt work either!!!!
Help would be greatly apprecated :p
Thanks
Michael
View 3 Replies
View Related
Apr 7, 2007
I have a table with a compound key, and one of the two fields in the compound key has to start at 100 and finish at 999 and I'd like it so that each number didn't have to be typed in individually.
So I thought about using an autonumber that somehow starts at 100 but doesn't go over 999 if thats possible? Or if you have any other ideas on how I could achieve this?
Thanks
View 1 Replies
View Related
Apr 23, 2008
First I will open a form and choose a salesman. Then based on the salesman selected I want to open a recordset and start searching for the last record for the salesman selected. When the record is found some of the information from that record is pulled on the form.
View 9 Replies
View Related
Dec 2, 2005
Hi!
Can anyone help me how to create query selecting only the records starting with the numbers?
Thanks a lot in Advance
View 1 Replies
View Related
May 13, 2006
This is probably elementary, but I'm entirely lost. Here's my issue:As most of you probably know, when first creating a switchboard in a database will automatically create a form based on it.Somehow I managed to delete that form, and have no idea how to make a new one with the same default switchboard format (where command buttons are automatically generated, and there's a default title label with the shadow effect, etc.)I thought I might try to just delete the switchboard and create a new one so that another form would be created, but it won't let me delete the switchboard!If I understand correctly, I have to create a switchboard without any other switchboards already existing for Access to create a related form for me. Any suggestions?
View 6 Replies
View Related
Apr 7, 2007
I have a table with a compound key, and one of the two fields in the compound key has to start at 100 and finish at 999 and I'd like it so that each number didn't have to be typed in individually.
So I thought about using an autonumber that somehow starts at 100 but doesn't go over 999 if thats possible? Or if you have any other ideas on how I could achieve this?
Thanks
View 1 Replies
View Related
Mar 23, 2015
I have a field to record the last 4 digits of a credit card number in regards to tracking payment information.
The field is currently formatted as a Number field. When I try to enter a set of 4 numbers that start with "0" (e.g. 0123), Access removes the 0 from the start automatically (so 0123 becomes 123).
That function makes perfect sense under normal circumstances, but in this case I want to be able to keep the 0 at the beginning because it is part of the 4 digit sequence.
View 5 Replies
View Related
Sep 1, 2014
Why my Recordset start from record # 301 instead of # 1 Here's part of my code:
Set db2 = CurrentDb
Set rst2 = db2.OpenRecordset(strTable2)
If rst2.RecordCount = 0 Then
MsgBox "No records to process."
[Code] ....
Table has 12,000 records and the first record has an ID of 1. So why is it starting from the record 301? What am I doing wrong?
View 3 Replies
View Related
Apr 27, 2006
Hi, in some application I have made using a switchboard after starting up, I saw that when the user holds the shift button, this switchboard does not show up automatically. How can i fix it that the user cannot interfere holding this button?
View 2 Replies
View Related
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
Aug 9, 2005
in access 2003 i am not able to get the wizard to start. as per MS KB site the wizards are diaslabled due to security risk and i have to installed KB patch 829558 still unable to get the wizard to come on. anbody having same problem pleeese help
sekra1959
View 2 Replies
View Related
Aug 8, 2006
Im just starting to use access for a small business. Im fluent in visual basic but i cannot seem to get this to work. so im using the wizard for the "Order Entry" and it works great. However, on the Preview Invoice where you can also print it, i would like it to include the credit card number, payment method, experiation date, ect. which all can be found on the payment form for the order. I have a text box but i cannot seem to get the write content source. what would be the content source so it can access the payment details from the other form and print it along with the invoice.
View 1 Replies
View Related
