Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.92 seconds.
Search: Posts Made By: CJ_London
Forum: Tables Yesterday, 11:55 PM
Replies: 3
Views: 54
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 Yesterday, 05:40 AM
Replies: 5
Views: 97
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 Yesterday, 03:39 AM
Replies: 10
Views: 113
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 Yesterday, 03:07 AM
Replies: 12
Views: 117
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 Yesterday, 02:16 AM
Replies: 12
Views: 117
Posted By CJ_London
Re: Whats the best approach too??????

and what do you call the linked table?
Forum: General Yesterday, 01:15 AM
Replies: 12
Views: 117
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 Yesterday, 12:44 AM
Replies: 12
Views: 117
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 Yesterday, 12:20 AM
Replies: 12
Views: 117
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 Yesterday, 12:08 AM
Replies: 3
Views: 64
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: 114
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: 134
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: 134
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...
Forum: General 10-11-2019, 09:20 AM
Replies: 7
Views: 134
Posted By CJ_London
Re: Maintaining database on remote

Depends on what you mean by maintenance - if you mean you will be doing things like fixing problems, undertaking installation etc, your customer needs to allow you remote access so you can connect...
Forum: General 10-11-2019, 12:37 AM
Replies: 24
Views: 1,042
Posted By CJ_London
Re: Moving to SQL Server

Not sure if you have understood what Pat was saying or whether it is your termininology. Filtering occurs in forms after you have brought across the recordset. Pat is saying apply criteria before you...
Forum: Queries 10-10-2019, 09:18 AM
Replies: 5
Views: 732
Posted By CJ_London
Re: Query taking awfully long to process :(

another method is to join the table to itself with a non standard join (in red below) - i.e. can only be done in the sql window

SELECT M.Customer, M.tDate, sum(T.DC) as Bal
FROM [Cleansed...
Forum: Tables 10-10-2019, 05:37 AM
Replies: 12
[SOLVED] duplicate index
Views: 173
Posted By CJ_London
Re: duplicate index

by autogenerated, do you mean an autonumber?

And have you checked the table design for fields set to 'indexed, no duplicates'
Forum: Forms 10-10-2019, 05:32 AM
Replies: 12
[SOLVED] Text Formatting
Views: 136
Posted By CJ_London
Re: Text Formatting

you can use the format property in that case for numeric types

if you can work with the basis of null=N/A and -1=FAIL then a format property set to

0.0"";[RED]"Fail";0.0"";"N/A"

should do...
Forum: Queries 10-10-2019, 05:26 AM
Replies: 21
Views: 496
Posted By CJ_London
Re: I a little direction in starting my project

No, depends on how many columns but I have db's with millions of records. You are talking about 30,000 which is not much at all.

If you need to know which workbook and/or which worksheet a record...
Forum: Forms 10-10-2019, 03:41 AM
Replies: 12
[SOLVED] Text Formatting
Views: 136
Posted By CJ_London
Re: Text Formatting

you can't do it with the format properties - they require a consistent datatype (text, number, date)

and text only has two states - either there is some text, or there isn't (null)

numbers have...
Forum: Theory and practice of database design 10-10-2019, 01:16 AM
Replies: 57
Views: 19,340
Posted By CJ_London
Re: Access OOP examples wanted

I use OOP for some things, but not all. Primarily for creating new events

Took a look at JDraws mouseover event link as I have written my own class to handle it. The code in the link is simpler...
Forum: Access Web 10-09-2019, 02:11 AM
Replies: 6
Views: 110
Posted By CJ_London
Re: Access Web DB running on Linux... Possible??

Your question is a bit vague about what you actually want to do - develop or execute

there are these opensource options
https://opensource.com/alternatives/access

however no experience of any...
Forum: Queries 10-08-2019, 11:05 AM
Replies: 21
Views: 223
Posted By CJ_London
Re: Close Queries if no records

what happens if you right click on the top bar of the query window? Do you not see?
https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=76862&stc=1&d=1570561472
Forum: Modules & VBA 10-08-2019, 07:19 AM
Replies: 3
Views: 87
Posted By CJ_London
Re: Getting data from external website

code in excel can be adapted to work in access. Also take a look at the bottom of this thread for similar questions
Forum: Queries 10-08-2019, 07:16 AM
Replies: 21
Views: 223
Posted By CJ_London
Re: Close Queries if no records

how about something like

if dcount("*","SearchCaTrackerCLUpdatedOn_Bt_qry")> 0 then
DoCmd.OpenQuery "SearchCaTrackerCLUpdatedOn_Bt_qry"
else
msgbox "No results to return in " &...
Forum: The Watercooler 10-08-2019, 01:24 AM
Replies: 2,992
Views: 579,969
Posted By CJ_London
Re: What's your best/worst joke?

A horse and a chicken are playing in a meadow. The horse falls into a mud hole and is sinking. He calls to the chicken to go and get the farmer to help pull him out to safety. The chicken runs to the...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:08 AM.


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