Search results

I have a select query, it has 10 tables in, some are local, some are linked to FoxPro DBF via ODBC, some with inner joins, some with right, I'm expecting null values in some fields, however I get ODBC--call failed. [Microsoft][ODBC Visual FoxPro Driver]Index does not accept NULL. (#886) I had...

I've been troubleshooting an issue where a totals query based on the above left join query (with the left join that returns the boolean field that may not exist so can be NULL) gives 1 result and if I instead have it make a table and run the same test I get a different result, The outcome was...

My old functions were serious pyramid code, often multiple nested if's deep, since then I've been using guard clauses and setting values/checking values though a series of separate if's instead of nesting, it's definitely easier to keep track of the "end" compared to nesting! However I'm stuck...

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...

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...

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...

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...

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...

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...

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...

When you google thing kind of thing you end up on stackoverflow learning about 6NF, I've had to take over databases designed like that, they make sense, however starting from scratch with just the tables is fairly tricky when you have more tables with 3 or 4 columns of ID's than you have tables...

As part of a deployment tool I want to rename autoexec1 to Autoexec to "enable" a database for deployment, In VBA I've got a "Save and Publish as ACCDE" working and "compact and repair", I just need to rename this macro and I'm sorted, Set db2e = OpenDatabase(CurrentProject.Path &...

I have data in two tables like: ID ParentID Value 16 ID6 1 17 ID6 2 18 ID6 3 and ID ParentID Code 35 ID6 A 36 ID6 B and I want the report to show this in the detail: ParentID Value Code ID6 1 A ID6 2 B ID6 3 instead of how a query would normally give: (without...

I have Page level locking on if that makes any difference to the below I'm trying to make multiple "worker" databases process data in a table (current in an ACCDB on a server, to be moved to SQL server at some point) there's too much data for 1 to process in a timely manner (as real-time as...

There are some reports/queries I need to export and email at certain times, I've got the email part sorted but my "Certain Times" code needs significant improvement, I'd like to select specific times/reoccurances for each "report" and store them in a table like Windows Task Scheduler / Linux's...

I've got a query that's evolved over the years, the field in question has an IIF statement resulting in in one of two dates (A & B) and the criteria I now need to apply to it is an IIF that also results in one of two dates (D & E), C and F are a boolean field I need to check as that affects...

I try to set the criteria of this field: CurrentShipDate: (IIf([sndplan].[shipdate]>1,IIf([sndplan].[shipdate]>[sndplan].[cldate] Or [sndplan].[shipearly],[sndplan].[shipdate],[sndplan].[cldate]),Null)) To be this statement...

I have a form with a number of fields and sections which change visibility based on the data entered in other fields, The fields have an "on update" event to check the content of the field and make the appropriate changes, I've changed this form to be able to edit records instead of "Data...

So I'm making a "simple" Fault and Solution system, When I made the form to add Faults I just put some unbound fields and list boxes onto a form bound to the Parent table and used SQL to insert records into the Child table, Later when I made the Solution form I used a subform bound to a...

Access 2010 - simple update query gives "Operation must use an updateable query" UPDATE PrioStaff INNER JOIN wname ON PrioStaff.wn_ref = wname.wn_ref SET PrioStaff.wn_lvr = [wname].[wn_lvr]; Both are tables, why on earth doesn't this work?!? (I started with something more complex and kept...