Search results

Hi, I have a report in which I had to display so many fields that it spans the limit of 55cm. I have formatted it carefully so that the first half of the fields appear on one page and the second half on the second page. This all looks fine. My only problem is that my report header also spans...

I have generated an UPDATE statement but keep getting the error message that it was expecting a reserved word. Naturally the statement begins with UPDATE so I can't figure out where the problem is. could someone please take a look and help? UPDATE tblComparativeVolume RIGHT JOIN tblVolumeData...

Thanks Carol for the response. This problem is going to be a little more complex however. Further research is indicating to me that I can't simply use a straight query with parameters that come out of a custom dialog box. What I will have is a the same set of data being pulled out for each...

I have a table of volumes processed for a particular financial quarter including the totals for each month within that quarter. I need to create a series of static information reports from this data. The table is broken down into clients, products and activities with their respective volumes...

Hi, I'm using the docmd.transfertext action to import a .csv file. The file is a softcopy of an invoice. I have the spec set up and I thought everything worked fine. Now I have found that when I import the file using the code it is somehow changing my values in the (monetary) amount field...

I'm doing a custom function to get the last workday in the month. This will be used in an update query on (obviously) the date field. The function first gets the last day of the month. I then test that day with 2 additional functions to see if that day is a Saturday or Sunday. If Saturday...

Thanks for the suggestions. On the report that I'm referring to above this works fine. I actually put those details in under the Vba section where we were also debating this one. However I'm trying to do it in another report within the same database and this one won't work. Again it should...

This is a similar problem to RpbertS's listed a little while ago but unfortunately not yet answered. I have a report with 2 fields that are bound ole objects (scanned signatures). The second signature needs to be printed only if the report contains letters that are barcoded. So I'm trying to...

I have what should be a simple task. I have a command button on one form that opens another form with an SQL string as the linking criteria. Depending on which record I am in, there may or may not be details to show in the second form. At the moment because the second form needs to be read...

Firstly, is there a standard/built in function called Parse()? I'm making addtions to someone else's database and they use this in a piece of code. I can't find any information on this in the Help files and the MSDN Search was typically lacking. I tried tracing it back in the database as well...

Sorry to be a pain!! Thanks again for the suggestions. By changing the recordset to Snapshot though the information in the form can't be updated by the requeries as I scroll through the records. And I tried opening the form with code as acReadOnly but that doesn't seem to make a difference...

Thanks for the suggestion. Unfortunatley, although the requery is only based on 2-3 combos, there are around an additional 40 or so text fields or other combos on the form. I would rather not have to select each individually and set Enabled to No and Locked to Yes. Is there something I can...

I'm trying to make my form completely read-only by changing all the form properties (Allow Filters, Edits, Deletions, Additions, and Data Entry) to No. This worked up until the point where I placed an On Current Event procedure that requeried a couple of Combo Boxes to show the applicable data...

I have a combo box for which the Record Source is an SQL Statement. What is displayed in this combo is the result of selections made in 2 other combos on the same form. All the SQL works fine. When I make my selections from the other combos, the correct (single) selection appears in the first...

I am generating reports that include individual name and address fields (ie. Salutation, Fname, Lname etc). What I wind up with however is a large space after the first name before the last name if the first name is small. Are there any variations or alternatives to the Gan Grow/Shrink...

I have a graph based on a query. It's quite straightforward, a calculation of an average percentage per person per month. The query works fine up to the Print Preview, but somewhere between the preview and the print job the data refreshes. The test data that I'm working from is the month of...

I have a report that prints out 3 to 4 records dependent on criteria selected by the query including date and names. Each of the records has a total percent field which represents the total mark/grade for that record. This field is bound to the underlying table. I would like to show an...