Search results

I am having exactly the same issue. Well mine is that my sub reports have queries built into them to determine whather a record exists in order to display the sub report or not. If there is no record to display it does not display the form, but it does leave a blank page. Can anyone help with...

Is the form open? If it is not open and active then it will ask for the information manually

Hi All, I have tried searching for this but I don't really know what to look for. I have A main table that is populated by a form. I then have another table that collects data and is related the main table by a common field (a One to Many relationship). I then have a separate form to...

Well done Rabbie, great stuff. Works perfectly this time. I did think there was a need to adjust the brackets around the field criteria, but I could not figure it to work properly. At last the code for entering up to 3 email addresses from 3 fileds in a specific form is...

Actaully I spoke too soon! There is a type mistmatch error with that code! Will have to try and see if all the formatting is correct!

Excellent work Rabbie, but unfortuantely it is too long for the Macro field! It may work if I reduce the amount of people for it to be sent to. I have done this and reduced the amount in the "To" field to three. The fourth can just appear in the CC field, it's not a problem. Thanks for your help!

Cheers Rabbie but I am not sure how to do that! :confused:

This is an excellent bit of information on the sendobject macro. THANK YOU! I have used this to full effect, enabling me to send out notifications of a concern that has been raised to a select group of people as stated on my form!!! I used the following to send the notification to more than...

To remove the menu bar from view on start up, you need to change your start up options: Go to Tools, Start Up. There you can check and uncheck all the toolbars and whether the Database window (the one with all your tables, forms, macros etc..) appears etc..... Then when you open whatever is...

Thanks Doc Man, I did think that there would be a problem with IE (or any other browser for that matter) having issues with viewers. The only other answer would be to implement any forms that I want linked in Infopath. This would allow me to obtain any data that a user inputs into a form and...

HI All, I have scoured the net and these forums looking for the answer but cannot find a good solution. I am producing flow charts in Visio, and then saving them as HTML documents for use on our Intranet. Within the Visio flow diagrams I am using Hyperlinks on various shapes and text, to...

Ok, with help from Chergh, I have cracked the code required: If Not IsNull(Me.txtcustomer) Then strWhere = strWhere & "(" For i = 1 To 4 strWhere = strWhere & "([Customer " & i & "] Like '*" & Me.txtcustomer & "*') OR " Next i End If...

OK figured out (well someone else did, thanks Chergh) how to get it to look at all cutomer fields. Now I am having problems with the syntax! I get run time error 3075. I have tried all of the following varients: If Not IsNull(Me.txtcustomer) Then for i = 1 to 4 strWhere = strWhere &...

HI all, I have a relatively straightforward filter working on a search form where a string is built based on the criteria entered in the form. Easy peasey while you have one Txt or Cmb box on the form each filtering through one filed in the records, but what if I want one txt box to filer...

Yeah and again, Allan, thanks.......just what I needed.

Excellent, thanks Ruralguy! I thought it was something to do with that because I have only ever used this function on number fields! I had spent ages trying to figure out where to put the """, but thanks, you have made it work! :D

Hi Bob, Yeah the records exist, the form that contains the button actually derives it's records from the same table as the form I am trying to open. It is a summary of non-conforming parts. You can then view details of the parts and edit the data contained for those parts by clicking the...

Hi all, I am really stuck as to why this is happening. I have the following code, whereby a button opens a form on a certain record depending upon the part number field selected on the current form. The code used for this button is as follows: Private Sub showrecord_Click() Dim stDocName...

That's what I am trying to do...but I am unsure how or where to apply the query? I know I am missing something really obvious here! Is it applied to the forms events tab? Sorry I am still learning this Access milarky!

Ok I have successfully created a query that utilises Dmax and one that utilises Dlookup +1, but how do I get it to record into the field of choice whenever a new record is added? I have tried adding the query to the default value of the field but it does not work. I am lost as to how I can...