Search results

Gmail should work with Outlook so if you can manage this, then there is lots of help in the forum for what you need to do. Typically, a piece of code like this would do. Public Sub eMailJobSheet(streMail As String, myJobNo As Long, myClient As Long) lngNo = myJobNo ' for filter on R-Print...

Yes John's idea is along the lines of what I was going to suggest, although using a Public Variable that you increment by + 1 would also do the trick.

What I may be tempted to try is to put your code in a Public Module and then call the Sub from the buttons on the Switchboard in the usual way - Command 8. With the sub maybe something like this Public Sub mySwitchboardButton() Application.Echo False ' stops the screen refreshing so the...

Not quite sure I understand fully but if you were able to run an Append query when a ceratin event triggers in your main form, you will be able to automatically add records to any subform. The key here may be to decide upon the Main Form event and then of course, what data do you want to add to...

Its easy if you use the Outlook Object model. Is that a possibility?

Not exactly ground breaking but this code I put together opened up other opportunities to use it as the Docmd.Outputto code requires a query and for a variety of reasons, I did not want to create one. The Form FP-Dates is nothing more than two unbound controls that are the date range. Remember...

As I see it, the problem arises because you are not using a table as a RecordSource which would have an autonumber field present. This begs the question why> Perhaps if you could answer this question, someone may be able to help. :)

You need to step through the code using a break point and then pressing F8 to find the line that errors. Failing that, try opening the code module and select Debug and Compile, which may show the problem line. Post that line here. One thing I have noticed in your post, and it may just be a...

If you can pick the code out of these elements attached then the button on the Contact form with a 'Bell' on it [ stands for laBEL ], then this is a solution that works well for J8163. The interesting part of the technique is where the chosen position for one label on the sheet of blank labels...

It seems to be that what you are asking for requires the values of various fields to be concatenated together to provide the somewhat complex code to which you refer. My advice, for what its worth, would be to use a standard incremental (autonaumber) PropertyID field for each record. By all...

There is no simple way of doing this. Sure, you can write a module of code to do this but to provide that here would require a great deal more information from you. For example, you have not said anything about the format in which you would like these addresses to be printed, i.e. labels...

Sounds like a plan. "Ignorance?" Never. This forum is here to help and sometimes we all miss the obvious, like I did yesterday in another post.

Thanks Bob - my workaround with the SQL works fine but I appreciate your comments. Now you mention it, it is of course obvious!

Nope - but I am now. Kool!

As requested. At the moment the Form is set to AllowEdits = No. The troublesome field is the red one. Just look at the last part of the Load code. If you open the form now it will not be in ReadOnly. - try changing the Tonnage figure as that is not locked. Then make the red box unbound and...

Yes and thanks to Dev - here is the code Option Compare Database Option Explicit 'This code was originally written by Dev Ashish. 'It is not to be altered or distributed except as part of an application. 'You are free to use it in any application provided the copyright notice is left...

Have you tried using the code Dim str As String str = InputBox("What Company are you searching for?", "Company") str = "*" & str & "*" DoCmd.FindRecord str, , True, , True

On the assumption (always dangerous) that your Customer_Orders_Query is a table containing all the orders and that each order has a date, you could try putting a (Date) Criteria in this Query such that when it runs, it only totals up to the date you require. Something like this may do <=...

How about introducing a CheckBox into each that is set to Yes as the default with all previous records are set to No. When your code runs, it sets all the Yes to No. In which case all you need to do BEFOREHAND is COUNT all the Yes and No's.

It would be better to have one field per hyperlink as I am not aware that you can join together hyperlinks. In any respect, if you could you would need to separate them to get them to hyperlink. If you were then to produce a new table with (say) 3 hyperlinks displayed as 3 records, then all...