Search results for query: *

Probably something like this: Private Sub Detail_DblClick(Cancel As Integer) Dim strFormName As String strFormName = "The Name Of Your Form Goes Here" DoCmd.OpenForm strFormName, , , "Put your where clause here" End Sub Where you replace "Put your where clause here" with...

What error are you getting? Is the secongd combo box not requerying, or is it giving the wrong info...? Kyle

Fox, The easier way would be with the absolute path, but there is another way. Absolute path: Dim dbs As DAO.Database Dim strFilePath As String strFilePath = "C:\Program Files\Microsoft Office" & _ "\Office\Samples\Northwind.mdb" Set dbs =...

Fox, glad we could help you! For further clarification, the reason dbOpenTable won't work on linked tables is because it's trying to open a tabledef type of object. Tabledefs are only stored for local tables, so in this case, to open it with dbOpenTable you would first have to set you...

Fox, Very sorry about mistyping the Dynaset as Dynamic. Anyway, why not use the .FindNext method of your new Dynaset recordset? It's actually easier than setting the .Index and then using .Seek Kyle

Fox, Try switching ...dbOpenTable) to ...dbOpenDynamic) My Dao knowledge isn't what it used to be (any reason you're not using ADO?) Kyle

the code you've given is trying to open "tbl_Temp" within the current dB. Is the table linked to the front end? If not tDAO won't know where to look for the table Kyle

Attempt to clarify: m1/y1 m2/y1 m3/y1 ... m12/y1 m1/y2 m2/y2 m3/y2 ... m12/y2 With each record being the sales totals for the previous 12 months? (by customer, of course) and the 2 years are the two yars prior to the current month, so if run today the query would give the rolling year summs...

Wow, I'm just all kinds of stupid today... I spent all that time looking for the checkbox anywhere bu there. Thx for the quick answer PHV. Kyle

Thanks for the reply PHV. Maybe I'm missing something (I've always used pass-through or DAO/ADO to connect tables so sadly most of the DSN stuff is new to me). When I go to File-->Get External Data--> Link Tables, then select ODBC Data Sources I get the standard "Select Data Source" window...

Well, it's been a while but I've got a question I just can't answer (even with searching this site, Google and msdn) I have an Access 97 dB (well, about 30 dBs actually) that I didn't write (pretty standard story really) which is connected via DSN to an AS400. That link works great. I need to...

Hi, The Min/Max functions work far differently in JetSQL than they do in Excel, so give this query a run SELECT Switch([ProjStartDate]<[RptEndDate] And...

HTH soup! Kyle

Try this thread Tek-tips Kyle

What you've got there looks like it should work (I got it to) but try this instead: Private Sub Check28_BeforeUpdate(Cancel As Integer) If Me.Check28= True Then Me.txtStartDate.Enabled = True Else Me.txtStartDate.Enabled = False End If End Sub Just to...

If you start with the end date combo box first, does the start date still get the information populated? Try putting a watch on the cboOriginator variable and see what happens to it when you select the end date box, and when you select the actual end date from the calendar. Kyle

Also, you could think about using a Switch statement, SELECT JobNumber, SubPreFix, CTCDTE, LastOfInvDate, NvNoTax, DSCRPT, Switch([SubPreFix] In (3007,3008,3090) And [DSCRPT] Like "*Lot Clean 1*","EC1", [SubPreFix] In (3007,3008,3090) And [DSCRPT] Like "*Lot Clean 2*", "EC2", [SubPreFix] In...

I have a VB form with an embedded Excel file so the users can change the file in Excel. How do I save the embedded object to a specific file path - C:\Test ? Thanks, Kyle

Thanks for the reply... I've got all the parameters, tried using the Excel VBA editor... Nothing seems to work. Can it be an issue with the Excel file itself? If I create another variable, and set it = to a new instance of Excel, all this syntax works fine, but if I copy the current...

Hi, I'm using the free eval copy of Excel 5.0 (don't ask, let's just say my work is a little cheap...) I've got my application all ready to go, it opens and edit Excel workbooks, and then when saved, moves the file somewhere where the user can't get to it and saves the pertinent data to my...