Search results for query: *

I have a query that creates a list of e-mails on the fly from current data. The user uses a form with a drop down selector to run the make table query, and the query uses the critera from the drop down list as type of customer to generate the lists. The problem is...since it is a make table...

I have a combo box that displays peoples names, as well as their ID numbers. When the user selects a person from the list (only their names are displayed) I want to have their name entered in the [OrderPerson] field of the order, and their number entered in the [OrderPersonID] field...

I have a query that I want to use to append a table. I have 10 sets of fields that can be updated, and I want to use the same form to update ANY of the 10 sets of fields. The field names are the same except for the number.....for example...there is a fild in the table called Opt8Choices...

I have a complex database that in one area calculates an order and figures the sales tax if applicable. In this case the 7.75% tax is calculated, and a total is shown. Apparently the customer paid the total, and there is shown a zero balance, but they are still showing up on a recievables...

Can you select one field from multiple fields in a drop down list...and match that to a text field where you type in a value? I'd like to do this search from a separate search form on a button click. I tried this but it doesnt work: Private Sub Command67_Click() On Error GoTo...

I'd like to use a combo box on a search form to list about 5 fields from a different form (Orders)...so we can match any of the fields from the combo box to the value typed into the text field...thus opening the Orders form to the correct records based on the link criterea. That way the user...

I have a table that's basically a spreadsheet of a year's worth of stock closing prices on 100 stocks. I have a macro that runs a series of about 11 querys to compare any two symblos to each other, each one performing a different computation on the data produced from the previous one. What I...

I have a table that's basically a spreadsheet of a year's worth of stock closing prices on 100 stocks. I have a macro that runs a series of about 11 querys to compare any two symblos to each other. What I need to figure out is if there is a way to query the master table to create a list of all...

I have a pretty sophisticated database in place where its on a central server and accessed by about 6 people at once all day long..taking orders, entering payments, printing packing slips...etc. Its been in use a few months, and all of a sudden now it keeps running compact and repair on its...

I read a couple of posts about this but I still can't figure out how to do it. I'm a bit of a novice but I follow instructions very well!!! X-) I have a contacts table with firstname lastname address and city and all 73,000 records are upper case. I want to permanently change them all to...

I have a form with contacts and a subform with calls and notes. I want to make a button that prompts for a keyword(more if possible) from the notes field on the subform and then opens those records. I made a query (keyquery) that brings up the prompt, and finds the correct records. What I want...

I have a contact form with several tabbed subforms. On the Calls tab there is a form with a "notes" field. I'm trying to make a popup search form that will return all the customers with certain "keywords" in the notes field on their call info tab. The notes field is NOT in...

Anyone else ever had this problem. All the settings seem to be correct, but the date shown when you open the calendar form remains at the date I built the form. Really bizarre... Otherwise this date picker form works great. Anyone have any ideas? This is the ActiveX calendar object that comes...

I'm trying to make a mini search form that opens my main form, Orders. I made a simple text box to enter the order ID . The problem is that the Orders Form expects to be opened from another source, so it is looking for the parameter CustomerID. I'm using this code on the button. Private Sub...

Im using this code to update a bunch of records on multiple tables. They're all visible on open forms and sub forms. The last one in the statement - "EmbroideryDetails" was originally on a tab - and the code broke saying "Can't find the Form EmbroideryDetails" . I tried just...

The following code creates a new order, and a new order detail at the same time, which is what I was trying to do. The only problem is I want to set the value of OrderID in the newly created Order detail record, to the OrderID of the new order that was just created. Where I have !OrderID =...

I have multiple forms, and tables that when linked together make what the customer calls an "order" If a client places a re-order of something they ordered in the past, I would like to locate the order using the entry form (no problem) and use a re-order button to duplicate it, with...

I got this code from this site which I got to work. The only problem is that if no image exists that corresponds to the naming in the code...it throws an error. Anyone have any ideas on what I need to add to default it to a default image???? HELP!!! Thanks! Here's the code: It uses the orderID...