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,
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
1 replies | 33 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 | 51 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 | 60 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
1 replies | 33 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 | 51 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 | 54 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 | 54 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 | 54 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 | 54 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 | 54 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 | 54 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 | 54 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 | 54 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
13 replies | 166 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
13 replies | 166 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 | 54 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
13 replies | 166 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 | 129 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 | 60 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 | 60 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 | 60 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 | 103 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 | 129 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 | 78 view(s)
Yesterday,
10:24 AM
Welshgasman
replied to a thread
Data base repair
in
Access
Have you moved the DB?, is it in a Trusted location? So the code is not running? Put a breakpoint on the first available line in that code. Does...
see more
5 replies | 78 view(s)
Yesterday,
09:08 AM
easyrider
replied to a thread
Using Input boxes to populate a Form?
in
Access
So here's a screenshot of the form's current iteration. I've consolidated the Owner's address & Owner's mailing address sections, thus reducing the...
see more
6 replies | 129 view(s)
Yesterday,
08:55 AM
mattreed75
replied to a thread
Checking for Similar Values Contained in Different Records in Another Field
in
Queries
Thanks again. Your first recommendation reminded me that I already had a query that placed X's in blocks assigned to morning and afternoon sessions...
see more
14 replies | 188 view(s)
Yesterday,
08:48 AM
daveone23
replied to a thread
Data base repair
in
Access
I see that visual basic code in my program but it does not work. I am lost. Clear filter does not clear the box and the number in the box does not...
see more
5 replies | 78 view(s)
Yesterday,
08:17 AM
Micron
replied to a thread
Having windows explorer show the width and height of a folder with pictures
in
Programming
Why VBA? In File Explorer and with the folder view set to Details right click on a column header and choose Dimensions from the columns list. Done.
see more
1 replies | 75 view(s)
Yesterday,
07:51 AM
Welshgasman
replied to a thread
Data base repair
in
Access
Me.txtFindATube = "" Me.Filter = "" Me.FilterOn = False Edit. It opens for me and works for me? This is your code, which is what I suggested...
see more
5 replies | 78 view(s)
More Activity
No More Results
No Recent Activity