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,
05:46 PM
June7
replied to a thread
Changing image source
in
Access
All images are external from database? What condition for display of image files? Can have IIf() expression in ControlSource. I have never used...
see more
4 replies | 96 view(s)
Today,
05:42 PM
Middlemarch
replied to a thread
Changing image source
in
Access
Thank you. Have now changed to using a Form with Border style none (instead of an image control) and the problem has gone away.
see more
4 replies | 96 view(s)
Today,
09:32 AM
Gicu
replied to a thread
Changing image source
in
Access
Usually it is done by setting the Picture property of the image control in the Current event of the form; basically you would use...
see more
4 replies | 96 view(s)
Today,
06:41 AM
skydivetom
replied to a thread
Issues with query (linked to crosstab) when a value (for column heading) is missing
in
Queries
Orange: Please see attached screenshot. Entering crosstab's field headers (e.g., "A", "B", "C", "D", "E") into the column headings will include...
see more
4 replies | 134 view(s)
Today,
05:11 AM
orange
replied to a thread
Changing image source
in
Access
Did you look at Similar Threads at the bottom of the page to see if any offered insight on an approach? There is one marked SOLVED that has 7...
see more
4 replies | 96 view(s)
Today,
05:05 AM
orange
replied to a thread
Issues with query (linked to crosstab) when a value (for column heading) is missing
in
Queries
Tom, You might want to post a sample showing the related code and some descriptive material. It might be helpful to others. I'd suggest the Code...
see more
4 replies | 134 view(s)
Today,
04:29 AM
skydivetom
replied to a thread
Issues with query (linked to crosstab) when a value (for column heading) is missing
in
Queries
Yes, it is solved. I found solution where I could force field headings in query's column heading properties. Thank you.
see more
4 replies | 134 view(s)
Yesterday,
10:42 PM
Middlemarch
started a thread
Changing image source
in
Access
My image control is bound to a query, but I'd like to conditionally change the picture but restore it when moving to another record. I tried using a...
see more
4 replies | 96 view(s)
Yesterday,
06:16 PM
madpiet
replied to a thread
Students Database
in
Forms
What do you mean by Class1 and Class2? Is this a students and classes database? (Oh that done to death database!) Without an explanation how the...
see more
2 replies | 112 view(s)
Yesterday,
02:51 PM
abdulhafiz
replied to a thread
Creating a search form
in
Forms
Thanks for the quick reply, will check it out
see more
2 replies | 88 view(s)
Yesterday,
02:26 PM
Welshgasman
replied to a thread
Creating a search form
in
Forms
http://allenbrowne.com/ser-62.html
see more
2 replies | 88 view(s)
Yesterday,
02:04 PM
abdulhafiz
started a thread
Creating a search form
in
Forms
I created an ms access database with the following tables: ActiveIngredients, Class, Indications and with the following junction tables :...
see more
2 replies | 88 view(s)
Yesterday,
05:58 AM
Davide
replied to a thread
form field update
in
Access
Thanks, but I think I could have just solved adding the following line of code: Forms.main_form.Refresh I have to do more tests, but it seems...
see more
2 replies | 88 view(s)
Yesterday,
05:45 AM
Welshgasman
replied to a thread
Students Database
in
Forms
Depends on your structure? If you have Year table, then you would just change the keys that link the Years to the Students.
see more
2 replies | 112 view(s)
Yesterday,
05:44 AM
Welshgasman
replied to a thread
form field update
in
Access
As it is in a subform you can use Me.Parent.ControlName I would expect that SaveRecord to apply to the form it is in (the subform)? You could try...
see more
2 replies | 88 view(s)
Yesterday,
04:22 AM
Abdulaym
started a thread
Students Database
in
Forms
Good day friends, please am new in Ms Access DB. I have a table data contains students biodata, Classes(combo drop-down) & payments. Please do I...
see more
2 replies | 112 view(s)
Yesterday,
03:17 AM
Davide
started a thread
form field update
in
Access
Dear all, I am updating the field control_level of the main form from a subform. Unfortunately, the new value won't show up (and the associated...
see more
2 replies | 88 view(s)
Yesterday,
03:12 AM
June7
replied to a thread
Issues with query (linked to crosstab) when a value (for column heading) is missing
in
Queries
Thread is marked Solved. Is it? If you want to force column headings to display even when there is no data for that category, must specify...
see more
4 replies | 134 view(s)
Yesterday,
03:10 AM
June7
replied to a thread
One liner to find the position/index of a value in list box??
in
Access
Just how are you interacting with this text file? Have you set a table link to it? A graphic of schema might be helpful. Or could provide files...
see more
6 replies | 205 view(s)
Yesterday,
01:04 AM
Welshgasman
replied to a thread
Importing Excel into Access
in
Import/Export Data
If you must have spaces in your fieldnames :( then you need to surround them with Put the sql into a string varibale and debug.print it until you...
see more
14 replies | 1074 view(s)
Yesterday,
12:29 AM
Welshgasman
replied to a thread
Importing Excel into Access
in
Import/Export Data
Use the # button :(Sub ImportData() Dim fileName As String Dim filePath As String Dim WKS As Object Dim WKB as object Dim colWorksheet as object...
see more
14 replies | 1074 view(s)
05-10-2024,
11:47 PM
katjoe
replied to a thread
Importing Excel into Access
in
Import/Export Data
Hi, I would like to thank everyone' for their help. I had success in getting my script to run. Now, I would like to add a SQL query to update...
see more
14 replies | 1074 view(s)
05-10-2024,
11:25 PM
skydivetom
started a thread
Issues with query (linked to crosstab) when a value (for column heading) is missing
in
Queries
Hello: I'd like to get some assistance with a query linked to a crosstab query. I'll provide some background first. Background (file...
see more
4 replies | 134 view(s)
05-10-2024,
08:02 PM
madpiet
replied to a thread
Linking Single Values from Multiple Combo Boxes with ID Control Source to Single Foreign ID
in
Access
Why not do something sensible like remove the "used" items from the combobox for the given record, so a user can't add the same analyst 3 times? Or...
see more
10 replies | 203 view(s)
05-10-2024,
02:59 PM
Welshgasman
replied to a thread
Linking Single Values from Multiple Combo Boxes with ID Control Source to Single Foreign ID
in
Access
So cycle through your combos. If they have a value use either sql to add a record or a recordset. The choice is up to you. Now how you get them...
see more
10 replies | 203 view(s)
05-10-2024,
02:47 PM
pbaldy
replied to a thread
Linking Single Values from Multiple Combo Boxes with ID Control Source to Single Foreign ID
in
Access
Post 8 was moderated, I'm posting to trigger email notifications.
see more
10 replies | 203 view(s)
05-10-2024,
02:38 PM
Welshgasman
replied to a thread
Access or Excell for my needs
in
Access
However that raises a familiar issue. If you do decide to ask elsewhere, it is polite to mention in each place that you have done so, and supply a...
see more
30 replies | 995 view(s)
05-10-2024,
01:56 PM
cgoss
replied to a thread
Linking Single Values from Multiple Combo Boxes with ID Control Source to Single Foreign ID
in
Access
Well, the main thing isn't the constraint - I agree I could limit that through some code, but the constraint itself isn't needed for this. I am...
see more
10 replies | 203 view(s)
More Activity
No More Results
No Recent Activity