Search results

Thanks! I had searched on here prior to posting and I didn't see these posts. I will be able to use something here to fix my issue, though I am waiting for IS to approve my Azure db to make these issues go away sportsguy

Query is from a single table, 4 fields, i don't think its the query complexity. was trying to populate a tmp table. . . any other suggestions? any registry changes I can make? Thanks

Access 2010 x32, Windows 7 x64 FE db size 35M BE db size 1.5G single table made a table from BE in FE with 25K records. deleted records after creation keyed table, ran same query as append to same table Error message System Resources exceeded How can I fix the issue? hotfix applied, error...

missinglinq That was one part of the problem, so thank you! The other part was that the form was doing the validation in the BeforeUpdate code and the prior designer had done some in control validation which was failing it took me awhile to find that error! Thanks everyone for reading and...

I have a data entry form based on a query on a table with primary keys. I am using before update to validate that there is data in the fields before saving. When the fields are null, the error message comes up, but then the form tries to save the record and I get error 2015 - Private Sub...

plog, finance guy here, know a $2B when I see it. . and then why would 400 + 0 = scientific notation of any kind? There is something about ODBC Access, SQL 2012 and union queries. . I am just too old, and I was lazy, so I copied it over to t-SQL, and I am fine. . but thanks for trying. ...

don't worry about it, I just copy and pasted it to T-SQL and the query works fine. . There is something about MS Access 2010, ODBC link to SQLSERVER 2012 and union queries, if I recall, but I can't since I am old! sportsguy

Thanks for re-reading. . The queries are all written correctly, doesn't matter if I use all invoices/remits, 200K in each query, or the subtotaling query which selects one invoice, with two rows, and the select query returns two rows with $400 or zero in each row, but when the group by and sum...

plog, That's what I did, was that not clear? So, assuming that I did what you suggested, and I did already, why would I be getting the 2 Billion as a total out of a total of maybe $200K? Thanks, sportsguy

I have an MS 2010 Access union query running off of a single SQLSERVER 2012 table, and the query runs fine. All the output columns are aligned. I the first three columns are the fiscal week, location and the invoice number The next two columns are the invoiced amount, and the Balance remaining...

its much easier to extract a text file of 10 million rows and import them than to have ODBC append 10 million rows of data. But I solved the problem. I edit and replaced the .000 at the end of the SQLSERVER time field in the text file, and then MA Access linked view sees the data as datetime...

SQLSERVER text extract for datetime has a text format with milliseconds. '2015-07-13 15:20:25.0000' MS Access link table format can't handle more than 19 characters, or the period and anything to the right of the period. Exporting the SQLSERVER date time as LEFT(CREATED_DATETIME,19) as text...

Thanks, perfect! I will submitt the VBA after i write it later! sportsguy

Good Afternoon to people east of the USA Central Time Zone! I have a workday headcount extract, and I mention Workday because their extracts suck! The extract comes out in only two choices, pdf or .xls So I am copying and pasting the output into an access database to design the tables prior to...

The answer with some testing is that the OPTIONAL in the function is not being recognized, not sure why, but that is the answer! thanks PBALDY, for pointing me in the correct direction! sportsguy

Thanks for the response pbaldy I searched and there are no variables declared twice, at least that I can find. Also the debug print on the variables all come through as correct or expected. . This piece of code has worked for years for me, not sure why its not working on this particular server...

Why does the DoCmd.TransferDatabase work in the Immediate window, but not in the Sub, which has always worked in the past? :confused: Public tblname As String Public tblNewname As Variant Public pstrDatabasePath As String Public Const dbType As String = "Microsoft Access" Public Sub...

I have an excel spreadsheet i want to copy and paste into a pre-formatted table, and the excel date format is integer YYYYMMDD or today is 20140825 I can't get the input mast in MS Access 2007 to create that ! any suggestions? thanks sportsguy

Not really, because that is where the FE table goes after development. . . I am just hoping there is a setting or switch somewhere which turns off table validation. . . i hate that setting. . . :banghead:

The specfic symptom is that the external hard drive is being accessed, while i am working on a table in the pc located hard drive. I am the only one using the BE tables, so that is not an issue. There are no forms, just tables open. . . open one local table, switch to design view and it...