Content Source Help (probably Easy But Im Just Starting Access)
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 Replies
ADVERTISEMENT
Apr 16, 2007
Can I create contents of one field based on the contents of others?
I have a database of pc systems which we've tested and was wanting to generate a single text line to identify the individual pc
The single filed would contain data from the following fields
Job Number
CPU Type
CPU Speed
RAM
HDD size
eg
So the new field would contain "Job345-P3-1000-256-20"
Can this be done?
View 3 Replies
View Related
Feb 4, 2015
how many elements matching to my primary elements from any records of my query and count match, if some element doesn't match then I need to add it to my primary elements, then at the end (rst.eof) count how many primary elements I have.
E.G
id colours
1 blue;red
2 purple;blue;green
3 red;violet;purple;blue
dim matching_elements as long
dim primary_elements as string
dim TheNumberOfPrimaryElements as long
First of all, if I open recordset primary_elements is empty so I need to assign a value form first record.
primary_elements = rst!colours (so primary_elements = blue;red)
Now I can start comparing my primary_elements with second record:
matching_elements= 1
primary_elements = blue;red;purple;green
comparing my primary_elements with third record:
matching_elements= 3
primary_elements = blue;red;purple;green;violet
It's my last record so I need to count primary_elements
TheNumberOfPrimaryElements = 5
I need "matching_elements" to count other function in my application.
View 7 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
Nov 25, 2013
As I began thinking about the data that I need to include in one of my reports I relized that I need to gather some extra data.Each design change has a lifecycle with 7 basic states from not started through to closed. States 4, 5, and 6 have two posible sub-states that I need to capture and report. It is almost like having options.
My data entry form already records the 7 basic states. What I would like to do is have another field that records the sub-states if the design change is in one of those three states.
Will a ComboBox do this?
Do I need a test routine for the After Update event in the first text box? Something that will check for states 1 - 3 and 7 move on to the next field and if states 4 -6 require users to enter the sub-state.
Would a nested if-then-else routine do the job?
View 1 Replies
View Related
Oct 3, 2006
When I start my Access program I get this error and can't
seam to be able to get rid of it.
Security warning:
unsafe expressions are not blockked. Do you want to block unsafe expressions YES NO
When I select YES MS access cannot change the registry setting that controls whether or not unsafe expressions are block.
any suggestions
KMB
View 1 Replies
View Related
Feb 7, 2014
I have an table with attachment field in which PDF files are attached.I need Access 2013 form to display PDF file content instead of PDF icon .While record changed should display PDF content for each record navigated
View 7 Replies
View Related
Jul 27, 2012
I have a question that i have implemented database with access runtime 2010
I have a navigation form opens up which provides buttons to open different forms & reports .
But I cannot open some of the forms in runtime although title heading apears but other content just goes blank , it has subforms in it . . some forms opens and some reports as well but some form just doesn't.
And on the notification bar it asks for a save as ??? why is that ...
View 5 Replies
View Related
Jul 24, 2014
how to generate a Report through "Form".I should be able to input the date ex: text box1= Start Date and text box2 should be End Date, by Clicking a button ...i.e Generate Report Button, a report should generate should be generated showing data in between the Start Date and End Date.
View 3 Replies
View Related
Nov 6, 2004
ms access
I have a empty table called ...'Table2' with 3 fields 'firstname', 'lastname', 'value'
i have another table called ...'Table1' with 2 fields 'firstname', 'lastname'
i have form with a textbox callled Text0
this is the query that i am having trouble with:
INSERT INTO Table2 SELECT Table1.firstname, Table1.lastname, Forms!Form1!Text0.text FROM Table1;
the query doesnot run, gives an error. The SELECT query works stand alone but not when in above.
P.S someone will ask me if the form was open and had a value and that it was open before the query was run...and the answer is yes
View 2 Replies
View Related
Aug 10, 2005
I have used Excel for many years and used the if formula. I have just started using access and need a little help. I have a table the has 20 fields. I am only concerned with about 8 of these fields for a report. I have a field named completed in this field I put a "x" if the job is complete. I would like to create a report that shows me all active jobs. Everything that does not have an "x" in complete field. Can somebody either direct my to the forums I should be in or possible give me the correct coding. Thanks for your help in advance.
View 8 Replies
View Related
Dec 28, 2006
HI,
I have the next 3 tables,
*************************************************
Table USER: id_user (primary key)
name
Rec: id_user, name
------------------
rec: 1, A
rec: 2, B
rec: 3, C
*************************************************
Table AP : id_ap (primary key)
nr_ap (primary key)
id_user
id_sort
Rec: id_ap, nr_ap, id_user, id_sort
-------------------------------------
rec: 1, 2, 1, 1
rec: 2, 5, 2, 1
rec: 3, 1, 3, 1
rec: 4, 3, 1, 2
rec: 5, 4, 2, 2
rec: 6, 3, 3, 2
NOTE:
SELECT sum(nr_ap) AS Total FROM AP
with id_sort = 1 -> SUM(nr_ap) = 2+5+1 = 8
with id_sort = 2 -> SUM(nr_ap) = 3+4+3 = 10
*************************************************
Table SORT: id_sort (primary key)
value
Rec: id_sort, value
------------------
rec: 1, 80
rec: 2, 200
**********************************************
I need do create a QUERY that for all records in SORT table, it will
show only for user 'A', the rescords as in the result shown below.
NOTE: xxxx = (valueSUM(nr_ap))*nr_ap
RESULT EXPECTED
------------------
id_sort, name, ap, value, xxxx
1 A 2 80 20 (808)*2 = 20
2 A 3 200 60 (20010)*3 = 60
Regards,
Elio
View 3 Replies
View Related
Sep 28, 2004
Hello, this is probably an easy question to most of you but I've only ever designed a couple of simple databases so I've never came accross this problem.
In my database I have several forms viewable using tabs, The main form is tab 1 (client details), tab 2 is marketing information and tab 3 is booking information. Data on tabs 1 and 2 are linked to Client details using the client name. I tested with a sample record and everything was working fine. I have now started inputing all the client details into the client details form (currently entered 200 records) however when I closed the database and re-opened later only one record was showing in the client details form. I though all of the data had been lost but when I looked at the client details table all the data was still there. Why are all of the records not appearing in the form.
I hope you can help and thanks in advance.
Julie
View 1 Replies
View Related
Jan 24, 2008
If you build a DB in Access 2007, can it be operated in earlier versions?
View 3 Replies
View Related
Feb 9, 2006
I have a project in which i have to make a database. Its nothing real complex it has to have 3 tables.
heres my idea
An address book database.... "I know how orignal lol"
anyways here is what i have.... Looking to get my primary keys and forign keys established
tblAddress
AddressID "Pri Key"
First
Last
Address
City
State
Postal Code
tblContact
Email
HomePhone
CellPhone
DateLastTalked
DateUpdated
tblPersonal
Nickname
Birthday
College "Yes or No"
If Yes Where
Hobbies
So I need to get 3 FK keys and 2 more primary keys... This isnt jumping out at me as to what i should use.
View 3 Replies
View Related
Dec 10, 2004
I have a table in Access that has many columns in it. Two columns are in question, one is social security numbers and another is a image file name column that needs image file names in it. The pictures are named with a social security number of the person Ex. 123456789.jpg. I have about 1000 rows of SSN's and need to place the image file names SSN.jpg in the image column. If I copy and paste the SSN column to the image column it is missing the .jpg, is there a way to do this other than manually? And also set it up so in the future the image column is automatically updated when a SSN is typed in.
thanks
View 1 Replies
View Related
Jun 27, 2005
Hey i need some one that knows Access to help with a work Database, and just make sure everything is working and set properly.
This is for a Construction Managment Company.
Email me at *email removed* for more info, and i can send out the DB to be looked at.
Thanks
Kevin Maguire
President
GOT LOCAL MUSIC
View 1 Replies
View Related
May 4, 2005
I am doing a cert. III in business admin that finishes on MOnday 9 May 2005. I have 3 days to do a mammoth business trip assignment, AND pass a test on Access. The school is a little dodgy and didn't make me do that practical assignment - they gave me multiple choice q's and written q's to take home.
PLEASE HELP!!! I need to pass this course - and we never use Access at work.
Q1. What is wrong with this formula?
=Iff([Product]=Home,1,0)
I'm sure there's more wrong with it than the 'Iff' - that's meant to be 'IIf' isn't it? I've only ever used formulas in Excel..
Q2. What result will the 'Is Null' expression return?
Q3. What is the difference between a Combo Box and a List Box?
Q4. Why is the purpose of the Paste Append function?
Q5. Which formula is correct?
a. =[Qty]*[Price]+[Freight]
b. =[(Qty)*(Price)+(Freight)]
c. =([Qty]*[Price])+[Freight]
d. =[(Qty)*(Price)]+(Freight)
???
Q6. A chart can be placed on:
a. Table view only
b. A form or Report view
c. A Query or Table view only
d. A Report view only
Please answer any of these questions you can - the last one I can trial by error later tonight.
Thanks in advance.
View 4 Replies
View Related
Sep 27, 2004
I am trying to find out how to integrate ms access with source safe and also the cost of source safe. The microsoft website does not give me information on the cost or even how to buy source safe. Can any one help me??
Thanks
View 2 Replies
View Related
Apr 8, 2007
hi,
im trying to add a text box for entering a date into the table database for my form but i cannot seem to connect the control source to the text box, the name of the box/script is not appearing in the control source list. I have already made a column in my table for this box on the form but just cannot connect the two properly?
Any quick thoughts on this?
Thanks.
Trevor.
View 2 Replies
View Related
Sep 19, 2005
I have an unbound form with three tabs. On each tab there is a sub form. Each tab is a search form and each sub is a results returned. I have made everything unbound and set the sub form recordsource and its controls control souce on afterupdate of the main form search criteria. Works fine except for after some use the db decides the sub forms are not unbound and sets the record source and control sources.
I'm trying to do a
Me.PollingPlacesResults.Form.RecordSource = ""
Me!PollingPlacesResults!PollID.ControlSource = ""
but this does not seem to work in actualy removeing the record source and control source.
View 14 Replies
View Related
May 12, 2013
We having this Human resource system that the company will be using however, the current payroll application will still be used as normal but the update will not be done on the same application.At the moment the current set up is that there a three database linked together that makes up the payroll application but for now one of this database will not be pupolated with data as it will now come from another source all together via extraction or file interface which is the new HR software.
The only problem I'm facing is some of those fields that i will need to transfer over to suit the current set up of the payroll application is not included on that new software file extract and i dont know where to start or what to do because abviously the file interface should consists of this mandatory field.Without seeing the relationship of what I'm talking about do you think its worth continuing this project as those wanted field are not included?And how can we go without these mandatory field?
View 1 Replies
View Related
Mar 24, 2008
hi,
i have to create one Master Data transformation tool use Microsoft access. The input file and output file of this tool are excel spreadsheet. There are 2 levels of the data transformation, first level is data mapping and validation on the raw data, second level is data update on the field value.
My question can someone show me step by step how to build this tools using access and read from excell.
View 3 Replies
View Related
Jun 10, 2012
I've been working on a large project for my employer for a year now (but software development isn't part of my normal day to day duties). Most of the work (around 70%) has been done in my own time at home. The company were going to buy a system that would be customized by developers at a cost of around $60,000. I've developed a solution that is probably better than what they would have got. At my last appraisal my boss said that it had been discussed that i would be rewarded if i delivered it. My question is:
Is it possible to password protect access to the source code? I'm working with Access 2003 just now. I know I can create a .mde file to prevent access to the source code but that would make further development difficult. e.
View 8 Replies
View Related
Mar 7, 2014
The access file has a lot of rows which do not show on the excel file. The added files in access either have a space before their names, an * before their names, or no name at all. I would attach the new access file but it does not show up on my windows 7 list of files on my computer. It only shows up as a new file on my access program.
View 3 Replies
View Related
Sep 7, 2012
I have a client who needs a Database created in Access for him. he would like to regularly auto-populate this Access DB from an Excel file - like twice a week.In addition, he wants me to create Forms, Queries, reports and Macros for him in the Access, which will have 2 Tables from Excel files and about 3 Tables created in Access.I figured that I could do that if I gave him a link to the Tables he needed from the Excel file(s). But how do I work remotely for him- the path to those files is on his computer. I can load them to mine, but then he can't open the files.How can I create Forms etc. in an Access DB which uses links from source files as its Tables?
View 2 Replies
View Related
