Search results for query: *

:^) THE SITUATION: I have 2 database files. One is open to multiple people for data entry. In the other only I have access. I review the entries and if acceptable I append or copy them to the secure database. :-( THE PROBLEM: I am copying from one table to another table and each has an...

Here is how I did this without writing code... 1) Create a delete query to delete all records in "Table A". 2) Create an append query to add in the new data to "Table A". 3) Create a Copy of "Table A" with no records. I'll call this "Table B". Both tables...

The fields I use are a size field and a dollar field. The size field runs from 1000 to 100,000. The dollar field runs from $5.00 to $250.00 The chart is a line type. I don't know how to submit a volume of data in this forum. If I can send you sample data directly please let me know. I don't...

I have users entering parameters which are picked up by a query to select records and display in a report with a chart. The chart is only part of the report and is small. I need to limit the data points to a maximum of about 15 but it is possible to get up to 1500 records. THE PROBLEM...

I have a report generated by a query. The query with find about 1 to 500 records. Each record with vary in length of pages due to a memo field of varying size. I need to print 1 or all of the records but need the page numbering to start over with each record such as Page 1 of 3 then Page 2 of 3...

I need to take selected items from a mult-Select listbox on a FORM and display them on a REPORT. I can get the selected items to print to the debug screen but listboxes or textboxes don't have the same funtionality on reports that they do on forms so I'm having trouble getting the information...

When a user clicks on a combo box list and selects an item on the list, then changes their mind and wishes no selection. How do you do that? Control-click does not seem to work. Does this take special programming? s-) Culby

MattBeas: I'm fairly sure you can delete all the record in the table, but if you are going to add and delete records on each use you may need to compress the database regularly to keep it from growing too large. It is my understanding that when you delete you just delete the reference to the...

zerosandones ... Thank you for the reply! I think you are exactly right. BUT... as unplausible as it may sound, here is what happened. I did as you suggested and you were right! I did somehow change the display setting for my main table under the lookup tab for the Yes/No field. I had selected a...

I want to display a Yes/No field in a form displaying as a checkbox. If it's checked, its "Yes". If its not checked, its "No". Simple right? Wrong! I can get this type of display in a query display. I can get it when I put it in a form, BUT...... When I use the same form as...

zerosandones: Thanks for the reply. I see what you are saying and I'll try this out, but won't this result in the photos and large comment areas displaying between each line of the other text since it is in the detail section? I'm trying to get the spreadsheet like data together with the...

I'm having a problem similar to one address before in this forum but I don't understand all the stuff you guys (and gals)were talking about. Any help would be appreciated greatly! Here is the goal: I have created a form to display data (photos, and long comments) from a table. I have created a...

Doug and Robert: I'm having a similar problem but I don't understand all the stuff you guys were talking about. Any help would be appreciated greatly! Here is the goal: I have created a form to display data (photos, and long comments) from a table. I have created a subform based on a query...