Recent content by DaniBoy

Hello, I need help on this simple procedure: I have two forms, in form1 I have a textfield name file1 that I input any if info, than on form2 I have another textfield name file2. What i want to do is that when I press my comand botton it gets the value of file1 and puts it in file2? Can you...

Hello, I have a table that has many duplicate records. I tried importing the table and setting the field to no duplicates but did not work. How can I delete duplicate records. The primary Id id fine I have another field that I can use. it is a BAC number that is repeated many times. Here is the...

Hello, I have a form that updates a field on the event "On Current". I like to make a command botton that will go through all the records on this form, as if I am pressing the goto next record botton automaticaly. I know I have to do a do loop but I dont know the syntax, can you send me the...

Yes its always been a continues form, I am actualy building the db. If I didnt had to choose the department and only pick the product I wouldnt have any problems, but the client uses the same product code for different departments, example: Department Plumming 10" galvanize tube Product Code is...

Hello, I have an invoice form with its detail subform that I have been stuck with for a while. The main problem is on the detail subform, here is what I have: 1. I have 5 fields, DepartmentID, ProductID, Qty, Price, Total. 2. The department is a combobox and I want to select the department...

thanks I will try that

Hello, How can I make my DB dectect the users computer screen resolution and adjust my forms and reports to it? What is hapening is that is I make the DB on 1024/168 and than the user uses 800/600 the forms and reports look huge..... Is there a way to fix this automaticaly?

Thanks Doc, I figured it out, it was as simple as picking my nose!!!! hehehehe, its been a while since I used access and what seemed like nothing than meant a lot this time.... It was an event, afterupdate event.... Sorry for the waste of time!!!:(

Did anyone figured out how to do what I need to do? On invoice details I have to combo boxes I first select the Department combo box, than I want the product combobox to only give me the products from that department. thanks

thanks Keith, I did upload it is called tools.zip

sorry here is the attachemnet

I tried to do the example on the listbox combo example db but I just cant get it to work here is a copy of the database to see if you can helkp me out. on the form Facturas=Invoices on the detail I need to first select the department and than select the product that is on that department...

Hello, Yes they will also select the product from a different combo box on the detail form. thanks

Hello, I have an invoice form where ofcourse I have a invoice detail subform, I got everything working fine so far, but now I need to do an update to this form and I dont know how to do this. I have the following tables on my DB: Clients Products Departments Invoices Invoice_Detail Now each...

got it working !!!! Hello got it to work it was an update event missing!!! thanks