Search results

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

Hi , I am using the following code in the Detail of a report. Reports!R_PreCard![PName].Visible = (Reports!R_PreCard![PSurname] <> "a") but am getting popup message: 'Object doesn't support this Property or Method.' Can anyone help as to why? Thanks Peter

Hi, Is there a vba way of changing the conditional formatting expression. I want to change [MonC] = 1,2,3 .. on each of the conditions to [TueC] = 1,2,3 .. Thanks for any help Peter

Hi, I have a form with two field [IncChk] and [IncTotal]. [IncChk] is a Yes/No field [IncTotal] is a number. My question is I want to mark a couple of rows on the form and display the Sum of the selected rows only, in a textbox on the form. Any ideas? Thanks Peter

You are absolutely correct and no way would I have a BE on OneDrive . This idea is more about web design than Access. Most websites need up-to-date data and as for me the data comes from Access. Until I learnt this trick I had to create the report/excel and then have an upload to my website now...

Just an update when adding a BE and installing the FE on another computer find and use UNC path when Linking the BE as it is the same for all PC' on the network. Found out the hard way. Peter