Search results for query: *

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

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

Hey guys.. thanks for your help Quique79

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

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

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

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

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

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

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

.

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

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

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

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