Search results

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

Hi, Youtube seems to have changed. Search 'create google drive for hosting' there are a number of videos that explain the concept. Peter

Not to sure what you are asking?

Ok, Coming at a totally different angle. If you only want data from the database to be accessed from the internet ie reports etc. you may want to look at this youtube I found. What this does is make a Google drive look like Hosting so is accessed via the internet. On your computer it will just...

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

Hi, Just solved the issue. Peter

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, Thanks for the quick reply. I may have not made myself clear. I plan on putting the data on USB router and having clients on the PC's. It seems to be working OK on my home network but only have one PC so will need to try on a bigger network. Peter

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

You may remember Easytreive ! (spelling?)

Hi, Just a thought, before I started using MS Access I used a now out of date product called Paradox from Coral Draw. I did some major databases using it as it also had coding. Try finding a copy and having a look at it. Peter

Hi, See 'Onedrive/Google drive Hosting' https://www.access-programmers.co.uk/forums/threads/onedrive-google-drive-hosting.319353/ on this forum. on this forum Peter

Hi, Just an update. I have found a simple solution to this issue, please read Post Onedrive/Google drive Hosting Peter

Hi, I did not think that this would cause such an issue. As Pat above has stated this is not about Access. Forget Access, I put this post on this forum as a lot of businesses use access to run their business. As part of this process they may need to get information from Access out to the 'field'...

Hi, I am so sorry I should have explained a bit more clearly. I have a database that produces all the reports, excel and html etc but had no way of getting them onto the net easily for ease of distribution, at present it is via attachments to emails. By using this method you can export them to...

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