Search results

Hold that Cheers!! I want to nail this one first! Ok so, basic use I have already found is to change a format of a font color From what I can see I can't set conditional formatting on a checkbox, so I have turned my attention to the control that needs to meet the condition in order...

Ah my apologies VBA, it is Friday after all I must be slacking and gunning for the exits!!! Nice one! I actually only started using Conditional Formatting over the past few weeks to set font color on a control if a condition is met. I never thought of using it here but the same...

Hi VBA, Thanks for the reply, however at this point updating the data is not what I want to achieve. The bound checkbox I mention is disabled by default in the form design. On form_load or the test button I have on the form, only if another bound text box on the same record has data...

Hi JHB, thanks for your prompt reply. The checkbox is definitely bound. As for the name, I tend to change my field and variable names before posting! Just habit! The checkbox is actually called "Pricing_Signoff" Here's the real stuff! Dim rstPricingForm As...

Good morning all, I have a bound continuous tabular form, that pulls in my data that I need. However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown...

Update to the above code...... I have utilized the DateAdd function to add 30 minutes to the current time The cDate function then changes my field string value to time, and compares against the time() + 30 minutes variable I set earlier. This allows my form to show upcoming deadlines 30...

Hi Mark, Many thanks for your suggestion and I think that will suit me as it will get upcoming deadlines if they are approaching. I do have a loop working, but it is only showing me the latest past deadline Dim sFirst As String Dim sResult As String Dim rs...

Don't tell me!! Getting there! Recordset is setup and I can loop through each value and display it utilizing recordset.Fields("Field Name") Dim sFirst As String Dim sSecond As String Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT...

I have a form with continuous sub form. The main form contains a combobox, populated from a query which pulls in specific data (time) from a table The subform is linked to the combo box on the main form. Based on the combobox selection, the subform updates with associated records with the...

Good stuff out of you CJ! I have used plenty of parent / child code in another form of this project! So this should be a doddle!! :D No need for the multi select. I'll give it agai Cheers again LarryB

Good morning CJ, Many thanks for your reply. It seems expanding the listbox is the only option. The font size is already at 8, so I do not want to reduce anymore if it is at all possible. Is there anyway that a listbox can be manipulated to force data onto the next line, so instead of...

Good morning all! I have a listbox on my form, which has a column count of 2, and widths 1.7cm, and 15cm respectively. The width of the listbox itself is 9.2cm In form view when the listbox is active, there is a horizontal scroll bar, it does scroll to the left, but not right to the...

Thanks again CJ for your input I have never used replace() before and I'll put this to use. Thanks again Regards LarryB

simples! If InStr(1, S, chr(34)) Then MsgBox ("There are quotation marks in my box") End If

OK using the instr() function I can find the comma If InStr(1, S, ",") Then MsgBox ("There's a comma in my box!") End If Struggling with finding the quotation marks " I'm looking at ways of using ascii code chr(34)

Hi all I am adding additional code to help make the function fail safe. This code requires the user to separate the input criteria with quotation marks and comma's, eg "id","id" How can I check for the required characters in the string? Basically if they do not exist then exit function...

Many thanks CJ. Although a form is not what I need in this instance but I just remembered that I have used code before to generate quries and assign SQL statements using VBA In my case here I want to retrieve data from multiple tables and export to excel. Here is my code, plus your code...

Many thanks CJ OK I have decided to use a public function containing the code that I hope to call at a later stage I can confirm that the user input is updating the Select string with the multiple values. I'm not too worried about the inverts and comma's required How do I now use the...

Hi all, Is it possible to run a basic select query to pull records based on multiple strings entered by a user? I have a query with field criteria - Like '*' & [Type In MMDBID:-] & '*' This allows the user to input one MMDBID and the records are retrieved from the db. I can also use the...

RESOLVED - Switchboard - Call Switchboard from VBA code? I got this working using the following code [Forms]!Switchboard.Filter = "[ItemNumber] = 0 AND [SwitchboardID] = 2" Note the main switchboard needs to be open before using the code. This code was input in code module as a public...