Search results

Hi, I have a bit of a problem in that I have two same databases and have updated one and now I need to import the new forms from one to the other as I have only updated the forms. Is there a way of finding out when forms designs were last changed which should give me an indication what forms I...

Hi, Can anyone tell how to export a time field to spreadsheet as hh:mm only. My short date also includes the date 00/01/1900 08:45:00 Thanks Peter

Hi, Does anyone have a script to email an attachment that does not use Outlook as I use Thunderbird. Bot Perplexity and Gptchat cannot manage it. Thanks Peter

Hi, Can anyone give me advice or example of producing a ghantt chart in ms access Thanks for any help Peter

Hi, Has anyone been able to Integrating online payment system to Ms access? Regards Peter

Hi, Has anyone managed to integrate and online payment site with MS Access or will I have to just download. The data base is local. Thanks for any help Peter

Hi, Is Ms Access able to connect to an online payment platform that will integrate with MS access, which is not online, and if so can you give me some leads on how it works Thanks Peter

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]...

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, What is the simplest vba way of FTPing html file to hosting. Thanks for any help. Peter

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

Hi, Hope you can help. I have two arrays and want to use to edit a table. For example this is what it looks like normally: rs1.Edit rs1![Ready Date] = "[R Date]" rs1.Update rs1.MoveNext This is what I am after: rs1.Edit myarray1(1) = myarray2(1) rs1.Update rs1.MoveNext...