Search results

If I have an MS Access frontend that connects to an MS Access backend, is there a way to hide/permission block the pathway to the backend's folder but still allow access via the frontend db? Right now I can't dedicate a server to a more "secure" form of DB or anything like that so I'm stuck...

I want to be able to go down my rows and, with VBA, filter out any number of arbitrary rows. I'm not looking into hiding rows but rather filtering them so I can always turn them back on later with .ShowAllData.. Is this doable?

I have a query with a field labeled OldName. I want to rename it to NewName. However, when I do this, other queries that either have joins/relationships/whatever you call them on OldName break because they can't find OldName after the renaming.

I have a report where I currently sum values by doing =sum([VariableName]) but I'd like it to only include values for which they are >0... is this doable?

I have a bunch of databases. When I port them over to a new server, they break on open due to two references. Is there a way to update these references without needing to go into VBA Tools References manually for each one?

Say I want to take a string but EXCLUDE the left 60 characters. How is this done?

I have a process that plucks out various reports from other databases and outputs them in pdf format. However, for some reason, when I import the report object, it tells me the recordsource doesn't exist (since it exists in the other db) How do I correctly import/copy the report into my db?

I have the following dim rst as adodb.recordset set rst = new adodb.recordset rst.open "select * from officeTemp", currentproject.connection But the problem is that rst now possesses a set that is, say, 50 entries long. If I open up "select * from officeTemp" manually in Access, it shows 42...

What would be the code for doing the following (I've tried all sorts of ways and I can't get it to quite work right, so I'm just starting from scratch): 1. Check if destFile exists 2. If it does, save current sheet destName in new workbook labeled destFile 3. If destFile exists, check if...

Say I have a table like so (Branch, Area column names): California, Los Angeles California, San Francisco California, Fresno Colorado, Denver New York, New York City New York, Buffalo Pennsylvania, Philadelphia And I want to basically convert this table into an array, where something like...

I have a really, really massive table (over 160 million rows) -- but I want to make some indexes to optimize this thing. I have three columns, User ID (number/int), Badge ID (number/int), and WinDate (Date/Time) There may be duplicate values in each column, but each row is unique in itself...

Is this possible? For a personal project I have about 250 million records worth of data, and I am inserting them into separate backends (about 10 of them) because each Access backend has a 2 GB limit. But in my frontend, if I were to do operations on the aggregate union of all these backend...

Say I have a query and one of the fields is State. How would I easily export this query into broken-up Excel files? For instance, one file containing every record where state="Atlanta," one where state="California," etc?

When I move my access databases to a new server, a lot of the code breaks on-run. For instance: Microsoft Office xx.0 Object Library PDFCreator Is there a way I can programatically remove bad references and re-add the good ones across all my databases?

Basically I have everything formatted in my report except the actual values (I've got column text headers going across representing C1, C2, C3, and row text headers going down representing R1, R2, R3, etc) So I have a table, T, that actually has all the values I want to pull onto this report...

So I know there's a fact() function but bear with me -- there's a reason why I need to use a user-made function, here, but I don't need to get into it. But I am using the following: Function facty(expression As Variant) As Variant Dim I As Double Dim bNum As Variant If...

Background info: Cust_ID represents the id number of a customer, Branch is the general location (e.g. "Dallas"), Representative is the person assigned to that customer, and Address is the customer's address. SendMail, SendEmails, and SendCalls are boolean values that basically ask "Is it OK to...

For instance, say I have a bunch of queries like so: select a, b from [pathway to db.mdb].RandomQuery and I want to programatically change them to this: select a, b from [a new pathway.mdb].RandomQuery

What is the quickest and most effective way to do this? Say I have a database, a.mdb. It has a query inside of it, MainQuery. I want to be able to take the contents of MainQuery from a.mdb and then export it to Excel format. I also need to not kick off any startup macros/automations that...

I find myself hitting the 2 GB limit pretty frequently with a few of my backends, so I want to split them up. But how can I tell which things to split off first?