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,
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
0 replies | 0 view(s)
Today,
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 | 36 view(s)
Today,
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 | 36 view(s)
Today,
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 | 36 view(s)
Today,
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 | 36 view(s)
Today,
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 | 36 view(s)
Today,
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 | 36 view(s)
Today,
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 | 36 view(s)
Today,
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 | 36 view(s)
Today,
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 | 161 view(s)
Today,
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 | 161 view(s)
Today,
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 | 36 view(s)
Today,
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 | 161 view(s)
Today,
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 | 123 view(s)
Today,
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
2 replies | 54 view(s)
Today,
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
2 replies | 54 view(s)
Today,
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
2 replies | 54 view(s)
Today,
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 | 100 view(s)
Today,
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 | 123 view(s)
Today,
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 | 73 view(s)
Today,
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 | 73 view(s)
Today,
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 | 123 view(s)
Today,
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 | 177 view(s)
Today,
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 | 73 view(s)
Today,
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 | 74 view(s)
Today,
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 | 73 view(s)
Today,
07:48 AM
CJ_London
replied to a thread
Data base repair
in
Access
Your attachment is invalid - cannot open
see more
5 replies | 73 view(s)
Today,
07:42 AM
daveone23
started a thread
Data base repair
in
Access
Can someone fix this data base? Somehow it got messed up. The "clear" and search button no longer work. It should clear the entry and let me search...
see more
5 replies | 73 view(s)
Today,
07:23 AM
davegri
replied to a thread
Form behaviour
in
Access
Advantage of listbox is that multiple rows can be selected. Combobox can do that too if evils of multi-value table fields are invoked. Yes you can,...
see more
13 replies | 161 view(s)
Today,
06:59 AM
CJ_London
replied to a thread
How to Hide MS Access Database On Client Machine
in
Security
Just to say this thread is 11 years old - suspect the OP has their answer by now
see more
3 replies | 5647 view(s)
More Activity
No More Results
No Recent Activity