Search results

Hi everyone, Our school is moving to G Suite. I want to create/modify a script in one of my google sheets which will add a once-off validation rule to a column in one of my sheets. For each cell in column C (starting with C2), return a range from the same row but using columns I2:AA2 as the...

Hi all, long time no see. I have cobbled together a Side-end (SE) which is triggered by Front-end (FE) to Compact/Repair (C/R) the Back-end (BE) in an automated way when users are not connected. Basically, I have the SE "wait" for the FE to do its own C/R on close, and I've chosen a very safe...

Hi everyone, I have a database that a work colleague asked me to look at. They accidentally changed a value and couldn't change it back. There is something strange with the queries. There are four listed in the database, but in one of the queries (in design view), there's another two queries...

Hi, in my continuous form i have three images each with onClick events. when user presses one of these images, the code is executed for the 'current' record, not necessarily the one that the user clicked on. How can i make access acknowledge the record that the user wants? I have tried setting...

no idea how to build an android app myself - is this on the cards for any bright development out there? :-)

Hi everyone, what i'm trying to do is manipulate excel data in preparation for import into access. i have progressed quite well, but i'm stuck on how to select a dynamic range from within access: i have some columns of data, which i want to copy to a new worksheet. They are columns A:I, but...

Hey everyone. Intro I'm going to tackle an import procedure i've been avoiding for a while - mainly because i have no idea of where to start with this. Please open the attached PDF (the files are excel, but i've printed to PDF for convenience of showing you guys) so you know what i'm talking...

Hey everyone, we have this strange behaviour of our relationships in relationship view. the scenario is that we are adding a second instance of some tables and trying to add relationships between these and another table. what access is doing is changing the relationships we have made back to...

hi everyone. i have a form. i would like to return the max date from, a field in a table which is not bound to anything on that form, into a form textbox control on the form. googling around (and searching this forum), i've only found threads where people are wanting to get max values from...

hi everyone, i'm looking for hopefully an easy solution to something i don't even know where to start (query/report/VBA?) i have a set of normalised data - basically samples vs positive results ("targets"). looks something like this: what i need now is to generate a string of the results to...

hi everyone, i'm in the situation many will tsk tsk about. i was, in the past, assured i wouldn't have to deal with this data, but here i am, dealing with it. i have a field with descriptive text. i want to extract some of that text for further analysis. i can find various instances of text...

Hi ChrisO, i just noticed something, don't know if you're aware of it: when you mouse-over on the graph, the graph flickers on every recalculation of the mouse position (displayed in the textbox top right hand corner). however, when the TEXTBOX has the focus, mouse over on the graph still...

Hi Guys, I'm making a batch file to automate file backups, which i thought was working fine but i've noticed now it doesn't do one part correctly... by comparing the string "C:" to the "built-in" %~d0 argument, i test whether the batch file is running from the local C: drive, or an external...

hi, i was thinking to use a .bat file to parse a text file i have, but don't know where to start. it is 11 Mb, and contains many many annotations of DNA from 9 whole plasmids. i need sort each annotation by plasmid and then by contig (there would be 9 plasmids in total, but many contigs). and...

could be a silly idea, but: maybe a link to "thread viewed by" and then a list of users who have been to the thread (and when)? similar to when you go to someone's profile and you can see "current activity".... not really ALL that useful, but interesting and useful in some situations (like if...

hi, i want to remove evidence and shame in the form of table-level lookups from some really EARLY databases i made back before i knew about the evils of table lookups. there's one particular database that is now HUGE and will take a lot of work to fix the referencing (lots of dependent queries...

Hi, i'm trying to combine the versatility of DCrake's shell extension code (which opens any extension with the native app via shell) with the functionality of Ken Higg's front end loader/version control (which checks and manages version difference of master FE and client FE) but my combinations...

this is DB shows a basic method of managing a relatively linked image for each record, such as an employee image for each employee. it features: an add image button a remove image button (does not delete image fom computer) a default "no image" image once added, code copies the image from...

Hi guys. i wanted to use the name of the subroutine/function that is running as a string in my error handler, but i don't know how to reference it. what i hope to get is: when i get an error, let's say i would prefer to have instead BUT i don't want to have to manually change the...

hi everyone, i adapted some code from Ken Higg's FE loader code in order to open an excel file (his was to open an access FE). this works fabulously, but now i need to update it to use whichever excel version is installed (folder path for 2007 includes "Office12", while all previous versions...