Go Back   Access World Forums > Search Forums

 
Showing results 1 to 7 of 7
Search took 0.32 seconds.
Search: Posts Made By: winshent
Forum: Modules & VBA 06-10-2015, 05:35 AM
Replies: 13
Views: 2,735
Posted By winshent
Forum: General 11-14-2014, 04:28 AM
Replies: 10
Views: 1,525
Posted By winshent
Re: Connected users?

If you create a config table in the back end with a bit field named 'GetOut', that you can edit manually.

Build the app so that the forms check this flag every minute or so using the Form_Timer()...
Forum: Tables 11-08-2014, 02:25 AM
Replies: 12
Views: 1,192
Posted By winshent
Re: Renaming tables

+1

Your system is working.. there is no need to change it..
Forum: Tables 11-07-2014, 08:52 AM
Replies: 12
Views: 1,192
Posted By winshent
Re: Renaming tables

If there are spaces in the table names, are there also spaces in the field names ?

It seems like an unnecessary piece of work, as although its not good practise to use spaces in names, your...
Forum: Tables 06-18-2014, 07:45 AM
Replies: 11
Views: 844
Posted By winshent
Re: DDL to create TimeStamp field

Ok.. looks like the following code works..

Frustrating that I cannot set the default in DDL though.

CurrentDb.Execute "ALTER TABLE Audit ADD COLUMN RecordCreatedDate DATE ;"
...
Forum: Modules & VBA 05-06-2014, 02:54 AM
Replies: 1
Views: 661
Posted By winshent
Re: Determine if field is Primary or Compound Key using ADO

Okay.. So i've managed to get my head around this now.

You need to use the ADO Extension library

Firstly, add a reference to 'Microsoft ADO Ext. 2.x for DDL and Security'

The following code...
Forum: Reports 02-22-2012, 03:10 AM
Replies: 2
Views: 691
Posted By winshent
Re: One Report - Two Queries?

In your code that opens the report:

If monkey Then
DoCmd.OpenReport "Report", acViewPreview, , , , "qryMonkey"
Else
DoCmd.OpenReport "Report", acViewPreview, , , , "qryBanana"
...
Showing results 1 to 7 of 7

 
Forum Jump



All times are GMT -8. The time now is 12:40 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