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: *

  1. PharmaFun

    Creating tabs

    Haha....that was so simple, and yet I couldn't figure it out. Thanks!
  2. PharmaFun

    Creating tabs

    Hi there.,...I'm trying to create a series of tabs, but the thing is, everytime I try to draw something so that it is visible when just one of the tabs is clicked, I end up getting the drawing on all the tabs. Any advice? Thanks, Dino
  3. PharmaFun

    Past 255 rows

    Sorry..,..what I meant was can I have a table with more then 255 columns? Thanks, D
  4. PharmaFun

    Past 255 rows

    Hi there...is it possible to put more then 255 rows of data in a table? Thanks, Dino
  5. PharmaFun

    Create a copy of a record to hold

    Hello, I wish to be able to edit an existing datasheet entry in a form, without creating duplicate entries. So I thought I would create a "Save" button where the old entry is copied, the old entry is then deleted, and the new entry plugged into its place. Should I use the...
  6. PharmaFun

    How to search two tables in a combobox

    Hi there...I have two tables. What I want to do in a form is be able to search by SearchID in a combobox and to pull records with a matching number in two different tables. Here is the code that someone else graciously helped me to write, but it doesn't work. I'd be happy to send the file to...
  7. PharmaFun

    Help!

    Yes it is...I don't understand what you did. D
  8. PharmaFun

    Help!

    Would anyone be willing to work with me briefly on resolving this problem I am having? I am very new to Access, and I have a file here I need some help with. It's easier to explain if I can send the document and discuss it with someone. Any takers? Thanks, Dino
  9. PharmaFun

    Search a different table

    Hello, I have this code here for searching a table tied to a form, and returning the entry that matches the search number. The code is below. How can I search an entry in a table no linked to the form? I've tried changing "[Number]" to "[Initial Patient Report].[Number]&quot...
  10. PharmaFun

    Searching two tables in one combo box

    Would anyone be willing to work with me briefly on resolving this problem I am having? I am very new to Access, and I have a file here I need some help with. It's easier to explain if I can send the document and discuss it with someone. Any takers? Thanks, Dino
  11. PharmaFun

    Editing a non-duplicating table

    Hi Ginger...no apologies needed...your help is invaluable. Yes the Data entry property for the form is set to Yes. Here is the code associated with AfterChange on teh combobox: Private Sub Number2_Change() Initials = DLookup("[Initials]", "Initial Report&quot...
  12. PharmaFun

    Editing a non-duplicating table

    Combo Box: Row Source Type: Table/Query Row Source: SELECT [Initial Report].[Number] FROM [Initial Report]; Number is the key field that cannot be duplicated. If I try to edit it, I just get an error that duplicates are not...
  13. PharmaFun

    Editing a non-duplicating table

    Hi there, I have a table tied to a form. In the form, I can pull up an entry with a combo box that fills all the fields. However, if I try to edit the fields and then re-save, it says duplicates not allowed. Well I set the table data to avoid duplicate entries, but I do want to be able to...
  14. PharmaFun

    IF statement for a combo box

    Hi there, I have a combobox in a form tied to a table called "A." I also have a Table "B." What I want is an IF statement for the combo box, so if a value is selected that exists in table "B" and not "A" only fields 1-5 on the form are filled in with...
  15. PharmaFun

    Combo Box with search and autonumber

    Hi...might be a tricky one to explain. I have a field box that calculates an autonumber for a form. However, I would like to have it be a combo box, that you can select previous autonumbers from a table, but if you want to add a new autonumber, you just select "Autonumber" from the...
  16. PharmaFun

    Tab Index

    Thanks Richard, but that only sets the focus on a field by name. I have 10 forms, each where the 7th field is a different name. I was to set focus to the 7th field, irrespective of its name. Dean
  17. PharmaFun

    Tab Index

    How would I structure an "On Lost Focus" command which directs the cursor to the 5th field in the tab index? Thanks, Dean
  18. PharmaFun

    Cells updated

    Hello, Any help would be appreciated. I have a table and a form called "Initial Report." In the form, I enter some info on customers, which is then copied into the table automatically. This includes an autonumber. Now, I also have a form called "Sales." I want to be...
  19. PharmaFun

    Returning text to a table

    Thanks again Rollie E. Yeah, I made the necessary changes, but whether the field "Gender" is set to text or integer, it still says "1" in the field for male. Any further suggestions. Sorry, I'm a knob at this stuff. Dean
  20. PharmaFun

    Option Group to Return a Text Value in Table

    Hi John....thanks again. No worries about the earlier error...it happens to the best of us! So I added this event to my gender options box: Private Sub Gender_AfterUpdate(Cancel As Integer) Select Case Me.Gender Case 1 txtGender = "M" Case 2 txtGender =...

Part and Inventory Search

Back
Top