I made a bunch of tables by importing them from excel. Then I had someone ask me a question regarding a specific instrument. My tables have a bunch of parts and id's but I don't have the instrument associated with a specific part in the table.
Is it possible to add the data into the new column automatically using a query. I tried the append query, but I'm either doing it wrong or it won't do what I'd like it to do. I just want every record within that table to have the same instrument in an instrumentId column.
i have a form frmCreditNote with a subform sfrmCreditNote. They are linked by a creditNoteNumber. As soon as i pick a customer in the main form, i want the first line of the subform to have that customer name as well. If I change the customer name in the main form, I need the first line of the subform to correspondingly change as well. If the form was new, i would open a recordset and use .AddNew to put in the new first line date If I was updating the form customer name, then I would need a .Edit to change the first line of the subform. My question is : how do I determine if the subform is empty? Is it a command likeIf subform.HasData, orIf IsNull(?)Please let me know thanks
I wish to automatically fill in a form in datasheet view with records from a table. Currently you need to select each record to fill the list. I think this can be done using VBA, I'm a begininner to programming but think I need the code to do something like this.
Lookup the table or query, DoCmd select the first record, DoCmd select next record, Loop to end of recordset??
Basically it is automatically entering/ filling in each row (record) in the datasheet for every record in that table or query.
I have a form with a date of when training was completed. I would like to set it up so it displays the date of expiration which is one year from when the training was complete.
I have a form where all records are listed on one page with a vertical scrollbar (all simple textboxes):
---------------------------------------------- PrimaryKey Name ForeignKey ---------------------------------------------- 1 Pam 20 2 John 20 3 Kim 20 4 Larry 20
... underneath these on the form is a blank record for NEW additions, which obviously has nothing in any of its textboxes, waiting for user to input some data, as normal.
The Foreign Key, due to the nature of my DB, will always be the SAME value for each record in the DB (don't ask, it's part of an export/import-to-main-db app). So I know that the NEW record, if created, will have the same value as the rest of the records.
How do I get it so that when a new record is created, the Foriegn Key textbox is automatically filled in with the value from the row above? (Due to referential integ reasons the Foreign Key field MUST be filled in accuratly or else an error ocurrs.)
Looking at the various events, I realise that it is the BeforeInsert event that will sort this out, but I'm at a loss regarding how to get the NEW record's Foreign Key textbox to match the Foreign Key value above it.
I have a training log that has 4 tables, the employee table, the training course table, and the department table.
These tables all contain the names of employees, training courses, and department in one field and their respective ID codes in the other.
The 4th table is the actual log where the manager logs in who took the training courses. When the manager goes to select the employee name, course name, and department name is there a way not using VBA for the respective ID number to appear in the 4th table (they use the same field names and are related)
I have a table with about 700 records in it that I import. In my code I am using Alter table to add a column called BlID. I want to populate each record with a unique number. Because of other things that are happening I cannot use auto number, so I am using the date (with the date, hours, min, and seconds). My problem is that I cannot think of a ways to loop through this and insert a the date and time in each record.
I have a crosstab query of which I cannot sort a Totals column by descending order. Is there any way to sort a certain column automatically after the query runs and is in Datasheet view?
I'm making a db that will import a spreadsheet from Excel, then separate it into 3 different tables using queries, but then I need to put all the 3 different tables together one after the other. The problem is that the 3rd column on each table have different names on each table, so I can't append the tables together.
So, how can I use a Macro or something to change the column name on all 3 different tables so that they match and can all get appended together.
How do I auto populate a sep column created which is blank at present, with the table name of the table I append/join to table with a query - to uniquely identify all these rows..from each table..?
I need to create a New Form control for this situation:
If I enter a date into a field and the choice for another field is equal to a certain value. How can I get the date I entered to be automatically populated into another date field.
For example:
If I enter 11/10/2005 in a date field and I choose either "BN", "BA", or "BT" in a text field, I need that date of 11/10/2005 to be automatically populated in another date field on the same form.
i would like to sum all the column fields in a tables column where an id is the same as the id in that table. I know you can use the SUM function in the select statement of your query.
But how can i set this sum result into a variable, so i can use it for calculation further on in the program?
In our company, passwords expire every 90 days (NO EXCEPTIONS) for DB2. This means that all my linked tables can't be accessed. There are many other users using the DB's and when I have to reset my password, I get locked out a lot because I can't seem to re-link the tables fast enough. It also seems that "refreshing" the tables from the Linked Table Manager doesn't work very well.
I am try to build a small invoicing interface in access 2007. I have designed a purchase invoice form with a table purchase_detail. When I receive products from supplier, products have a specific batch # on its cover.
I entered products in purchase invoice with these batch #. Now when I sale these items through sale invoice form, I need to get batch # automatically in batch # box from purchase_detail.
I have one database containing several tables, two of which are associated to this inquiry:
1) tblCategories Contains two columns: CatID and Category Name
2) tblPending Contains many columns of data obtained through upload from a web form including a column to capture the CatID and also a column for Category Name. I wish to populate the Category Name column based on the results of data uploaded into CatID column
How is this accomplished? This is inherited project and I have very little experience with Access so just limping along... Specific instruction much appreciated.
Don't know where this question will rank. Completely weird or completely common.
I've been getting great suggestions from this forum, one of them was to begin creating seperate tables for our data (I'm currently cleaning up a mess created 10 years ago for a nonprofit). The best way I have found to link/associate/whatever tables is to use their STUDENT identification number (since this value never changes). So we linked tests to that number (many tests to each student) by entering each new test as a seperate item with a manually entered stu id. We linked TUTOR and so forth the same way. But now I would like to start linking some more things. Particularly INSTRUCTION HOURS.
The question I have is this. How do I automatically create a value in the HOURS table that links to the value (stu id) in the STUDENT table. So that every student (previous and new) will have ONE associated HOURS set each time new student data is entered.
I have a table of nursery school children, names, addresses etc etc. One field is Under 2? Is there a validation rule (or something like) that will automatically put Yes (or No) depending on today's date and the child's date of birth?
I am working with a table where I want to be able to add choose the customer name from a dropdown and have the customer number automatically populate. I set up the dropdown already using the query builder for customer name and it works perfectly. I also chose customer number in the query, but it does not show.
Even better, in case of duplicate names, I would like to be able to select the customer number and have the name populate.
So ultimately, when I select either field, I want the other to auto populate...
I have 5 tables (Client, Driver, Appointment, LessonType & Booking). The Booking table is empty as it is made up from the other 4 tables. I want to have a form (Booking) which collects data from the 4 tables to create a record.
I want this to be automated as much as possible rather than typing the data into a textbox, because this would be difficult for the user and there would be conflict.
The Booking form will be split into 4 sections relevant to the above tables. For example, select ClientID from a combo and the other fields populate, such as forename, surname, address1, address2. And then select DriverID and this populates the relevant fields and so on, until a booking is created.
Ive tried After_update and couldnt get that to work. Any suggestions or help will be much appreciated as this has been a headache for a few weeks now. Thanks
I have another Table2 - which is identical to Table2
I want Table2 to automatically update with the information put on the form (which currently only populates Table1) without asking the user whether they want to do this. And when I say update, if a user adds a new record to the form, I want that new record to be put on Table1 and Table 2.
Tables: Employee Record HR Record Orientation Record Certification Record Optional Certifications
All are related.
I have a form where I do data entry, with all of the fields from these tables on the form. I want to type in the name only once, at the top of the form, and then have it populate the Name field in EACH of the above tables. Can anyone help me with this? I've been working on it for two weeks now. I'm sure it's an easy fix that I haven't thought of.
I've already tried using subforms, but unless I type in the name in each of the subforms for the above tables, I end up with blank name fields in all the tables, except for the one I pointed the data to go to.
I'd be SO grateful if someone could help me figure this out. Thanks!
I have 5 tables (Client, Driver, Appointment, LessonType & Booking). The Booking table is empty as it is made up from the other 4 tables. I want to have a form (Booking) which collects data from the 4 tables to create a record.
I want this to be automated as much as possible rather than typing the data into a textbox, because this would be difficult for the user and there would be conflict.
The Booking form will be split into 4 sections relevant to the above tables. For example, select ClientID from a combo and the other fields populate, such as forename, surname, address1, address2. And then select DriverID and this populates the relevant fields and so on, until a booking is created.
Ive tried After_update and couldnt get that to work. Any suggestions or help will be much appreciated as this has been a headache for a few weeks now. Thanks
Hey all. I posted this over at Mr. Excel too on the Access forums, but I thought maybe someone from this site might know the answer to my question.
I know pivot tables and charts are more up Excel's ally, but my question has more to do with Access I think. I've made a pivot table form from a query and everything is working fine except one thing. I want the table to refresh automatically. I don't want the user to have to go in and refresh the data manually.
I'm thinking I could put something on the forms "On Open" event but I don't know the specific coding. If anyone has any idea on this, I'd greatly appreciate some feedback.