Search results

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

Hello, I have simple invoice database, tyhe old one I made works fine, trying to make a newone always simple but now Access is not helping me for some reason,,,, Can you look at this? I create an invoice form using wizzard i join invoices and invoices details to it and from there I create my...

Hello, I have been killing myself trying to make a simple invoice database. It only has four tables.... clients, products, invoice, invoice_details.... Well its been a while since I have used access and I wanted to make this simple database for my cousins small hardware store. All my...

Hello all, I am trying to make a simple inventory control system. This system will only record input of products and output of products. Explanation: This is a catering service company. I buy tomatoes, rice, oinions, Oils, meat, ect. When we buy this products they usaly come in different...

Hello I need to create a small DB for our Apartment Complex. Its basicaly just to keep track of leases and peyments. Here is what the DB need to do. I need to have Tenants info and Apartment info on the DB, for this I create two different tables, tblTenants and tblApartment. So far I'm doing...

Hello, I am trying to make a query where it will give me the following resutls: I have a form where I have a Delivery Date. The user needs to be able to check what the delivery schedule is for the next two weeks. This way they can decide when they can deliver the product to the customer. I...