Search results

Hi Everyone, I just cannot get my head round this one and the more i try the more confused i am! I have to open a form to warn us to re-stock. So i am setting it for the Form - On Load event and also when the remaining level goes below the reorder level. So i need to create something like...

Hi, Been working on this for sometime but cant quite get it. If this can be solved then the system is a goer if not its scrapped. I am trying to make an efficient booking system that has to integrate with the users current well established Excel spreadsheet. I have to be able to enter a string...

Hi guys I have a form called 'PitchAllocate' on which there are buttons which relate to pitches on a campsite. When the user clicks on the button a modal form called 'EnterEmail' is displayed where the user simply types in the guests email address and hits the 'Enter' key and the email is sent...

This is rather annoying and baffling at the moment. This whole little system works but there are two anomalies preventing it from being perfect. The first is in the 'control measures' section of the 'Main body' report where i am getting duplicates which i really need to prevent. And secondly...

Hi guys, Trying to work out the best way to achieve this? I have a table 'Booking' with fields 'BookingID' PK and other detail fields but also a field named 'Position'. I have a form with a map and on it i have up to 113 buttons (Btn1 - Btn113) When the user clicks the button it inserts the...

Hi again, Been working on this for a long time and getting more confused. I have tried so many different things but I think I now have to ask for help I'm afraid. I have an active DB which is working fine apart from this minor but important part. From the view all Items form, the user...

Hi again, As i don't fully understand the code below i get the above error only when i add an image to a new record i have entered in the subform as in the attachment. It fails at this line - rstMain.Edit Once i select Save and then go back in again it allows me to add the image with no...

Hi, Now this worked before but for some reason it is throwing the error message - Runtime Error '13' Type mismatch at this line: Set fldAttach = rstAttach.Fields("FileData") I've set breakpoints and broken it down and checked the tables and associated forms but still get the same error? Here...

Hi, I had this working but now need to insert multiple rows for an item (Description) into either one record in Excel or each row into their own row while keeping PONumber, Supplier, SiteID, Date and Ordered for the same. The main form - frmPO has the continuous subform - StoresTempSubFrm on it...

Hi, Can someone give me a clue here? Tried multiple things and its not quite there. I need to attach an image using the EmployeeID and also the CertID. Call AddAttachment("EmployeeCert", "CertImage", "EmployeeID", Me.EmployeeID " & " "CertID", Me.CertID) But it is failing at the ampersand...

I had all this working perfectly from outlook before we swapped over to outlook 365. So from the form frmPO i have this code: Private Sub OrderValue_AfterUpdate() Dim mailTo As String Dim Body As String Dim Subject As String ' Dim attch As String Dim lngWhite As Long...

Hi, I have 6 subforms that i want to use on multiple forms. So to save creating a great many additional subforms and associated queries i am trying to make the subform queries dynamic. At the moment i have this in the query criteria: [Parent]![LocationRef] But it isnt working? The subforms...

Hi everyone, I have been on this thing on and off for months now and it is so close but due to my uselessness and plain stupidity i just cannot get this last bit working!!! Obviously i am as usual missing something but i feel i am just chasing errors around??????? I send entered data from an...

Hi, Being self taught i do not fully understand all vba functions and procedures and which best to use yet. I have this code: Private Sub Form_Current() Me!Position1QrySubform.Form!Type.SetFocus If Me!Position1QrySubform.Form!Type = "Foam" Then Me.Btn1.BackColor = RGB(255, 228, 181) Else If...

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...

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...

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...

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...

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, 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...