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.
working with a MS Access calendar
Hello, everyone I'm by no means an expert with Access, and need help with what's probably a small problem.... OK, I've got a calendar on a form. When the user clicks the Go button (next to the calendar), the selected calendar date is...
Hello, everyone I'm by no means an expert with Access, and need help with what's probably a small problem.... OK, I've got a calendar on a form. When the user clicks the Go button (next to the calendar), the selected calendar date is...
answer(1) view(36) status(
)
)
Adding Hours
I've been trying to subtract times i.e. 15.40 to 16.10 and cummulatively add these hours in order to track flight hours. I can complete this if I convert the times to decimal times i.e. 1530hrs become 15.50. I would like to be able ...
I've been trying to subtract times i.e. 15.40 to 16.10 and cummulatively add these hours in order to track flight hours. I can complete this if I convert the times to decimal times i.e. 1530hrs become 15.50. I would like to be able ...
answer(8) view(756) status()
)
calendar
How do you have a calender similar to yahoo's calender in Access so I can enter events by clicking on the day and then scheduling info is entered on a form for that day
How do you have a calender similar to yahoo's calender in Access so I can enter events by clicking on the day and then scheduling info is entered on a form for that day
answer(6) view(676) status()
)
Selecting results from query on form
Thank you for this forum. I am working on a project where I have 133 stagnant questions on a survey (that are grouped within 7 categories) that are to be answered with a Y, N, N/A response. I am having a difficult time associating the q...
Thank you for this forum. I am working on a project where I have 133 stagnant questions on a survey (that are grouped within 7 categories) that are to be answered with a Y, N, N/A response. I am having a difficult time associating the q...
answer(3) view(887) status()
)
PLease Help a Novice
Hello i have over the last few weeks tried to learn the basics of access to make a Autocad register I have now got the basics of what i need sorted but what i need now has completly thrown me! What i am after is a way to create a button...
Hello i have over the last few weeks tried to learn the basics of access to make a Autocad register I have now got the basics of what i need sorted but what i need now has completly thrown me! What i am after is a way to create a button...
answer(1) view(990) status()
)
Some fields not updated
I've developed an MS Access application that normally works fine, but there are times when a field in a record cannot be retrieved. The field is displayed when you open the table directly in MS Access, but when you try to run a query agains...
I've developed an MS Access application that normally works fine, but there are times when a field in a record cannot be retrieved. The field is displayed when you open the table directly in MS Access, but when you try to run a query agains...
answer(1) view(217) status()
)
#Error when requering subform
Hello all, I have just run across a very strange problem. I have a main form with two subforms in it. One for personel and one for equipment. I have a button that opens another form that allows the user to add items that are in a ...
Hello all, I have just run across a very strange problem. I have a main form with two subforms in it. One for personel and one for equipment. I have a button that opens another form that allows the user to add items that are in a ...
answer(2) view(923) status()
)
subform and command button
hi, i have a subform within a main form. i have create a command button. how do i link the command button with the data in my subform??? help is greatly appreciated!!! thanks!!!! nono
hi, i have a subform within a main form. i have create a command button. how do i link the command button with the data in my subform??? help is greatly appreciated!!! thanks!!!! nono
answer(2) view(978) status()
)
Creating a custom primary key
I work for a small ambulance company and I'm Trying to build an application that will help us dispatch our runs and keep track of times for each call. I have recieved help on here already and I need to ask for more. I need to create a prima...
I work for a small ambulance company and I'm Trying to build an application that will help us dispatch our runs and keep track of times for each call. I have recieved help on here already and I need to ask for more. I need to create a prima...
answer(9) view(811) status()
)
changing form from form wizard to updatable form
Hi! How can I change a from created using the Form Wizard in to an updatable form? Everytime i go to a field and try to change it, it won't let me. It displays a message on the status bar "This recordset is not updateable"
Hi! How can I change a from created using the Form Wizard in to an updatable form? Everytime i go to a field and try to change it, it won't let me. It displays a message on the status bar "This recordset is not updateable"
answer(11) view(227) status()
)
Delete Command Button
I'm new to Access and VBA and I need assistance. I'm building a form that has a subform. I have a delete button on the main form that is not allowing deletes from the subform. I used the command button wizard to build the delete butt...
I'm new to Access and VBA and I need assistance. I'm building a form that has a subform. I have a delete button on the main form that is not allowing deletes from the subform. I used the command button wizard to build the delete butt...
answer(10) view(531) status()
)
Automating Reports
I have a query that returns the sales by employee for the week by department. This query feeds a report that I print and distribute to the head of department each week (There are over 20 departments). I would like to write some code t...
I have a query that returns the sales by employee for the week by department. This query feeds a report that I print and distribute to the head of department each week (There are over 20 departments). I would like to write some code t...
answer(2) view(322) status()
)
linked cells integration with vba
hello, I want to use linked tables to create a database. Now the problem is that i want to add linked tables using a subroutine that can easily do this. Regards, Niek
hello, I want to use linked tables to create a database. Now the problem is that i want to add linked tables using a subroutine that can easily do this. Regards, Niek
answer(1) view(85) status()
)
Database on a web site
Gday all New comer to working with databases on a web site and the boss gave me the task the other day to do just that. I have designed it well enough through Access (2002) and tested it - all worked excactly how i wanted it to. Tr...
Gday all New comer to working with databases on a web site and the boss gave me the task the other day to do just that. I have designed it well enough through Access (2002) and tested it - all worked excactly how i wanted it to. Tr...
answer(0) view(637) status()
)
How do I ADD to a table from main form?
Hi everyone. On this 2nd day of snow (ny) I am writing my first question . . I will try to help those, when I can, and if I have an answers to give I have an access db that has many controls fields on a form. In the db, I have ...
Hi everyone. On this 2nd day of snow (ny) I am writing my first question . . I will try to help those, when I can, and if I have an answers to give I have an access db that has many controls fields on a form. In the db, I have ...
answer(4) view(943) status()
)
Problem opening database in DAO
Hi! Is there a difference in opening a database and using recordsets in Access 97 and XP? I'm using DAO and my statements work in Access 97 but not in XP. I get an error message in the part where i'm using the OpenRecordset method.
Hi! Is there a difference in opening a database and using recordsets in Access 97 and XP? I'm using DAO and my statements work in Access 97 but not in XP. I get an error message in the part where i'm using the OpenRecordset method.
answer(2) view(34) status()
)
Menu list values won't pass to db
Please help me! I am trying to pass values from a menu list to a db. When I submit the form, the selected value becomes "unselected" and the there is no values being passed to the db Can someone help me?
Please help me! I am trying to pass values from a menu list to a db. When I submit the form, the selected value becomes "unselected" and the there is no values being passed to the db Can someone help me?
answer(3) view(446) status()
)
subform update
G'day people, I know this may seem like a stupid question to some but I have been looking for an answer to my question for some time now to no success. I hope that someone can help me out. At the moment im constructing a database for ...
G'day people, I know this may seem like a stupid question to some but I have been looking for an answer to my question for some time now to no success. I hope that someone can help me out. At the moment im constructing a database for ...
answer(3) view(175) status()
)
how can i access an mdb through a web page?
I am trying to add a database to my site and I want to know how to make it executable and updateable online, rather than just downloading it at a different site. Can someone help?
I am trying to add a database to my site and I want to know how to make it executable and updateable online, rather than just downloading it at a different site. Can someone help?
answer(0) view(179) status()
)
wanna a good help
i wanna make a software to connect to a pbx "phone central" panasonic d1232 by c# the case is that ther is way by using TAPI i have searched in the MSDN and found that control but i cant use it cos i didnt understand it from the M...
i wanna make a software to connect to a pbx "phone central" panasonic d1232 by c# the case is that ther is way by using TAPI i have searched in the MSDN and found that control but i cant use it cos i didnt understand it from the M...
answer(0) view(718) status()
)
problems with dublicates
Hello, We have created a database where we run a query and make a table in which we find dublicates (dublicates-function at queries; meaning we have 3 fields, i.e. pupils and instruments which all have been allocated to a teacher --> ...
Hello, We have created a database where we run a query and make a table in which we find dublicates (dublicates-function at queries; meaning we have 3 fields, i.e. pupils and instruments which all have been allocated to a teacher --> ...
answer(1) view(962) status()
)
using datestamp?
Hi, I am trying to do a little library script, where a user can search for a book, and then book it out for 1 month. All is well, exept I don't know how to make the script to start the booking at todays date and to last for one month ...
Hi, I am trying to do a little library script, where a user can search for a book, and then book it out for 1 month. All is well, exept I don't know how to make the script to start the booking at todays date and to last for one month ...
answer(0) view(803) status()
)
updating excel from access
I wonder if anyone can throw some light on this. I have an excel worksheet set up and i have an access database. I was wondering how to update the excel sheet by entering data into the access form. it is office xp i am using. thanks ...
I wonder if anyone can throw some light on this. I have an excel worksheet set up and i have an access database. I was wondering how to update the excel sheet by entering data into the access form. it is office xp i am using. thanks ...
answer(3) view(432) status()
)
Line chart in Access
I work in a hospital and the administrator wants me to make a report (with a chart) that shows the number of procedures performed over time. I have a simple table that includes: Procedure name Month Year Number of procedures I p...
I work in a hospital and the administrator wants me to make a report (with a chart) that shows the number of procedures performed over time. I have a simple table that includes: Procedure name Month Year Number of procedures I p...
answer(3) view(563) status()
)
date format problem..help!!
How can i make the dates be displayed all in one format, like 'dd/mm/yy' just like access assigns it when you create the date field and in it's format type as short format ?? rathern then to be displayed in mm/dd/yy format after you insert ...
How can i make the dates be displayed all in one format, like 'dd/mm/yy' just like access assigns it when you create the date field and in it's format type as short format ?? rathern then to be displayed in mm/dd/yy format after you insert ...
answer(1) view(393) status()
)
Date format problems in Access2000, need your help!
-I have a tblPayDates, and the field DueDate as Date/Time Short format ex..31/11/03 which is dd/mm/yy Access 2000 it automatically assigns it that way -I have a form æ…ºrmPayDate? with 3 fields clientID, firstdate, period, and an æ…½nsert?but...
-I have a tblPayDates, and the field DueDate as Date/Time Short format ex..31/11/03 which is dd/mm/yy Access 2000 it automatically assigns it that way -I have a form æ…ºrmPayDate? with 3 fields clientID, firstdate, period, and an æ…½nsert?but...
answer(1) view(628) status()
)
Access Colummn add up
Can anyone help me? I wrote a program in vb, with an access database. I want to create a form with the total of each column in the database. A button will be pressed to get to this form. Please help if you can Koos
Can anyone help me? I wrote a program in vb, with an access database. I want to create a form with the total of each column in the database. A button will be pressed to get to this form. Please help if you can Koos
answer(1) view(359) status()
)
Moving values from cell below to the cell next to
Hi, I have a bit of a puzzling problem. I have a large set of data in Access part of which appears as follows: Field 1, Field 2 Data A Data A1 Data B Data B1 Data C Data C1 etc.. I would like to move the A1, B1, C1 etc. fr...
Hi, I have a bit of a puzzling problem. I have a large set of data in Access part of which appears as follows: Field 1, Field 2 Data A Data A1 Data B Data B1 Data C Data C1 etc.. I would like to move the A1, B1, C1 etc. fr...
answer(1) view(39) status()
)
Grouping an Access Query
I have a Access query that returns many results, but with duplicates in the property_id column. eg: Code: property_id date ====================== 1 31/01/2001 1 27/05/2003 1 22/09/200...
I have a Access query that returns many results, but with duplicates in the property_id column. eg: Code: property_id date ====================== 1 31/01/2001 1 27/05/2003 1 22/09/200...
answer(1) view(471) status()
)
Auto form:data sheet
Hi I am using an auto form data sheet.Can i get row change event for this if yes than how. I am getting textbox focus events. Can i also change the colour of selected row.If yes how. Thanks in advance, Amit
Hi I am using an auto form data sheet.Can i get row change event for this if yes than how. I am getting textbox focus events. Can i also change the colour of selected row.If yes how. Thanks in advance, Amit
answer(0) view(943) status()
)
Programming
Related Pages
- Find & Replace options
- Avoiding Make-Table Queries
- Syntax error in FROM clause.. Why?
- Queries
- Merging tables and retaining data
- Couldnt find installabale ISAM (registering dll didnt work)
- Formatting 5/10/05 into May 10, 2005
- Marking records after reports printed.
- Help! How do i add icons and check boxes??!
- Keeping Form Window on Top
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