Register
Help
Remember Me?
Forum
What's New?
Activity Stream
New Events
Mark Forums Read
Quick Links
Today's Posts
How to Post a Question
How to Mark Thread Solved
How to Attach Files
Advanced Search
Home
Activity Stream
AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please
join our community
, the registration is free and takes only one minute.
Activity Stream
Filter
Sort By
Time
Show
Recent
Recent
Popular
Popular
Anytime
Anytime
Last 7 Days
Last 7 Days
Last 30 Days
Last 30 Days
All
All
Photos
Photos
Forum
Forums
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
11:19 AM
skydivetom
replied to a thread
Crosstab query -- replaced NULL values with 0 (zeros) but replacement values are stored as text
in
Queries
Thank you both for the recommendation to remove the Format()... I appreciate it.
see more
5 replies | 52 view(s)
Today,
11:18 AM
skydivetom
replied to a thread
Crosstab query -- replaced NULL values with 0 (zeros) but replacement values are stored as text
in
Queries
I swapped the "Val" before the NZ... that did the trick! CountStatus: Val(Nz(Sum(),0))
see more
5 replies | 52 view(s)
Today,
11:12 AM
skydivetom
replied to a thread
Crosstab query -- replaced NULL values with 0 (zeros) but replacement values are stored as text
in
Queries
I changed the expression to: CountStatus: Nz(Sum(Val()),0) Unfortunately, they values still come out as text. See attached screenshot. ...
see more
5 replies | 52 view(s)
Today,
11:02 AM
CJ_London
replied to a thread
datasheet font set in module
in
Modules
suggest rather than using a datasheet which has fewer design options, use a continuous form
see more
10 replies | 289 view(s)
Today,
10:56 AM
CJ_London
replied to a thread
Crosstab query -- replaced NULL values with 0 (zeros) but replacement values are stored as text
in
Queries
The format function changes values to text. Just remove it and leave the nz function
see more
5 replies | 52 view(s)
Today,
10:31 AM
madpiet
replied to a thread
Crosstab query -- replaced NULL values with 0 (zeros) but replacement values are stored as text
in
Queries
Remove the Format() part. Specify the field types in the query. Format returns a string if I remember correctly.
see more
5 replies | 52 view(s)
Today,
10:14 AM
moke123
replied to a thread
Colo(u)r - what is the return value of the RGB Function?
in
Access
rgb function returns a long
see more
1 replies | 23 view(s)
Today,
09:48 AM
skydivetom
started a thread
Crosstab query -- replaced NULL values with 0 (zeros) but replacement values are stored as text
in
Queries
Hi: Please see attached sample DB (as well screenshot). The default crosstab includes NULL values for n records. I changed the crosstab's...
see more
5 replies | 52 view(s)
Today,
09:16 AM
Welshgasman
replied to a thread
unable to empty text boxes
in
Programming
Well I would say that is making it up as you go along. :)
see more
11 replies | 126 view(s)
Today,
09:06 AM
TOPSie
started a thread
Colo(u)r - what is the return value of the RGB Function?
in
Access
In any new code I develop I use the RGB function when defining control backcolor. But I have come across some old code which I am trying to tweak...
see more
1 replies | 23 view(s)
Today,
08:44 AM
davegri
replied to a thread
unable to empty text boxes
in
Programming
Lots of examples via google like Option Explicit statement (VBA) | Microsoft Learn
see more
11 replies | 126 view(s)
Today,
08:20 AM
lawdy
replied to a thread
unable to empty text boxes
in
Programming
Ok davegri , you solved it. I did have a label in the table mtQueryMenu. I deleted that object from the table and all methods works, = Empty, =...
see more
11 replies | 126 view(s)
Today,
07:49 AM
davegri
replied to a thread
unable to empty text boxes
in
Programming
If mtQueryMenu contains names of objects that do not have a .value property, such as labels, it will produce the 438 error. Still suggest you...
see more
11 replies | 126 view(s)
Today,
07:37 AM
Micron
replied to a thread
unable to empty text boxes
in
Programming
You may be able to eliminate some repetition by assigning an object to a variable, but I don't see how you're going to eliminate lines of code by...
see more
11 replies | 126 view(s)
Today,
07:24 AM
ano
replied to a thread
datasheet font set in module
in
Modules
mmm dnt know why im sure i did upload it , i try again
see more
10 replies | 289 view(s)
Today,
07:23 AM
lawdy
replied to a thread
unable to empty text boxes
in
Programming
I wasn't trying to make up my own code. "Forms!.Form!tbLineNumber] = Empty" will work. I use 'empty' like that all the time. I just wanted to make...
see more
11 replies | 126 view(s)
Today,
06:15 AM
mike60smart
replied to a thread
Access or Excell for my needs
in
Access
Hi Rob Are you able to upload a sample copy of your current Excel file without any confidential data?
see more
7 replies | 105 view(s)
Today,
04:49 AM
CJ_London
replied to a thread
datasheet font set in module
in
Modules
I don't see a screenshot
see more
10 replies | 289 view(s)
Today,
03:38 AM
antam
started a thread
error on the command with sub
in
Modules
Dear Everyone, The sub c1tim() on command 4 of form as follows: => error Sub c1tim(tablea As String, loai As String, x1 As Integer, tableb As...
see more
0 replies | 6 view(s)
Today,
03:19 AM
skydivetom
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
"If nothing is selected in listbox, why would you need to have anything in textbox?" Again, the subform is linked to the query! Listbox merely...
see more
9 replies | 134 view(s)
Today,
02:56 AM
hollies
replied to a thread
Access or Excell for my needs
in
Access
Good morning everyone. Many thanks for all of the replies. I've been fully retired for 12 years, so this is for leisure activities, ie Caravan...
see more
7 replies | 105 view(s)
Today,
02:41 AM
ano
replied to a thread
datasheet font set in module
in
Modules
sorry columnwidth i did mean and that should be cleat bec i refer to form resize :) if 2 forms beside each other under an other form like u see in...
see more
10 replies | 289 view(s)
Today,
01:58 AM
CJ_London
replied to a thread
datasheet font set in module
in
Modules
do you mean resize the column width? If so, you set the columnwidth property to -2, not the fontsize (and not coiumn per your first post no idea...
see more
10 replies | 289 view(s)
Today,
01:41 AM
NoellaG
replied to a thread
Access or Excell for my needs
in
Access
I think the most important question is : how do you want to work? I can imagine that most data would be entered/changed on location and you don't...
see more
7 replies | 105 view(s)
Today,
12:00 AM
ArviLaanemets
replied to a thread
Access or Excell for my needs
in
Access
Maybe all this is needed when you use your Excel DB from phone, but generally: Never put same kind of information on separate sheets; Never put...
see more
7 replies | 105 view(s)
Yesterday,
07:50 PM
June7
replied to a thread
unable to empty text boxes
in
Programming
Immediate window is just seeing Empty as a variable, possibly Variant. Can do the same with x: ?x = "" True ?x = 0 True
see more
11 replies | 126 view(s)
Yesterday,
07:45 PM
Salty Mariner
replied to a thread
Access or Excell for my needs
in
Access
How much time do you have, or are you willing to spend to learn something new like Access? This is something you should ask yourself before diving...
see more
7 replies | 105 view(s)
Yesterday,
07:30 PM
ano
replied to a thread
datasheet font set in module
in
Modules
after many continue searching and trying i have add a toggle button above the forms in form1. bound font to toggle and na the screen look fine with...
see more
10 replies | 289 view(s)
Yesterday,
07:20 PM
June7
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
I don't understand "incl. the previously selected value from its last execution". If Organization is same in all records, then agree, don't need...
see more
9 replies | 134 view(s)
Yesterday,
07:10 PM
skydivetom
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
Oh, btw... yes, a listbox value is shown/highlighted once a selection has been made. However, given my subform is automatically populated based on...
see more
9 replies | 134 view(s)
More Activity
No More Results
No Recent Activity