Search results

I've got an MSSQL 2014 express server that i've started using as data source to interrogate some data from our shift and access control system, So far it's been a really pain for regional settings etc, especially two key fields for roughly "shift minutes" that are both currency rather than...

Hi, using excel sounds like a bit of a bodge, surely there's risks to numeric data where it could end up with the wrong formatting, same with dates etc? Ideally I'd like to do it directly to tables within Access with ADODB somehow? surely it must be possible if you can get it into a recordset...

I've used ODBC for most of the tables but there are some that use VFP9.0 features that aren't support by ODBC (vfp6), the suggestion is to use OLE DB, I can get a connection string to execute like this: Set con = CreateObject("ADODB.Connection") con.ConnectionString = "Provider=vfpoledb;Data...

I ended up using the ugliest hack to sort this, I put a small "fix" button next to the zoombox button, it opens a totally separate database with 1 form with a zoombox button, the Font button works there and allows changing the default for Access to be a usable ZoomBox again, users only have to...

I've tried ACCDE & ACCDB, I've imported the objects into a new database etc and the crash persists, something we have set somewhere, somehow, must cause the crash but I've no idea which bit of code,

We've just started a partial rollout of Office365 as our outlook2010 finally stopped working with Exchange365, we've still got a lot of desktops just used as terminals running Runtime2010, they work fine, However the new installs of 365, which include Access have a strange bug where their...

haha, fair enough, I guess it has to interpret the GUI view into a WHERE clause and sometimes it can't figure the brackets out I guess?

ok, that's odd, I've seen one or two issues before where I added some complex criteria onto a totals query and the query designer changed it if I saved and re-opened and made it incorrect, it moved which fields I'd saved in which boxes etc

Thanks, are there any known issues with 2010's GUI query designer?

It appears to be an Access 2010 Query GUI bug, if instead of having two "or" rows in the GUI, I combine the Or criteria (it's only one statement different anyway) into a single criteria field and delete the second line it works as expected! oh god, this is what it looks like apparently! I've...

I'm using a left join query from a main parts list to a table of "records to exclude or discount" where if a boolean is true they should be discounted and false excluded entirely, so the where clause is if the left join doesn't match (i.e. the boolean Is Null) they should be included or if the...

yea i'm using an image frame to display my images, the bound object frame just seems really cooperative with the rest of the windows UI for drag drop etc etc, just doesn't seem to be possible to get a handle on the data in there to do anything with it

Sorry if I was ambiguous, I wanted users to paste the image/location into the form to then save it to a directory and use that path in a table, I don't plan on putting the actual files into Access, that sounds bad! Path's all the way

Yea I've done FileDialog with late binding which I'm happy with, hopefully users will just deal with the small amount of admin of having to save it to pictures or documents etc before attaching,

"Bound object frame"'s seem to do what I want, but I'd then need to save what's in there to a file path I specify in VBA and then update that path into my table

In Access 2010 (split Front end and back end) I've got a continuous form where images are displayed on each record based on a file path field in the table, Currently users do SHIFT + Copy as Path - paste (and I remove the double quotes) Ideally they could: Drag and Drop files from windows...

We have a similar issue with Outlook 2010 freezing with linked images sometimes, I wonder what this setting it and how to control it because it would solve a number of issues!

Access 2010 - split front end and back end, First Question: When I have the Control Source set to a field, does this override the Picture Type formatting option? From normally Embedded and set it to Linked even though the dropdown in Format still says embedded? Second question: (I can handle...

Thanks, AfterUpdate was the bit I was missing, this worked: Me.Text64 = Replace(Me.Text64, Chr(34), "") for some reason: Me.Text64 = Replace(Me.Text64, """, "") this goes red like it doesn't like it? And anything in BeforeUpdate gives me Run-time error '-2147352567 (80020009)': The Macro or...

I'd like to strip quotation marks " from user inputs in a form control, this seems to be hard to do and harder to google Issue is caused mostly because "Copy as Path" in Windows puts leading and trailing quotation marks, I thought it'd be fairly trivial to remove these in BeforeUpdate or...