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 7 Days
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
09:52 AM
Welshgasman
replied to a thread
subForm returns 0
in
Forms
Perhaps explain a little more of why they are like that. Generally, repeating groups become separate records, but that is not 100% all the time.
see more
9 replies | 123 view(s)
Today,
09:36 AM
baouk2000
replied to a thread
subForm returns 0
in
Forms
There is an other way to design. But, it would Take more complicated way to code it in VBA and SQL. I'm not professional ..
see more
9 replies | 123 view(s)
Today,
09:23 AM
mike60smart
replied to a thread
subForm returns 0
in
Forms
All of those fields should not be in 1 record
see more
9 replies | 123 view(s)
Today,
09:12 AM
baouk2000
replied to a thread
subForm returns 0
in
Forms
Hi, I made this design because there is relation (formula) taking in consideration qte1m to qte6m ... or nb1m to nbm4m in the same record ..
see more
9 replies | 123 view(s)
Today,
09:03 AM
Welshgasman
replied to a thread
Better Search/Filtering Method
in
Access
Yes cascading, sounds like what you need. Plenty of data on those. Might want to start with a quick Google...
see more
1 replies | 36 view(s)
Today,
09:02 AM
Micron
replied to a thread
Combo Biox question
in
Access
Use a fixed width font?
see more
9 replies | 85 view(s)
Today,
08:40 AM
mike60smart
replied to a thread
subForm returns 0
in
Forms
Hi You need to look at the design of your tables. Your table MVMT has what are known as repeating groups. The fields qte1m through to qte6m...
see more
9 replies | 123 view(s)
Today,
08:24 AM
jhergert
started a thread
Better Search/Filtering Method
in
Access
Hello Everyone, I am in need of some advise/help with a better search and filtering method. Right now the code that i use for searching works...
see more
1 replies | 36 view(s)
Today,
07:35 AM
isladogs
replied to a thread
Form behaviour
in
Access
This article may help Accurately Move Forms & Controls (isladogs.co.uk) See sections on trips, pixels & points together with the use of the hidden...
see more
14 replies | 203 view(s)
Today,
06:53 AM
baouk2000
replied to a thread
subForm returns 0
in
Forms
Thank you CJ_London, I tested the date format yyyy-mm-dd and it works perfect :thanks:
see more
9 replies | 123 view(s)
Today,
05:09 AM
CJ_London
replied to a thread
subForm returns 0
in
Forms
other problem you have - in sql, when dates are expressed as a string they need to be in the format of mm/dd/yyyy or the sql standard of yyyy-mm-dd....
see more
9 replies | 123 view(s)
Today,
03:44 AM
baouk2000
replied to a thread
subForm returns 0
in
Forms
Thank you, F_MENU is not the principle Form, it is an other Form that is already open before principle Form ( and subForms ) Load
see more
9 replies | 123 view(s)
Today,
02:07 AM
CJ_London
replied to a thread
subForm returns 0
in
Forms
Subforms load before the main form so if F_Menu is your main form, the line mydate = !! will fail
see more
9 replies | 123 view(s)
Today,
02:01 AM
CJ_London
replied to a thread
Importing Excel into Access
in
Import/Export Data
Difficult to advise without seeing your code. Unfortunately macros are not very developer friendly for debugging. most developers here use vba....
see more
1 replies | 93 view(s)
Today,
01:55 AM
NoellaG
replied to a thread
SQL Server Functioln problem
in
SQL Server
Try something like: select @bnchmark = Benchmark from hvvmgrpt.dbo.tbl_benchmarks2 cross apply string_split(@tmpstr,',') where ID = value and...
see more
3 replies | 88 view(s)
Yesterday,
11:03 PM
baouk2000
started a thread
subForm returns 0
in
Forms
Hello, I have a matter with subforms that not return good result. subforms are based on conditional queries. queries return results when...
see more
9 replies | 123 view(s)
Yesterday,
09:31 PM
katjoe
started a thread
Importing Excel into Access
in
Import/Export Data
Hi, I am new with macro builder and need help with some errors. One, I am trying to import three spreadsheet tabs out of five from Excel into three...
see more
1 replies | 93 view(s)
Yesterday,
09:29 PM
Middlemarch
replied to a thread
Combo Biox question
in
Access
What I'm displaying varies and can be any length. All that I'll know is the number of characters. But the space they need varies because of the...
see more
9 replies | 85 view(s)
Yesterday,
09:08 PM
June7
replied to a thread
Combo Biox question
in
Access
Truncated in dropdown list? Will not wrap. Will wrap in the text box part if you increase height.
see more
9 replies | 85 view(s)
Yesterday,
08:54 PM
Middlemarch
replied to a thread
Combo Biox question
in
Access
Thanks June , that is working great - but now I see another problem. If the text doesn't fit it is truncated. Can it wordwrap? Or failing that, can...
see more
9 replies | 85 view(s)
Yesterday,
08:22 PM
June7
replied to a thread
Combo Biox question
in
Access
I revised my previous answer, perhaps after you first read. Initial test with UNBOUND combobox with ValueList exhibits same results you...
see more
9 replies | 85 view(s)
Yesterday,
08:02 PM
Middlemarch
replied to a thread
Combo Biox question
in
Access
Likewise moke, no change. I can see ItemData(0) though.
see more
9 replies | 85 view(s)
Yesterday,
07:53 PM
Middlemarch
replied to a thread
Combo Biox question
in
Access
June Unfortunately that had no effect. There's nothing in the combo box until the dropdown is clicked. Can this work, or is it a lost cause. In...
see more
9 replies | 85 view(s)
Yesterday,
07:45 PM
moke123
replied to a thread
Combo Biox question
in
Access
try Form_frmtest.cboA.DefaultValue = Form_frmtest.cboA.ItemData(0)
see more
9 replies | 85 view(s)
Yesterday,
07:36 PM
June7
replied to a thread
Combo Biox question
in
Access
I just tested with combobox that uses query for source. Setting DefaultValue to first item ID works, item is selected. But why bother with...
see more
9 replies | 85 view(s)
Yesterday,
07:14 PM
June7
replied to a thread
Form behaviour
in
Access
Read and set listbox Height property in VBA as TWIPS. 1440 TWIPS per inch. Fonts are measured in points, approx 72 points per inch. ...
see more
14 replies | 203 view(s)
Yesterday,
05:58 PM
davegri
replied to a thread
Form behaviour
in
Access
While I asserted that the height could be calculated, I had no formula in mind. I would work it out via trial and error.
see more
14 replies | 203 view(s)
Yesterday,
05:57 PM
Middlemarch
started a thread
Combo Biox question
in
Access
In an unbound Combo box can the default item be the first item in the list ? I'm trying For i = 1 To UBound(Files) ...
see more
9 replies | 85 view(s)
Yesterday,
05:02 PM
Middlemarch
replied to a thread
Form behaviour
in
Access
I'll check out a combo and pick whatever works best to display data. Re listbox, what's the formula to calculate height exactly? Can't find it on...
see more
14 replies | 203 view(s)
Yesterday,
02:45 PM
CJ_London
replied to a thread
Using Input boxes to populate a Form?
in
Access
don’t disagree but I was thinking of navigating from one control to another
see more
6 replies | 149 view(s)
More Activity
No More Results
No Recent Activity