Here's an awkward problem that i'm experiencing...I've created a form and everytime i hit the Enter key, any data that i've inputted disappears . I've noticed on the bottom right corner where it displays form view when i hit enter it say's calculating...and then poof , data gone...i've created a test record, #3738...Any help will be greatly apprecitated...i've attached form for a better understanding...
Is there an easy way of entering a value in a text box, passing to a query to do a count function and then return the value of count function in to anther text box?
I've searched the forums for quite a while now and haven't exactly found the answer I'm looking for, so I appologize if it's already been covered elsewhere.
I have a tough situation to explain, but I'll do my best:
I have a query that has several fields that are calculated by adding or multiplying other fields in the same query - a few of which are parameters. I have made the parameters the "right way" by going to the query menu and selecting Parameters... and filling in the neccessary Parameters and Data Types instead of creating a new field in the query and putting my parameter info in that way.
So, long story short. I want to have a form where the user can enter in the parameters, select a value for a field from a drop down box, hit a "go" button and a report will be generated listing info from that query.
How do I go about entering parameters through a form and how do I put in a drop down box that will list all of the values available for a field in the query?
Hope someone can help with this one - I have searched the Forum and cannot find any reference to this problem. I have a form which was originally based on a query linking 2 tables - data entry into the form worked fine. I then needed to add another field to the form from another table so I added the 3 table to my query, linked the table and then added the required field to my form and now the form will not allow me to enter or change data in any of the fields. I have checked relationships and they all seem to be OK. I have also tried creating a new query based on the original query and added the new table to that in case there was an issue with the first join, added my new table to this query and then based the form on this new query but the problem stills persists. Is there a limit to how many tables/queries a form can be linked to? Any help would be appresicated.
I have Created This Macro (Photo1) to Display Clients Home Address on A Bing Map, however, When I run Code I get A "Enter Parameter Value" Pop-Up. (Photo2) When I actually enter ClientID number in this case 5 it Does what I want See (Photo3). How do I get it to open directly to form with out Enter Parameter Value popup?
I am doing my internship now and am new to vba and excel. I need help with the following.
I need to create a form which allows the user to enter records into a table. The fields for this table is [product type], [Reasons] and [Breaks]. However for each [product type] there is a specific list of [reasons] and [breaks]. I need to reflect this onto the form using drop down lists or list box. That is if the user selects [product 1], the associated [reasons] and [breaks] will populate the other 2 list box. And then the user will click the update button to insert a new record into the table.
Can somebody help me out here? Thanks so much in advance.
Is there anyway to have a subroutine be called when a form is brought up? meaning, as soon as the user opens the form, stuff happens without them doing anything besides opening the form.
I am making a database and I am currently doing my forms. I have been using wizards and so far everything I have wanted to be able to do has been achievable, except for where I am now! I am making a 'purchases' form. What I want to be able to do is make multiple purchases in the one form. Let me try and give you an example to further explain myself.
Lets say Mr John Smith wants to purchase 1 black pen, 1 30cm ruler, 2 rubbers and a compass.
I want it so that rather than have to add each one of the purchases one by one, I want to be able to add them all in the same time and be able to go back to my purchases table and see:
Mr John Smith - 1 black pen Mr John Smith - 1 30cm Ruler Mr John Smith - 3 rubbers etc
I was able to enter data into my form but I made a few design tweaks and added another table into the form and now, in form view, I''m unable to enter data into any field.
I have a make couple of Forms and couple of tables.
My problem is how to I connect the form to the table, so it will store entered data from the form to the table. There are about 2-4 places where the user can enter data into the Form and it should be stored to a table. I made 5 forms and 5 tables, where the user fills out the first form and clicks next and next form opens and so on.
If possibly I would like to skip all the coding that can be used.
I have a search form from which the user can search by multiple criteria. Currently users run the search by pressing a button on the form with the mouse, the keyboard enter button just tabs around the form. My question is can I get the enter button to run the search rather than tab around the form? If so how?
it is zip file unable to get the size lower yet minimal amount in database I have 2 tables and one form when I create an query on the form the form then becomes that I cannot enter data in it or edit etc
I created a form that allows users to enter data into the fields and populates the table.But can I have it do that and populate instead of one table, two tables?
I have an exceptions report that i would like the user viewing it to write some form of justification on why the data if falling out. Is it possible to create a text box where the user could actually type text on the report before printing it?
I have a form to enter new records in a table.But when user enter empty record i want to display a validation text to to fill the required.I tried this code.
If txtItems="" then msgbox("please fill the required fields") else code to insert the records. end if
with this code its accepting the blank record also.What is the correct code?
I am attempting to setup a database and need setting up a form that captures/enters multiple records from one form.
We have batches of case files consisting of 25 folders each. I would like to setup the form where the user only has to enter the [User], [FileGroupID], [Examiner] and [DateAssigned] just once, but also allow for the individual 25 case file numbers in that batch to be entered. (See attached image)
So far I have created 2 tables; BatchLog table which would capture the batch details that is entered once and a CaseFiles table which would capture the individual case file numbers.
I have been having problems with opening a form to add new records only. I have gone through all possible solutions but somehow the problem persists.I want to add new records only and not view any of the existing records. I have set the form properties to Date Entry Yes, Allow additions to Yes, Allow Edits to No. The form opens through a command button on another form and the vba code is the following.
How can I update all the queries when I enter a new record in a form? When I enter a new employee record in a form, I want all the queries that are related to the employee information table to be updated with this new entry.
I'm creating a Dating Database on MS access, Now I've been given the attributes for all the tables. They are five (Client, Hobby, Meeting, ClientHobby, ClientMeeting)
Now I'm needed to create a form which allows me to enter the client data + at least two interests and their age calculated from their DOB. Seeing as I was only asked to put DOB in the actual Client table, I thought I'd create an Age query and then make that form out of the Age Query. (I already successfully managed to get the Age out of DOB in that query in a field of its own)
However, how can I add the hobbies field to that age query so I can finally create the form that I am required to do?
Second, I am to create a query which will be used for ‘matching’ clients. The criteria that you will use are: gender, age (using a range e.g. 20-25), interests/hobbies and city/town, this query ill be used to create a report which lists all the clients who match the entered criteria. How am I to do that?
I have a form where I select either "Male" or "Female" via tick box. If male is selected I would like it to automatically enter "he" in my table in another field so I can use this info in a Word template letter.
Does anyone know how I can create a form which asks for the name or lastname of the customer and does a search throuout the database and brings up all that customers informtation. And if their is more than one thats are the same you can switch through them untill you find the right one.
I have a column in a table that only is allowed one value, "Repealed" or simply left blank. I would like to have a checkbox on a form that enters the word "Repealed" or removes it depending on whether it's checked or not, rather than having the user enter the word "Repealed" each time.
Can anyone offer direction as to how to complete this? I've not had much experience with VB code.