Search results for query: *

Thanks Fella, But it makes no differeence if I put them in one function or 2. I am going to have a long day i feel lol......

Yeah Fella. But on the next form there are going to be combos with 100s of records in them..... Possibly thousands

Cheers Fella. I am way too stubborn for that. There is another person that works here that created the other form but is on holidays. I can not have her come back and see I used 14 queries to do what she done in one lol...... But Thank you for all your efforts. Much Appreciated

I can not find anything that would appear to be causing the full form to refresh. I just can not see how one database is working perfectly and the other is rubbish........ Do you have any idea if there are any settings or anything that would cause this refresh. It can not be a PC issue as I...

Changed to On Load but no different. You may be on to something with the refresh. I will try and find if there is anything causing the form to requery Thanks

Yeah if I really have to, I will create more but I would really prefer not to and the fact that i can see it working the correct way using the above code is driving me mad. I just can not see how it works on one form but does not work for me Thanks for suggestions though

On the other form these functions are called when the form opens and each combo has different values.....I just dont get it !!!!!! Private Function GetBranches() Dim q As QueryDef Me.fldBranchCode.ListRows = 10 Set q = CurrentDb.QueryDefs("pt_qryRequest") q.SQL = "exec...

Hi, Well on the actual combobox on the form The Rowsource is: pt_qryRequest This is the name of the pass through query to pull info from SQL Server. So it sets q to be the Quereydef for this and then sets that to the required stored procedure. I have another form wher it works with just one...

Hi, Yes both combos have the same row source. The thing is I have another form to do later that will have about 12 combos So I can not create a seperate pass through query each time. And there are values to be assigned to the combos for what has already been selected so they can not be...

Hello. I am having an issue that is driving me insane today. I have an access form on which there are 4 Combo Boxes. The form is in MS access but the data to populate the combos is on SQL Server. I have a pass through query that links to the server and when the form opens, the following...

Oh cheers mate. As easy as that. Really do appreciate it. Exactly what I need. Thanks JP

Hi, Would really appreciate some help with this query. I am moving an access database on to SQL Server and need to reproduce some reports. The reports are mostly based on Bands that are created during running the query behind the report. So if the field being reported was value and the bands...

Thanks fella. I will try this and see how I get on. Appreciate the help JP

Thanks. But to wrap them in one TRAN do I need to have them all in one procedure? Regards JP

Hi, Hoping someone could please help. I have 2 stored procedures that run one after the other. They both insert a row but in 2 seperate tables. However the rows are linked so if the row goes in the first table, it has to also go in the second table. I know how to use Transactions within a...

Geoff. Thanks for your replies. The parameter is being pulled in by the query from the form so I thought it should work. It works if you were just to run query manually. Anyway that line of code from PHV (PH) works a treat. Never saw that before. Thanks very much. I am sorted Thanks again to...

it bugs on: Set rec = DB.OpenRecordset(currentquery) Yeah, the query needs the date parameter as it is dependant on the date on the form. Thanks JP

Hi all. I am having a problem with a very simple piece of work. I cannot ever remeber there being an issue with this before. I have a form which has a textfield which has a date in it. I have a Select query that selects from a simple table all records that match the date that is in the...

Yeah I am also using that keydown function and checking for keycodes matching tab or enter. It worked fine for NT. Now though i get the error mentioned avove when the system hits the activate line. I have textbox2.select textbox2.activate the select works but this highlights the textbox...

Sorry - I did mean sheet not form. Thanks I will change it and use a form instead.