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 Rhinorhino 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. Quique79

    User Log with restrictions

    Hi!!! Any idea how to do an interface (form) with username and password??? I have the idea that I must use a table were user's data will be stored.... And what about the restrictions??? I want to restrict the access depending on the current user... Any tip or hint? Thanks Quique79
  2. Quique79

    How to populate a Datacombo??

    Hi all!! I have a form where depending on a value in a textbox, the Datacombo should be populated with a specific info. I've tried with Onlostfocus event of the textbox, trying to put Datacombo's rowsource to the specific table, but it doesn't work Any hint or tip? Quique79
  3. Quique79

    Auto Id Generator

    Hey guys.. thanks for your help Quique79
  4. Quique79

    Error in functions

    Hi!! I've done a databese, in it, I have form where I use some code (VBA), in my machine runs ok, but when I open this database in other machine, some functions don't work... like Ucase, Now(), Date(), etc. I have installed Visual Basic 6 in my computer... will be it the problem? If so, How...
  5. Quique79

    Auto Id Generator

    Hi!! I'm designing an form that will work as an Invoice, my problem is, that I want that every time I add a new record (or invoice) the Invoice No. will be generated automatically. I was trying to obtain this number from a separated table (InvoiceNo) and inside the Invoice form to put a field...
  6. Quique79

    Newbie: How to give permissions

    Hi! I'm an Access newbie, I want to restrict the access to some users, dependign their arear, they could enter in some areas like orders, products, etc and others to invoices, reports, etc Any hint, tip or any web site where I can find something related????? thanks Quique79
  7. Quique79

    Setfocus event

    Hi!! I'm designing a form, and in a textbox on lostfocus event I wrote this: if Text27.text = "" then Msbox "Data Needed" Text27.setfocus End if Message works ok, but I got an error that I cannot establish a control property at least that the control has focus What can I...
  8. Quique79

    Filter a Record to Print a DataReport

    fastaway: Thanks, I did understood... and it worked.. thanks!!!
  9. Quique79

    Filter a Record to Print a DataReport

    Hey Fastway!! Thanks for your tip, but I can't do it, something is wrong... In Access 2000 I used to write something like that in a Query Criteria Field [Field]=[Forms]![FormName]![FieldName] to filter, but SQL I don't know how... Please help me!!!! Quique79
  10. Quique79

    Filter a Record to Print a DataReport

    Hi!! I want to print a DataReport (Invoice), I have a form, where I'll select Invoice No. to print it. My question goes to what can I do to take this text contained in Text1.txt to use it to filter a SQL query??? Please Help me!!!! Any tip or hint will be helpful Quique79
  11. Quique79

    SQL Criteria to Filter a record

    .
  12. Quique79

    SQL Criteria to Filter a record

    Hi!!! I want to filter a specific record to print a report, I'will choose the InvoiceNumber that is in a DataCombo, within a Form(PrintForm), I've tried to do something like this: over InvoiceNumber Field of a SQL Command (Data Designer) [Forms]![PrintForm]![InvoiceNo],but it doesn't work...
  13. Quique79

    Invoice

    Hi!! I'm designing a form that will operate as an Invoice, in it, I have used a DataGrid to fill invoice's concept (like product description, amount, etc). In my form, User must give the Invoice No. My question is: when user is filling the datagrid and save the data, it works ok, but the...
  14. Quique79

    Find a Record

    Hey guys... thanks for your help... I have another question, how can I fill the form's text boxes with the record found Any hint or tip? Thanks Quique79
  15. Quique79

    Find a Record

    Hi!! I need to find the IDCompany depending on user selection that matches with the ID For Example Text1.Text= "SCA" 'User selection and I need to obtain the CompanyID that is in the same table (Access Database) in a Text Box for further use IDCompany CompanyName 1...

Part and Inventory Search

Back
Top