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,
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
5 replies | 92 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
0 replies | 10 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 | 183 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
5 replies | 92 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
5 replies | 92 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
5 replies | 92 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
5 replies | 92 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 | 85 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 | 82 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
5 replies | 92 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 | 85 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
8 replies | 76 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
8 replies | 76 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
8 replies | 76 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
8 replies | 76 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
8 replies | 76 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
8 replies | 76 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
8 replies | 76 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
8 replies | 76 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 | 183 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 | 183 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
8 replies | 76 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 | 183 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 | 141 view(s)
Yesterday,
01:19 PM
RayMilhon
replied to a thread
SQL Server Functioln problem
in
SQL Server
Sorry thought I had put that after the code tag. yes tmpstr it's not the value being returned is < 25 characters. It kept erroring and I was...
see more
3 replies | 82 view(s)
Yesterday,
12:51 PM
June7
replied to a thread
SQL Server Functioln problem
in
SQL Server
Please edit your post so the narrative below code is not between CODE tags. And when you say "tempvar", did you mean "tmpstr"? bchmark is declared...
see more
3 replies | 82 view(s)
Yesterday,
12:40 PM
RayMilhon
started a thread
SQL Server Functioln problem
in
SQL Server
I have a sql server function that queries a table to get a value for a report. The function looks like this. SET ANSI_NULLS ON GO SET...
see more
3 replies | 82 view(s)
Yesterday,
12:31 PM
SilverDevil72
replied to a thread
DB update error - DB or object is read only.
in
Access
After several days of frustration i deleted the .edit command and the error went away!!!! Incredible!! Many thanks for the responses.
see more
5 replies | 109 view(s)
Yesterday,
12:16 PM
June7
replied to a thread
Using Input boxes to populate a Form?
in
Access
In my experience, your form is fairly simple. The multiple similar name fields of AttributeX indicates a non-normalized structure. All 6 are...
see more
6 replies | 141 view(s)
Yesterday,
11:07 AM
daveone23
replied to a thread
Data base repair
in
Access
I made the directory and it works again. Thanks
see more
5 replies | 90 view(s)
More Activity
No More Results
No Recent Activity