I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access Board   Print This     

MS Access Interactive Topic RecentCreated Threads

Interactive Access (creating forms, reports, queries, etc.).
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

PS_2515
Best Blinds Online
Get stylish and modern Newcastle Blinds to cover up your window and other desired location. Lakeview Blinds Awnings & Shutters carefully manufacture the best quality products that are long-lasting. Get affordable shutters, blinds, awnings, security screen door, window screens & coverings. Browse now. 
14 days ago
Nothing New Since Your Last Visit
10
Hits

Thread 24 of 25
Thread Starter  

PS_2516
Graduation Invitations
{Too Long!}
71 days ago
Nothing New Since Your Last Visit
36
Hits

Thread 23 of 25
Thread Starter  

PS_2515
Get Best Awnings
{Too Long!}
71 days ago
Nothing New Since Your Last Visit
36
Hits

Thread 22 of 25
Thread Starter  

PS_2205
MS Access Memo Field Problems
coolBeing an Access database user it’s too common to encounter several issues regarding several of it’s functions. Among various function one very common massive issue creator function is MEMO. Have you used it ever in your database….? Whether you have used it or needs to use it in future in both the cases you it’s important to have right knowledge of how to tackle problem conquered during accessing of Memo In Access database. To catch complete information regarding this MS Access Memo Field Problems, check out this helpful post. 4 Common MS Access Memo Field Problems Along With It’s Fixes wink
8 months ago
1 Reply:

Sean.G
Helpful post! happy wheels full
5 months ago
Nothing New Since Your Last Visit
125
Hits

Thread 21 of 25
Thread Starter  

Wade.G
Query help (again)
I have 2 tables, one (tblLOCProfile) is a list of locations, start day, and end day (LOCATION, StartDay, EndDay).  The other table (tblDailyData) consists of a list of locations and a temperature reading for each day of the year (LOCATION, DayofYear, TEMPERATURE). What I want to do is get an average of TEMPERATURE for each location based of the Day of Year range (StartDay, EndDay) from the first table.  THe kicker is the StartDay and EndDay may be different for each location. Any ideas of how to go about constructing such a query? Thanks,
10 years ago
Nothing New Since Your Last Visit
2147
Hits

Thread 20 of 25
Thread Starter  

Wade.G
Query help
{Too Long!}
10 years ago
Nothing New Since Your Last Visit
2906
Hits

Thread 19 of 25
Thread Starter  

mrs179
Form with dependent combo boxes (beginner)
Hello- Very much a beginner at Access here.  I'm trying to create a form for data entry, and may have several questions, but let's start with this one: I am entering data related to employee attendance at professional development sessions.  There are six categories of sessions, and each category contains about 20-40 independent sessions. For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question  (sorted by data and course title) is selected.  Of course, I would rather not have the second combo box contain over 200 sessions.  The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second? Thanks in advance.,
12 years ago
1 Reply:

dmichael
{Too Long!}
10 years ago
Nothing New Since Your Last Visit
4324
Hits

Thread 18 of 25
Thread Starter  

gsempcb
Populating ComboBox...
(Hi, I am using Microsoft Access 2003) Is it possible to populate a ComboBox with choices from more than one field? I've got a couple of different tables, both having a "Department" field. One table has some departments, and the other table (Linked SharePoint table) has some different departments. I've got a form with a ComboBox control where the user picks a department from the drop-down list, and right now it only pulls the departments from one of the tables (the non-SharePoint regular table). Is it possible I could give the ComboBox "Row Source" property to, in addition to pulling data from the one table, also adding the Department field from the SharePoint table, too? Just so it lists all departments from both tables. Any help is appreciated, thanks.
12 years ago
13 replies. Last post:

nashwannabe7
{Too Long!}
12 years ago
Nothing New Since Your Last Visit
6773
Hits

Thread 17 of 25
Thread Starter  

gsempcb
Mathematical data in a report..
{Too Long!}
12 years ago
4 replies. Last post:

nashwannabe7
{Too Long!}
12 years ago
Nothing New Since Your Last Visit
3007
Hits

Thread 16 of 25
Thread Starter  

craigh
upgrading Access97 DB to Access 2007.

I have a database that I wrote about 8 years ago in Access 97. I need to upgrade it to Access 2007. I know parts of the VBA code I wrote do not work. I need a frame of reference to begin to rewrite whatever parts of the code that are incompatible, but I don't even know where to begin. I assume some functions and stuff changed over 10 years.

What I was hoping was someone could give me a starting point - a resource of "how to upgrade" or "here's all the functions that changed", etc. Can someone get me started? TIA

12 years ago
Nothing New Since Your Last Visit
2594
Hits

Thread 15 of 25
Thread Starter  

gsempcb
Acess 2003 basic report question...
I am using Access 2003. Say you've got a report that draws some fields from a query, then spits out their values on a report. Now what if I wanted to set some sort of condition on one of the number data-type fields such that, "If is blank/zero, don't display other field."  In this report, say I want to set it up such that "If 'Hours Spent' is blank/zero, then don't display 'Project Description' (or make it blank--whatever)." And then, how would you do something like "If 'Hours Spent' is blank/zero, then don't show that particular record at all." ? Is this possible?
12 years ago
3 replies. Last post:

nashwannabe7
Ok, I was mistaken. I thought since I had not directly addressed this that it was not yet fixed. But it appears to be self-correcting--possibly as a result of what I did in correcting the other field--as I now cannot make a query that returns any blank numeric values at all in the report. So that's great. Thank you for replying.
12 years ago
Nothing New Since Your Last Visit
3080
Hits

Thread 14 of 25
Thread Starter  

gsempcb
Form questions...
{Too Long!}
12 years ago
3 replies. Last post:

nashwannabe7
{Too Long!}
12 years ago
Nothing New Since Your Last Visit
3428
Hits

Thread 13 of 25
Thread Starter  

gsempcb
Stuck, in Access 2003...
{Too Long!}
12 years ago
3 replies. Last post:

nashwannabe7
{Too Long!}
12 years ago
Nothing New Since Your Last Visit
3920
Hits

Thread 12 of 25
Thread Starter  

S0nY
New to Access, File Size Question.
I am very new to MS Access i have a question. My.mdb file is 312MB, i am looking thru the mdb file at the tables and queries and what not that are in my mdb file, i am trying to figure out which tables in my mdb file are the largest.. I have found in the file menu Database properties and it tells me the total size of the mdb file, but is there a way i can see the file size of each table and wetc that are inside of my mdb file ? Thank for the help, David.
13 years ago
3 replies. Last post:

S0nY
Again Daniel, you once again helped me, thank alot ! hehe
13 years ago
Nothing New Since Your Last Visit
3702
Hits

Thread 11 of 25
Thread Starter  

lucasLondon
Full Outer Join in Access
{Too Long!}
13 years ago
1 Reply:

Dan
{Too Long!}
13 years ago
Nothing New Since Your Last Visit
5172
Hits

Thread 10 of 25
Thread Starter  

kbeana
macro won't run on another computer
{Too Long!}
14 years ago
Nothing New Since Your Last Visit
2554
Hits

Thread 9 of 25
Thread Starter  

JBoeder
How to add Pic at Input Scree
Can someone share with me how to allow a user to add a picture (embedded) to a database at the Data input screen? It seems everytime I try it blows up the program or maybe my brain is not able to wrap itself around the process. Please help!!!
14 years ago
1 Reply:

SANDMAN
Hello: This URL to tutorials onMSAcess maybe of some help to you ? http://search.yahoo.com/search?ei=UTF-8&y=Search&fr=yfp-t-501&p=ms+access+tutorial&rs=5&fr2=rs-top
13 years ago
Nothing New Since Your Last Visit
3820
Hits

Thread 8 of 25
Thread Starter  

salating
Counting in Reports
I am making a report that has to count different locations for each company I have in a table., , Each company has more than one POA with different locations. , , Example:, ABC Company has ABC Components with 34 locations and ABC Products with 50 locations., , I need it to read all those locations for ABC Company and display a total., , How would I count this in a report?
15 years ago
1 Reply:

salating
{Too Long!}
15 years ago
Nothing New Since Your Last Visit
2138
Hits

Thread 7 of 25
Thread Starter  

ObsidiansLight
Form, to create several fields in one part of the
I've created a database, but would like to be able to insert another database in to the current one, so that when I create a new main form, the secondary form will refresh, but I can create several secondary forms within the main form. Does that make any sort of sense? So if I have one persons information in a main form, then perhaps I have a form with (Date of Dr. visit, Name of Dr., Diagnosis, date of next appt.) I could click on a *create new and submit several Dr.s appointments for that one person. I apologize, i'm not an access expert by any means, so I doubt I'm even using the correct terminology. I've made seperate tables, but can't seem to import them in to the main table. I've also created relationships, but this does not put the other tables in to the main one. Does anyone know what I'm talking about? , , Thank you,, Shawn
15 years ago
Nothing New Since Your Last Visit
1928
Hits

Thread 6 of 25
Thread Starter  

Sheshi
MS Access table only prints column titles - not da
Hi, , , Wondering if anyone was familiar with this issue. I have a client who is trying to simply print a table in Access however it is only printing the column titles and not including the data she inputs. , , Any thoughts? , , Thanks so much, , Sheryl
15 years ago
1 Reply:

Occie
Print? Do you mean print out the table to a printer or export the table to say Excel?
15 years ago
Nothing New Since Your Last Visit
2552
Hits

Thread 5 of 25
Thread Starter  

tinty99
Autofilling fields in a form
Is there an easy way (no programming experience) to enter a field *last 4 digits of a SSN) and if there is a match, auto fill in FirstName, LastName, Phone etc?
15 years ago
Nothing New Since Your Last Visit
1666
Hits

Thread 4 of 25
Thread Starter  

natasha epperson
Help with "If and or"
Okay, I'm designing a data base for regional/city contacts. The issue i'm running into in the query is that say for IE-> Region is National. All sites(cities) fall under National. Rather than populating another table with National, I need to be able to say type in "Houston" and it will pull up all the National entrys and all the houston entrys where it has national or not. I hope that makes sense. Right now I have it as , Like "National"[Your City] Or Is Null Is Not Null, Which is working but it's not pulling up the entrys under region that don't have national but have the city you entered., , So say I know it's national but I don't have the city but want to have it so that any city I enter will pull up the national's and one's that are populated.
15 years ago
Nothing New Since Your Last Visit
1485
Hits

Thread 3 of 25
Thread Starter  

David H. Thornton Sr
Dues
I use access 2003 and I am trying keep track of my team dues and it is a weekly dues that is being paid. I want to add a command button that I can add the payment and store it in my table with the current date and payment so I can get a current dues paid every week, Thank you
15 years ago
1 Reply:

mprestwood
Just checking, did you complete this task?
13 years ago
Nothing New Since Your Last Visit
2113
Hits

Thread 2 of 25
Thread Starter  

David H. Thornton Sr
Autodialer
I have a question?, I am using Access 2003 and I used the command button to make an autodialer. My question is how can I force the autodialer to dial the number in a set field instead of having to highlighting it to dial the dial, Thank you
15 years ago
Nothing New Since Your Last Visit
1947
Hits

Thread 1 of 25
Thread Starter  

rosenbergms
Placing a table on a form
I am changing an applicaiton over from PAradox to Access. In Paradox 10, you can place a table "control" on the form and then define the table. In access, I can place fields from tables on a form, but I do not see a way to place an entire table object on the form. I don't want the table for data entry purposes. It is serves more of a look-up function, wherein user can scroll through the table a select the record he wants to stop on. Then all the dependent tables are a function of this record. Is there a simple way to do this in access? I have trided creating a subform, but it doesn't do quite what I can do in Paradox. Is paradox a better DBMS?
15 years ago
Nothing New Since Your Last Visit
1455
Hits

New Thread

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech