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,
10:17 PM
Gicu
replied to a thread
How do I move to the next record when searching for a specific record.
in
Programming
You don't want to loop, check the code in this link, it is what the built in Access wizard uses for a "searching" combo box (using the FindFirst...
see more
1 replies | 0 view(s)
Today,
10:02 PM
CowCamp
started a thread
How do I move to the next record when searching for a specific record.
in
Programming
I have a main form (Cemetery) in this form I have a Map overlayed with a Grid, a ListBox (lstPeople) and a Button (btnEditPeople). The user can...
see more
1 replies | 0 view(s)
Today,
08:25 PM
Simon L.
replied to a thread
HTML in Access and Web Data Display
in
Access
Got it, thanks!
see more
2 replies | 62 view(s)
Today,
05:27 PM
CJ_London
replied to a thread
HTML in Access and Web Data Display
in
Access
Not clear to me what you are asking. You can use html as a source to a web control and the rich text field uses html for formatting text however I...
see more
2 replies | 62 view(s)
Today,
04:40 PM
orange
replied to a thread
Sample database retrieving Yahoo Finance info with WinHTTP into an Access table
in
Sample Databases
(For reference) Eric, There are several API's available from AlphaVantage. You might want to try a few and use their csv outputs to augment your...
see more
42 replies | 50888 view(s)
Today,
04:32 PM
Simon L.
started a thread
HTML in Access and Web Data Display
in
Access
Hi, I'm new here and not sure where to post this, so my apologies if I'm in the wrong forum! I have two somewhat related -- and probably pretty...
see more
2 replies | 62 view(s)
Today,
02:03 PM
mmmbl1962
replied to a thread
Using column numbers instead of column names in query
in
Access
I got it to work.. instead of using the column number I used the value from the dropdown box and concatenate "" as the header VENDOR: DLookUp("!!...
see more
10 replies | 164 view(s)
Today,
01:27 PM
madpiet
replied to a thread
export an mdb file to many CSV files with a record limit
in
Import/Export Data
Then use a TOP (n) query with a filter, and export it one chunk at a time. Nothing doing.
see more
2 replies | 62 view(s)
Today,
01:09 PM
Welshgasman
replied to a thread
export an mdb file to many CSV files with a record limit
in
Import/Export Data
Does it have an autonumber field that is incremental?
see more
2 replies | 62 view(s)
Today,
12:51 PM
amrad
started a thread
export an mdb file to many CSV files with a record limit
in
Import/Export Data
I need to know how I can export data from an access table to a csv file. The table has 14K records, and each csv file can only have 4K rows of data.
see more
2 replies | 62 view(s)
Today,
12:51 PM
madpiet
replied to a thread
Using column numbers instead of column names in query
in
Access
I'd unpivot this mess in Excel using PowerQuery, so you end up with a simple table with the following columns (Store, State, Brand(?), and whatever...
see more
10 replies | 164 view(s)
Today,
11:51 AM
Welshgasman
replied to a thread
Using column numbers instead of column names in query
in
Access
Have a read of this http://allenbrowne.com/casu-23.html
see more
10 replies | 164 view(s)
Today,
11:29 AM
CJ_London
replied to a thread
Using column numbers instead of column names in query
in
Access
Only way you can reference a column is using vba to loop through the recordset fields collection e.g. for I =0 to recordset.fields.count ...
see more
10 replies | 164 view(s)
Today,
10:23 AM
June7
replied to a thread
Using column numbers instead of column names in query
in
Access
And no, cannot use column numbers in SQL. I agree with other comments. Your data is not relational database normalized. However, could...
see more
10 replies | 164 view(s)
Today,
08:53 AM
Welshgasman
replied to a thread
Using column numbers instead of column names in query
in
Access
Far from normal I am afraid unless you are an Excel user. :( Access and Excel are completely two different beasts and you have to think differently...
see more
10 replies | 164 view(s)
Today,
08:47 AM
NoellaG
replied to a thread
Using column numbers instead of column names in query
in
Access
Hi, the table can look 'normal' to you, but it certainly isn't normalized. If you want to continue working with Access I suggest you read the link...
see more
10 replies | 164 view(s)
Today,
08:35 AM
mmmbl1962
replied to a thread
Using column numbers instead of column names in query
in
Access
Thank you for the reply. As far as I can tell my table is normal because it has regular column headers. What I am trying to do is when I select a...
see more
10 replies | 164 view(s)
Today,
08:17 AM
Welshgasman
replied to a thread
Can't add new (blank) record in a form
in
Forms
Look at the Record Source on the Data tab?
see more
5 replies | 127 view(s)
Today,
08:01 AM
JoeRCav8r
replied to a thread
Can't add new (blank) record in a form
in
Forms
How do I find out if the source of the form is a query?
see more
5 replies | 127 view(s)
Today,
07:56 AM
JoeRCav8r
replied to a thread
Can't add new (blank) record in a form
in
Forms
The Allow parameters are form view, datasheet view, layout view, additions, deletions, edits, filters. All are YES except datasheet view. This form...
see more
5 replies | 127 view(s)
Today,
04:52 AM
NoellaG
replied to a thread
Using column numbers instead of column names in query
in
Access
Or if you want to work further the way you started, use Excel (names like xls_Beer Vendors suggest you already do so). With a macro in Excel you...
see more
10 replies | 164 view(s)
Today,
01:50 AM
Welshgasman
replied to a thread
Using column numbers instead of column names in query
in
Access
Stop right there and normalise your tables, else you will be banging your head against a brick wall for most eveything you are trying to do. Always...
see more
10 replies | 164 view(s)
Yesterday,
11:16 PM
mmmbl1962
started a thread
Using column numbers instead of column names in query
in
Access
I have a table with our store numbers vendor numbers as data for rows and beer brands as the headers. I also have a drop down list where I can select...
see more
10 replies | 164 view(s)
Yesterday,
02:36 PM
Bulzie
replied to a thread
Can't add new (blank) record in a form
in
Forms
Yep thinking the source on the 3rd form is a query?
see more
5 replies | 127 view(s)
Yesterday,
02:06 PM
Welshgasman
replied to a thread
Can't add new (blank) record in a form
in
Forms
What are the properties for the form with Allow as the first word? What is the source for that form?
see more
5 replies | 127 view(s)
Yesterday,
01:28 PM
JoeRCav8r
started a thread
Can't add new (blank) record in a form
in
Forms
I have 3 forms in my database. Two of them allow me to add a new record by clicking on the yellow icon on the bottom bar. However, in the third...
see more
5 replies | 127 view(s)
Yesterday,
10:17 AM
diegomarino
started a thread
Modern chart upcoming!
in
Access
Hi, i didn't find anything on this forum, so i have to post this cause i'm very excited (and maybe i can sto linking excel charts on access) ...
see more
0 replies | 92 view(s)
Yesterday,
07:53 AM
davegri
replied to a thread
Extremely strange behaviour of Access overnight
in
Access
Give this a try: Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption (fmsinc.com)
see more
5 replies | 144 view(s)
Yesterday,
03:53 AM
Thomasso
replied to a thread
Extremely strange behaviour of Access overnight
in
Access
Haha, that is one very diplomatic way of saying that it needs some serious work. ;)
see more
5 replies | 144 view(s)
More Activity
No More Results
No Recent Activity