i have a form and it always displays the first record as it opens.
i dont want it to display any records and be just blank.
i have tried the code on Form_load
for i = 1 to col.count
col.item(i)=""
next
i dont know whats wrong with this code.
please help
I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?
View 1 Replies View RelatedWhat I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
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?
View 5 Replies View RelatedI have created a MS access form having a combobox,button.There I have coded like : When the user click on button,a report will be generated. I need to show the access form in the excel form.I have searched and got code,which only allows me to open the ms access not the form.
View 8 Replies View RelatedFirst, I am a beginner with Access. I am a graphics designer that has been assigned to cover for a db programmer that quit!
Here is my problem:
I have a database that we use to hold customer information. There are 22 fields in each record, and we are now well over 3000 records.
Once upon a time, to find a specific customer, we would just go to the bottom of the page, and use the arrow buttons to scroll through them all. This is no longer possible as the size is too big to manually search.
What I would like to do:
Upon Access startup, display a form that has a single input field and a button titled "Search". The input field is titled [UserName], as this field is the unique key identifier for the record. When the user types in the UserName and clicks the SEARCH command button, another form appears to display JUST THAT RECORD in the easy to read form!
If this is really basic, I appologize. I have 20 years experience with commercial illustration and only 7 days experience with Access. I have purchased books, and hit the forums, but I am not a VB programmer, and my skills this area are REAL weak!
My resourse books include the following:
Wiley - Access 2003 Bible [Prague, Irwin & Reardon]
Osbourne - How to do Everything with Access 2002 [Anderson]
O'Reilly - Access Cookbook [Getz, Litwin & Baron]
Thanks in advance for any assistance.
Hi All
My sub form appears to work fine most of the time.
But the records in the sub form (which is a datasheet) don't display when I apply a "filter by form" on the main form ?
Any clues as to what is wrong ?
I am a beginner - it could be something quite fundamental !
NoVoiceLeft
Hi all
Quite busy these days but never too busy to visit this website.
I have a question.
I am busy create a "Logsheet" database. Where you enter all your trips done with your vehicle.
Trip;Date;Trip_From; Trip_To;Start_Km; End_KM;
I do have a textbox where get the Trip_distance.(End_Km-Start_Km)
Is it possible too display on the current form the previous page End_KM.
Previous Trip End_Km-123456 (Display from previous page)
Trip Start_Km-123456 End_KM-123466 Distance-10
Next Page End_Km-123466 (Display from previous page)
Trip Start_Km-123466 End_KM-123486 Distance-20
I tried to do this but it came out only in a mess..
I have a DB with a form based on a query where we keyin a parcel identification number (PIN). If there is a corresponding PIN the form opens. If there is no PIN available, a blank form appears. Is there a way that if no corresponding PIN is found, a different form or message box would open stating "No parcel available"?
Thanks,
SKK
I have a form that allows the user to "Enter a Parameter Value" that determines the data that will show up
on that form. I'd be pleased to know:
1) How can I display the Parameter Value, choosen by the user, in the form.
2) Consider a form that will display all the students whose name is having Vincent.
If the user doesn't know the complete name, how can he define the parameter value. I mean in some
languages I can use Parameter Value = Vincent* and it will show me all the students whose name includes
Vincent. And in Access? How can I do that?
I am trying to build a form with feilds from multiple tables in access 2002. When I use both the design view or the wizard to build the form, the form displays in design view, but is blank and unusable in all other views.
View 3 Replies View RelatedI have a form where a user enters a bunch of client info into a database. I also have a form that I want to use if a user wants to view the table. What control do I use to display the data? I want it to be in tabular form so they can browse the list.
View 1 Replies View RelatedCan anyone help?!? I need desperately to display a web page in a form but when i insert the browser i cant find where to put the URL in order to display the webpage..........!!?!?! HELP!!?!:confused:
Ben
My users have asked for a form to display various database statistics, as they prefer this to a report. I have designed a form which contains several DLookUps and some sub forms. But several areas on the form display "white", as if they are being selected by deafult.
For each area/element/text box, I have set the Tab Stop and Auto Tab properties to No. Each background and border is also transparent. Is there some other setting I need to adjust, whether at the main form, subform or individual text box level?
The form works fine, it just doesn't LOOK very professional and I'm keen to improve how I do things. Please see attachment. Thanks.
Is it possible to run more than 1 query and display results on the same form?
I have 1 form with a Record source of Query 1.
The control boxes can therefore just reference the query fields.
So, Control box 1 has =[selectedfieldfromQuery1] as its control source.
I need to have a second control box displaying the value of a different query from a different table.
So, at the moment Control box 2 has =[Query2]![selectedfieldfromQuery2] as its control source but Access doesn't recognise that.
ANy ideas on how to progress?
I have a table that contains fields as follows: [userId], [userName], [userFullname]. About 10 users (records) in total.
I have a function username() that gets the username of a user from their logon.
Now on my form, i have a textbox that I'd like to display the Fullname of the user that's currently logged on the form (On Open event). Meaning, it will get their username from my function, then compare it to values in the users table and display the full name of the user when the user opens to form to view their records.
Can anyone enlighten me on how to do this. I have tried tried tried, my methods aren't getting me anywhere.
Any help, suggestions, ideas will be greatly appreciated!
I have a subform which displays details of an Insurance Certificate. Upon or near Expiry, a Letter is created to remind the Broker. I'm using the following
=DCount("[LetterID]","InsLetters"," [InsLetters].[InsCertID] = Forms![subInsurance]![InsCertID]")
in a textbox recordsource to count the number of letters which have been sent out for a given Cert., so User can then click to display a summary of those letters.
The subInsurance form is a Sub on a TabCtrl on a main form 'Aviation'. When I got through the Aviation form, it displays an error... but then corrects when I open the subInsurance form directly, but Users will not wat/be able to do this.
How do you get round this? Please.
I want to display table data in an MS Access form (using a Text box or a grid) using VBA?
Any ideas or examples?
Kind Regards
Richard
My current database is in need of an upgrade. Currently (view image), as you can see (its the only form), each student entered into the database can only have one course. However, I would like to add the ability for students to have multiple courses. my problem isn't so much how does the database user enter in the new course for the student. This can be achieved with another form. However, I am struggling on how I would display these multiple course, in a user friendly way, on a form. What controls do i use? I'm thinking a table control would be suitable (much like an excel spreadsheet) as it would allow show all the courses/ edit a specifc field if required. However i do no believe access 2010 has this control.
View 1 Replies View RelatedI have created a from which consists of search boxes in the above and the table in the below.If we search for any in those search boxes then the results will be displayed at the bottom (The results will be displayed in the table which is located at the bottom of the page).I had done with the above part.
My Requirement : If I click on any of the row in the results table then is it possible to display only the selected row in a new form? If I search for a keyword MS in a search box and if it returns 40 results and if I click on any one of the result then the selected result should be opened in a new form.
want to display on a form the totals of one filed/columm in one of the tables the form is based on.I added a text box to the table and in proporties----data----control source--opened expression builder, selecedt my table under expression elements then under catagoroes selected the field - and from there I am lost as under expression values I see nothing I can relate to Sumtried to input an expression for the sum of all currency values in one columm.
View 13 Replies View Relatedhi, i have created a form and would like to display todays date and time in the following format
Mon 6 June 2005 24:00
this will literally be just on the form, no link to anything or any extra dynamic features. just there for the user's benefit
if anyone could tell me the steps that need to be taken, im guessing some formatting will need to be done, or some script will need to be placed in the form event code builder.
i have only recently focused my attention on ms access so a descriptive but to the point explanation will be ideal thanks
I have a query that querys another query for check boxes that are checked. I would like to display in a text box on a form the # of records that the query found to be checked. I have looked all day and have found nothing that I have enough knowledge to use. I need to know how and how to apply this. If you have other suggestions to do this, I am game! :)
Thanks!!!
Hi,
I've searched for this but can't find how to do it, When I open this form I want it to display the last record in its control source, This is probably a simple one but I just can't seem to make it happen...
Thanks
Ryan
P.S. This is what i Have so far...
DoCmd.OpenForm "frmAbout"
:rolleyes: Hmm how should I put it? I want like to create a form so I can show 8 to 10 records at a time on a single page (instead of using continuous form); so when I press the next button, the next set of 8 records will be show on the next page.
Is it possible to do that with Access?
Thanks,
Jason
I have a form with a sub form that opens based on a record search for a patient, whose details are displayed at the top in the main form.
The sub form displays visit information for that patient (there can be multiple visits).
On opening the sub form is filtered and only shows one record at a time. I would like it to open and show all existing visit records for the patient and be ready to enter a new visit!