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
Filter by:
Last 30 Days
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
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
10 replies | 102 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
10 replies | 102 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
10 replies | 102 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
10 replies | 102 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
9 replies | 270 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
10 replies | 102 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 | 95 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
9 replies | 270 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 | 131 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 | 95 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
9 replies | 270 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
9 replies | 270 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 | 95 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 | 95 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
10 replies | 102 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 | 95 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
9 replies | 270 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 | 131 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 | 131 view(s)
Yesterday,
07:02 PM
skydivetom
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
June7: Almost there... =.(0) immediately displays a value once I select/change the listbox value. Great! HOWEVER... nothing is displayed upon...
see more
9 replies | 131 view(s)
Yesterday,
06:55 PM
June7
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
txtORGANIZATION_SELECTED is wrong usage. Must be a field in table/query such as the key field. Don't need to use DLookup. Include Organization...
see more
9 replies | 131 view(s)
Yesterday,
06:48 PM
skydivetom
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
It would be awesome if that's working! Right now, I have placed the following into the unbound's control CONTROL SOURCE: ...
see more
9 replies | 131 view(s)
Yesterday,
06:33 PM
June7
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
Works for me. No code needed. Does query have multiple records? Your DLookup can only always return value from first record because there is no...
see more
9 replies | 131 view(s)
Yesterday,
06:32 PM
skydivetom
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
Property = None
see more
9 replies | 131 view(s)
Yesterday,
06:32 PM
June7
replied to a thread
What DAO's Are Not Dynamic?
in
Access
Auto-correct will not modify references in quotes. I think OP's real problem is invalid DLookup expression. See post 10.
see more
12 replies | 127 view(s)
Yesterday,
06:23 PM
June7
replied to a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
There is no "Single" option for listbox. Multi-select property offers: Simple, Extended, None. Listbox cannot be set for multiple selection. ...
see more
9 replies | 131 view(s)
Yesterday,
06:21 PM
Gicu
replied to a thread
What DAO's Are Not Dynamic?
in
Access
I think the OP is looking for Name Autocorrect or similar functionality, it has improved since was first introduced but many programmers still shy...
see more
12 replies | 127 view(s)
Yesterday,
06:15 PM
skydivetom
started a thread
Need to requery/refresh DLOOKUP (in unbound control) after listbox selection has changed
in
Forms
Hello: I need some assistance with re-querying a DLOOKUP control. Process: - I have a form including 2 listboxes allowing to select a *SINGLE*...
see more
9 replies | 131 view(s)
More Activity
No More Results
No Recent Activity