Search results

Ok - slightly different post here but I'll chuck it out there like a fishing line and see if anyone has an opinion or idea. Moderators feel free to move this if required. I work with road condition data. We have a lot of information with regards to the attributes at given intervals down a...

Hello, Has anyone come up for a neat workaround for this? Re-sourcing the cascading combos is not a problem in itself, but it is on a continuous form. Was thinking perhaps a subform in each form on the continuous form perhaps? Any ideas would be greatly appreciated. Regards, Pete

Does anybody have a link to a ListBox control that I can download to use on a form my A2K database that will be able to display images (or rather icons) as well as text? Regards, Pete

Gidday folks, What I'm trying to do is pass the values of a textbox on my web form to a textbox on my report. Here's what I've done so far (and I am open to suggestions of ways to do this better as I am a novice using Visual Studio 2005). I created a DataSet to a table in Access. I added...

I have a table tbl_Fixtures made up of: fixture_id team1_id team2_id ... ... ... A team id can appear in either team1 or team2 (depends on how the algorithm to compute who plays who calculates it). I want to know how many games a team plays, so I wrote 4 queries: qryTeam1Games: SELECT...

Using DAO in Excel connecting to an Access database, which is the better of these methods to get my recordset: a) Create the query in Access then connect to it using set rst = MyDB.OpenRecordset("MyQuery") or b) strSQL = "SELECT MyID, MyField, Count(MyNumber) as MyCount FROM MyTable" set...

I think I know the answer to this but ... Using continuous forms, I want to use a slider control to display the value of a field. However, when I change the properties of the slider using the OnCurrent event, it changes the properties for all displayed (which I don't want). I do have a...

I have 2 tables in 2 seperate databases that I want to "relate" and extract data from. How/any suggestions on how I can do this in Excel only? I can do it from multiple tables in one database fine but not sure how to use relate and use multiple tables from multiple databases. At the moment...

Gidday! I want to send keys to a specific application that is running, regardless of what the user is doing ... I was kinda hoping there might be some sort of API for this? Here's the background to this: I've got a lot of roading video data stored as avi's. One avi file contains many...

Is there any way to zoom to specific extents of a picture in an image control in A2k? e.g. If I had a TIFF/JPG with dimensions of 30cm x 30cm and on a form / report I had an image control of 10cm x 5cm, is it possible to scale the image so my upper left scaled position in the picture is (15,8)...

Gidday, From within Excel, I was asked if I could automate a process to extract data from an Access database that resides on a terminal server on our domain. I can navigate to the server within our network through explorer ok. I found the database I wanted to get into and tried to open it and...

If anyone can explain: In A2k, when I try to use a recordset on a linked table (or a query based on a linked table), it spits out a "Run-time error '3061': Too few parameters. Expected 2" error. If I import that table fully (instead of linking), it works fine. I'm trying to create the...

Hello all, I'm running into a problem when viewing a PDF in a report. The report is an A3 page oriented landscape. The PDF (which is a technical drawing) is 38.85cm by 9.65cm. However, when I insert it as an object, it only comes through at 29cm wide, and when I resize it, the image quality...