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!

  • Congratulations bkrike 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: priapus
  • Content: Threads
  • Order by date
  1. priapus

    scanning input

    Does anybody know the syntax for scanning through a string upon input being entered, checking for an apostrophe character, and replacing it with a ` character? Thanks in advance for any help.
  2. priapus

    referencing field length in for loop

    Uhhh...Fairly simple question, I just can't figure it out. I have this for loop where the first line is something along the lines of For Each MyCharacter in Me![MyComboBox].Length Only the Me![MyComboBox].Length is invalid syntax (there's no .length function). What's the correct way to...
  3. priapus

    Problems with an apostrophe

    I have a form that contains a combo box. the control source of this combo box is a query of companies, and when you choose one it takes you to that record for the form. yada yada, easy peasy. the problem is that one of the companies (so far) contains an apostrophe, so in the after_update code...
  4. priapus

    unhide 'hidden' form

    i right clicked on a form, clicked hide. now i need it to be visible again but can't figure out how. any ideas? thanks for any help.
  5. priapus

    hiding field in datasheet view

    I have a form that is in datasheet view with three fields. all three are visible, but i want one of them not to be visible. For some reason it still shows up (in datasheet view at least, but not form view) when the field's visible property is set to No. Thanks in advance for all help.
  6. priapus

    setting control source from possible null field

    I have a text box on a form whose control is the sum of two other text boxes on the form. When both source fields contain data, works fine. One of the source fields, however, is based on a Dsum statement that sometimes results in data but usually results in nothing. What's the easiest way to...
  7. priapus

    Summing all cells of a datasheet form

    I have this subform which consists of a combo box (based on a query) and another text box (Amount). On my form, the user can choose a billingOptionID from the subform's combo box and the amount for that option shows up in the field next to it. The subform is in datasheet view, because there...
  8. priapus

    htm pages in access

    This might be simple. I have a form with 50 records, each containing about 50 fields. I created an html page (in access) based on the same query that the form is based on (with the same 20 fields). When I open the page from the pages section i can scroll through the records, seeing each of the...
  9. priapus

    html page in access

    This might be simple. I have a form with 50 records, each containing about 50 fields. I created an html page (in access) based on the same query that the form is based on (with the same 20 fields). When I open the page from the pages section i can scroll through the records, seeing each of the...
  10. priapus

    linking to a url

    I've posted on this before but am still having some problems. I have this form where a user enters a company name into a certain text box, resulting in data on that company to appear in certain other text boxes (e.g. creditcardnumber, creditcardexpmonth, creditcardexpyear, et.). the user then...
  11. priapus

    URL linking

    I've posted on this before but am still having some problems. I have this form where a user enters a company name into a certain text box, resulting in data on that company to appear in certain other text boxes (e.g. creditcardnumber, creditcardexpmonth, creditcardexpyear, et.). the user then...
  12. priapus

    linking form fields to a website

    I have a form with a bunch of fields in it, and I'd like to be able to have the user click on a button and have the info from each field on the form automatically get exported/copied into specific fields on a certain web page. Is this possible?
  13. priapus

    parameter query

    I'm kindof a newbee to access, so if this is trivial sorry. In a form, I have an unbound list based on a query, one of whose fields has a parameter value. On the same form, I have a text box (a date defaulted to the current date that can also be changed manually). That date is the object of...
  14. priapus

    how to create a dynamic list

    in a form, i want to create a list whose length isn't static. i have a table field with a bunch of dates, and need to create a list in a form with the number of fields depending on how many dates in the table field have the same day as the current day. thank you much, in advance.

Part and Inventory Search

Back
Top