Search results

Hi All, I have a form with numerous toggle buttons on. When first loading the form nothing happens when clicking the toggle buttons. Hovering over changes the colour and they aren't grayed out to indicate they aren't enabled. However when I open design view (I CHANGE NOTHING) then go back into...

Hi again, Apologies for the delay! I used: Dim rervalue As String rervalue = [RER] Me.PRQ.Form.Filter = "[Previous_Returns_Q].[RER]<>'" & rervalue & "'" Me.PRQ.Form.FilterOn = True And it seems to be working now! I want the form to be in datasheet view and the subform results are shown as a...

Hi RuralGuy, I'll have to try this tomorrow. 1000 things just hit my desk! Many thanks!

On Serial Number yes.

The subform record source is Query1. Query1 pulls values from TableA. Parent form record source is TableA.

I know the feeling well! I look forward to your reply!

Well that information is already available if you see what I mean? Preferably I wouldn't like to duplicate information being shown. If a user sees the same RER number on the parent from and sub form they may think there is a difference between the records. I'm trying to make it less confusing...

Hi All, I am looking to filter my subform records. Maybe. I have two fields: RER Number Serial Number My subform shows the RER Number of all the records in which that Serial Number has been entered before. However it shows the current parent RER Number also. I tried applying a filter to the...

You Sir have reached the legendary status! Thank you!

Hi, So I have a field in a table that will actually store numbers. I have had to make it text field as a serial numbers will be formatted as 1234/9876 which wouldn't work in a number field. Other serial numbers may also be formatted as 5 or 6 digits without any other characters. The code is...

Hi Both! Thank you for your replies! I have managed to finally get it working with the use of Cancel = True. I'll try your method CJ and see if it works just for fun! :) Thanks again!

Hi, Is there a way I can keep the focus on the current control if an If statement is false? But if true move to another field? I currently have: Private Sub TestStage_AfterUpdate() If Unit_Type <> "SP2240" And TestStage = "ESSPASS" And PreESS_FTP = "NO" Then MsgBox "My text"...

I always wanted to make it look a bit neater but once a code worked I never wanted to muck it up so didn't dare touch it! I'm completely self taught on Access so far by browsing existing databases at my firm and applying aspects to my one so I've been keeping it simple so far but I'll give that...

I knew it was simple! Thank you!

Hi all again! I am writing what I thought was a simple bit of VBA but have become stuck. I am getting this error on the line: If Unit_Type = "SP2240" Or "SP2241" Or "SP2242" Or "SP2270" Or "SP2271" Or "SP2280" Then The rest of the code is just simple: PreESS_Tested.Visible = False I feel...

I managed to find away around this using an excel spreadsheet (we have to fill this anyway) and by typing the IDD_Number number is able to find the file and gather all the information needed. Thanks for sticking with me! Anyone reading this looking for answers I would highly recommend checking...

That was a method I considered but I would prefer the "IDD Number" to almost be an auto number field but for each set of serial numbers. So 18000 for the first set of 10, 18001 for the next set of 4 for example. I'd rather not have my user's looking up the last IDD number and entering it...

Hi Uncle Gizmo! I have come across your "Create Many Records" before actually and really helped me with one of my projects so thank you very much for that! The only issue I have for this case is that the "Serial Number(s)" won't necessarily be sequential. The Serial Numbers will be entered by...

I'm not at all familiar with looping in VBA so I may need to waffle... I am looking to create a form that, when opened, asks for a "Date", "Quantity" and "Serial number(s)" all in separate input boxes preferably. How do I accomplish this so that the number of input boxes that appear for "Serial...

Hi All, Is there a way of allowing some duplicates through in column A but only if column B equals a certain value? I would define the value(s) in column B and this would allow any entry into column A any number of times. Otherwise duplicates are not allowed in A. Thanks.