Search results

I have access 2007 with sp1. I have a report designed to print from a label printer(address size label). If i make the label printer my computers default printer, I can setup the page properties just fine, and the labels print just fine. But I can't have it set up this way. I have many other...

I cannot figure out how to stop my query from producting duplicate records. it only happens on the field "TestName" Ive tried all kinds of things including using DISTINCT and DISTINCT ROW Here is some sql that duplicates: SELECT tblAccountInfo.Agency, tblAccountInfo.ReferringPerson...

I'm thinking about upgrading to SQL Server. I have a few questions: 1) How are forms and reports designed? Is SQL server and application that has the graphical design features of Access? 2) Is SQL Server just as effecient using Access as a front end? 3) What is the most common way of...

At what point does one need to get an SQL server, and use SQL as their back end? I want to network access across 30 computers in 10 different locations(outside of LAN), having front end databases on each computer with forms, and the back end to have the tables. Is one terminal server with remote...

There are many people who have this problem, and I can't find a solution. When I open my forms in form view, they FREQUENTLY shrink to so small that you can even see the contents of the form, all you can do is close the form. This only happens when you have forms in pop-up mode. I feel like I...

I need a picture to load every time I select a client name from my combo box. The picture needs to be installed on the computer, not the database. How I want it to work is that when creating a new client i click the "Take Picture" button on my form, a blank screen pops up and I take the...

Drug Testing Database. Issue: I have a table that lists a names of possible drugs that can be tested for. I need to set up pricing for the tests, but I CAN"T price each drug individually(Amphetamines 3.50 Cocaine 3.50). I need to price it by drugs - 1 drug Tested for, 2 drugs tested for, 3...

I have a main form that has a donorID. My subform is connected to my donor ID. When my form loads how to I get a certain field in the subform to create a new record on a table. For instance: Table1 DonorInfo DonorID(PK) Table2 DateTime DateTimeID(PK) DonorID(FK) I need the DateTimeId...

I have a main form that has a donorID. My subform is connected to my donor ID. When my form loads how to I get a certain field in the subform to create a new record on a table. For instance: Table1 DonorInfo DonorID(PK) Table2 DateTime DateTimeID(PK) DonorID(FK) I need the DateTimeId to...

I am trying to figure out what is the best way to lay out my situation. I am designing a drug testing database. I need to be able to "sign" a donor in for a test(s) for drugs. It could be 1 drug, or 5 drugs. When the donor is signed in, i need a date and timestamp to be placed on that test for...