Hello, this is my first post. I am very much a novice and have come across a problem that I'm sure is simple to solve but so far the solution has eluded me.
All I want to do is subtract a field in one record from the same field in the next record in a query or report but I have no idea how to do it.
Can anyone help please ?
Thanks in advance.
Hey Readers,
I'm using MS OFFICE 2003...MS ACCESS
I am having a problem in my one form where I have to click on the "go to next record arrow" twice before it displays the next record. (even on the "create new record" it requires 2 clicks)
All other forms I have display the next record for only a single click on the arrow.
Is there something unique in the properties of the form in question that needs to be changed so that a single click displays the next record?
Any help would be greatly appreciated.
Thanks,
Duncan
Hello Helpers..
I have a table imported from excel with a large data with columns like..
Level3-
Category
April-03
May-03
June-03
till.......mar-04..
Level3 category April-03 May-03 June-03
Trading Income 10000 13300 15500
Trading expenditure 5000 3000 4000
Investment Income Income 25000 28000 23000
I want to design a form where i select the Level,category and period to display the respective values of income or expenditure..
no:2
How can i calculate the year to date totals based on the table above.....
Thanks a ton.... :confused
Hi,
I have a report that requires the user's input for a field called UserID.
I also have a form in which I want to have a button that can be used to print off this report (which would involve automatically entering the UserID into it). How do I do this?
Here is the code for the form button that I am using at the moment, but when you click it, Access still needs the UserID (duh!). So, how can I automate the input?
Code:Private Sub Command25_Click()On Error GoTo Err_Command25_Click Dim stDocName As String stDocName = "Menu" DoCmd.OpenReport stDocName, acNormalExit_Command25_Click: Exit SubErr_Command25_Click: MsgBox Err.Description Resume Exit_Command25_Click End Sub
I have a table in my database which I want to update on a daily basis from an Excel workbook. Normally I would just use the TransferSpreadsheet command but in this case the format of the source sheet makes things a bit more complicated (It's not my workbook so I have no control over its layout, unfortunately)
My formatting issues are as follows :
-the header row is not on row 1, but row 3 (the first two rows are free format comments)
-there is a gap row between the header and the data region
-the source sheet is laid out with dates as the headers (left to right) and my field headers running down (top to bottom) - so would need some form of transposition
-Basically, looking for some direction on how I should approach this while maximising efficiency. One approach would be to have my own local Excel sheet with VBA code added, to open the source sheet, copy / edit / transpose as necessary and then import my local version and append to the existing table. But this adds an extra step to the process which I'd like to avoid if at all possible.
I would prefer to 'customise' the import within Access itself, to account for the above obstacles, so that I could just point to the source document directly but import according to my own 'non-standard' rules.
I have a form that requires at least a transaction code (from a combo box) and a total value field (numeric) to be entered.I have used the following code but when I click OK on the message box the form is closed.I want it to remain open so the user can enter the fields and properly save the record. As the code is in the Before Update event it does the same thing if I have Cancel = true.
Private Sub Form_BeforeUpdate(Cancel As Integer)
' Check to make sure the TransCode has been selected and the total field doesn't = zero
'If Me.cboName.ListIndex = -1 Then
' MsgBox "A value is required for ...."
' Me.cboName.SetFocus
' Cancel = True
[code]....
I have a form that has several sub forms and what I want is that if the user chooses Plan Name in the main form "No Fault" or 'Workers Comp". I want message to pop and go to the field in the subform to enter data but I keep on getting an error.
Private Sub Plan_Name_AfterUpdate()
If ([Plan Name] = "No Fault") Then
MsgBox "Enter additional information in No Fault form before continuing."
DoCmd.GoToControl ([NoFaultWCompsubForm]![Attorney Name])
End If
End Sub
It says the action or method requires a control name argument?
What am I missing?
I have created database but I now have 3 questions. I havce changed a subform to view as a pivot chart but I am unable to split and group in a similiar waay as in excel, is this just something I have to accept because otherwise my "lets have a works database" theory is shot.
2nd I would like to create a switchboard how do I do this.
and lastly some of the data I would like to utilise for mail merge document ( name and address stuff) are these easy to set up??
thanks very much
Andy
I am completely new to Microsoft Access but otherwise consider myself to be a Tech Geek. I have made a very simple and small database. It contains the name of my customers and the orders they have placed with my company over the past three years.
Now i want to generate report which when given the name of my customer would give me all the orders placed by that specific customer. I know how it can be done query but i want to do it through some kind of access page so that my subordinate who is very technically challenged can manage that.
Though i know it is a very basic question but i tried everything and could not do it....can somebody please please please help me.!!!!
Hi. I have a problem. I want to make a search form that will collect info from several tables and show the results in a list box, like a list(for example with the same name but with different other attributes ). I know it is possible and it is not hard but i'm novice to access. Thanks in advance :)
View 1 Replies View RelatedI'm trying to set up a database from scratch and have never used Access before. It's being set up to hold information gathered from a survey of roughly 2000 people on their fave Manchester songs and artists.
It's going to include their name, email, city and 1,2,3,4,5 choices of fave songs. The aim is to have everything in a simple datebase where I can work out who has voted for what in each section, how many votes a song got a position 1 and so on. But I also want to be able to work out the total number of votes over the five catagories.
Is there a way of doing this? I can bring up information by using query but can I be specific as to what information the query brings up?
This is probably a stupid question but any help would be very useful. I'm using the Idiots Guide to Access and as I said this is the first time I've ever used the program only installed it yesterday!!
Ta
Nick
www.PrideOfManchester.com
HI all,
I am a beginner at access, please help me.
I need to create a customer id filed that has letter and number together, i.e. ZH72773. And the id must change incrementally, but no number 00000. Also it should change the letters after the number reaches 9999, i.e. ZH9999 --> ZI0001.
Would anyone tell me how to do this, please.....thanks in advance
Songrit
Hi everyone, heres a question I hope is easy to answer:
I have two tables, one containing about 1500 entires another with about 43,000.
I want to find out which entries in table1 are also in table2.
I really appriciate the help, thanks so much!!
I am quite new to access and am not sure if what i am trying to achieve is quite simple or needs some VBA Code written.
I have a large table (about 10,000 records) with a varitey of different fields, including "Member ID", "Banker Name", "Location" etc. I would like to develop a form where I can filter on a field such as "Banker Name" or "Location" (using a list box) and below (maybe in a subform??) for all of the records to appear that fall under that banker or location in a datasheet view.
Any help would be greatly appreciated.
Sam
I'm brand new at Access and would appreciate your help.
I have an existing database (table) and would like to make a duplicate table so that I can modify the new one without messing up the old one. How do I duplicate the table either w/ or without the data?
I've created a name tag. I'd like to create another name tag that's the same format except for a different group of people pulled from the database. How can I do this without having to re-create the name tag all over again?
Thanks for your ideas!
The database has three tables:
Equipment: 3 columns - ID, Nomenclature, Location
Procedure: 3 columns - ID, ProcedureNumber, ProcedureName
PMHistory: 4 columns - ID, Nomenclature, ProcedureNumber, CompletionDate
The PMHistory-Nomenclature is linked to Equipment-Nomenclature so that when an entry is made into PMHistory-Nomenclature there is a drop-down window showing all the equipment available. PMHistory-ProcedureNumber is similarly linked to Procedure-ProcedureNumber.
Assume four entries into the PMHistory table:
Equipment1, Procedure1, 3-September-2006
Equipment1, Procedure1, 19-September-2006
Equipment2, Procedure1, 4-September-2006
Equipment2, Procedure1, 20-September-2006
Equipment3, Procedure2, 5-September-2006
Equipment3, Procedure2, 21-September-2006
How to write a query so the result will only contain the latest date for each Equipment/Procedure pair.
The desired result is:
Equipment1, Procedure1, 19-September-2006
Equipment2, Procedure1, 20-September-2006
Equipment3, Procedure2, 21-September-2006
Regards,
Hardin
Hi,
I work in the quality control business and recently purchased a system which on first inspection seemed like the way forward, however I have since discovered that imputting the data is very slow.
I wondered if Access could be programmed to create a better database.
When a sample is tested, I would like the numberical values to change colour depending on whether it is inside or outside the specifications. (Is this possible?)
The main problem I can see is that samples of different substances will be analysed and each substance has different specifications. (Is it possible to set this up?)
I hope this question makes sense to you all
Any advice would be greatly appreciated
Thanks
Jimmy
In the interest of speed in my current project, I'm working with bound forms, where in the past I have developed mainly using unbound forms. Hence, the word novice in my subject line.
Is there a way to do the following, and is it typically done?
The layout: A typical, record by record data entry main form, with a linked datasheet subform. The underlying query contains person's names and other associated data. The subform is a datasheet with an alphabetical listing of the person's names.
My goals (2 of them):
1. To have the datasheet subform go to the record selected on the main form.
2. To have the main form also go to the record selected in the subform.
The forms' On Current events conflicting with one another, as the subform's Current event fires whenever the main form's does.
could anyone advise how to get a date written to a field when a check box is changed to "yes"? i'm useless at VB!
thanks.
Hi everyone,
Basicly I am doing an Access Project for my school coursework, but I am really confused and my teacher isn't that great.
My coursework is based on a video rental company.
The database (in breif) has to be able to bring up a customers details, and add a loan to/under that customers details. (as you would expect from a video shop).
Now, to be honest, I dont know if I have the correct items in each table, but was wondering if someone would be so kind to have a quick look to tell me what to change and where to put the relationships for the database to work correctly.
I have taken a screen shot of my current database:
http://img259.imageshack.us/img259/8216/accessproblem4de.th.jpg (http://img259.imageshack.us/my.php?image=accessproblem4de.jpg)
If you would like any other information, please let me know.
I am really grateful for this!
PS65
Hello all,
I wouldn't call myself a beginner at Access but I am nowhere near a skilled programmer. I have a database I have to finish in the next several days and have some challenges that I have searched and searched the forums for answers to and can't seem to find the answer. Maybe I am not searching the correct terminology but I just can't find the answer(s).
#1 - I have a subform in which we enter quotes. Our quotes are for repairs to train cars and like automotives, they are done part by part (line by line). Each job per car can start out with say 5 lines and be modified several times (estimate and supplement) and wind up with as many is 80+ lines per job. To handle this, I have created main form with the job data and a subform containing the ob detail with a checkbox on each line so that we can select only the lines that need to be printed per quote and/or modification as they have to be submitted to the customer independently. This works great HOWEVER, since there are sooooo many lines and the check boxes have to be checked and unchecked for various reasons what I need is a check box or control that will check all or clear all of the checked boxes. Can anyone help accomplish this? I can't figure it out.
#2 - Based on that same form and checkboxes we another form/subform that has 2 columns, 1 for estimate approval and 1 for supplement approvals. These are set-up to feed into our customers required billing format. I have a pop-up form that pops up the lines as they are approved by the customer based on those same check boxes and what is being approved. This is working great as well, HOWEVER, again, these can be as many as 60 or so lines long and the approval number has to be entered into the appropriate box over and over and over. Is there a way to add a text box that has estimate approval and another that has supplement approval and auto populates the appropriate box (estimate or supplement) based on the value typed in the box? I have this working and it populates the fields but isn't saving them in the table.
#3 - I can't figure out how to set form size. For example....I have a form that opens to full size and I want the subforms to open to a smaller size. I have tried setting this but they seem to all still open to a full size form.
Thanks so much for any help you can give!
Dianne
Hello, I am pretty new to Access. I am able to create simple forms that will interact with tables, reports, etc.. I am trying to go a little farther and customize a form that will automatically be displayed when the user opens the file. I have read that you must have 'modal' properties set to yes. I have done this and when I enter then .mdb file, I still see the default menu.
Do I have to write an expression within the properties? And if so, on which command?
Also, I would like to become more familiar with customizing forms. Is anyone familiar with a web based step-by-step tutorial out there that will walk a person through the process? I am not satisfied with the Help menu.
Thanks for the help.
I hope (boy, do I!) that someone can help me with Access 2007 amd SQL.
I'm a graduate student taking a course in databases. I'm NOT techie, but I figured my husband or kids would be able to help me - they can't!
I am absolutely stumped and am hoping someone will be patient enough to chat with me about SQL and Access.
(You CAN query in SQL with Access, right?)
Thanks,
Bev
Hi, I am currently stuck on making a working one to many table relationship, I will post what I have so far, what I am stuck on is forming a proper working relationship.
tblCustomers
CustomerID
Name
Address(street)
City
Region
PostCode
Telephone
Discount %
tblOrders
OrderID
ProductID
Description
Qty
UnitPrice
tblProduct
ProductID
Description
Room
Finish
UnitPrice
Stock Qty
The desired output is a working order form, that when, for example you enter the product ID into the appropriate field automatically brings the rest of the product fileds such as description and unit price. And when the customer ID is put into the appropriate field all of the relative customer info is shown.
I am new to access and I apologise if my post is unclear or incomplete, any input is appreciated.
Thanks in advance.
have a table i am creating for a subform to calculate a price for a line total.
[item] [amount] [weight] [yeild] [linetotal] *[need coverted price from a query]
the converted price is in a query and i would like to load it with its selected item in a table (or form?) so i can multiply for a line total in the subform.
is this easy?
I have managed ti create my first database, and i have an issue date and a renew date, at present i manually have to calculate and enter the renew date, what i am trying to achieve is that if i enter an issue date of say 01/01/06 and say the renew date is 4 years from now can this field be set so that it looks at the issue date and then say asks me a question like how long before renew , say inter 48 months it should then display a date of 01/01/10
View 1 Replies View Related