Search results

As further clarification - on the left of the subform you will see the list of Positions from 1 to 6. All i want to do is to insert whatever position number along with its matching position number in these textboxes. The subforms data is from a query

Hi guys and thank you. Its probably less complicated than i explained so i''l try and let you know where i am so far. The buttons work a treat and i can already change there backcolor with code which works great and when i click on them my code also inserts the position number of the button...

Hi everyone, This is beyond my current capabilities so i will try to explain: In the form attached you will see six buttons in pairs. Each button is numbered e.g. Btn1 - Btn6 I have been able to insert the position number which correlates to the button number into the table and corresponding...

Hi Guys, To conclude then - I used CJ's method which is working very well but i understand that earlier versions of Access do not have this ability. Thank you everyone

Yes, point taken. Think i will work on that now i have a better idea of how to achieve it. Many thanks everyone

Strange, nothing happened?

Hi Minty and thank you What i did was this: Dim Location As String Location = Me.LocationRef.Column(1) If IsNull("DescriptionRef") Or IsNull("LocationRef") Then Cancel = True Else DoCmd.OpenForm Location Which worked as well but i found out why it wasn't working - Some...

Surely this isn't hard but I just cannot find what i am looking for! When the user clicks on a save button of a form i want another form to open whose name is the text (Location) from the combobox (LocationRef) on the the current form. So basically there are forms called by the name of every...

Thank you guys for all your replies. They are ideas to consider. I will come back here to conclude later

Hi, Not sure if this is possible? I have a table of items that are used for records in a field of the main table. So in the lookup table: Item 1 is a purple disc (BMP object) Item 2 is a red disc (BMP object) Item 3 is a blues disc " " and so on So when the related record in the main table...

Ok finally back at work and the penny dropped in the end. Sorry for my stupidity but thank you to all of you and your patience! In the end i now have this: If IsNull(Quantity) Then DoCmd.Beep MsgBox "You must enter a quantity", vbExclamation, "Tanera Asset Maintenance System"...

? I don't know but i'll have a look. I just think i am too stupid to do this sort of thing

I dont know whats going on but whatever i try it is not preventing empty text and also just bypasses it and jumps to the next section of code to confirm? I stepped through it all and cannot see what the problem is?! I have to go soon but will have to come back to it later. I need a drink!

Thank you very much for your help! Here is the full code of what i am trying to do. Its all from a 'Save' button on the subform Private Sub SavePartsBtn_Click() On Error GoTo SavePartsBtn_Click_Err If IsNull Forms("OrderMachineParts").PartsSubform.Form.Quantity Then Dim Msg, Style...

Seeing as my dementia is getting worse i just cannot solve this despite trying endless things, referring to past projects and trying numerous examples online!!! All i am trying to do is to ensure that at textbox 'Quantity' on my 'PartsSubform' (Which is a continuous form) which is a subform on...

Wow amazing replies - Thank you. I am going to look at all this right now and hopefully fix it. In answer to your questions Pat: Tech is only for Servicing and only one Tech responsible for each service when conducted. When i deploy the app i go through it with the users as we work for the...

I dont know how i can incorporate Service and Maintenance into the same table as they record different things and some different components? The Recordsetclone code was given to me from a previous problem by Arnel. Thats all i know at this stage?

Hi everyone, I hope i can describe this correctly? I have been working on this particular problem on and off for around 5 weeks now and after trying so many ideas and orders of operation it still will not work. Basically what i am trying to do is after entering a new status from the...

Hi Guys, Thank you both for your help and advice which is gratefully received. I implemented Vlad's input and it appears to be working now

Hi, here i am again. I have a form (ViewVessel) with a tabbed form on it with a subform on one of the tabs (MaintenanceSubform). On the 'MaintenanceSubform' i have a combobox control 'Status' whose RowSource is a table 'Status'. Column(0) is the primary key and there are three items in the...