Search results

Thanks If you could post an example that would be wonderful. I am using access97

I am using some code that hides the access screen itself eg Makes it look like a stand alone program. This code relies on the forms etc being pop-up so that they can be seen. This bit of it works and look fantastic BUT !!! The problem i have is that i can't preview my reports as i would like...

OK i think that i have got it :D :D Thanks mate

Sorry mate i am having a nighmare ... i don't understand what you mean.

Hi all, I am currently trying to get a full list of GP's and practices in our local area together so that in a form you can use cascading combo boxes to select a GP name and from that select a surgery that the GP is at. That bit is straight forward but after looking at it i am sure that there...

Startup In the tools menu click on stratup. In there it lets you select a form to open automatically Steve

In the after update event of the first combo box use me.secondComboName.Requery Steve

I use an umbound text box and set it in the current even of the form. Me.txtRecordNumber = CurrentRecord & " of " & Me.RecordsetClone.RecordCount Where txtRecordNumber is the name of the unbound text box. Hope this helps Steve

OK .. no probs... Shame about that though! Thanks mile :D & Col

It still comes up with the same error!!!!

Hi there. I am using a parameter query based on a form BUT i can't seem to get it to refer to a specific column. If i have the combo box limited to 1 column then it works fine as i don't need to reference the column property. So what i need to do is reference the combo.column(1). I know...

Sorry. Sorry, My stupid mistake .. i have it all working now ... thanks all for your help!!

I have sorted out the what is going in to the array by basing it on a query :) Just can't seem to get the array to work outside of the function. Damn my monday morning stupidity. Steve

I can't seem to get that to work ... I think that i am trying to declare the array wrong but i will keep trying. Also how do you limit the info that goes into the array? Something like a where statement? Steve

Thanks Thanks All works fine now :D :D Steve

Looks good Except - I can't figure out what to do after the array is done. As soon as the function exits the array is cleared?? So where i call the function from it seems that i can't actually use the array for anything useful. Any ideas. Is there a way for me to be able to use the array...

Not really sure if this is possible but here goes I need to place the results of a simple select query into an array. Does anyone know if this is possible ... and if it is how would I go about doing it?? Steve

Thanks a lot Pat ... that is exactly what was up.

Hi there. I am trying to use an SQL query in a report but i can't seem to get it to work. The query itself works but i can't seem to get it to work as i put it into the string. The problem is getting the correct number of " in the format statements. Any help please!!! strSQL = "SELECT...

Cheers ... thought that i had already set that.