Search results

Good afternoon whereever you are in the world! I have a linked table from a text file with a date time field. When I open up the table to look at the data in the date time field, there are many date stamps, and a few #num! I am wanting to trap the error and return null . . . Function...

Goal is to loop through a subset of sheets in the workbook and set a local sheet range name based with the same cell per sheet. Sub CreateRangeName() On Error GoTo Err_RN Dim myCell As Range For Each ws In ActiveWorkbook.Worksheets ws.Activate Range("Z1").Select...

Windows 10 x64 MS Office 365 x32 On Prem Azure billing SQL Server 2016 x64 version 13.0.5882.1 the latest SQL Server update patches require the use of the latest ODBC driver I loaded the SQL Server 2017 x64 version to my laptop, but I am still getting some weird errors when MS Access queries...

I have a very nice front end database connected to a back end *.mdb database, all on my local drive. Everything works fine all day long, the next day, like this morning, I open the database, the home/start form pops up nicely, and any button button i click, crashes MS access, just quits...

I have a table, built from an excel source file to paste the excel data into (everything in this f* company is in excel) One of the field names is "EE_Status", short text 10 I cannot for the life of me, get the column to show up up in normal view, it shows up in design view, but not in the...

so far, All examples have failed, and yet, I don't exactly know why. I have extracted data from a SQL Server onto a tab named DATA, the row count will be different each time, but the column count is fixed. I highlight the data and am trying to assign the highlighted range to the name PIVOTDATA...

Hack SQLSERVER 2016 dba here, ie, not technically certified, but have enough experience to create properly designed tables, indexes, view queries, security users, schemas, procedures, and running all procedures from O365 ms Access from a button. However, I can't get a local file system SSMS...

I used the sql server native 11 ODBC driver, but I can't open any columns with a decimal column type. Is there a different ODBC driver I can use, or any settings, or do I need to set the columns to currenty or long or something Access will recognize? I have set the columns in the security area...

not repairing and compacting an Access 2003 *.mdb file, even when mt. Error message is "Selected collating sequence not supported with the specified file format." Any suggestions? Registry, retirement, lottery to put me out of my misery? thanks sportsguy

good afternoon readers! I have manual queries which run just fine, but in the following sub, the second append query blows up and give the error 3035 System resource exceeded. :banghead: so I am asking for the experts' help. The data is copied from excel and pasted into a form in table...

Is there any VBA which has been written to move tables into custom folders? I have some VBA which deletes and reattaches tables which makes people saving the front end and back ends to their local drives from the network a single click. I use it when moving tables from front end dev to back...

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

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

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

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

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

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

Everytime I close, open, modify, etc, you get my drift, either a linked table or an in database table, Access validation takes minutes before I can continue. What can I do to reduce this time or process? thanks sportsguy

I have linked an excel spreadsheet within access, and a particular field is formatted as data. If one of the column cells is MT, (empty), then the view returns #num error. Question is how to trap that error to convert to a date or null, or something else? thanks in advance. . . sportsguy