Search results

Populate a lookup table on the fly Hello All, I have a database where I'm tracking the continuing education classes that employees have taken. In the database I have the course name as a lookup field that refers to tblCourseLookup. In this table all I have are the course names Some names are...

Got it THANKS neileg you got me pointed in the right direction!!

Ok I did the =Sum([Cost])+Sum([Hotel])+Sum([Gas])+Sum([Other]) and that got me the correct $ amount. Now how do I subtract that from 10000?

I have a database that tracks Continuing Education classes attended by employees. On the form I enter the employee, class, Cost, Gas, and Hotel. I have a report that gives me a total sum for each of the Cost, Gas, Hotel and Other fields (=sum([Cost])) now I want to add the totals of those 4...

Just curious if anyone out there has done any ASP programming? I need help with a small change. Any suggestions on where to get help? Thanks, Rick

How do I group by client?

What does that mean? I'm not an access guru.

Hi all, I have a database that I created that is for our social workers. They enter their contact with their clients in this and then at the end of the month they need to print a couple reports out and mail them to the state. I have the report but I need help grouping the output. My report is...

I just ended up copying and pasting all my query's, forms, reports, etc.. into the proper areas in the BE database. Then I renamed it to mdb. Everything seems OK. Not exactly what I wanted to do but it was the only thing I could think of to accomplish what I wanted.

I used the database splitter to split my database but now I need to do some testing on it and I don't want to use the REAL thing. So I copied the database but I'm still linked to the REAL data. How do I "unsplit" or bring everything back into 1 database? Thanks, Rick

I am working on a database to be used with our Juvenile Detention Center and I'm running into a problem on how to tie the tables together. Here is what I have. I have 6 main tables Residents Guardians InvPersons Admissions Careplan Discharge My main Residents table stores data about the...

Hi all, I have a form that we use that list outstanding work orders. This form is a Continous Form and it has such things as Work order number, Contact Person, Priority, and due date. Being a continous form the actual form is just 1 line but when you view the form it lists all outstanding work...

How do I combine 3 name fields? I have 3 seperate fields LName (Last Name - Public), FName (First Name - John), and MIName (Middle Initial - Q). How do I get Reports, Forms, and/or Lookups to display in 1 field Public, John Q Thanks Rick

Thanks mrabrams that did it!!!

I had just the DMAX statement and it worked fine. I tried adding the IF THEN stuff and now I get the error. Ionly want my DMAX statment to run if the ID field is blank. If there already is a ID I don't want it replaced. Sorry about the reply post Doc_Man I noticed my mistake and I thought I...

What I'm trying to do is if the ID field is blank the do the DMAX command If ID isn't blank then display the msgbox. I get Run-Time error '424' object required Here is my code: Private Sub AssignID_Click() If Me.ID Is Null Then Me.ID = DMax("ID", "tblResidents") + 1 End If...

I have an ID field that I want to function basically like an autonumber field. I don't want it to be an autonumber field because I want to pick the starting number. So I'd like to have it give me the next available number in sequence when I click a button. If I can assign a starting number...

Hi Everyone, I've got a database that all I'm trying to do is on one form I have a users record on the screen I double click a button and I want it to open up a different form, start a new record, and copy the users name from the first form to the new form. Sounds simple but I can't get it to...

Thanks Hayley, I've never heard of a Query by Form (QBF). Once I have the QBF in place will I be able to have it ask me which field I want it to check? If so then I think we are on the right track here. Any assistance you can give me on the QBF would be greatly appreciated. Thanks,

Hello Everyone, I have a database that our department uses (IT department). In this database we track PC specs (HD size, RAM...). We also track software installed on that PC (Win '95, 2000, NT Bridge, INsyte...) Now on the software I have the software name and a check box next to it. If the...