Search results

Greetings! I have a report that is grouped by a field called GroupCode. The GroupCode can be either a 0 or a 1. Essentially, this is intended to divide the report in half, so to speak. What I want to do is show the group footer after the first group, but not after the second group. Something...

Hi there, I wasn't sure whether to post in reports or queries, as I do want to end up with a report. I reckon it will all start with a query, however, so here goes.. I have a situation where I will be keeping track of people that are registered for a convention. Now, each person will be...

Good morning, I would like to place a line after groups of records based on a value in the record. For example: Record 1 1.05 Record 2 5.77 Record 3 9.87 --------------- Record 4 10.50 Record 5 17.66 --------------- Record 6 23.00 --------------- Record 7 36.99 Record 8 38.99...

Good Morning, I am having a heck of a time trying to get a report to line up properly! The report is to print out a large number of membership cards, on to pre-printed card stock. There are 3 cards on each page, with no margins at the top, bottom, or side of the pre-printed form. The cards...

Hello, I suspect there *should* be an easy way to do what I want, but I am having difficulty getting it right. Here goes... Let's say I have the basic tables ORDERS and ORDERLINES. Each order can have many orderlines. Now, I've created a query that gets the following: From ORDERS: orderID...

Hello, I have created a report that will act as a calendar. It contains 35 unbound text boxes and 35 subreports. Each subreport is linked to one of the text boxes. Now, the idea is to populate the text boxes with dates upon opening the report. The subreports will then each disply the...

Hello, I would like to have two combo boxes on a form (in datasheet view), where the contents of combobox number two are determined by a selection made in combobox number one. I read the Microsoft article on this subject, which explains why combobox number two will show blank records when...

Hi there, I want to have the simplest of charts on a form, but am with absolutely no clue as to what I'm doing! First, here is an idea of what I want this chart to look like: Payable ********************** Outstanding **************** Received ****** I have a query that gets the 3...

Hello, I have placed a linked image in a report that previews and prints just fine on one machine, but does not appear on two other machines. The image is located in a specific folder, which I have ensured exists exactly as on the one machine where the image works. Other images, such as some...

Hello, OK, here is my best attempt at explaining what is causing me a great deal of grief! I have a form, with a combobox and a listbox. Selecting an item from the combobox causes the listbox to be requeried. The query for the listbox contents needs the value from the selected item in the...

Hello, I have a text box on a form, which is bound to a number field in a table (type: single, 2 decimal places). I only want to allow values between -20.00 and 20.00. This part is no problem for me. However, I would also like to limit the choices to be multiples of 0.25. (ex.: 0.25, 0.50...

Hi there, I have a date/time field in a table where I have set the format to "mm/dd/yyyy". Oh, I should mention that my Regional setting is "US English". Now, I have a form to add a record to this table, with this date field defaulting to today's date (Date()). I have set the format for this...

Hi there, I have a form with a bunch of text boxes, etc. that eventually runs an append query to add the record to a table. One of the text boxes' contents is to be added as a memo field in the table. When I enter in a large amount of text (more than 255 characters), I recieve an "Invalid...

Hello, I have placed some vertical lines in the detail section of a report, to act as dividing lines between groups of related columns. A couple of the text fields have their CanGrow property set to true, as sometimes they are longer than average, and need to be seen. Is there a way to have...

Hello, I would like to be able to count the number of occurances of a particular time during a specified date/time range. For example: Start: September 1, 2001 7:00 AM End: September 3, 2001 9:00 AM 8:00 AM occurs 3 times during this range. Is there a way to have Access provide me with...

Hello, Is it possible to change the mouse pointer on an Access form to something other than the 5 or 6 choices documented by Microsoft? (Hourglass, I-Beam, etc.) I want to make a label behave like a hyperlink, and have the mouse pointer turn to the hand on the on_mouse_move event. (and of...

Heelo there, I have a text box on a form, along with a button that runs an Append query. The value of the text box is appended to a Memo Field in a table. Upon entering a larger amount of text (could be more than 255 characters), the append query doesn't seem to work. If I place a text box...

Hello, I have made a form and used a bunch of labels with hyperlinks to a series of reports. I've added some code to the reports themselves to display a MsgBox when there is no data. I also set Cancel = True to stop the report from opening. When I click on a hyperlink to a form with no...

Hello, Well, I am encountering a similar problem with a few reports that I am building. Each record in the underlying query/table has a number of Yes/No Fields. I would like to provide a count of the "Yes's" for each of these fields in my report. So, it would look something like this: Field1...

Hello , I would like to set a textBox on a form to a default date of the 1st of the next month. Sooo, if it is July 26, 2001 today, and I open the form up, I would the like the text box to display August 1, 2001 (actually, it would be in the short date format: 26-Jul-2001 here). Any...