Search results for query: *

One thing that you might want to take into consideration when looking at VB.NET, is that it will only run on certain operating systems, so if the current systems are too old i.e. win 9X then your program will not run. Do or do not, there is no try. - Yoda

Hi, If you need the FixingDay data what benefit do you get from grouping them query by sparepart? If the date connects to the sub-report, how do you do it, individual days? Regards, Mike. Do or do not, there is no try. - Yoda

Hi folks - 2nd attempt as the first thread stopped appering on the forum!? The following code for creating a query works fine except for the date line, can someone please tell me what is worng with the line of code. Private Sub cmdOpenQuery_Click() On Error GoTo Err_cmdOpenQuery_Click Dim...

Hi cLFlaVA I have taken out the ' ' marks, but this wasn't causing a problem. The date line still does the same thing, it runs the query, but no records are shown. cheers, Mikee Do or do not, there is no try. - Yoda

Good point, I have taken them out now, but the date line still dosn't work, the query runs, but there are no records to display. regards, mike. Do or do not, there is no try. - Yoda

Hi folks The following code for creating a query works fine except for the date line, can someone please tell me what is worng with the line of code. Private Sub cmdOpenQuery_Click() On Error GoTo Err_cmdOpenQuery_Click Dim db As Database Dim qdef As QueryDef Dim strSELECT As...

Many thanks to all Now sorted, just one little quote or space out of place and it's goes wrong, but never tells you where it is :( Cheers, Mikee. Do or do not, there is no try. - Yoda

Leslie, thanks thats better, but now I get a parameter box asking me to put the value in. Even though it is on the form. So it nearly there. Thanks Mike. Do or do not, there is no try. - Yoda

Hi all, tried all of the above and others, still no joy, this is the whole code block, hope someone has the answer. Private Sub cmdOpenQuery_Click() On Error GoTo Err_cmdOpenQuery_Click Dim db As DAO.Database Dim qdef As DAO.QueryDef Dim strSELECT As String Dim strWhere As...

just a quick one using a WHERE clause in a VBA SQL module and I keep getting an "invalid use of bracketing" error the code line is: strWHERE = "WHERE [qryAddressUK.Postcode] =" & Postcode I'm trying to allow the user to select the postcode from a form, can't figure whats missing. Many thanks...

Just as an afterthought If you import manually from the database window you can select sheets, shame that you can't do the same from vba, perhaps something for the developer at MS to think about.... maybe. Do or do not, there is no try. - Yoda

PHV Top stuff - that does the trick, not they way I was thinking of, but all the same - it works :) Cheers, Mikee. Do or do not, there is no try. - Yoda

Hi PHV, Checked the Range parameter, but when I put in the name of the sheet I get a runtime error telling me that the database cannot find, on this occasion "F1 Range".. ? I put the name of the sheet in " " and that didn't help, is just naming the sheet normally sufficient? Mikee. Do or do...

Hi folks, Using the TransferSpreadsheet command in vba I know that you can import single sheets or named ranges, but.. I am importing details from one spreadsheet, but there are 3 different worksheets in it and each one goes into a different table. Is it possible to tell the system which of...

thanks, I've got books on both and the software for creating runtime versions of Access, I've read that VBA is not a true OOP language and also there are things like being able to change the colour of command buttons, which you can't do in Access. There is also the bit that I will most likely...

Are there any advantages using Visual Basic 6 to program against the Access Jet engine as apposed to using the VBA which comes with Access. Just trying to weigh up some pros and cons of which system to use, I have a developer edition of Access so I can create runtime versions using that, so...

Thank you very much :-D Big smiles here now. Mikee. Do or do not, there is no try. - Yoda

Hi all, I am writing a database for a customer, but before we go to far with it I want to send him a demo and I would like to be able to limit the amount of records or rows he can store in a table to say 5 or something. Can this been done in a table or a form or programmically? Many thanks...

I have two text boxes on a form which need to be able to calculate values, I can run an If statement in VBA and that runs fine; which is: If Me.OrderOrigin = "Home" Then Me.IncostHome = Me.TotalPrice * 0.0525 + 0.4 Else Me.IncostHome = Me.TotalPrice = "£0.00" End If but when...

Hi Missinglinq Yes agreed, but if you do it that way you can only have data entry and you can't view any other records in the form. Mikee. Do or do not, there is no try. - Yoda