Search results

Aesthetically there are differences. Some of the functions in Outlook are not available in 365 (vice versa?). When you open a 365 calendar it still says Outlook at the top. I use both at work, but much prefer the desktop version to the 365.

Hi Have a search for information on the ListObject object. This contains the properties and methods you may be looking for.

You just need a Delete query for the relevant table. EG DELETE [Portal Mail List].* FROM [Portal Mail List]; This will delete all the records leaving it blank for import. Either run it before import (if you use the data after import) or after.

Are you removing the file used for import OR the data in the table you import to? Kill will work with the file and an action query (delete) would resolve the import table.

If you set your taskbar buttons property to "Never Combine", you should get the custom Icon HOWEVER you also get the labels (which i hide normally). No option to never hide + no lables:banghead: Only downside now, is every instance of an app opens seperatly, so the bar fills up tooooo quick.

You say you are using a query as the source of your continuous form records, so =Dsum("[Score]","[SOURCEQUERY]") {where [SOURCEQUERY] is the name of your query} in a textbbox should do.

If you have multiple Customers in the access table, so which one do you export (how do you decide) to the spreadsheet? You could use automation to send the relevant values to the corresponding cells (using VBA open excel, then loop through your recordset 'sending' each item to the correct cell)...

That is the flaw of my method :banghead:. The more records you have and the more days you want to show on the calendar, the slower it gets. That said, i know an attendance diary i set up a couple of years ago, handles 350 employees, with records over 5 years, showing 7 days on the diary form and...

Dmax() function should get you the right % value. Dmax("[ID]","[Table]","[EffectiveDate]=<" & [testdate]) will give you the ID. Add that to a Dlookup() for the rate; Dlookup("[Rate]","[Table]","[ID]=" & Dmax("[ID]","[Table]","[EffectiveDate]=<" & [testdate]) )

hi James I suppose the first question is how is a numeric field storing non numeric values? That aside, so long as the CaseID does not contain non numeric characters (eg its a number but formatted as text), i would think the following using Val() should work...

Please see attached demo of my approach. Its very basic but the principles can be expanded easily enough. When you update the rootdate on BookingDiary form (normally rootdate would be invizible) the diary is adjusted. The colours are worked from conditional formats. I have used this approach...

Hi Barry, the way i approach calendar displays on forms is to use x number of unbound text boxes for the dates, in the forms header (x = days to show 7,14 etc). You can then add all types of controls to change the displayed dates (move day by day, week by week, month by month etc). Then create...

A hyperlink uses a word or phrase to anchor the hyperlink to (the bit that is underlined and in a different colour). Normally in a Word doc you would highlight the word/phrase and add the hyperlink OR use the add hyperlink function. That is what you need to do in VBA. So, in your original post...

Hi DevAccess You would use the Hyperlinks.Add method. Leave the anchor word out of the text you are writing and then just use the .Add method after that. So in your example leave out the last word paragraph; .Text = "this is paragraph where in there would be text url in within a "...

hi bigal If you have one form that is always open (a menu form?), the easiest way is to use the OnClose event of a form to update the log. If you use a button to close the database, add the code there.

Hi, Not a lot for us to go on there. How is it "not working"? what error messages are you getting? How are you generating the QR string? I have used ID Automation in the past without any problems, although that was standard barcodes.

Hi John just an amendment to your code from 'Set the ATTACHMENT field. I have used StrHyperlink instead of strFileName 'Set the ATTACHMENT field '-------------------------------------------------------------------------------------- If Not IsNull(StrHyperlink) Then...

You do not have any code to assign the file path to your variable after setting it to Empty. If the attachment location varies, then have a look at the FileDialog Property to allow the user to navigate windows explorer for the file. If the attachment name/location is the same, set your variable...

too many &'s :banghead: try, "firstname LIKE '*" & Me.textBox2 & "*' AND surname LIKE '*" & textBox1 & "*'" Make sure you don't miss the single quotes '

hi Create a template with that signature and use the CreateItemFromTemplate method. Alternatively, use .Display earlier (after Set OutlookMail = OutlookApp.CreateItem(0)) and then assign the current body of the email (which is just the signature) to a variable - signature = OutlookMail.body...