Auto-fill In The Gaps - Advise Plz
May 12, 2005
i have a query that provides data like so:
IDNumber - Units - WeekNo
55643 - 180 - 1
55643 - (Null) - 2
55643 - (Null) - 3
55643 - 135 - 4
55643 - (Null) - 5
55643 - 0 - 6
55643 - (Null) - 7
is there a way of adding something to the SQL to make it fill in the Null values to the most previous value of Units? in other words, the top 2 Null's would become 180, the next one down would become 135 and the bottom one would become 0.
since data is not entered weekly, these Null's are inherently there for certain weeks and i am hoping that with the Nulls replaced, i can produce a bar chart from this query for a report. if the Null's remain, i am getting 'gaps' in my chart which look like zero's.
many thanks.
View Replies
ADVERTISEMENT
Jun 8, 2005
I've tried googling this, but I can't find anything helpful. I have five columns in my 'Main' table. In each row, column B, C & D are solely dependant on column A. And column E is completely independant of all of them. I want to be able to select a choice in column A using a drop-down menu (which I know how to do) and have columns B, C, & D automatically fill themselves in (which I don't know how to do). Column E I would just manually enter.
How do I get columns B, C, & D to automatically fill themselves in my 'Main' table. I would select a value from a drop-down menu in column A and want everything else to fill in. The values for A,B,C,& D are all in seperate tables with an ID and linked to their respective fields in the 'Main' table. Appreciate any help.
View 1 Replies
View Related
Aug 14, 2007
Hi
Does anyone know how I can auto fill all the records of a field by just entering it once
Thanks
View 2 Replies
View Related
Jan 17, 2008
I am looking to find the experssion that will allow me to put a date in a query under date completed and have it fill another field for schedule.
I know that in Excel it would be =sum(A1 +90 ) and this will give a date 90 days after the date inputed into field A1 and so on down the column. and it would auto fill the next column for me
View 2 Replies
View Related
Sep 27, 2005
In using a form to input new information, I want to utilize the autofill feature, but I don't know how.
For example. When someone inputs a month, I want the season to be automatically entered in, in the following entry.
Can someone please give me some direction or help me to do this!?
:D Thanks!
View 1 Replies
View Related
Dec 12, 2007
I have an access database with information that is posted to through a form. On the form I have a dropdown box with a list. After choosing an options I want a text box to auto fill from data in a separate table in the same access file. I have been trying different things for about a week, and I have done alot of reading.
View 2 Replies
View Related
Jul 15, 2005
I have a subform and when the controls on it are updated, changed from previous info, then I need a control(called dtmUpdate) to show the current date (=Date()).
How would I go about doing this?
Thank you
View 5 Replies
View Related
Mar 31, 2006
I am trying to auto fill feilds when I select from a combo box. I have tried to use help, but I can't get it right.
View 1 Replies
View Related
Mar 7, 2006
hi. this might be simple for others but i'm new with access. how can i automatically fill a YES/NO field referring to a Text field. which means, if the field is EMPTY, it will automatically say "No or False" in the Yes/No field, or vice versa.
thank you people of great minds and kind heart. more power to you all.
View 6 Replies
View Related
Mar 9, 2006
Hi,
I am trying to write a database that has one table for companies and another for the services they hire.
The objective is to end up with a managable excel sheet that imoprt into an accountancy package. (Using Acess to eliminate several sheets in current procedure and also free up 1.5 days PCM data entry time).
I have set an auto look up that will autofill the required fields into the form ( =MYQUERY.column(1) ). This works fine and does what i need it to. My problem is that it does not write back to the table so I can not run an outputto command.
I do not know of any other way to produce the autofill to try another way. I have looked at the setup and can not find any problems.
Does anyone have any ideas to help me out?
craig@lenihan.me.uk
Thanks
Craig
View 1 Replies
View Related
Mar 28, 2005
Alright, I've tried just about everything else, now I need to tap into the grapevine for some help. I've read every thread about auto pop info, DLookUP and auto fill. I'm so lost and confused. I'm an Access 97 beginner and can't seem to get my form to do the things I need. I'm working with an existing form and trying to get text fields to auto fill with an "After Update" command. I'm not familiar with VB coding and the function isn't working. If someone out there can help me, I'd really appreciate it.
View 12 Replies
View Related
Mar 28, 2005
Alright, I've tried just about everything else, now I need to tap into the grapevine for some help. I've read every thread about auto pop info, DLookUP and auto fill. I'm so lost and confused. I'm an Access 97 beginner and can't seem to get my form to do the things I need. I'm working with an existing form and trying to get text fields to auto fill with an "After Update" command. I'm not familiar with VB coding and the function isn't working. If someone out there can help me, I'd really appreciate it.
View 3 Replies
View Related
Apr 24, 2005
I am a new access user and need some help. I have created an auto fill query to fill in information on a sales order table from my customer table based on CustomerID.
I have also created a sales order form. When I enter the customer ID in the form the rest of the data does not fill in. Actually nothing happens.
How do I link the form to the query so that the form knows where or how to look for the auto fill customer data.
Thanks
Darrell R
View 1 Replies
View Related
Aug 9, 2005
Here is what I have so far. Table 1 has employee info. Table 2 is for the courses that employees take. Table 3 is a listing of available training courses. What I have done is created a form with all the employee info and linked it to table 2 by ss #'s. What I am wondering is if I can create a field, lets say course #, in table 2 and table 3. That way when I input the course number into the subform, then the corresponding info from table 3 is inserted, ie course name and course hours. Any suggestions or help would be great.
View 1 Replies
View Related
Oct 25, 2004
I have a database with a table of all our records. I created a form, and would like to be able to type in the last name in the last field and have it bring up the record. Also, this could be a problem because there are several people with the same last name. How do I do this? Thanks!
View 1 Replies
View Related
May 1, 2006
I am desperate for some help. I have 2 forms.
1. School
2. Venue
I am entering school names into the school field in the school form. I want that information to automatically appear in the school field in the venue form. I know nothing about VB. Can anyone help me?
For a temporary solution I put a refresh button on the school form so after the information is entered into the school field you have to hit refresh and then that adds the data to the school combo box in the venue form.
Martha
View 2 Replies
View Related
Aug 7, 2006
can I have fields in a form auto filled from fields in another table?
View 1 Replies
View Related
Mar 21, 2007
Hello,
First post!
I'm looking for help with auto-fill (more specifically, I believe I need to use the "After Update" function.
What I have is an order form where I will be putting customer orders. I have a form and a subform, and the line items for the actual order go in the subform. Therefore the subform has a combo box for "products" which references the "products" table by fetching "productname" through "productID"
What I need to happen is when I select a specific product in that combo box (which works), I would like the "price" to be auto-filled into the "Price" box I have to the right of "product" and "quantity"
However I can't figure this out for the life of me, and I've searched places and tried different things, but I always end up with it not working. I can do this in Visual Studio with a DDL and a Label and a small function, but Access is way different from what I can tell with my little knowledge.
Any help would be appreciated!!
Thanks!
View 2 Replies
View Related
Mar 23, 2013
How to auto fill value from table3 to table1 and 2 ? for exmple, ShareID and Contract#, move from table3 to table1 and 2.
Table1
ShareID
ShareName
Table2
ShareID
Contract#
Table3
Date
2/2/2013
Contract#
123
ShareID
AAPL
ShareName
Apple
Cost
Quantity
View 3 Replies
View Related
Aug 23, 2006
Hi
In my database i have a field called product code which the user enters the code as T0001, T0002, T0003 and so on for each record.
would it be possible when adding a new record for that field to auto fill the product code as T0004 for example, so the user doesnt have to type the code in all the time.
please help, ty
View 1 Replies
View Related
Mar 6, 2006
Please help
I have 2 tables:-
1 Master Input Table.
1 Job Lookup table - (contains Job Number and Name)
When in-putting job details into the Master Input table i would like to enter the job number only and have the job name appear automatically without running a query, much the same as a 'vLookup' command in excel.
Is this possible?
Can anyone help?
View 3 Replies
View Related
Jan 9, 2008
Its been a long time since I did dB work - stopped back in the days of dBase IV.
Still, using Access 2007 is not that difficult - except right now. I have 2 tables; one with customer contacts, the other with project details. Heres what I want - hopefully someone can help:
Within the project table, select from a lookup into customer contacts a name, which then auto fills in the fields for phone and email in the project table. I want to do this in the table or form, but have the data deposited into the table for sure!
Any help really appreciated.
View 2 Replies
View Related
Feb 15, 2006
Is it possible to connect data so that when one field of a record is entered the rest of the fields associated with that first field of the record automatically fill in?
Example: If I were to enter a new contact record name in the name field I want the corresponding fields of address, city, state, zip, phone....etc. to fill in automatically.
View 4 Replies
View Related
Sep 13, 2006
I set up an Access database to track visiting families. Each person in a family is inserted as a seperate row in my table. The table has the following columns: Visitor # (which is an auto #), Head of household, last name, first name, phone, email, address and etc.
The first person I enter when a family visits is the head of the household. I set up a quiery with a pull down combo box in my form so when I enter a new entry I can select a head of the houshold to assign each person to. Since I put the head of the household in first. I can then select that head of the household (this way I can track each family member seperate but still know they belong to the same family). So if we have a family visit that has a husband, wife and a child. There are three entries each having a head of the household as the same. When I use the query to select the head of the household in the combo box I would like the information that is the same as the original "head of the household" entry (address and phone #) to be automacially filled in from the husband's initial entry.
How can I do this? I read some other post with some VB in them like "Me.TextBox = ComboBox1.Column(3)" but I don't understand the syntax too well since I'm new at this.
Any help would be appreciated.
Thanks
View 3 Replies
View Related
Jun 11, 2014
I have a situation where, in a query, I need to autofill the column called "Xferd Vendor No" from the column called "Vendor No", where if the data in the Vendor No column changes, then the autofill changes to match.The one called Autofill Raw Data.xlsx shows the expected query results. The one called autofill Final Output.xlsx shows the final results I need when the task is completed.
View 2 Replies
View Related
Jun 21, 2013
I have a form for my customers where i also fill in the email adresses, know i don't wan't to fill in the hole email adres each time. I have seen a acces database before that gives a list when you typed the @ sign in the email adres field.I know that the builder used a tbldomain for listing al the domains that the putin the database. and each time you tab to the field emailsadres you begin to type
example.. markrutten@ and when you type the @ there popup a list of the table [tbldomain] en you begin to type for example Hotmail.com but you can hit the entrebutton afther the letters hot because the match of Hotmail.com is already in the field.
View 6 Replies
View Related