Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.33 seconds.
Search: Posts Made By: CJ_London
Forum: Forms Today, 03:10 PM
Replies: 44
Views: 544
Posted By CJ_London
Re: MS Access: custom control built in another language

I've got three - this was a while ago and I may have added further functionality. In the example I've just posted see these functions

fIsScrollBar
fIsScrollBarHZ
getScrollhWnds

I don't have...
Forum: Forms Today, 02:54 PM
Replies: 44
Views: 544
Posted By CJ_London
Re: MS Access: custom control built in another language

this is an old example using that module. It scrolls without scrollbars. I originally developed it for touch devices where the scrollbar a) may be too small for stubby fingers or conversely b) the...
Forum: Forms Today, 02:12 PM
Replies: 44
Views: 544
Posted By CJ_London
Re: MS Access: custom control built in another language

the code is old and there is a small change you need to make

in several functions, e.g. fIsScrollBar, there is a line which is used to identify the scrollbar for a window

If...
Forum: Forms Today, 02:01 PM
Replies: 10
Views: 68
Posted By CJ_London
Re: Displaying a grid, with not-records

thank you for clarifying

I suggest the basic solution you will require to do the count is as follows

1. create a table called say tblTimes. It needs a single field called say DayTime of type...
Forum: Forms Today, 11:54 AM
Replies: 10
Views: 68
Posted By CJ_London
Re: Displaying a grid, with not-records

further to my last post - just trying to clarify the actual requirement

so you are not looking for a specific point in time

so not

12:00 pm
12:15 pm
etc
Forum: Forms Today, 11:41 AM
Replies: 10
Views: 68
Posted By CJ_London
Re: Displaying a grid, with not-records

all you've done is moved the goalposts, you've not answered the question. Are you saying all employees 'clock on' or 'clock off' at exactly quarter to/past etc

again, not answered the question...
Forum: Forms Today, 08:33 AM
Replies: 10
Views: 68
Posted By CJ_London
Re: Displaying a grid, with not-records

You need to clarify what this means

What happens if someone starts at 12:30pm and finished at 1pm - does that count as 0 for 12:00pm and 1 for 1:00pm? or something else.

also this

is it...
Forum: Forms Today, 02:27 AM
Replies: 5
Views: 125
Posted By CJ_London
Re: Determining when user moves to webcontrol

Without the control having focus, none of the web control events will fire except the mousemove event.

focus will be received with the click and doubleclick events but suggest use the mousemove...
Forum: Queries Yesterday, 12:52 AM
Replies: 5
Views: 92
Posted By CJ_London
Re: Creating a Stored Procedure in MS Access 2016

access does not have stored procedures - you create them in the backend (sql server).

Not tried it but you might be able to use a passthrough query in access to create the procedure in sql server....
Forum: Modules & VBA 10-17-2019, 05:46 AM
Replies: 12
Views: 111
Posted By CJ_London
Re: FileDialog not filtering files

So far as I know that can't be done. Filedialog can

specify an initial filepath, which you don't want
specify a file type, which you don't want
specify what a file name is, which you do want,...
Forum: Modules & VBA 10-17-2019, 03:15 AM
Replies: 12
Views: 111
Posted By CJ_London
Re: FileDialog not filtering files

Not sure if you are asking a question -if you are, provide some examples and the path you would actually require for several users - or are they all

"E:\VnomicRep\Master_Workbook\username"

or...
Forum: Modules & VBA 10-17-2019, 02:38 AM
Replies: 12
Views: 111
Posted By CJ_London
Re: FileDialog not filtering files

dynamic how? with a username? e.g.

.InitialFileName = "E:\VnomicRep\Master_Workbook-Microsoft\Azure_Workbook\ImportData" & environ("Username") & "" & partialName & "*"
Forum: Modules & VBA 10-17-2019, 01:44 AM
Replies: 12
Views: 111
Posted By CJ_London
Re: FileDialog not filtering files

not clear what you mean by filtering - do you mean the initial file name? or the filter?

if the former, you need to add .csv to the end of the initialfile name - at the moment it is looking for a...
Forum: Tables 10-15-2019, 11:55 PM
Replies: 3
Views: 95
Posted By CJ_London
Re: Multi-value lookup field

for your example, you need three tables - companies and activities as you already have plus a joining table (with a multivalue field this is hidden).

The joining field need two fields, the FK to...
Forum: Access Web 10-15-2019, 05:40 AM
Replies: 5
Views: 112
Posted By CJ_London
Re: Looking for advice on migrating to Cloud

you do need to be very clear what the reasons are for moving to the cloud. access from anywhere, access by partner businesses/customers/consumers are good potential reasons, speed is generally the...
Forum: Modules & VBA 10-15-2019, 03:39 AM
Replies: 10
Views: 135
Posted By CJ_London
Re: Selecting Multiselect Listbox values from recordset data

Depends on the other code you have but try


rs2.movefirst
while not rs2.eof
For i = 0 to Me.TaskSelection.ListCount -1
If Me.TaskSelection.ItemData(i) = rs2!Task_ID Then
...
Forum: General 10-15-2019, 03:07 AM
Replies: 12
Views: 134
Posted By CJ_London
Re: Whats the best approach too??????

So I called my table tblVisitors, you have called it Data

You need to create a table which I called tblTimes with a field called pTime which you need to populate with the times you want to get a...
Forum: General 10-15-2019, 02:16 AM
Replies: 12
Views: 134
Posted By CJ_London
Re: Whats the best approach too??????

and what do you call the linked table?
Forum: General 10-15-2019, 01:15 AM
Replies: 12
Views: 134
Posted By CJ_London
Re: Whats the best approach too??????

totally confused now - what has normalisation got to do with it? what does 'working from a csv file' mean? You've linked to it? imported it? have a query on it? something else?
Forum: General 10-15-2019, 12:44 AM
Replies: 12
Views: 134
Posted By CJ_London
Re: Whats the best approach too??????

no you need a separate table for the times - I called it tblTimes. Looks like you already have a table of that name holding visitors - which I called tblVisitors (Betty, Wilma, etc)

For the future...
Forum: General 10-15-2019, 12:20 AM
Replies: 12
Views: 134
Posted By CJ_London
Re: Whats the best approach too??????

to determine a count (of visitors in this case) for a given time or period you need to find those where the persons start time <= the period end time AND the persons end time >= that the period start...
Forum: Queries 10-15-2019, 12:08 AM
Replies: 3
Views: 79
Posted By CJ_London
Re: Time Queries :confused:

help to know what the error actually is but it looks like you have a surfeit of parentheses
Forum: Reports 10-12-2019, 11:55 AM
Replies: 5
Views: 121
Posted By CJ_London
Re: Display 0 in blank or no data fields

why not use the format property?

0.00;-0.00;0.00;0.00
Forum: General 10-11-2019, 01:44 PM
Replies: 7
Views: 135
Posted By CJ_London
Re: Maintaining database on remote

google sheets is nowhere near as powerful as a desktop excel - about the equivalent of office 365 online excel. However you can combine it with Google Forms

There is no real equivalent to access...
Forum: General 10-11-2019, 10:03 AM
Replies: 7
Views: 135
Posted By CJ_London
Re: Maintaining database on remote

You have a copy, make the changes in your copy of the fe and send it to the customer.

No - I maintain my client databases

In all cases I have the master copy and make changes to that then...
Showing results 1 to 25 of 500

 
Forum Jump



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