Search results

Ah OK thanks for clearing that up, this means that my problem is a bit more complicated than I thought !! Going to try a few more things before posting the whole shebang. Thanks again Paul.

Hello, Quick question: When you do a RunSQL Update "tablename" Set Field1='" & Me.text1 & "', Field2='" & Me.text2 & "' etc etc , do the field names need to be in the same order as they go in the table, and what happens if you are only updating say the 2nd field 4th field and the last two...

Solved the issue of not being able to change the font size in datasheet view ... if anyone's interested ... You have to open the subform in datasheet view then change the font size via the ribbon <Home - Text Formatting> For some reason datasheets ignore all font settings set in the design...

Hmm, not really got my head around what anchoring was all about :confused: I think i'm just going to whack a 17" on my desk at work and resize things for the lowest used resolution (1024x768) and see how it all looks, then go from there if it still needs tweaking. Just want to be able to...

Sorry spikepl but I have to disagree with you !! If you write something in font size 10 on a monitor running at 1280x1024 it will physically look smaller than if you displayed the same text on a monitor running at 800x600, because it is scaling it. so : I need to reduce my form sizes down...

Hi spikepl , I think you misunderstand me slightly... I fully understand that you can't get as much on a smaller screen than a larger one ! But the issue I have is that I can't change the text size in the Access forms, no matter what PC or monitor I run it on, it's the not the text size of the...

OK thanks chaps. I did try some VBA code that was designed for Access 2003 I think, that was supposed to be able to re-size the forms based on the users resolution, but it didn't work. It's probably well beyond my knowledge level at the moment to code this myself. And I'd rather not have to...

Hello all, Just wandering what people here do about testing your Access DB's on different screen sizes. Other than physically using a 17" monitor or using VMWare or alternative, is there any monitor emulators out there ? I've done a quick search, but it looks like there are plenty of web apps...

Ah ... didn't know that... Thanks GTH (Dave)

I actually didn't know you could have themes in Access !! Unless it is because I used the wizard to create the navigation form ? which I know some may frown upon. I will fiddle more ;) I'll read up on the movesize function and give that a go - thanks. I did read back along that you can hide...

Yay thanks Gina, You the Girl :D This is getting manic !! trying to work on my database, whilst watching a number of threads, cooking dinner and trying to stop dog from eating said dinner :eek: Thanks again, that one issue resolved.

Hello, My access has just started to do strange things :eek: When I close a form after making changes, it now doesn't ask to save. It does appear to be saving, but just doesn't ask if I want to save !! I've been working on a database all day, and it's just started doing this half way through...

Hi Gina, Thanks for the reply. More info: I have a Navigation form that has 6 subforms that nest within the NavigationSubForm. Each subform is in datasheet view. From within the Navsubform and for each separate subform, I selected all of the label and text boxes and then changed the font size...

Hello, I need to make the text size smaller to fit everything on the screen (users use 17" monitors.. grr!) I have gone into each form and subform and changed the text size for each text box to 9, but when I view them in form view the size has not changed ? Am I missing something really...

Hi Isskintm, Thanks a zillion !! I did actually modify it a bit as your method was automatically activating the OK button and then throwing up a error message regarding the setfocus (i think because the form had closed) So I put the password check code back into the cmdOK_Click event and kept...

Hi Isskint, I sort of understand what your saying, but .. The OK button is the where the password verification happens, so unless there is some access quirk that I'm not aware of (there will be many) would it not matter how many times someone entered random letters ? Also, no it's not holding...

Hi all, back again ! I have had to put my DB on hold while working on another project. Just trying to finish things off now. I couldn't really find the right words to describe what I want in the title ! So.. what I have is a password entry popup, it's very simple and there is only one...

Thanks JHB, That's spot on !! As always I learn something new every day :) It's very strange that the count function works fine in all other form environments but not when used in a navigation form. I'm really happy that this issue is sorted thanks to you, I can pretty much finish the DB off...

OK thanks JHB. Pretty much removed all forms, tables, queries and reports as they were all tagged with corporate logos, dbase is set to open the nav form in question. Thanks for taking a look. BTW I have tried building the function with the expression builder, before anyone asks (or suggests...

Further thoughts: I think the issue (and I say this as a Access newbie/numpty) is that the "NavigationSubform" is actually a placeholder for the subforms that are then populated into "NavigationSubform" when the appropriate button is pressed. But based on all of my recent history of learning...