Recent content by Alan Harrison

Thanks for that info @isladogs. Pipework is fixed and the garage is drying out. Now all my tools are rusting. I've checked out the web article and I'll have a go at all the suggested settings tonight. Thanks so much for your assistance with this.

Thanks everyone for persevering with this conundrum. I've not made any progress myself. A burst water pipe has distracted me a bit. Just another thing. As I type this I'm seeing random spots float down my display just like snow. Is this a special AccessWorld Christmas effect? It's only on this...

I'm running two monitors. One is at 2560 x1440 and the second is 1920 x 1200. The issue occurs on both screens. I'm using windows 11 on an updated version of Office 365 Access I dug out an old laptop running windows 10 and Access 2007. I fired up the same database and that works just fine. The...

Thanks for your quick response. I quickly downloaded the Access inventory DB to see if it was my app that was causing the problem. This screenshot shows the same issue still occurs. This is full screen. Scrolling makes no difference. I don't use tabs anywhere. My menu page which is just a title...

Hi Access friends Since going over to Office 365 the record selector bar at the bottom of the screen is partially covered over. It's the same on all my forms. I didn't realize how much I used them before. So far I have tried the following to fix this. Textsize. Screen resolution. Different...

Has anyone any further information on this? I'm running Access 2007. The problem seems to have cropped up after installing Windows 10.

Many thanks for your input CB. In my frustration I deleted everything and started again only to find my query worked perfectly. I have no idea what was wrong but it held me up for hours.

Good morning All. Could someone give me advice on query criteria please. I'm want to retrieve the criteria from a subform. Using the expression builder I got. Forms![A_Sales]![A_SalesinvSubF]!Form![Stock number] When this is entered into the criteria box square brackets are automaticly added...

Yes Al that's what I did. Linking the tables from the laptop seemed to take an age. Probably about 90 seconds before they linked but I don't think that's a connected issue. I didn't get a chance to try again today. With only one person able to get into the DB there's a bit of a queue building...

Ha! Spoke too soon. Everything was working fine so I moved the 2003 version of the BE on to my office PC and I'm back to the same problem. As far as I can tell, everything is the same on my Home PC (where I do all the mods to the DB) as on the office PC. I'm going to try moving the BE to the...

Thanks for your help Al. I converted back and everything is fine now. Being able to use the Offce button and save as previous version made it easy. regards

Doh! Just noticed I'm four years late with this reply

This is my conversion from meters to Feet and Inches.. The formula below returns the result of two fields Length [SizeL] and Width [SizeW] where [SizeL] is the length in metres and [SizeW] is the width in metres. Set the control source of a text box to...

I've just upgraded from Access 2003 to 2007 on my desktop PC. My Front End converted to 2007 format without problems and I created an .accde file. My FE is linked to my BE which resides in the same folder. I kept the BE in the 2003 format because I still run 2003 on my laptop and I want to...

Doh!! Why didn't I ask 3 hours ago? Thank you. Thank you. Thank you.:o