Recent content by pekajo

Hi, Hope this is not to complicated. I have a [startdate] and a [finishdate] fields and want to show all the people who will be working on a [selecteddate] (variable). [startdate] = #01/03/2024# [finishdate] #/01/05/2024# For everyone who will be at work between these dates and will be at...

Hi, Many years ago I used Skype to make calls from MS Access to mobile phones etc. Can anyone tell me if this still works or if they have another provider that will do the work. If you do can you send the code so I can use it. Thanks for any help. Peter

Hi, Does anyone know if it is possible to create an outlook type calendar to run on access? Thanks for any help. Peter

Hi, I am using the build in contact form using the php version but am having a issue that I think the browsers may not run php on the hosting site. That is, it works on my browser (Braver) but not on Edge both are on the same PC. If this is true is there a way around this issue. Thanks Peter

Hi, Hope you can help on 2 questions. 1. What are the pros and cons of migrating my ms access tables to sql and moving to an sql server. and using ms access as a front end. (forms, queries and reports) 2. Advice on the easiest way of doing the conversion. Thanks for any help. Peter

Hi, Can someone help in a DSum function. The following works aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt") But when I want to add another AND statement it does not aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt" & " AND [Incyy]...

Cheers

Hi, I am starting to play around with migrating my tables to an SQL sever and have 3questions. 1. Can anyone point me to good information on the migration I can read or watch. 2. Does the FE use MS access to add/delete/edit the tables on the server or SQL. That is, if I have a form do I have to...

Hi, A simple question I have been meaning to ask. When using VBA what is the difference between using ! and . in say DoCmd.GoToRecord , , acPrevious vg = Me.IncGiven I know the 'Me' but not the '.' Thanks Peter

HI, Just a suggestion, if you pivot the one record to a one column in excel and import the data which would be one field with all the records(Column) data and start from there. Peter

Hi, What is the simplest vba way of FTPing html file to hosting. Thanks for any help. Peter

This is a great idea however I am not able to see how I can duplicate other object like the original video. Tried copying the original text box and the code but it only moved the first box. Any ideas? Peter

Hi, Thanks for all the helpful advice. I should explain what I am trying to achieve as there maybe a better way. I am printing business card labels. There are 10 business cards to a page. If I have used the first 3 labels I want to start the labels at position 4 on the used sheet. So I add 3...

Now getting the message

On Format