Search results

@MajP I'm using the following code: dim rs as dao.recordset set rs = currentDB.openrecordset("Select * from tblAction order by partno, acedate, acttype") I'm using a make table query first to create tblAction then using tblAction for my recordset as shown above. I was under the impression...

I believe there might be some confusion, I'm not using an Access report at all. i'm doing all this to add the negative qty's to the appropriate records in a table, then querying that table for only records with negative values, then dumping that into an Excel file. @Gasman when you say "yes"...

This might be somewhat of a duplicate of a thread titled "table not sorting properly". (I'm still a newby so it won't let me post the link) What I've gathered from that thread is that tables have no inherent sorting applied to them. They are just a jumbled container for your data, and the only...

Guys, just to give y'all an update i was able to write a .prg file and compile it into a .exe. I then used a shell command from access to convert the .dbf file to excel. Thanks a lot for the help! I'll go ahead and mark this as solved. I did this on my c:\ drive, will test it out on a mapped...

I was able to install foxpro from the link @Gasman sent. still haven't gotten a chance to mess around with it yet. @arnelgp can i operate this converter using VBA? The whole idea is to automate the conversion, our legacy software already allows users to manually convert from .dbf to excel

@Isaac i meant the same thing i said to @Gasman "Thank you and i'll look into it"

@Gasman thank you so much! I'll look into it right away. @Isaac same to you

I'm working with legacy software that was built with Visual Foxpro. While there is a Vfpodbc driver that will allow linking to and importing the data from the .dbf tables into Access, it is 32-bit and i have since been forced to upgrade to 64-bit Office and can no longer use this driver. On top...

So basically on database open, run some code to find the bit-version of Access then programmatically create a connection string for the DSN with the matching bit-version?

Correct I probably should've opened the link and read that myself before asking you :P I was hoping they'd be free, Devart has much more reasonable pricing. cdata pricing is ridiculous imo. Either way thanks for sharing, i will keep those in my back pocket if we ever decide to go that route...

I'll take a look a those, i had heard about devart but couldn't find a download file anywhere, thanks! Are these bundled as 32-bit and 64-bit or just 64-bit? (I'm assuming the latter). Also it appears these are for xBase, you sure they will work for Foxpro? I use .mdb versions for everything...

Looks like that's the only option here. I opened my old laptop with windows 7, 32-bit access and created a new DSN and it worked just fine.

I get the following message Which is strange because I do have administrative privileges. It then allows me to create a user DSN but the driver won't show up. My Access is 64-bit and the DSN is 32-bit. I'm 99% sure that my Access version was 64-bit before i upgraded to 365 so not sure if...

I was recently forced by my IT group to upgrade to Office 365. I had an issue with Excel and they "accidentally" deleted Microsoft Office and claimed that there was no way to reinstall my old version of Office and had to upgrade..... I didn't want to upgrade to Office 365 precisely because of...

I just last week upgraded to Version 2408. Here is the full version: Microsoft® Access® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20114) 64-bit. Josef P shared a great .gif earlier in this thread where he showed that only the basic Calibri font was changing to system font and Calibri...