Search results

Hi All, Thanks for your replies! Apologies for the delayed response but I have discovered a way around this using a linked excel spreadsheet. :) Kind regards, Toby

Hi Doc Man, Thanks for your reply! I was contemplating a linked excel spreadsheet. I will give Cartesian JOIN a look. Thanks for your warnings! :)

Hi all, I am trying to make it possible to create a certain number of records where one of the fields is equal to all values in between a specified range. So I have fields A, B and C. I want to specify the range for A (Something in the format of 7290/0001 to 7290/0200). The first four number...

Hi guys, Thanks for help. I was able to find a solution myself over the weekend. Apologies for wasting your time! Kind regards.

Hi all, I want to look up the value of [A] and return all values of [B] that has that value of [A] against it. However I don't want to define the value of [A] myself each time. I want it to look the value up from existing records and each time I add a new one then display them in a...

Do you mean in column B? Then yes. If the second bit is not achievable then no worries. I may "archive" our current data, and start from fresh with only allowing the format of C???.

Nothing like reviving a 13 year old post! I want to do something similar to above but count the number of time the value in column B appears next to/with the value in column A. For example count the number of times "Apple" appears in column B every time "Granny Smith" is in column A and count...

Hi guys, It has been decided by the powers that be, that they want to know the [RER_Number]'s at the end of the row so they can quickly search it up if needs be when entering a new record. Is this possible? Thanks.

Private Sub ButtonName_Click() If ButtonName.Value = True Then Me.Control.Visible = True Me.Control.Height = 2.3 Me.Control.Width = 19.7 Me.Detail.Height = 2.5 Else: Me.Control.Visible = False Me.Control.Height = 1 Me.Control.Width = 1 Me.Detail.Height = 0.75 End If End Sub Is the...

Hi All, I have a toggle button that when clicked will make a sub report appear and when clicked again would make it disappear again. I have tried to do this by assigning a macro to the OnClick to SetProperty visible of Courses_R to True. I then assumed that clicking the toggle button again...

Minty. You have made me and therefore a lot of other people very happy indeed! Thank you very much! :) jdraw thank you for your help also! I'm sorry I didn't explain it well! I'm rubbish at that sort of thing! :D

[RER]=1234 and [RER Suffix]=1 Then [RER_Number]=12341 [RER]=5678 and [RER Suffix]="" Then [RER_Number]=5678 [RER]=9999 and [RER Suffix]=0 Then [RER_Number]=9999 I don't know if you can enter tables on here so sorry this is the best I can do.

Hi All, I am trying to combine two fields into one [RER_Number] from a table in a query using a calulated field and using the expression builder to do so. I want to combine [RER] and [RER Suffix] but only if [RER Suffix] is not blank and does not equal 0. If [RER Suffix] is blank or does equal...

Thank you both for your help! It is now working! :)

Sorry it's been a long day I'm not fully understanding what you are proposing? I need it so that the [RER_Number](s) are visible after entering a serial number on a new record?

By a query you mean by defining a serial number in a dialog box or something? We can sometimes get numerous records at once to enter and don't want to be searching for each serial number as it can be quite time consuming. I wanted this to work so I can work of this and it can "alert" me when a...

Hi All, I am trying to add a Field [Previous_Returns] that looks up the value of Field [Serial_Number] to see if it has been entered before. If it has been entered before then [Previous_Returns] should equal [RER_Number] of the previous entry/entries of [Serial_Number]. If it has not been...

Hi all, I am trying to make some adjustments to an existing database that a previous employee created. There are quite a number of queries in which one particular field "Part_Number" from the table "GRAAN_Data" is called up. I have added another field "Part_Number_2" to the same table. All...

Thanks Minty! :D Best regards.

I have solved it! Private Sub Part_Number_AfterUpdate() If Me.Account_Ref = "ARB20" Then Dim answer As Integer answer = MsgBox("Do you need to enter another part number?", vbYesNo, "Another Part Number?") If answer = 6 Then Me.Part_Number_2.Visible = True Else Me.Part_Number_2.Visible =...