Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.26 seconds.
Search: Posts Made By: CJ_London
Forum: Forms Today, 03:43 PM
Replies: 10
Views: 58
Posted By CJ_London
Re: Centering a Rectangle on a Form

to avoid confusion, please get your terminology right. the form is as wide as you set it - up to a maximum 22 inches. the window can be any width up to the width of the monitor or multiple monitors...
Forum: Forms Today, 03:09 PM
Replies: 10
Views: 58
Posted By CJ_London
Re: Centering a Rectangle on a Form

the width of the form (which is what you design) is not the same as the width of the window (which is where the form is displayed i.e. what you see)

the window may be much wider or narrower that...
Forum: Forms Today, 11:13 AM
Replies: 10
Views: 58
Posted By CJ_London
Re: Centering a Rectangle on a Form

the coordinates you need to calculate are left and top

so to centre horizontally (using the left property) you take the width of the form, subtract the width of your rectangle and divide by 2
...
Forum: Tables Today, 08:31 AM
Replies: 14
Views: 279
Posted By CJ_London
Re: 900+ blank records appearing in Table!

compact and repair should be part of a regular maintenance routine. Otherwise change the way the data is imported. Link to the excel file then run an append query, filtering out the blank rows.
Forum: Reports Today, 07:17 AM
Replies: 3
Views: 60
Posted By CJ_London
Re: Trying to use a Cross Tab Query to build a sup report

fixed columns means to need to specify them - in the query window, click on properties and complete the column headings. You appear to be showing a full years worth of data so not sure why this is a...
Forum: Introduce Yourself Today, 01:21 AM
Replies: 2
Views: 54
Posted By CJ_London
Re: Access and VBA

looks like you may be missing a library reference. Go back to your 2007 version, open vba and at the top click on Tools>References and see if there is a reference to Lotus Notes ticked.

If so,...
Forum: SQL Server 02-17-2018, 02:54 AM
Replies: 5
Views: 158
Posted By CJ_London
Re: Access2010 & sqle 3.5

your error message is telling you where the error is - line 3, 23 characters in and an = sign.

My guess is it is the iif which is cause the problem. iif is a vba function and although available...
Forum: Macros 02-16-2018, 07:36 AM
Replies: 2
Views: 105
Posted By CJ_London
Re: Show All Actions in Macro not doing anything

cross posted here http://www.accessforums.net/showthread.php?t=70629 with responses from Ranman!

@habboubih - please read this link about the etiquette of cross posting
...
Forum: Tables 02-16-2018, 03:57 AM
Replies: 14
Views: 275
Posted By CJ_London
Re: Are certain table relationships redundant?

looks a lot better to me:)

But it is your app, so long as it meets the requirements. With regards Marks comments, they may be beyond the scope of the original question however I would agree these...
Forum: Queries 02-15-2018, 07:10 AM
Replies: 9
Views: 170
Posted By CJ_London
Re: Query with 2 LEFT JOINS to different tables not bringing back what I want

not a problem, but until you can, you can always paste a link as text
Forum: Forms 02-15-2018, 05:40 AM
Replies: 18
Views: 216
Posted By CJ_London
Re: Cross referencing tables

dcount can never return a value less than 0

and I suspect your data is not what you think

time is stored as a decimal expressed as the time in seconds divided by the number of seconds in a...
Forum: Forms 02-15-2018, 03:50 AM
Replies: 18
Views: 216
Posted By CJ_London
Re: Cross referencing tables

according to your code that is to be expected
Forum: Forms 02-15-2018, 02:59 AM
Replies: 18
Views: 216
Posted By CJ_London
Re: Cross referencing tables

your spaces left field is a text field, either change it to a number type or change your code

....AND [Spaces Left] = '0'
Forum: Queries 02-15-2018, 01:34 AM
Replies: 20
Views: 308
Posted By CJ_London
Re: Check box to select output fields

possibly with code but no idea what that code would look like without knowing your table structure and how your form is constructed.
Forum: Forms 02-15-2018, 01:30 AM
Replies: 18
Views: 216
Posted By CJ_London
Re: Cross referencing tables

and it also helps to know what the runtime error actually is. So please also provide some example data - I suspect it is your start time on your form is not in a time format
Forum: Queries 02-14-2018, 11:37 AM
Replies: 9
Views: 170
Posted By CJ_London
Re: Query with 2 LEFT JOINS to different tables not bringing back what I want

not sure what the OP is trying to achieve but you can modify the criteria from say

RightTable.field=somevalue

to

RightTable.field=somevalue OR RightTable.field is null
Forum: Queries 02-14-2018, 10:24 AM
Replies: 9
Views: 170
Posted By CJ_London
Re: Query with 2 LEFT JOINS to different tables not bringing back what I want

for the benefit of responders, cross posted here with responses

http://www.accessforums.net/showthread.php?t=70593

@code - please read this link about the etiquette of cross posting...
Forum: Forms 02-14-2018, 10:00 AM
Replies: 18
Views: 216
Posted By CJ_London
Re: Cross referencing tables

you are missing a " at the end of your criteria which vba will be telling you with the syntax error (although with those spaces, the error description may be misleading). But hey, keep it as your...
Forum: Modules & VBA 02-14-2018, 09:45 AM
Replies: 5
Views: 125
Posted By CJ_London
Re: Issue with user permission

I didn't even see it, think I need a new monitor:)
Forum: Modules & VBA 02-14-2018, 05:47 AM
Replies: 5
Views: 125
Posted By CJ_London
Re: Issue with user permission

mo - are you making a statement or asking a question? and if asking a question, what is the issue?
Forum: Modules & VBA 02-14-2018, 05:46 AM
Replies: 2
Views: 96
Posted By CJ_London
Re: Permission on Form

mo - there is nothing to see
Forum: Forms 02-14-2018, 03:58 AM
Replies: 8
Views: 153
Posted By CJ_London
Re: Multiple users

you always split a database and users should always have their own copy of the FE, record locking has nothing to do with it. See this current link as to what can happen when you don't....
Forum: Tables 02-14-2018, 03:47 AM
Replies: 14
Views: 275
Posted By CJ_London
Re: Are certain table relationships redundant?

relationships only matter for the control of data, otherwise you are just using them as documentation to auto populate a query in the query builder when the two tables are included.

so if you...
Forum: Queries 02-14-2018, 01:21 AM
Replies: 14
Views: 242
Posted By CJ_London
Re: Join with null values

From Colins link I see ZLS also stands for Zero Lifetime Space - now does anyone want to explain what that is?
Forum: Tables 02-13-2018, 04:53 PM
Replies: 14
Views: 279
Posted By CJ_London
Re: 900+ blank records appearing in Table!

if you are importing a worksheet it will import everything in that sheet from cell A1 to the bottom right cell that has been used by row and column (used at some point, may well be empty now)
...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:47 PM.


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

Sponsored Links

How to advertise

Media Kit


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