Search results

I found the problem, thanks o supreme uber great fantastic supercalefragelistic majestic mr ma Thanks

lol Thanks This is my first VBA code I am writing and I am learning it at the same time so I will indent from now on... I am not using all of the variables-they were in from the last code as i am just trying to adapt this code..I will put the full code below... yes sorry the datasheet is...

Hi I am adapting my former colleagues VBA so when the VBA runs it firstly: 1)looks at the date in the access table and if this then matches the preset date in my excel worksheet (cells 1, Y..-refer to code below) it then places the value from the next field in my access table to a range of...

Hi I keep getting the above mentionted error can anybody help..?? Please look at the VBA below...Thanks Public Sub Report_Run23(LOCReport As Recordset, datasheet As Variant, RepType As Integer) 'OUTPATINETS FOLLOW-UP' Dim AppExcel As Object Dim CurrentPG As String Dim CurrentSheet...

Hi, Currently when i run my vba it populates my excel spreadsheet fine. The only problem being if there is no data within a month in my access table it wont recognise it and will just populate the the excel spreadsheet not reading the month. for example if my access atble dosnt have a july...

ok thanks mate

Sorry david, Please now find the attachement correctly attached..the previous file was to large so it has now been compressed.. Many Thanks, matthew

Thanks for your reply..i will look into the In() syntax..i am fairly new to this.. i am using a cross tab and tgere no figuers for certain months-it would be very helpful if i could get it to bring out the month name even if there are no records for that month... I have attached a...

I am getting no records at all for certain months....so basicaly null values..

hey thanks rainman but i am still noty sure how to incorparate this in my vba....i have llimited brain cells!!!

Hello all, I am counting contacts through using the field "SCHDL_REFNO" as my count field and i am listing all the 'contacts' per each financial year month using the field "SchduleDate". The problem occurs when there ahve been no contacts for a certain month. If there have been no contacts...

Thanks i will do :@)

Hi theres no need to post a solution..i simply inserted txt fields in teh form as start and end dates..i then refernce dthe queries to look at the form before each query runs i.e. Between [forms]![Test]![cmbStartDate] And [forms]![Test]![cmbendDate] under the field of 'referldate'. thank...

I belive having the the start date and end date in an unbound form as the best bet..howver I have been trying all day but i just cant seem to figuer out how to implemnt it even with your help... Previously I was running it with parameters as each start date and end date howver with around 14...

:)Thank you so so much you all have been very helpful:)

Hi i am new to VBA and i am hoping somebody will help be write the following vba code...I need to include a statement so if I enter a date once I don't need to enter further dates as at the moment after each query runs i have to keep enetering date ranges. I have managed to adapt the code...