Home > Microsoft Access Help
Microsoft Access Help
Microsoft Access forum discussing questions and answers for the Access database. MS Access is used to handle small to medium database needs.
searching
I have a cross tab query set up which iwould like to search for a criteria which is input by a user. i have a form set up which includes a command button and a text box. I have been trawling through the Help but cannot find a solution, othe...
I have a cross tab query set up which iwould like to search for a criteria which is input by a user. i have a form set up which includes a command button and a text box. I have been trawling through the Help but cannot find a solution, othe...
answer(7) view(212) status(
)
)
Updating Data in a Table on the basis of another Table
Help Me! This probably seems like a stupid question but as you will tell I'm not proficient at Access! Basically I would like to update certain records in one table by replacing the data with that from another table where the surname a...
Help Me! This probably seems like a stupid question but as you will tell I'm not proficient at Access! Basically I would like to update certain records in one table by replacing the data with that from another table where the surname a...
answer(4) view(933) status()
)
How to unstring
I have a column in an Access database that contains "last name, first name". I'd like to copy that to a new column that contains "first name last name". Can anyone help?
I have a column in an Access database that contains "last name, first name". I'd like to copy that to a new column that contains "first name last name". Can anyone help?
answer(1) view(628) status()
)
Switchboard
I have created a switchboard which i would like to open on starting the database. In the help of MS Access it states "To make a switchboard open when you open the database, click the switchboard name in the Switchboard Manager dialog b...
I have created a switchboard which i would like to open on starting the database. In the help of MS Access it states "To make a switchboard open when you open the database, click the switchboard name in the Switchboard Manager dialog b...
answer(3) view(524) status()
)
Alphabetize value lists?
I have set up a v basic database to catalogue our photo collection. The main table is Photos, and I have added fields to this table using the Lookup Wizard that use value lists from other tables, such as Category, Staff, Supporter, Supporte...
I have set up a v basic database to catalogue our photo collection. The main table is Photos, and I have added fields to this table using the Lookup Wizard that use value lists from other tables, such as Category, Staff, Supporter, Supporte...
answer(4) view(700) status()
)
Help With Vb 5 And Access
Hello there, Ive been assigned to a VB 5 program that uses Access databases. It was made under Office 97 and at that time ('99-'00) it worked perfectly under win98 and Office 97, the problems started when office 2000 & win2k came up...
Hello there, Ive been assigned to a VB 5 program that uses Access databases. It was made under Office 97 and at that time ('99-'00) it worked perfectly under win98 and Office 97, the problems started when office 2000 & win2k came up...
answer(0) view(206) status()
)
Virtual Tables
Hello everybody. This is my first post and I am not too familiar with ASP (but can gt along as I know a bit of VB/VB .NET). I have an asp page that contains a table. The table is populated from data in an Access database table that ma...
Hello everybody. This is my first post and I am not too familiar with ASP (but can gt along as I know a bit of VB/VB .NET). I have an asp page that contains a table. The table is populated from data in an Access database table that ma...
answer(2) view(701) status()
)
Selecting 'yes' values from checkbox in query
I have a table with Photo ID, title, etc and whether or not we have a hardcopy of the photo. The hardcopy field is defined as a check box with Yes/No values. I would like to run a query that only selects the photos for which we have hardco...
I have a table with Photo ID, title, etc and whether or not we have a hardcopy of the photo. The hardcopy field is defined as a check box with Yes/No values. I would like to run a query that only selects the photos for which we have hardco...
answer(2) view(1,004) status()
)
RowSource Property?
Hi I have a form that is populated by the user making a selection from a combo box with the RowSource based on a query. Once the record is retrieved the user can make changes to data and save any changes to a table. It is not a straightf...
Hi I have a form that is populated by the user making a selection from a combo box with the RowSource based on a query. Once the record is retrieved the user can make changes to data and save any changes to a table. It is not a straightf...
answer(3) view(505) status()
)
ms Access Query
I have a simple query with two tables. One table named List has a complete list of currency values and the other table MinMax contains a minumum value (currency) and a maximum value (currency). When I query the complete List with Between...
I have a simple query with two tables. One table named List has a complete list of currency values and the other table MinMax contains a minumum value (currency) and a maximum value (currency). When I query the complete List with Between...
answer(4) view(182) status()
)
Access DB crashing problem
Hi. My database crashes whenever I try to run 2 of my forms. They're reasonably complicated, but not overly so. I'm running Office XP (no service packs since I'm running it on Win98). Unfortunately, I'm not able to upgrade to Win XP. ...
Hi. My database crashes whenever I try to run 2 of my forms. They're reasonably complicated, but not overly so. I'm running Office XP (no service packs since I'm running it on Win98). Unfortunately, I'm not able to upgrade to Win XP. ...
answer(2) view(14) status()
)
ASP Database Fundamentals parts 1, 2, and 3.
Hello, I'm new to this forum and I found ASP Database Fundamentals (Part 4) very interesting to say the least. How can I get a hold of ASP Database Fundamentals parts 1, 2, and 3. Thank you
Hello, I'm new to this forum and I found ASP Database Fundamentals (Part 4) very interesting to say the least. How can I get a hold of ASP Database Fundamentals parts 1, 2, and 3. Thank you
answer(1) view(153) status()
)
query
I need to make a query with the info i select from a combo box. what criteria should i use ?
I need to make a query with the info i select from a combo box. what criteria should i use ?
answer(5) view(837) status()
)
annoying problem with a query
Here's my problem... I've created a query to pull the data I need but it is not updateable. However, the whole point of the query was to update a table with it... so I have a second query that pulls the data from the first and attempts to ...
Here's my problem... I've created a query to pull the data I need but it is not updateable. However, the whole point of the query was to update a table with it... so I have a second query that pulls the data from the first and attempts to ...
answer(6) view(216) status()
)
Two become one
At work I have created a training database that records all the latest Health & Safety work stuff. It consists of one table: MainData1. In it I have a list of all my employees and whether they have passed training or not. I have now ...
At work I have created a training database that records all the latest Health & Safety work stuff. It consists of one table: MainData1. In it I have a list of all my employees and whether they have passed training or not. I have now ...
answer(8) view(900) status()
)
calculated field
hi, two problems here: 1) i have a search done i the db and what the problem is the total calculated field. this field is the total sum of all balance and quantity under a NRIC no (primary key). however here in my example, the calcula...
hi, two problems here: 1) i have a search done i the db and what the problem is the total calculated field. this field is the total sum of all balance and quantity under a NRIC no (primary key). however here in my example, the calcula...
answer(18) view(628) status()
)
differentiate similar fields
hi, i have a search function where i want it to goes accordingly to what i have choose from the combo box. however it base on the my primary key to search, how can i avoid this?? i have attached a db for better understanding. pls a...
hi, i have a search function where i want it to goes accordingly to what i have choose from the combo box. however it base on the my primary key to search, how can i avoid this?? i have attached a db for better understanding. pls a...
answer(2) view(426) status()
)
Adding items to a listbox
I can't seem to find a way to add single items to a listbox. In other languages (Visual Basic, etc) there is a .AddItem type function that you can use to add items to a listbox. What I want to do is build the listbox from items se...
I can't seem to find a way to add single items to a listbox. In other languages (Visual Basic, etc) there is a .AddItem type function that you can use to add items to a listbox. What I want to do is build the listbox from items se...
answer(1) view(447) status()
)
Going From One Form To Another
My Clerk has highlighted a flaw in my database. As soon as I have sorted it out I will fire her I have 2 main input forms for all employee data. When I go from one form to another the records go back to the start. Not a major proble...
My Clerk has highlighted a flaw in my database. As soon as I have sorted it out I will fire her I have 2 main input forms for all employee data. When I go from one form to another the records go back to the start. Not a major proble...
answer(14) view(181) status()
)
sharing data between tables
Hello, I have 2 separate tables in an Access database containing membership info (tblusers; primary key - username) and a mailing list (tbllist; no primary key currently) for my site. Each table contains fields for firstname, lastname an...
Hello, I have 2 separate tables in an Access database containing membership info (tblusers; primary key - username) and a mailing list (tbllist; no primary key currently) for my site. Each table contains fields for firstname, lastname an...
answer(6) view(856) status()
)
Updating 2 fields with a dropdown list
I have a dropdown list that I want to use to populate two different fields. The dropdown list is set to display a company number and company name and I need the information from both columns. The properties of the dropdown list allo...
I have a dropdown list that I want to use to populate two different fields. The dropdown list is set to display a company number and company name and I need the information from both columns. The properties of the dropdown list allo...
answer(2) view(168) status()
)
import text file
hi, how do i import a text file with deliminator '|' into my database?? i have attached a text file for your reference. please give me some ideas of doing it. thanks nono
hi, how do i import a text file with deliminator '|' into my database?? i have attached a text file for your reference. please give me some ideas of doing it. thanks nono
answer(4) view(767) status()
)
problem linking 2 subforms
I'm having a problem linking 2 subforms. I have racked my brains trying to fix this and I'm sure it can be done too, because I have done it before in a previous database, but I must be doing something wrong this time. OK..I have a mai...
I'm having a problem linking 2 subforms. I have racked my brains trying to fix this and I'm sure it can be done too, because I have done it before in a previous database, but I must be doing something wrong this time. OK..I have a mai...
answer(2) view(744) status()
)
Fields update
hi all, i have a form where there are fields like name, id (staff_table), Accountno (staff_Account_Table), branch code (Branch_Table) etc. they are from 3 different tables. the form will have the branch code empty where the user wil...
hi all, i have a form where there are fields like name, id (staff_table), Accountno (staff_Account_Table), branch code (Branch_Table) etc. they are from 3 different tables. the form will have the branch code empty where the user wil...
answer(7) view(695) status()
)
date calculation - newbie needs help
I have two date/time fields and I want to display the "response time", in hours, between the two. Each field is in a seperate table and is formatted as a long date which includes the time ie 31/12/03 14:45 The calculation mus...
I have two date/time fields and I want to display the "response time", in hours, between the two. Each field is in a seperate table and is formatted as a long date which includes the time ie 31/12/03 14:45 The calculation mus...
answer(2) view(276) status()
)
Pleezz Help! Run-time error when copying between forms
Please help a access beginner!! I have 2 forms, the form1 has an staff_id field on it and a customer id. I enter the staff_id then the customer id, then press the button I made which brings up the new form2 which has staff_id, customer ...
Please help a access beginner!! I have 2 forms, the form1 has an staff_id field on it and a customer id. I enter the staff_id then the customer id, then press the button I made which brings up the new form2 which has staff_id, customer ...
answer(1) view(602) status()
)
time range access asp
how do you properly check for a range of time properly in an sql statement from asp to an access db?
how do you properly check for a range of time properly in an sql statement from asp to an access db?
answer(1) view(306) status()
)
New to Access and need help
Hi everyone, I'm new to using MS Access and have only completed two databases using the sample and built in type databases. I'm taking a computer class at my local community college and need some help with some very basic things on Acce...
Hi everyone, I'm new to using MS Access and have only completed two databases using the sample and built in type databases. I'm taking a computer class at my local community college and need some help with some very basic things on Acce...
answer(1) view(753) status()
)
Dynamic Datasource
I m working on an Access 2000 db. I have an example of code to be used for unbound forms which I would like to use. One thing I don't like about the example code is that the DataSource is hard-coded. ie xDataSource = "Data Sour...
I m working on an Access 2000 db. I have an example of code to be used for unbound forms which I would like to use. One thing I don't like about the example code is that the DataSource is hard-coded. ie xDataSource = "Data Sour...
answer(1) view(15) status()
)
Trouble Adding Data Into MS Access DB
Hey guys, Im rather new to this ASP stuff and have been working for HOURS trying to send just a few lines of text into my access databse. Any ideas? Code: strConnect is defined in another asp file as: strConnect = "DRIVER={M...
Hey guys, Im rather new to this ASP stuff and have been working for HOURS trying to send just a few lines of text into my access databse. Any ideas? Code: strConnect is defined in another asp file as: strConnect = "DRIVER={M...
answer(2) view(558) status()
)
Programming
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved