Search results

Yeah - Just checked. The query exists... If I take out the parameter it works. Just when I add the parameter it debugs on the QDF.Parameter line...

Thanks for the advice... but Ive fallen at the first hurdle. When I run the code it debugs at Set QDF "Run time 3265 - Item not found in this collection". The lstbox is there. Should this be obvious? Thanks

Hi All, Id like to ask a couple of questions about QueryDef parameters. Im looking blankly at a few help sheets online… The first is how do I set the parameter? The below is what I've been working with but its not working Dim db As DAO.Database Set db = CurrentDb Dim QDF As DAO.QueryDef...

Fantastic! Thanks PBaldy! Thats great... I had previously look at the various websites but I just want getting it.

Hello, This is driving me nuts and has been alluding me for months. I just cant get my head around it. I've looked at a number of detailed instructions on the web but im still having no joy. In a query, I want to reference a subform within a subform. There is a cbo control on frmSub2 that...

Thanks guys - will have a look...

Hi everyone… I have a very odd problem with calendar control. My function takes the date from calendar control (via a cbo box), and is used in a query def. This all works fine. The odd thing is, if the date is between the 1st and 12th of the month, it swaps the day and the month. So...

Hi and thanks for that... I wonder what the reason is for not being able to do these certain things in code. Perhaps its allowed in 2007+? Do you know of a way around this? The query filters based on a list box. This is being executed in Access. Thanks

Hello, Im having some trouble with “Run Time Error 3061 – Too Few Parameters. Expected 1.” I've tried jiggling the code about but cant seem to solve it.l Can anyone see what my problem it? Thanks MyQuery SQL

.value! Of course! How did I miss that! Thanks for pointing out the obvious!

Hello, Could someone please advise me on this problem. I have a txtbox on a form that I want to change the name of (the VBA isn't in the same form). I've tried the below options but none work – I've tried DefaultValue and ControlSource. Thanks for any advice...

Thank you - That seems to have an impact.

Hello, I'm having a problem importing an Excel sheet to Access. Attached is a cut down example (returning the same error as my full workbook). The column in the Excel sheet has a TEXT format. When I import to Access, most of the data imports (for some reason, even though the Excel column...

Oh of course! How did i not realise that! Thanks for pointing that out :)

Hello, I'm trying to amend a table column property, but I'm having trouble with a space. I'm using: DoCmd.RunSQL "ALTER TABLE Table ALTER COLUMN My Field Text;" The space in My Field is causing a debug. I've tried ‘My Field’ and My Field, (with the comma), but im not getting it right...

Hello, I have a question about the Vertical property of a text box. When using it, the text reads top to bottom. Is there a way to change it to read bottom to top? Thanks

Hello, I've tried a few ways of trying to achieve this but I keep getting errors. I have a query field that is a null value. I want to add a formula to the header so that if the result is null it shows as 0. Thing is I also want formatting in place. This is what I have so far: IIf([Target...

Hi vbaInet and thanks for that... im not really sure how to use that within my procedure though. How do I refer to the .SelectedItems(1)? For example, if I wanted a MsgBox to pop the value of .SelectedItems(1). thanks again

Hello, I'm using FileDialog to save an Excel file from Access query and I want to refer to the file location/name that the user selects – I wondered if anyone could tell me how to do this as I cant seem to see where the final path/file name values are stored. My procedure works by making a...

I didnt actually post it twice. As seems to be the case an awful lot lately, the website experienced problems. I didnt notice but it seems my form resubmitted.