Search results

I have to do a similar thing in the near future. I'm going to use "Application.Run"

Well spotted Poirot! You spotted my Hastings-like error and as a result, the inhabitants of Hove can look forward to many good nights out! :D

from the information you give, I'm taking a guess that the ID field is a combo box which displays the ID (hidden) and the name (displayed)? If so, replace Me.Form.ID with Me.Form.ID.Column(1). If not, can you be a bit more specific about the field displayed on the form that you wish to push...

Yes, Helen's page is very good. Just looking at your SQL I think you need to change objWord.MailMerge.DataSource.QueryString = "SELECT tblBookings.*, FROM tblBookings" & _ "WHERE ((BookingID = " & Me.BookingID & "))" to objWord.MailMerge.DataSource.QueryString = "SELECT...

I've not used Winfax in a very long time but it appears as a stanard printer to the app, no? If so, you should just be able to set the reports printer to your winfax printer and print teh report as normal. I'm assuming that you can then enter the fax number etc manually after that. Have a...

Hi Set-by-step guide. Hope I haven't missed anything. I assume you already have a word document with all of the merge fields and formatting etc set up. 1. Create a command button on your form. In its OnClick event type the following code. strFilename =...

Note sure I have an answer but some things perhaps to try 1. Does Chart1.gif look Ok if you open it in MS Paint or similar program? 2. Try changing your default printer in access and/or changing settings related to quality. 3. Export the file as a .jpeg and see if you get the same problem. 4...

Glad it worked for you:)

HTH. Let me know if you have any probs with the above.

1. Create an unbound form. 2. Set up a text field field (or combo or listbox, however you want the user to choose which report to open) 3. If using a combo or list box, set up the options correctly (ie options discate which report to open EN, MA etc) 4. Create a command button 5. On the...

Well, I don't know if there are other ways which are cleaner but in Excel you can use the Charts .Export method to save the chart as a.GIF (or .JPG if you prefer) formatted file. In Access report design, insert an object from a file making sure the link to file checkbox is checked. Just make...

Had the same problem myself. i don't know why it does this. I solved it by using a fully qualified path name to all files referenced in the .bat file

No probs, I've implmented a work-around

Hi I think this is the correct forum to place this question - apologies if not. Bascially teh set-up I have is this. I have to produce a graph showing quarterly numbers for a (varying) number of regions. Unfortunatly, some of the data is missing. I can interpolate this missing data by using...

Agree with all the above, but think that should be firstrec = DFirst(serial, tablename) based on the OP's description of the problem

If you don't want access to be openeed, it sound like the best way to do it would be from Excel querying the .mdb file directly (Microsoft Query) or through ODBC. As regards the combo box, it can either reside directly on the spreadsheet, or on a custom dialog in Excel.

From your description of your function, you could use the built-in DateDiff() function instead of your custom one.

My VBA is pretty reasonable. My thought in posting this was that this would be something that would be possible to execute in an SQL query. I reckon I could write this in VBA, thanks for the offer of help though Thanks for the pointer as well!

Good question. There is a PK already defined and is an auto-number field, so it will be sufficient to use that to order calls. Cheers

Hi I wonder if anyone can help me out on a db i have inherited. Basically I need to add a field to a table and backfill the field with a number depending on a date field. The new field (CallID) needs to record the order in which calls are received on a certain date (CallDate in the table). So...