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

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

I loop thu a table to get field names myArray(iCounter) = "[" & rstTableName.Fields("DJPR-Import") & "]" into an array as I need them for a query ie "SELECT DJPR1." & myArray(0) & ", DJPR1.[READY TIME],... My issue is that if the field name is one word it works ok however when there are...

Hi, I have been trying using a USB on my router to run Access. Has anyone tried or give advice on this method. I am aware to run on cloud drives. Regards Peter

Hi, I am having issues with the DSum and tried different ways of putting it none worked. My latest is: vIncAmt = DSum("[IncAmt]", "Income" And "[IncDate] between #06/03/2021# and #06/25/2021#") This one gives me a Type mismatch. Any ideas what I am doing wrong. Thanks

Hi, I have been playing around with MS Access during lockdown (Victoria Australia) and have just discovered that you can set your Onedrive and Google drive to also be hosting. What this then give you is from Access you can directly export what you like to your Local drive and then use a...

Hi, During covid-19 lock down (Victoria Australia, another 9 days to go:) I thought I would upgrade my MS Access skills. My project is one where I am trying to link/export MS Access tables to webhosting and display on website. I have the MS Access tables and website figured, what I need is some...

Hi, Can you tell me the best (possibly free) manual writing software for my Access database. I have notes on each field but my boss wants a manual. Thanks Peter

Hi, Hope you can help. As per the title, how do I find finding the 1st,2nd,3rd or 4th Wednesday (whatever) of the month given month and year? Thanks Peter