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

? What do you mean? Do you have an idea of how i can fix this?

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

thanks, that was the perfect answer

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

How do I go about in access, to have a button on a form, that when a user clicks, it opens to the file that has all of the pictures, and they can select the right one? And also, do you know of any "middleware" that I can try out?

Pricing The last post is exactly what it is. 1 drug = x 2 drug = 2x, how do i go about doing that?

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

Tables It is structured that way, the only problem is I would like access to calculate that pricing for me automatically, to avoid user errors

Pictures The pictures are of clients(so when they come in we can pull up each record) the files will need to be stored on a network server so all computers can access the pictures. No video, just pictures, probably small ones 256X256. What do I need to do to get what I want? Do I need to...

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

Price of Tests Yes I want to charge for tests. 1 Test = 1 Panel 2 Tests = 2 Panel and so forth. Perhaps I can write some VBA that has access count how many drugs are selected as some type of count function, and depending on the number it retrieves is what the price will be? I could make a table...

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

New Record Yes, but how do I get that new record to contain the donorID number(which has already been selected on the main form) donorID is the (FK) on my datetime table(which gets a new datetime record just fine. My problem is I don't know how to get access to put the donorID number in the FK...

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

Which Table Which table then would the fields, Positive, Negative, and PositiveValue go in? And if its that last table you listed, how do those results associate themselves with the certain test?

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