Search results

hi all so basically I have the following FrmFullDetails SFRMStaffDetails SFRMOfficeDetails The sub forms are big enough so when you scroll down on the main form you can see it (no scroll bars within the subforms), problem I have when you click into a subform field you are unable to scroll up...

perfect thank you! is this the same code if there is a subform within another subform, just trying to learn how it works for future?

Hi all I ham trying to have some headers with some relivant info across the top I have 3 forms FrmFullDetails SFRMStaffDetails SFRMOfficeDetails In the form header of Full Details I want a TextBox to show relevant information so when the user scrolls down the page this stays at the top of the...

Hi all I have a main form within that I have 2 subforms one under each other, I want to try and make it look like its all on one form so I have expanded them all to the correct size and removed the scroll bars from the subforms and left the main vertical scroll bar in place, the issue I have now...

hi all thanks for all the comments! I haven't been ignoring unfortunately work has been very busy :( Strive, thanks for the code, should this not be in the TEXTBOX001 after update?

Hi all I have a textbox named Staff Number the numbers are one letter followed by 6 digits how to I do a popup window to stay it must be the letters G F or R followed by 6 numbers, if its not done correctly a message box pops up?

just a quick thing, If on my form I was to add another field for location to the form for staffs location, if I create a new record and select the staff if automatically adds their location which is fine, if for what ever reason I change the location on that record it changes the previous record...

Hi mate thank you for the below, I would have ZIPPED the file but its been disabled on our computers :), ill have a look and see what you have done and compare, thank you

Hi mate sorry for the delay, the relationships etc were already done for me automatically I didn't touch them, I have changed it about a little, the lookups now look from the queries but still have the above issue rather than any further suggestions...

Hi mate this is a quick mock-up of my database, there is a lot more info but thought be best keep it minimal https://drive.google.com/file/d/15h6mL5gTmotq4-z749B5noLvGWHafubW/view?usp=sharing

sorry I am not too great with access still really learning :(, I have no idea what you mean :(

Vba thanks for the reply, on my table it shows the text My widths were on 0cm,2cm,2cm if I put a >0cm value in the primary key shows not the text?

Hi mate Thanks for the quick Reply, yes I have used the lookup from the Table Level, I have never done it from the Query side, can you provide any help on how to do this? didn't even know that was possible

Hi all I have a combo box (CmbStaffDetails) box showing a list of staff from a query named (QRYStaffDetails_InPost) this query shows what staff members are currently working. I Have three tables TBLStaffDetails StaffID (Primary Key / AutoNumber) Forename Surname Location (Lookup from...

thanks guys ill have a play later!

Hi all hope your all keeping safe during these strange times! wonder if you can help with three questions below :) 1: I have a form with 50 odd text boxes and depending on the drop down choice at the top I want them to be greyed out or not if the field names were for example: Txtbox01 Txtbox02...

Hello June thank you for the reply, I really do need it in the table if possible, in this instance no the customer wont have more than one record :)

Hi all I have a Subform within a main form I need a textbox on the main form that calculates a total number of records in the sub form and needs to save to the main table, I have tried a few different methods without any success, I have even tried calculating the record numbers on the SubForm...

Afternoon Mate thank you for the reply, that's kinda what I need but it seems to only update when I move onto another record and back, also is there a way for that value to be saved into the table? I managed to do it this way cheating I know but still doesn't save to my table In the Subform...

Not my actual Database but an example of it and in the same format, I want the number of items in the main form to count the number of records from the sub form