Search results

Just cheated and copied and pasted from a word doc

Hi here it is, thanks for the reply

Hello everybody, Ive been struggling with this for the last day or so. I've tried 2 ways. I am trying to insert text (names/address etc) into the body of an email (with terms and conditions etc) that has been loaded as a template in MS Access. The problem is I need a check box in the email body...

Thanks Pat I found a work around for that last problem. I have this working now, Ii dont think I'm at the point where I can design a Navigation form from scratch yet , but will have a look when ive finished this project

Thanks for that reply, ok so as a work around at the moment. Ive created a query in SQL that has 2 columns , 1 row. In one column is the value in the navigation subform that gets looked up in the other column is the answer. So when I click on the textbox in the nav subform, this qry is run and I...

Hi, I am getting really confused with how to use Dlookup with navigation forms, if its possible at all! if I have a navigation form with Form1 and Form2 as tabs on the menu , so I want to find what the HospitalID value is based on the fldPatientID (which is also in Form2) Form1...

Hi, if somebody could give some advice with this please Ive been going around in circles with it If I have a form called Form1 within a Navigation Form called frmNavigation (so the menu tab on the nav form will read Form1) if I have a text box that sits above and outside the navigation menu...

Thanks for that Doc, its working now - the explanation in english helps I was struggling to understand the statement

Is it possible to include an additional field from table A in the output that meets these conditions ?- I thought it might be A.test2ID included in the SELECT statement and then A.Test2ID in the debug - but that not working

Thanks that's worked !

Hi The_Doc_Man, Ive done as you mentioned and I now have a single list (Test1ID) of values in a qry that match values in the same field (Test2ID) in the second table. So to get the field values in the second table that correspond to these matching fields doesnt that mean I'm still looping...

I only seem to keep getting the first record hit and then nothing. I cant loop through the recordset.I think there must be something wrong with the code, I'll try the SQL approach from the The_Doc_Man

Hi - I'm trying to understand how to pull out values from a within related tables. I have a test example below to try and show this problem. If for example I have 2 tables titled Table1 and Table2. I loop through a particular field in the first table, and with each value, I want to find the...

sorry myvalue should have been mydate. I was trying to sanitise the code a bit, taking out things i couldnt include,.Forgot to change that

Thanks arnelgp, yes I was trying to figure out how to reset the listbox - is it by adding lstBox.Clear above 'If IsDate(startDate) Then' statement?

Hi, I am new to Access/VBA I am having trouble adding values to this list box from within a module. I was thinking I might use the results of the module within other parts of the database. I'm doing something wrong but cant figure out what it is, the module works on its own but the listbox...

Thanks for that, that works well now- I just needed to move the 'goto' inside the loop because it kept on tripping with the same error , inside the function I'd forgotten to do that. Just one final question - Ive noticed with recordsets do i need a rst.Close with Recordsetclone? Ive noticed...

Hi June7, Thanks for that, both yours and Arnelgp work well. I'm trying to learn VBA so its been really helpful from both of you. There is one thing that both answers do that I'm trying to fix, which is if I enter a value for a PatientID, say 2 and search, then the search works correctly.If I...

thanks for that, I'm still trying to learn VBA with access.Thanks