Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kpryan
  • Content: Threads
  • Order by date
  1. kpryan

    Using a drop down list to select background colour

    Hi all, Is it possible to have a drop down list box or combo box so that I can select a colour to fill a text box background? I know I can use conditional formatting to do this but, wanted to know if this is possible Many thanks, KP
  2. kpryan

    data entry before closing

    Hi I am looking for a way to stop lazy staff from closing a form before they have entered all data I want a message box to appear warning them to fill in this text box(s) and that the form will not close until its done. I have made the form a modal form. In this way the database will be useless...
  3. kpryan

    Custom Menus

    Hi all, Don't know if this is the correct place for this one. Is it possible to disable custom menus. I don't want some of them accessed by staff. What I have been doing is to remove them from the menu and giving some staff a different front end. But it would be easier to hide or make them...
  4. kpryan

    Setting criteria for a select query

    Hi In a query I have three options to select companies, ie: "C" (Companies) "P" (Private clients) "S" for (Suppliers). On the criteria line how do I just select companies and private clients. I know that I can enter "C" which will select companies etc, but to be able to select both at the same...
  5. kpryan

    Using a date to initate a flag

    Hi all, I would like to be able to have a date that when a certain date is reached, it makes a text box become visible. The reason for this is to be able to put a flag on staff when a renewal of qualifications is due, or is there some other method of doing this? Many thanks KP
  6. kpryan

    Make table Query

    Hi all On a form I have a text box which I am able to open a form by this code; "DoCmd.Openform "form42", , , "acctno=" & "'" & Me.AcctNo & "'" The acctno selects an account so all records can be viewed. I would like to be able to use a make table query so that just the records from a Acctno...
  7. kpryan

    opening forms from another form

    Hi all Need some advice with this please. I use a form with a texbox (AcctNo)This text Boxes data has specific code ie: 4-1000. When I dbl click on this text box it opens a other form to show specific data relating to that code. Inititally I set the Data type to long integer and the code used...
  8. kpryan

    Controllling Print fields with check box

    Hi I would like to be able to print specific fields on a report by using a check box. On a form I want to select certain text boxes with a check box and for only those selected boxes to print on a report. Could I have some help with this please. KP
  9. kpryan

    relationship question

    HI I need some professional advice on a relationship. I have three tables, broker table staff table and a client table. The staff relationship will be a one to many, as a staff member can have many clients. However a client can have many brokers and a broker can have many clients. For example...
  10. kpryan

    subform totals in a report.

    Hi I have another question I have a report which has a group header (Lastname) In this I have a subform (continous) which has members super contributions. There is a total in the form footer which only gives a total when a certain amount is reached ie: SuperT...
  11. kpryan

    Scroll bars on reports?

    Hi Does Access provide a means to put scroll bars on reports. I would find it easier that having to use the record selector at the bottom. KP
  12. kpryan

    data entry in text box to control combo

    Hi, I have a text box (Gross) which is (currency) showing totals. There is also a combo box which holds tax data in currency. What I would like to do is when the tex box(Gross) has focus then the combo box will drop down and match the data in the text box So far I have this; On the 'textbox' (on...
  13. kpryan

    controlling check boxes with a checkbox

    Hi Would appreciate some help with this please. I have a continuous form in which I use a check box via conditional formating to change the background of text boxes. This highlights the record so that the user can see that this record has been edited. I would like to be able to reset all the...
  14. kpryan

    Using a check boxon a subform to control a tcomand button

    Hi all, I need to be able to make a command button on a main form become invisible from a check box on a sub form. I have tried different option without success. I know how to make a command button invisible ie:button.visible = true/false etc. But to get this to work once the checkbox on the...
  15. kpryan

    Limiting record in a continous form

    Hi all, I have a form which has a sub form inserted. I want a user to be able to input data to just 4 records only. The reason for this is that the sub form provides data for an invoice for extra items. Is needs to be limited because the invoice report has to have a lot of medical data. So that...
  16. kpryan

    controllling text boxes with a text box

    Hi all, I have a text box that when it has a certain text in it that other text boxes will change background. I did try this, but not very successful If textbox 1 = "paid" then textbox2.background = 256 ( or other colour) else textbox2.background = 0 end if. How can I get this to...
  17. kpryan

    Opening a query?

    Hi, i want to be able to open a query by using the 'On dbl Click'event on a form. The command I have used is this: DoCmd.OpenQuery "Accounts_1_StoreOS", , , , "RecordID=" & Me.RecordID As a test If I use:DoCmd.Openform "Accounts_1", , , , "RecordID=" & Me.RecordID it will open a form. Is it...
  18. kpryan

    Using append queries

    Hi all, I have 2 append queries which rely on an ID to be inserted into the criteria of the query. I have a command button on a form which uses the on click event to action both of these append queries. However the criteria I need to use is the insertion of an ID in the query. But I need to...
  19. kpryan

    using a chkbox to add totals

    Hi all, I have a continuous form where a field (AmmtRcvd) is the amount received. I also have a chkbox which when checked shows that the amount has been received. I would like to when the chkbox is checked to add up all the Amounts received. Ken
  20. kpryan

    Printing Reports.

    Hi all, I use the code below to preview a report; DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim strDocName As String Dim strWhere As String strDocName = "Report32" strWhere =...

Part and Inventory Search

Back
Top