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,
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 | 117 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
6 replies | 81 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
7 replies | 249 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
7 replies | 249 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
6 replies | 81 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
6 replies | 81 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
5 replies | 86 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
6 replies | 81 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
7 replies | 249 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 | 117 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 | 117 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 | 117 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 | 117 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 | 117 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 | 117 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 | 117 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 | 120 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 | 117 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 | 120 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 | 117 view(s)
Yesterday,
03:43 PM
Welshgasman
replied to a thread
What DAO's Are Not Dynamic?
in
Access
I *think* the o/p is talking about, they had a dlookup on tbills but then had to change it to tbills2, but their dlookup and anything else did not...
see more
12 replies | 120 view(s)
Yesterday,
03:39 PM
June7
replied to a thread
What DAO's Are Not Dynamic?
in
Access
If by dynamic you mean it will calculate for each record, expression needs to reference value from current record. Complete the WHERE argument for...
see more
12 replies | 120 view(s)
Yesterday,
03:19 PM
Welshgasman
replied to a thread
Access or Excell for my needs
in
Access
I would also say Access, but that takes a different way of thinking, if you are used to Excel. I have created Excel workbooks in the past using dB...
see more
6 replies | 81 view(s)
Yesterday,
03:12 PM
CarlettoFed
replied to a thread
Access or Excell for my needs
in
Access
I would definitely say Access.
see more
6 replies | 81 view(s)
Yesterday,
02:40 PM
hollies
started a thread
Access or Excell for my needs
in
Access
Hello, novice question as I am not sure if an Access database is right for my needs or if I would be better served with a spreadsheet. I visit...
see more
6 replies | 81 view(s)
Yesterday,
02:32 PM
Salty Mariner
replied to a thread
Using Cutom Functions in a Query (form recordset)
in
Queries
Time is a derivative of distance / speed so yes there is a direct relationship.
see more
17 replies | 291 view(s)
Yesterday,
02:28 PM
Thompyt
started a thread
Adding Dig Sig blocks to PDF
in
Programming
Hello all, I have gleaned and tried to modify some VBA code to add 3 digital signature blocks to an exported pdf. It seems to be doing something,...
see more
0 replies | 46 view(s)
Yesterday,
02:27 PM
Micron
replied to a thread
What DAO's Are Not Dynamic?
in
Access
Not sure I understand your question. If I build a form and its recordsource is a table or query, I know which table it is by looking at the form or...
see more
12 replies | 120 view(s)
More Activity
No More Results
No Recent Activity