Search results

I've done this dozens of times, I don't know why this database is flipping out on me. (Apologies for the convoluted code, it started out giving the "too few parameters" error when runSQL referenced the form that was running the code, so I had to break the loop. Dim addrs As String...

Some of my users do not have access to all of our servers. In trying to automate I've hit one user whose system hangs up when Access tries to write to a server folder she does not have write (or even read) permissions for (Error 52, Bad file name or number). See the "Me.CitationType > 500" line...

This frame controls an option group. If they are in an existing citation and want to start one for another type, this offers to write a new record in when they try to switch. Problem is, if it DOES write the new record, it seems to be saving the old record, and thus both will end up 56, for...

This has to rank up there with one of the stupidest problems ever, but I've been staring at it for several hours now and nothing seems to work. Problem: I want to automatically filter a subform based on the value of a combobox in the main form (switchboard). But I need to filter based on...

I keep seeing this in a handful of forms... Access 2010. Some are converted, some are newly made. No pattern I can discern... anybody else seen this or know how to avoid it? It always seems to be the same color pattern, so it's not transparency bleedthrough. Obviously it only happens on Windowed...

No idea how to search this one due to the general terms involved. Lately I've got a couple of code snippets that want to 'stop' running and highlight a line with the yellow arrow. If I hit F5 or F8 and step through it as if I were debugging, it works fine from there on until I close and reopen...

Just wondering if I'm missing an SQL trick for normalizing this data I inherited from an Excel spreadsheet. Current data: Case | Insp1 | Insp2 | Insp3 | Insp4 | Insp5 | Rnsp1 | Rnsp2 | Rnsp3 | Rnsp4 | Rnsp5 --------------------------------------------------------------------------------- 1234...

I'm trying to make my query robust enough to count differently on Friday than Monday, but it keeps evaluating the criterion to '2' no matter what. For now I have to switch between two versions, one for M-Th and one for Fridays. Relevant field and criterion...

This is a really weird one (I think I say that every time I make a thread anymore, just goes to show how much I've learned here...) I have a form/subform that requires some fields from the Switchboard for its criteria. Last week due to no action on my part, it started asking for those values as...

This form used to work fine under 2003... it's still an .mdb, but in 2007/2010 it looks like hell. I haven't bothered to try to upscale it yet, but a search of the forum yielded nothing... thoughts?

I've got two nested queries. One finds the oldest inspections from an import table, the second compares that query to the main table again and pulls all 'expired' inspections for each Service Order in the first. These queries are trimmed down for the essential elements of my question. I can...

I must be rusty, because this seems like the simplest thing in the world. I have date fields on my new form. Data validation requires them to have a 'time' associated with them. I thought I could trap if they had left the time portion blank and insert the current time of day, rather than...

[SOLVED] Open File as .CSV, Save As .XLS via Macro I've managed to record a macro that opens a specific .CSV, imports and formats it properly, and then saves it as an .XLS file with the same name. But, I'm unable to discover what the Macro command is for pulling up the Common Dialog. I think I...

[SOLVED] Download new version of FE from within the FE? I'm having trouble conceptually with whether this is even possible. Traditionally, I've used version numbers to autoclose the database if the user does not have an up-to-date front-end, with a popup telling them to get a new FE off the...

I'm finding it hard to believe that this is as hard as it appears to be. I'm going to blame deafness from the fireworks over the last weekend... :rolleyes: Anyway, what I want to do is open a Word Template from a button in my database's main form, then immediately prompt the user for a filename...

For once, I'm using Access for fun and not for profit...err, work. I'm trying to query the game distribution on a site I'm at; There are seven players in each game, with 5 set roles (2 Mafia, 3 Townspersons) and two "optional": either the game contains a Doctor or it doesn't, and either the...

I've been trying to assign tours for an upcoming conference from the three options chosen by people, based on when they chose them. Now that the first tours are starting to fill up (maximum 40), some people should get shunted to their 2nd or 3rd choices. Having a hard time figuring out how to...

Trying to create this thing is tying my brain in knots, so I'm back for help. Hopefully I'm missing something basic: I've finally been able to normalize my database by taking it offline for a few weeks, and already the amount of duplicative/erroneous data that has been cleaned up is staggering...

I'm having a difficult time wrapping my brain around elegant solutions to this problem, so I thought I'd come here and see what anyone else thought. In a new part of the database, there is a Strategic Plan objective that should be linked to the Task in the main table/form. I have a reference...

Setup: One data entry form with subform (Contacts/subformContactDetails). One search form for locating records in subformContactDetails(searchContactResolutions). Situation: If a user has the Contacts form open, and then goes to search for another Contact via the searchContactResolutions form...