I have a table that containes: Member#, FirstName, LastName, CompanyName, etc. Multiple entries can be in the table for each Member#. On my form when a Member# is entered, if that # is already in the table, I would like for the form to autofill the FirstName, LastName, and CompanyName fields from the table. This is added protection to be sure the Member# typed is correct. If the # is not already in the table, then nothing will autofill. I am not new to Access...but my knowledge is not above "3rd grade". Can someone help with this problem, or can it even be done on the form?
I have a form that has a field called scope of work which is a combo box that you have 3 options to select from.
I have set up a table called scope of work which has other fields ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date.
The combo box works fine selecting the scope of work but I want the fields on the form to automatically fill in the other information. Say they select option 1 in the scope of work based on this option it will fill in 40hrs at $150 per hour normal rate and $180 per hour overtime rate and this will take 4 weeks to complete. Based on the start date field it will also calculate 4 weeks from now for the completion date.
I have tried everything from queries using SQL statements, joining tables one to many etc.. and for some reason I cannot seem to get it to work for me and I've spent hours searching around for a solution..
If anyone has any ideas it would be greatly greatly greatly appreciated!!
I have a table with customers details(Address Etc) but there is too many for me to use a combo or list box so i would like to use a text box. Here lies my problem. What i need is to be able to enter into a text box on form1 the first few letters of the customer ID no and this will open a hidden subform that will list the customers with those first few letters. I then want to be able to select one from the list using the number keys and once i press enter it opens another form(form2) with all the customer information already inserted into the text boxes on form2.
I am creating an ostensibly simple database, but I need help trying to get it to work. There are three tables.
1.Users – UserID, Dept Code, LName, FName 2.Boxes – BoxNumber, Description, Contents, and many other fields 3.CheckOut (junction table) – UserID, BoxNumber, Description, DateIn, DateOut
I want to create a form that would have the User fields at the top and a subform with the checkout fields.
I need the user fields to autopopulate after filling in the UserID (primary key).
I need the box Description to autopopulate after filling in the BoxNumber (primary key). At the moment, the form thinks that I am trying to ADD new records. There are no new records (boxes) being added. I simply want to use the form to check out and check out boxes.
Help. I know just enough about Access to get myself into trouble.
What I want to do is have a form where I enter a low work order # and a high work order # with a series of yes/no questions and then have that autofill a table with work order #s incrementally from the low value to the high value and attach all of the yes/no answers to each work order #.
How do I get the table to autofill from low to high work order #?
Thanks for any help in advance and type slowly. I'm not very bright.
Hi all! :D I'm trying to make a form to autofill with customer data (from a database), with 4 columns (= 4 customers). Each column contains on top a combo box and below 5 text boxes with address, phone etc. So i created a form and placed a combo-box (from wizard) with the option "Find a record on my form based on the value i selected in my combo box". The problem is that this one combo box controls all the text boxes. Even if i create an other one, it still controls all of them.
So i'd like to ask: How can i link a combo box, to autofill specific textboxes?:confused:
Hi all,Sorry if this has been asked before, but I've used the Search function and can't find exactly what I'm trying to achieve.The Current SetupI have a database that I'm now trying to expand upon by adding extra features. One of these features I'd like to add is the ability to, firstly, know how many records in the entire datasheet have not been officially closed (i.e. have their 'rmaclosed' column empty), and, secondly, to have a list autogenerated that shows all of these records and allows the user to double click an item from the list and have that record open.Now, to make life easier, I should point out that I already have a successfully working search function in my database. Clicking a button from the switchboard opens up a form that allows the user to enter full or partial text into a box, then, at the click of another button, the main window of the form will automatically fill out with a list of all those records which match the entered text. The user can then double click anything from this generated list and the appropriate record will be opened.Working on the assumption that the code for what I want to achieve would be near-identical to this search function code, I have replicated both the form and code, and am now trying to adapt it; it is this adaption I'm having trouble with.The Current SituationTake a look at the attached image. That is how my form looks to the user when opened.Now what I really, really want to achieve is for that central window to be automatically filled out with the listed column headings of any record stored in the table maindata that has a Null value in the column rmaclosed when the form is opened. However, I don't see any option for 'OnLoad', so I'm willing to compromise and just have the user click a button.You'll see the button there for 'List RMAs'. When clicked, that should populate the main window with the records that have not had their 'rmaclosed' column filled out. The code behind the button - which is where I'm having the problem - is as follows:Private Sub cmdSearch_Click()Dim strSQL As String, strOrder As String, strWhere As StringDim dbNm As DatabaseDim qryDef As QueryDefSet dbNm = CurrentDb()strSQL = "SELECT maindata.ID, maindata.rmanumber, maindata.company, maindata.rmalogged, maindata.initials " & _"FROM maindata"strWhere = "WHERE"strOrder = "ORDER BY maindata.ID;"'THIS IS THE BIT I'M HAVING TROUBLE WITHIf IsNull(maindata.rmaclosed) ThenstrWhere = strWhere & " (maindata.rmaclosed) Like '*" & maindata.rmaclosed & "*' AND"End IfstrWhere = Mid(strWhere, 1, Len(strWhere) - 5)Me.lstCustInfo.RowSource = strSQL & " " & strWhere & "" & strOrderEnd SubThis code has been adapted from that which - successfully - runs my filtered search engine. The problem is that my search engine runs a query based on text entered onto the search form by the user, whilst the form I'm trying to write should simply list every record in the main table, filtered according to the state of the 'rmaclosed' column.As I said in the opening paragraph, although it's not essential it would be really nice to have a counter somewhere on the form that would show the total numebr of records in the filtered list.
I have 2 tables StudySchedule and ExamSchedule.StudySchedule contains the detail information of opening classes of many different periods. I need to create a form that can:
1. let the user choose a period
2. form will generates automatically exam schedules of the opening classes of the chosen using the relevant information in StudySchedule. Those entries will be saved in ExamSchedule.
3. Note that there are 8 fields of the exam schedules generated/counted from some fields of StudySchedule. The 3 other fields of the exam schedules need to be entered by the users. User must also have the ability to edit the generated fields.
I want to Autofill one of the field in my form, by checking specific conditions in my database. Example of which is as below:
1. Date of Maintenance : 2. Loom No. : 3. Component Replaced : 4. Component Type : 5. Latest date for same component replacement :
I want to autofill the Sr. No. 5 in the form itself by checking database, and if Sr. No.2=Sr No.3=Sr. 4, then latest date should be autofill in Sr. No. 5
Say, A component was replaced in a Loom on 01/01/2013 & again after six month same component is replaced on 01/06/2013 so while filling up the form, In sr. no. 5 latest date 01/01/2013 of replacement of same component in same loom should be pulled from data base.
I have a review pop up form (frmReview) where a user selects their Name (StaffID), the type of check they are doing (QuailtyType), and the client they want to do it on (clientID). When they press on the 'do review' command button from this form another form opens (frmReviewDetails) which shows the client they selected from the frmReview form as well as a its subform which shows all the sessions that have been entered for this client along with some fields that have not been complted yet regarding review data. I am trying to have it so when they check the 'review check box' in this subform that today date auto populates in the Review date field (this is currently working). I also want it to auto enter the staffID that they selected on the the initial frmReview form.
This is my currunt code:
Private Sub Rev_AfterUpdate() If Me.Rev = -1 Then Me.[RevDate] = Now Else: Me.RevDate = Null End If End Sub
I really don't want a staff to have to enter their name each and every time they check the review box. Not all box's are going to be checked, so it needs to be on a record to record basis.
What I'm trying to do is create a database system for my company, it's not overally complex in the sense it's just managing the estimates and invoices we do.
Now I've tried to break the data down as sensibly as possible.
What i'm having trouble with is I have created a autofill combo box to fill out text boxes with information from the Clients table, the idea is that the client can be added via the Estimate form or pulled up from the record depending on the situation. Now the problem I have is one;
I cannot enter data via the form
and two
When you flick through the forms only the combobox information is staying put, either the text field is empty or incorrect.
I'm pretty it's to do with [Data Source] but I can't seem to get it to work. How to make it possible to pull up clients when typing an estimate OR be able to add a new client via the same fields. Secondly, when the Form is review the autofill text field display the clients details.
I want to be able to pre-fill records with information based on a form every day for each client. This needs to display in a datasheet view showing all clients for each location.
Each day the subform needs to show the expected results of that day's activity with clients if all default conditions are met. (i.e. client receives a call that day based on expected conditions calculated in a form for that day).
I am stuck for over a week now, and tried just about everything I am capable off ...
I have two forms: COMP (where I fill in fields for Company Table) and PERS (where I fill in fields for Person Table). On the COMP-Form I have a button, named: 'Add Person/Employee to Current Company'.
The two tables (Company and Person) are linked by PK - FK (PK_CompanyID & FK_EmployedAtID).
I can't get it to work properly. The PERS-form must be filled with the company info I filled in the form COMP, after I press the button. But the PERS-form also must be filled out normally (not via COMP, but seperately), choosing the company in the comboboxfield 'Company Name' on the PERS-form. Do you stick with me?
So I want to start the PERS-form with the filled in company Info by pressing the button. And I want to be able to start the Form seperately (which I can off course) and choose the company myself , by selecting the right company in the combobox.
I have a attachment sent with this.
Can someone look at this for me, and explain what I am doing wrong.
I tried to do it with a autofill macro, and with some code ...
I have a quick question that i need to get some help with.
In a form, there is two comboboxes and a textbox. The textbox is disabled and locked because nobody is allowed to enter data to it. It contains the value which is from the result of choosing the two comboboxes.
example; in table "Project" Name Subject Score michael IPA32 80 . .
CB=combo box
from the dropdown, CB1 = "michael", CB2 = "IPA32". Then 80 will appear in textbox. However, there is some cases where the score doesn't exist or null (not found in the table). Is there a way to check on the spot if the textbox is empty or not as soon as CB1 and CB2 have been selected. At the moment, i use the form_beforeupdate to check the textbox. If it is, cancel is true. the whole form disappears which i don't want it to happen.
Apologies if the answers are very simple, I'm a wee bit of an Access newbie!
I have created a form with which I am going to record gym attendances for my members in my members table. When I do this it will update a table 'gymattendance' which stores the information about price paid, date, memberID etc.
My first problem is that despite 'tblgymattendance' being linked to 'tblmembers', when I go to record a gym visit in my form, it will only allow me to enter new members, rather than select current members to record a visit. How do I get around this?
Once I get that sorted, I need the form to then send that record in its entirity to a new table, 'tbltakings,' which stores information on all the gym sessions attended to calculate total moneys taken from those sessions. I have been unable to find a way add records to 'tbltakings.'
If the latter is not possible, would a simple update query work to add to a field of 'totaltakings,' in 'tbltakings' ?
Many thanks in advance this is really starting to get on my nerves!!!
I've developed a pretty simple form with a few combo boxes, text fields etc. I need to put this on the web so that my colleagues can access it logging new forms etc. As this is new to me I've followed the instructions as per my Access for Dummies manual. This advises that you have to save thte form as a data access page...unfortunately it's not working. The form works fine on my desktop. I've saved it as an Access Data Page but the end result seems to have disabled the combo boxes and an autonumbered field. I thought this might be as some fields were unbound so created a new form based on a table but this won't save as an Access Data Page at all and throws up the error message 'MS Access is unable to create the data access page the file does not exist or you do not have read access to the file'. Clearly the file does exist and as far as I can see I have full administrative rights to it. What am I doing wrong?? Can I use this method to publish to the web? If not what do I need to do? Is Access indeed the best method? Any help would be greatly appreciated!
Case 3 does not work. with " " . So what do i do here to show Both records?
My second problem is with the reports opened with the above Case code. The search routine (apart from Both) work fine. It finds the records i ask of it and it opens a report to show them, however, there are instances where no records are found, and the report still opens!!. In my search form, what code can i use to test my query for "null" data before it even gets a chance to open the report?
I'm sure this is simple and I searched the forum but I was unable to find an answer so..please help! (btw, newbie here);)
I have two tables with a 1 to many relationship. I have two forms based on each table. Table1 has a key field called ECO. Table2 has two key fields, ECO and ItemNumber.
When I have form1 open I use a button to 'pop up' form2. Form2 shows only records that have ECO value = to Form1.ECO value.
When I create a new record on form2 I would like to have form2.ECO auto filled with form1.ECO value. This is where I'm stuck!:confused:
I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record.
How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being blank.
For example if I have Charger12345 open in the Asset form, I'd like to click the Add New Job button and it automatically have Charger12345 in the ChargerID field of the Jobs form.
I need to have a form which has a series of blank text boxes on it.
I then need a subform, that has all of the text boxes as above, in datasheet layout.
I then want to be able to type values into the text boxes on the main form, and have the user then click a button. If any records exist with the values that have been typed in, they should be listed on the sub form.
If the main part of the form had combo boxes then that would also be good.
Finally, I want the user to be able to double click on one of the rows that have been found, and for this data to be loaded into a third form.
Is this possible? Could someone help me out, by maybe linking me to a source that will help me, by explaining how to do it, or maybe by letting me know where i can get a sample database that does this sort of thing.
Some of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked (frmlocation and frmsample) these are linked by location code which is an autonumber.
These are laid out so that you fill in room data first, then location data then finally sample data. However after the location data has been filled out and a user attempts to move to the first combobox on the sample subform a message pops up saying that another user has altered the database and would you like to save changes (Impossible as they are using the database on a local drive). After this happens they reopen the form and in all the frmsample fields is "#deleted"
This doesn't happen every time...infact over the last 2 days i have been entering data myself to try and get this error with no luck. Has anyone else come across this and know how to fix it?
