Search results

I have a number of text boxes that need to be hidden if they don't contain data and I have tried it on all of them, they all return the same error! The code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(Me!Concern_Details) Or Me!Concern_Details = "" Then...

Nope, the code just doesn't seem to see whether the text box contains any data or not. It can see the txt box, because if I simply enter code that says on open, txtbox.visible = False it disapears on open!!! Just does not seem to be able to tell if it contains data or not. I think it is best to...

Thanks Rabbie, but if I use this code, I get an error that says: The debugger highlights the first line of the code If IsNull(TextBoxThatReceivesValue) Or TextBoxThatReceivesValue = "" Then :(

Hi, I have a line of text boxes on a report that report values via a query. Now sometimes the report may not have any values to display, but the report must still be produced and printed. I have 5 text boxes that, if the query does not return any results, I want these txt boxes to not be...

I am trying to do a similar thing here but I have text boxes on a report that are populated by the reports query. This code does not seem to work. I have tried it on various event procedures but it does not seem to want to work. I have 5 text boxes that, if the query does not return any...

Just as a bit of addtional info, it seems my system tries to open the hyperlink but it does not physically appear, as the document appears in my recent document list in the start menu, but never opens?????????????????????? :confused:

Hi All, I need some assistance. I have a txt box that records a hyperlink on a form. Now to save the user from having to input the file path manually, I have added a button that allows the user to select the file they want to link. The path is then recorded in the txt box. This works fine, but...

Thanks Tony, I will review it and see what I can do with it, looks good. Thanks again.

Thanks Bob, I will check it out and let you know how I get on.

To be honest it is the criteria that is different: I have a button that you simply press to pull up current year records. This will obviously be a common occurence, probably on a daily basis. The other button brings up the same report, but for a past year, that actually is stipulated in an...

Hi all, I have one report that I want the data source to be 2x queries. But I only want it to use "one query or the other" depending on which button is pressed on a form, to open the report. I have tried searching for this solution everywhere, but all I can find is how to create multiple...

HI All, I have a small question. I have a form that can be opened from another form to add a record to a combo box. So if the use looks at the drop down list from the combo box and they cannot see the item they require, they can click a button and "add" the required item to the list. In order...

Here is what the query looks like as it stands at the moment. It is really finding a away to get the major delivery fault thing do downgrade the alphabetical rating as described in my previous post. Location name is the supplier's name. I am not too worried about the error, as this only occurs...

Hi All, I have fought hard to try and figure this out and I have gotten 50% there. I have a query that generates the following calculated fields through numerous calculations etc....: [De-Merit Marks] [No Del with Major Faults] Now the way it should work is that a supplier gets a rating...

***CAUTION*** RANT TO FOLLOW: Spoke too soon. My above solution works up until the point that you save the form :mad:. I may have to look at you solution again though Pat, but I don't know how you get a combo to select both the text and the number? What am I missing? I have now set things up...

Thanks Pat, Your solution didn't seem to help, I think I was overcomplicating things as I failed to mention the lookup list was derived from a query acting as a filter and this seemed to make things worse! So I simply setup a new table, with the items and demerit marks, setup an unbound combo...

Noooooooooooooooooooooooooooooooooooooooooo! Thanks, does this mean there is no specific to solution to this conundrum!? Another way of looking at it is: Is there a better way to do the same thing. I want a table of Issues with related Demerit Marks. On a separate form I want the user to be...

Hi All, I have a lookup list in a field of a table. It is used on a form and contains a list of two field from another table. It is simply a text field and a number field. When the user clicks on the lookup list they see the test and associated number fields in the list. They click on the...

Thanks Ray, but doing this does not work either. It is not differentiating between ticked and unticked, it just shows the total of records with check boxes, not whether they are ticked :confused:!

This is true, but the simple count function just counts all of the records, it is not differentiating between those ticked and those not ticked.