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

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

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?

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

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

HELP, So simple yet I can get it to work!!! Hello, I am trying to do a simple invoice database!! Just 4 tables, Customers, Products, Invoice, Invoice Detail. When I make my form for the invoice everything seems to be ok, I pull up my customer and then I add products to the invoice. Fisrt...

Hello everyone, I am in the process of building a database for a turf selling company. One thing that they asked me to do was the following. They want to identify the price of the product that they will give the customer depending on the price level that customer has. Example: I Toms Landscape...

Hello, I need to make a small schedule program to schedule jobs, tests ect. does anyone have a program like this that I can take a look at and get an idea on how to make it. Also to get permission to change it if I can use it? Thanks everyone, Daniboy

Hello Guys, I have a VB Application that I created in a Spanish VB Version, I made it an exe application. Now when I try to install it on a Windows XP English Version I get an erro that says "Type Mismatch" Does language have anything to do with this? Thanks, DaniBoy

Hello, I am making a simple 2 table database for a client. Its only a Customer Table and a Workorder Table. Here is my problem: There is a text field called "Job_Num" on the Customer's table that never changes, The client wanted to have the workorder number to be the "Job_Number + the...

Hello, I have a person that want to make a database contact list. That part is easy, but then he surprised me :confused: he wants to connect his phone line to his computer and to have somekind of caller id system that actualy pulls up the contact record of the number that is calling the...

Ok, I have made one table and one DAP on MS Access. I them exported the DAP as html to be able to upload it to my website. I then uploaded the .mdb and html to my site. Everything seems to be working fine, I can view all my records on my site. The problem that I have is that when I add a new...

Hello, I have been looking for some info on how to do this: I have a form to input apartment complexes info, there I also have a subform where to put the units number, like 201,202,203 ect. I also have a form called leaseinformation. there I can put the tenants info and I get to pick what...

Hello, I dont know what happend!! the IS department actualy messed everything up!!!! They did something with the server and now my databeases give me this error!!! The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data...