Search results

Hi all, Sure this is a simple one :): I have two fields - [TimeFrom] and [TimeTo] which are storing short times. Is there a module or query syntax that will calculate the hours / minutes between the two? Presently I'm running a simple query which is [TimeTo]-[TimeFrom]. This is fine except...

Hi, Thanks for your response. Would this work en-masse though? (IE I have 32K lines of data with all different postodes). Thanks again.

Hi all, If anyone can help I'd be very grateful! I'm trying to trim a postcode (easy) so that only the first two letters are left (finding not easy). The issue I have is: AB21 4LF S21 2RE IE I'm after AB S If I trim from left or right based on the a space and characters to remove, the...

Thanks for that - I'll give it a try

Hi all, I have the below code that will create an outlook event and populate the fields as required. I'm trying to modify this so that instead of opening an email outlook event, it opens an SMS event (I've got the add in installed). Private Sub Command127_Click() Dim Olk As...

Thanks, helpful?

Hi, Thanks for your response and appologies for my late reply!! Okay, details... I've developed a data management sytem for an independent charity. They are recording information on paper forms when they are off site then transferring this into my db. The db itself is my largest one...

Hi, Thanks for your response. In regards of requirements, it's quite simple. Once I deliver a db, I just need a way for me to remotely access it so that I can make changes etc. By default my client will also need remote access. I did think about going the Citrix remote desktop route, or...

Hi all, Hope someone can help please? What's the best way for me to give customer remote access to my databases? I'm thinking of putting them on a servers desktop then letting them remote desktop onto this... Thanks for any help in advance.

Hi all, I've forged on and got myself in a jam I think... Basically, I've been building db's for small clients and got to the point whereby I need to have remote access to the db to carry out routine amendements etc. So, where I'm at is that I'm renting a dedicated Windows 2008 server. My...

What a star!! Thanks a lot.:)

Hi all, I'm banging my head a little on this one... I'm try to set a condition in a control on a form that will warn a user if they have input an incorrect tariff code. I'm trying: If [TariffCode] = "28258000" Or "28332600" Then MsgBox "Tariff Code Accepted", vbInformation, "User Update"...

Brilliant - now working - that's had me stumped for a while. Thanks a lot!!

Hi, I've put together the below code for merging text into a dotx document (it has the bookmarks in already). Dim AddyLineVar As String, SalutationVar As String If IsNull([ContactSurname]) Then AddLineVar = [Company_SchoolName] SalutationVar = "Sir Or Madam" Else AddyLineVar =...

Hi all, I'm just after a little general advice if anyone is able to help me please? I'm due to supply a database for the first time to a client. My plan was to 'rent' a dedicated server and put the database on there. My client would then be given the logon details for the server, and from the...

You Sir, are a star!! Thanks so much for the assistance!

Hi all, Still a bit of a novice with VBA and could d with a hand please.. I've got some VBA code working to take information from a loaded form and create an outlook event without any major issues. I'm really struggling to get it to add a CC & BCC field. The code I'm using is: Dim Olk As...

Hi, Thanks for the response. Do you mean in the criteria line in the query or as a SQL statement in a module?

Hi, I'm buliding a reporting suite which will primarily run by initially asking for a From Date & To Date. I'm fine to put this into a query, however as there will be multiple proceedures before the end result, I don't want my users having to put in a Date From & Date To each time a new...

Thanks for the help - I'll take a look through these - have a good one and thanks again!!