Search results

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

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