Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 362
Search took 0.05 seconds.
Search: Posts Made By: mjdemaris
Forum: Modules & VBA 08-17-2019, 09:57 AM
Replies: 9
Views: 137
Posted By mjdemaris
Re: ADO connection

My answer was "Yes", and here's the provider info: Provider=Microsoft.ACE.OLEDB.12.0

So, a linked table worked for you...I feel stupid. I am using a test DB that I did not refresh the links in......
Forum: Modules & VBA 08-17-2019, 09:07 AM
Replies: 9
Views: 137
Posted By mjdemaris
Re: ADO connection

Yes. Well, I just discovered that this will not work with a linked table, which "Users" is. It does work with a local table.

How would I change this to support a linked table? Would I need to...
Forum: Modules & VBA 08-17-2019, 08:59 AM
Replies: 9
Views: 137
Posted By mjdemaris
Re: ADO connection

Apparently this code is supposed to populate a recordset based on the "Users" table. It's just an example from the book on using the Command object.

The goal is to ultimately find out what is...
Forum: Modules & VBA 08-17-2019, 08:47 AM
Replies: 4
Views: 126
Posted By mjdemaris
Re: Backup .accdb

I usually have several copies of the front end and back end. For production, the front and back ends are stored on the server, and I use a batch file to backup those files to another location. This...
Forum: Modules & VBA 08-17-2019, 08:39 AM
Replies: 9
Views: 137
Posted By mjdemaris
ADO connection

So I am playing around with ADO connections, and got this bit of code from a book: Microsoft Access 2013 Bible

Public Function ExecuteCommand()
Dim adRs As ADODB.Recordset
Dim adCmd As...
Forum: Modules & VBA 07-17-2019, 11:45 AM
Replies: 2
Views: 132
Posted By mjdemaris
Forum: Modules & VBA 07-17-2019, 11:41 AM
Replies: 6
Views: 135
Posted By mjdemaris
Re: Exporting to SQL Server

What is your front end going to be to connect to SQL Server?

I have been using Excel for import/export, and that can be done via linked tables and VBA. The main issues I have had to deal with is...
Forum: Modules & VBA 07-17-2019, 11:38 AM
Replies: 2
Views: 132
Posted By mjdemaris
My Current Version of Front End Updater

A good chunk of this code came from Scott L Prince, which is based on code he got from Bob Larson via StackOverflow.com. It has been adapted to fit into any DB I have created so far.

The current...
Forum: General 07-15-2019, 03:59 PM
Replies: 8
Views: 146
Posted By mjdemaris
Re: Unable to open front end

And file back up made!
Forum: General 07-15-2019, 03:52 PM
Replies: 8
Views: 146
Posted By mjdemaris
Re: Unable to open front end

Ahhhh, yes, the import worked.

So, lesson learned, and thanks again for the quick responses.
Forum: General 07-15-2019, 02:16 PM
Replies: 8
Views: 146
Posted By mjdemaris
Re: Unable to open front end

Well, looks like this a do-over! Fortunately it's not a critical db and I get paid by the hour, lol.

Thanks guys!

Backup copies are a very good thing to have! :)
Forum: General 07-15-2019, 01:25 PM
Replies: 8
Views: 146
Posted By mjdemaris
Re: Unable to open front end

How can I do that if I cannot open the FE?

Unfortunately, I did not back this up before splitting...never had this issue before and was going to back up after the split.

I just realized that I...
Forum: General 07-15-2019, 01:16 PM
Replies: 8
Views: 146
Posted By mjdemaris
Unable to open front end

Hello all,

I just split a DB that I had put plenty of time into, and now I cannot open the front end.

It is recognized as an accdb file, when I double click or press enter, Access opens to the...
Forum: Modules & VBA 07-06-2019, 12:20 PM
Replies: 4
Views: 161
Posted By mjdemaris
Re: Date, WeekDay Functions

Well, I discovered something that did help:
Const conJetDate = "\#mm\/dd\/yyyy\#"

sfilter = "[DueDate] <= " & Format(Date - Weekday(Date) + 7, conJetDate) & ""


By using a date format, which...
Forum: Modules & VBA 07-06-2019, 12:02 PM
Replies: 4
Views: 161
Posted By mjdemaris
Re: Date, WeekDay Functions

Private Sub cmdCurrentWeek_Click()
' filter for this week's PMs
Dim dDate As Date
Dim lToday As Long
Dim sfilter As String
Dim dToday As Date

dDate = Date -...
Forum: Modules & VBA 07-06-2019, 11:09 AM
Replies: 4
Views: 161
Posted By mjdemaris
Date, WeekDay Functions

Hello All,

Why is Today not equal to Today???

So, if I filter a form with a date field, which contains today's date, where "Filter = Date()", it returns the record with today's date. However,...
Forum: Modules & VBA 06-18-2019, 04:33 PM
Replies: 5
Views: 8,559
Posted By mjdemaris
Re: Update to error 3146 ODBC--call failed. SQL Server Linked Tables

Happened to find this thread today, and happened to have the book that Gizmo mentioned...a quick read on how to look into the Errors object looks like what I need to do to solve the problem...
Forum: Modules & VBA 06-18-2019, 03:52 PM
Replies: 7
Views: 341
Posted By mjdemaris
Re: SQL Server table not updateable

After attempting to run an insert via VBA a few times, it still fails.

So it appears the problem is in the VBA, perhaps.

The first error that appears in the Errors collection states that the...
Forum: Modules & VBA 06-18-2019, 03:29 PM
Replies: 7
Views: 341
Posted By mjdemaris
Re: SQL Server table not updateable

I do have a time stamp field, but there was no default setting. I ended up dropping the table and recreating, with a proper time default setting and all seems to work fine so far.

The boolean...
Forum: Modules & VBA 06-18-2019, 01:37 PM
Replies: 7
Views: 341
Posted By mjdemaris
Re: SQL Server table not updateable

Yes, there is a primary key, marked as identity, so it should be ok, as long as i don't try to insert one, lol.

I will check on the boolean fields...

Update: It won't let me delete a record...
Forum: Modules & VBA 06-18-2019, 01:08 PM
Replies: 7
Views: 341
Posted By mjdemaris
SQL Server table not updateable

Hello All,

I have one table that is giving me problems. Access is the FE, SQL Server 2014 is where the BE is.

I am currently using DAO to access the BE tables. I have one table that gives...
Forum: General 04-23-2019, 09:11 AM
Replies: 2
Views: 145
Posted By mjdemaris
Re: Tables Not Adding To Query Designer

OMG, this was a lame experience. I renamed the folder...the tables are linked so the link was bad, lol.
Forum: General 04-23-2019, 09:04 AM
Replies: 2
Views: 145
Posted By mjdemaris
Tables Not Adding To Query Designer

Here's a strange one:

I open up a FE to make changes to some queries, and I wanted to create a new temporary query to test some aggregate functions...

Click Create - Query Design - Click Table...
Forum: Forms 03-09-2019, 09:45 AM
Replies: 6
Views: 164
Posted By mjdemaris
Spell Check, MS 2016, Windows 10

A spell checker has started appearing on one of my forms, and only on one computer, that I know of.

And it seems to have begun after a Windows update was applied.

I have gone through the...
Forum: Forms 11-01-2018, 04:10 PM
Replies: 1
Views: 152
Posted By mjdemaris
Re: Navigation Form and Sub forms

I think I got it, after reading this post:

https://access-programmers.co.uk/forums/showthread.php?t=294678
Showing results 1 to 25 of 362

 
Forum Jump



All times are GMT -8. The time now is 12:24 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World