Search results

If the data records you have in the Excel sheet match the data in your Access table can you not just copy and paste the column from your Excel sheet to the column in your Access table? I've copied an entire table from Excel to a new table Access but I had to have the records in place in the...

Bosch, Thanks for the link and confirmation that the Developer Extensions are part of the package however, I have just spent a couple of hours trying to find help file information on how to actually compile my Access 2003 application so I can distribute it. The Visual Studio package isn't very...

I'm trying to locate the Developer Extensions so that I can compile my Access 2003 application to distribute to my end user. I'm getting totally lost in the myriad of documents and links on the MS website that keep sending my round in ever decreasing circles. I've downloaded Visual Studio...

Hi, Well thanks to RuralGuy I have that working now. I had to remove an earlier version of the object library before I could set Microsoft DAO 3.6 Object Library but once I'd done that it loaded straight away. I used the following code to test and all record dates were displayed: Dim temprs...

RuralGuy, thanks for that, I have to go out now but will try what you have suggested later today and let you know. Appreciate your help :)

I'm a bit blank here, I'm using an Office Pro Access 2003 upgrade. I haven't knowlingly set the reference to the DAO Library. The previous version I used was from Office Pro 2000 and as far as my memory servers me, it worked them without problem.

I’m in the process of developing a holiday property availability form for displaying the available and free dates for a particular property in a particular period (usually 35 days). The main form allows the selection of the start and end dates of the period using a Calendar control and then...