I have got a db when I enter a new client in the client form it saves it in the table but when I return to the form the client I have just entered is still there so I cant enter a new client it does'nt clear the text in the text box can anyone help
Hi all, I have a form that is based on a query that uses a yes/no option as the filter. the problem i am having is that in this form if a user has more than 1 no entry the users name shows up as many times as entries that they have. i would like this to be shortened down to only one time for all no entries. is this done within the query? SELECT Employee.EmployeeLastName, Employee.EmployeeFirstName, Employee.EmployeeID FROM Employee INNER JOIN Expense ON Employee.EmployeeID = Expense.EmployeeID WHERE (((Expense.AdminApproval)=No));
OR could this be done better in the on load of the form using a counting loop?
i need to size a form so that it does not fill all the window, i have tried enabeling the min and max buttons but they will not display for some reason, i changed the borderstyle to sizable and the controlbox to yes the min and max buttons are enabled , but still not showing the min and max buttons, the close button shoes and thats it? i am running 2010.
I have a main form that displays records with a couple of sub forms and it also has a button to open another form which is based on the same table main table but different sub forms.
All I am trying to do is open the second main form by clicking the command button and to automatically display the same main record as shown on the first form before clicking the button.
Thanks for all your help on my previous problem but I now have another one that just seemed to start out of the blue. When I open my form the record selectors don't allow me to browse through all the previously entered records. This is a huge problem because if changes need to be made I can't call up the record to do so. I plan on adding a search funtion to the database soon but for now I need to be able to search through the records on my main form. Is there something I should look for or do you have any suggestions?
I am building a relatively small database, but it is made up of a number of different tables which are fed by other tables.
My three main tables are:
EmployeeDetails Occupational Risk Profile Health Surveillance Requirements
The employee details table has fields fed by small tables such as Department, Location, Business Unit, Occupational Group etc. These are all made up of an autonumber primary key column and a variable column as described above.
I have been going round in circles with a lot of this as I am still learning.
My problem is that on my forms these fields are showing as numbers and not the text values. For example, I have one form made up for each of the main tables above but I can't get them to display the relevant text.
I did a search on here and somebody said to create query to link the tables and bind this query to a form.
How do I set up the query just to return the text part and not the number? How do I bind this query to the form if I already have the record source on a my form as a table? (can you have more than one source in the record source?) Do I create one large query with all of these fields and use this as the basis for the form?
I have created a form off a query. I made the form for adding new records only. When i bring up the form it is blank, the labels and fields don't even show. Anyone know why this is?
I have created forms to add data. What i do is click the add new record command button and add the details. But when i open the form again, it does not show the record which i have just added. However the record is present in the tables.
Ok this null value thing is killing me. I have a parameter query that works great. I know if I use Is Null in the criteria field it will show me this. The problem is I made a search form which the users type the value in and it opens a form based on the parameter query, the parameter on the query is [Forms]![Search_frm]![txtClosed]. If they type a date in here it opens the form and shows the user all the closed records. The problem is they want to see all the records that have no value or Null. I've tried eveything to make this work. I'm ready to jump!! Just kidding. Is there a way to do this with out creating another query. Thanks a bunch!!!
I`ve searched the forums, but not knowing the terminology, i cant find what I`m looking for.
I have a table which is use for a drop down list in my forms. This is saved into a table, but shows up as a numerical instead of the name value.
Also In reports, I get a numerical value, instead of the text value.
Is there something I`m over looking ? Or am I doing something totally wrong. My relationships are correct. and the field data is right, I just cant over come the number issue.
I have a form field with a date in it, is there any way I can make the value in that field display one thing, but still run a query based on the original text?
for example: txtDate is 1/1/1000 if txtDate = 1/1/1000 then display = "*"
but the query still runs on 1/1/1000
I am asking this because I am trying to run a between statement for a date range and the only way I can do the entire range of dates on my table is to use the highest and lowest date possible (1/1/1000 and 1/1/3000) but I only want the users to see "*" so they are not confused.
I have another question about ACCESS forms. With VBA, I want to change the record showing when I open a form. I see there is a member "CurrentRecord" so I tried in the class module
Me.CurrentRecord = 2
I compiles but gives runtime error that is write-protected and cannot be changed. In the ACCESS help I read you could do it but HOW?
What should I do ( I am using ACCESS 97 ) ?!
Thanks in advance
Victor
PS : Is it true that VBA in newer versions of ACCESS has more features/functions etc?
Is it possible to open a form so that it shows the new record fields only? I want to create a form that only allows the user to enter data and not view any of the records in the table the form is linked to.
so I have been working on this form for a while and I'm really a newb at this maybe it easy maybe its not but i just couldn't figure this out I'm so frustratated that I'm willing to pay(beer money for help)
well anyways I have this form http://i27.photobucket.com/albums/c176/rlan214/WorkAssignForm1.jpg at the side you can see that there are 3 filters 1st has check box (check box is always checked) for the date 2nd check box for Target Location 3rd check box for ForkliftID1
I also don't know how to change the date format in my date its in yyyymmdd format right now and I want it mmddyyyy
In the middle theres a blank, and thats where I wanted my query to show
here's my query http://i27.photobucket.com/albums/c176/rlan214/WorkAssignQry1.jpg
How can I Load a Form into Memory without showing it?
I have a DB with some Forms. None of them are open. I want to check some properties of each form without actually opening them. How can I do this. Probably by loading it. Can anybody tell me how to use the LOAD command to load the Form?:o
I'm designing a relatively simple access database with four linked tables:
- users - computers - licenses - license_users
Each user as a computer_id linking to the computers table; they also have a set of rows in license_users, linked via their userid, that join them to the licenses table. The relationships are enforced with referential integrity. Everything works fine when I enter data manually in the table datasheet view.
I've designed a nice form to make it easier to enter data for all the tables at once, but when I try to enter the data it all goes wrong. I'm unable to enter any data into the users table fields until I have complete the computer and license data. If I enter that first, then start entering data into the users fields, the computer data suddenly disappears. If I inspect the table then the computers and license_users has been entered, but nothing is entered for the user and I can't get the rows to relate to the users!
It's a while since I designed any Access databases, and I'm stuck, so suggestions would be appreciated.
I have tried to find information on how to do this but everything I try fails.
I have a form on which I want to display JPG photos which are stored in a folder called FCP. The path to each photo is stored in the database table. Each record will have one photo only and the path looks something like this:
C:Documents and SettingsBKALProjectLRFCP4.jpg
Can someone tell me exactly how to design a form picture field that will display the relevant photo?
I have a query that has a total sum , my problem is when i create form all the fields in the query is visible in the form but my total sum doesnt show up, but when i view it in query it works properly.
I don't really know what the symbol really is called i just called it total sum, the E icon in query ....
I want to release an Access file which has eveything locked down and cleaned up so that my Form is showing full screen (and nothing else) for an optimal user experience.
I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.
Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.
I am currently working on a database and I'm using a form to view the records. A standard Access behavior is to show an empty record (new record) as the last one. is there a way to disable this "feature". I would like my form to display only the records, which are really filled with data and not show the blank one at the end??
Actually, I don't think i've done this right, but here's the goal I wish to achieve.
I have 2 tables, one containing contract info and another containing client info. I have the 2 related using the client name field. I have a form which is based on the contract table which contains a drop down field of client names. When I select a client, I want it to update a read only client address field within the form, just for display purposes.
Is this easy to do and can anyone point me towards some examples on how to achieve this???
I have a database which has one main form linked to a table which has 325 records in it. The problem is when you open the form it says there are only 324 records :confused: I have gone through the table comparing the records with the form records, I found what I thought was the 'missing' record. But when I did a find on the form I managed to retrieve the record. Can anyone help as I'm a bit baffled.