Search results for query: *

I posted a while back and got a couple different suggestions on what to do but they only solved part of the problem....I have to be able to pull up a report based on 2 things...One: is that the "Status" field must say "Registered Lead", Second: is that the "Date...

I need some help on writing a bit of code for a command button...I need it pop up a report based on some criteria...First one of the fields has to say "Registered Lead"...I've got that part figured out...The next criteria is that the field "Date Entered" has to be equal to 6...

On one of my forms there is a subform where the user can add a new entry to an existing record, for example the date....The main form (where the subform is located) and subform are related by the GageNumber-There are 2 tables in my database- one for the basic info for a piece of equipment, This...

I have a simple form that is used to add a new entry to a table...it works perfect but now I need to make sure that when a new one is added (a customer name) it is not already in the table....so I figured I'd need some sort of lookup, etc. I tried to make the text box into a combo box and then...

Hi - (Using Access 2K) On one of my forms I am using an option group to change the recordsource of my combo box. The option group has 3 options to chose from "First", "Second" or "Third" each of these representing a different table in the database. Each one is very...

I'm trying to run a query using a criteria expression. The query contains all the info for a 'customer phone book'. In the table that the query is run from there is a column called RepCode. If that column has a 999 in it then I don't want that record displayed in the query. I've tried using Not...

I have a simple database that requires some sort of form that allows the user to choose a certain customer, address(street addr or billing addr), and the type of label...1" or 3 1/3". I've tried to use a suggestion that I received from this same forum. I tired to run the reports off of...

I need to be able to choose a customer name and then a range of dates to produce a report that shows activities during those dates. I have already created a form with a combo box that contains the customer names and 2 text boxes where dates can be typed in. Here is the code that I've been...

I have a subform which contains activity information. It lists all of the acitivites for a certain day. Each activity has it's own ID number(primary key). I already have the form itself set up so that when the user types in the ID into a text box and clicks on a command button, the report will...

I have a combo box which contains a Hotel name, street address, city, state, zip and the auto number that it is assigned when it is first entered into the database. I have a form which allows a user to choose a customer which then pops up a 'prefered' hotel. This is displayed in 3 text boxes...

I have a simpe database that contains one table. This table contains Model#, Manufacturer, Description & Price fields. I have created a form so that the user can search for the equipment for a certain Manufacturer. But the problem is that when I create a combo box using the wizard to look up a...

I already have a post on here about this form but no one seems to no how to answer it. So I guess I'll ask a smaller question first. I have 4 text boxes on a form. Each will have a number in them. I also have another text box on the form named Totals. How do I get it so that the numbers in the...

I have to add 5 columns of new info to an already existing record. I have 4 text boxes on a form each of which contain a dollar amount (Lodging, Meals, Gas, & Misc). Then I have another text box, Totals. I know that you can't calculate columns across and I also know that you can't do this in a...

I have a small program that allows a user to schedule an "On-Site Job" There is a form that the user fills in, the info is stored, and a report is created. Now after this report is given to a technician and the job is completed I would like to enter the trip expenses into that same job...

Is it possible to total 4 fields in a query? I've been trying everything. What does the expression have to look like for the column that will add the other 4 columns? I have tried the following: Sum([LodgingCost]+[MealsCost]+[GasCost]+[MiscCost]) But I get the error - Extra paranthesis. I've...

I have a database that contains the following fields: Model#, Manufacturer, Description & Price Both the Model# and Manufacturer fields could be repeated/duplicated. I need to search by manufacturer, have a subform pop up that would list all of the records for that particular manuf. Then I'd...

How can I tell if my database is Table-type or dyna-set?? I know I should know this.........

I've posted a message about an editing form before and no one seemed to know much aobut it. I figured out what was wrong. I was just pulling up the whole table/the first record was highlighted, instead of a specific record in that table. What I need to do now is have the record, that the combo...

I need to create a form that when a JobID in a combo box is chosen the rest of the information for that record is displayed in the appropriate text boxes. I then need to be able to make changes to that information. I also have 2 subforms that are related to that same record (through the JobID)...

Does anyone know where I can get a good VBA book---general stuff about writing in code? Or a certain title? I've written some minor programs in MS Access but now I'm starting in Excel. Everything is in code whereas in Access I could get away with using some macros. Everyone tells me that Excel...