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.
Converting data - how to...
I have an Excel file that is a repetitive list of data. Instead of having a column with rows of data underneath we have Column A listing over and over what should be the column headings and then the corresponding data is in Column C. Fo...
I have an Excel file that is a repetitive list of data. Instead of having a column with rows of data underneath we have Column A listing over and over what should be the column headings and then the corresponding data is in Column C. Fo...
answer(2) view(371) status(
)
)
copy the table schema HELP???
Greetings, I am using a select into statement to copy the data fileds from a master table to a user table, this works well but I now need help figuring out how to copy the table schema from one table to another. Thanks,
Greetings, I am using a select into statement to copy the data fileds from a master table to a user table, this works well but I now need help figuring out how to copy the table schema from one table to another. Thanks,
answer(1) view(641) status()
)
Module Not Found Error - MS Access 97
Hi all, I am having some serious problems.Please help me. I tried to replicate the Access 97 DB application which is out on the network (it was created by an ex-employee). I did this process using the Briefcase method after reading t...
Hi all, I am having some serious problems.Please help me. I tried to replicate the Access 97 DB application which is out on the network (it was created by an ex-employee). I did this process using the Briefcase method after reading t...
answer(1) view(821) status()
)
Help - wont let me into Database
Hi, I've recently had a 'new' PC at work. Now when I try to load a shared database I get the following error: Quote: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the...
Hi, I've recently had a 'new' PC at work. Now when I try to load a shared database I get the following error: Quote: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the...
answer(1) view(676) status()
)
Creating Proceedure
Very basic query here. I am creating a Purchase order form using Access forms and tables etc. Included in this form is a combo for TAX rate,Unit Price, TAX cost and Total price. The user will select the Tax rate and put in unit price....
Very basic query here. I am creating a Purchase order form using Access forms and tables etc. Included in this form is a combo for TAX rate,Unit Price, TAX cost and Total price. The user will select the Tax rate and put in unit price....
answer(1) view(184) status()
)
Data Export Import
I am having trouble importing excel spreadsheets into access. I am exporting a table and that works fine as a macro, but when I use the transfer spreadsheet action to import the worksheet I just exported I am getting field name mismatch err...
I am having trouble importing excel spreadsheets into access. I am exporting a table and that works fine as a macro, but when I use the transfer spreadsheet action to import the worksheet I just exported I am getting field name mismatch err...
answer(4) view(189) status()
)
Trying to set it up
Set up IIS on my XP Pro for testing. FTPed down a site of mine that uses ASP and MS access database. I want to check it out on my own computer. I can view other ASP pages through my IIS but not ones with a database. I keep getting an er...
Set up IIS on my XP Pro for testing. FTPed down a site of mine that uses ASP and MS access database. I want to check it out on my own computer. I can view other ASP pages through my IIS but not ones with a database. I keep getting an er...
answer(1) view(516) status()
)
populate database
can anyone help please I have a large mp3 collection what i want to do is read the id3 tags/filenames/filelength/bitrate etc off all the mp3 files on multiple hard drives and have them automatically inserted into the corrisponding databa...
can anyone help please I have a large mp3 collection what i want to do is read the id3 tags/filenames/filelength/bitrate etc off all the mp3 files on multiple hard drives and have them automatically inserted into the corrisponding databa...
answer(0) view(405) status()
)
trying to auto populate some fields
Please help. We are new to ACcess. At our current project, we have 10 tables with and 8 of them having system name as the primary key and two of the table have combination of system table and Compliance Id and interface id as the primar...
Please help. We are new to ACcess. At our current project, we have 10 tables with and 8 of them having system name as the primary key and two of the table have combination of system table and Compliance Id and interface id as the primar...
answer(0) view(823) status()
)
Storing Data in MEMO datatype
Hi I am trying to store data in access file from my webpage using ASP. When i try to store the data from textarea to memo data type of access it is giving error. why.
Hi I am trying to store data in access file from my webpage using ASP. When i try to store the data from textarea to memo data type of access it is giving error. why.
answer(1) view(710) status()
)
MS Access Update form
Hello I am making a database for a ordering system, however i am stuck in trying to do a function which i am sure Ms Access can do. i am trying to do an order form where someone will order 20 items and if ten of the item is delivered ...
Hello I am making a database for a ordering system, however i am stuck in trying to do a function which i am sure Ms Access can do. i am trying to do an order form where someone will order 20 items and if ten of the item is delivered ...
answer(0) view(179) status()
)
Converting from 2000 to 97 problems
When I convert from Access 2000 to Access 97 I cannot run my reports as 97 doesn't seem to recognise Format$ function (and Trim function). I get an error message regarding Visual Basic files. From Microsoft website, it suggested copying ...
When I convert from Access 2000 to Access 97 I cannot run my reports as 97 doesn't seem to recognise Format$ function (and Trim function). I get an error message regarding Visual Basic files. From Microsoft website, it suggested copying ...
answer(0) view(897) status()
)
Lock problem again
I use Access2000 and ASP.Net. All tables are accessible for Insert/Update/Delete except one. I'm getting "Could not update; currently locked." message when I'm trying to INSERT, etc. I don't understand how it could happen because...
I use Access2000 and ASP.Net. All tables are accessible for Insert/Update/Delete except one. I'm getting "Could not update; currently locked." message when I'm trying to INSERT, etc. I don't understand how it could happen because...
answer(0) view(55) status()
)
print report for current record
Let me say this up front. I'm a novice using MS Access. But here's my problem. I have a database created with Access 97 that I have code to run a report for only the current record. It works fine. But when I try to copy the code to ano...
Let me say this up front. I'm a novice using MS Access. But here's my problem. I have a database created with Access 97 that I have code to run a report for only the current record. It works fine. But when I try to copy the code to ano...
answer(1) view(671) status()
)
Do I Use Arrays of Arrays? (If so how?)
I am building a database and it is basically an employee database. It includes address, department, employee #, etc. The final, and most important, category is the training category. I need to create something similar to what is below. ...
I am building a database and it is basically an employee database. It includes address, department, employee #, etc. The final, and most important, category is the training category. I need to create something similar to what is below. ...
answer(2) view(593) status()
)
Problems with database permissions
I'm making a website that accesses a database. I created it and it worked perfectly when under the administrator permissions but for some reason I can't find the permission to give anonymous users access to the database, I keep getting the...
I'm making a website that accesses a database. I created it and it worked perfectly when under the administrator permissions but for some reason I can't find the permission to give anonymous users access to the database, I keep getting the...
answer(0) view(298) status()
)
Too few parameters. Expected 1
MS offer an explanation of the above error but it doesn't work for me. I get the error when trying to run the folowing: Sub SaveChangedMarkerPrices(strGrade As String, strType As String, dblCurrentMarkerPrice As Double, ctlMarkerPrice...
MS offer an explanation of the above error but it doesn't work for me. I get the error when trying to run the folowing: Sub SaveChangedMarkerPrices(strGrade As String, strType As String, dblCurrentMarkerPrice As Double, ctlMarkerPrice...
answer(0) view(157) status()
)
field modification
How can i make sure that once information had been entered in a field in ms access 2000 the user cannot modify it? for example: I need a customer ID to be entered and make sure that the users cannot modify it, in other words i need the fie...
How can i make sure that once information had been entered in a field in ms access 2000 the user cannot modify it? for example: I need a customer ID to be entered and make sure that the users cannot modify it, in other words i need the fie...
answer(2) view(1,000) status()
)
The size of a field is too long
Hi Everyone I was wondering if anyone knows a workaround for the below. In a access 97 database when trying to open a table in normal or design mode i get the following msg "The size of a field is too long". This is also hap...
Hi Everyone I was wondering if anyone knows a workaround for the below. In a access 97 database when trying to open a table in normal or design mode i get the following msg "The size of a field is too long". This is also hap...
answer(1) view(328) status()
)
Calculation Help!!
i am sure this has been asked many many many times but i am a newbie when it comes to access. so here goes. the problem i am having is i am trying to get a total number out of a single column for ex. name.......sales.......hours.........
i am sure this has been asked many many many times but i am a newbie when it comes to access. so here goes. the problem i am having is i am trying to get a total number out of a single column for ex. name.......sales.......hours.........
answer(1) view(999) status()
)
Control Value Calculation
I have tried numerous methods to obtain a sum value displayed within a control box on a form. The calculation occurres within one colum of a subform. and concerns a customers purchase of several items. This is very similiar to the exampl...
I have tried numerous methods to obtain a sum value displayed within a control box on a form. The calculation occurres within one colum of a subform. and concerns a customers purchase of several items. This is very similiar to the exampl...
answer(4) view(178) status()
)
2 tables and 2 dropdown lists
Hi, I need help please. I have a an access db with 2 tables- subs and cats. I need two dropdown lists. when the page is loaded the CATS dropdown is populated. when i select a category from CATS i need the other dropdown to be filled wi...
Hi, I need help please. I have a an access db with 2 tables- subs and cats. I need two dropdown lists. when the page is loaded the CATS dropdown is populated. when i select a category from CATS i need the other dropdown to be filled wi...
answer(0) view(250) status()
)
regeneration combo boxes
Looking for some help, possibly some code. I have seen in some databases where a user selects an option from a combo box, and as soon as it is filled a new combo box with the same control appers ready to be filled by another option. I w...
Looking for some help, possibly some code. I have seen in some databases where a user selects an option from a combo box, and as soon as it is filled a new combo box with the same control appers ready to be filled by another option. I w...
answer(0) view(228) status()
)
Searching an access database
apparently the only way of "finding" a particular field in an access database is to query the database, however in this the criteria is pre-defined. I want to create an interface in Access which allows users to enter a search term...
apparently the only way of "finding" a particular field in an access database is to query the database, however in this the criteria is pre-defined. I want to create an interface in Access which allows users to enter a search term...
answer(0) view(178) status()
)
Access new table problem
after I created a new table in Access, why my "select" statemtn doesn't work on this table? If it's the permission setting problem, how can I set the permission on database on remote server? Thanks
after I created a new table in Access, why my "select" statemtn doesn't work on this table? If it's the permission setting problem, how can I set the permission on database on remote server? Thanks
answer(0) view(141) status()
)
Import Spreadsheet from Excel
Good Evening All.. I'm trying to create a macro that will import excel data into the Access table I've created for it. All headers and data are exact and in the correct order. However, when I run it the Macro I get the error message &quo...
Good Evening All.. I'm trying to create a macro that will import excel data into the Access table I've created for it. All headers and data are exact and in the correct order. However, when I run it the Macro I get the error message &quo...
answer(2) view(330) status()
)
ADO Not Working in Run Time Version
Hi to all. We have a Microsoft Access 2002 database that is referencing the ADO 2.5 library (as well as the DAO 3.6 library). On the development machine, the database works exactly as planned and all functions compile and work. Whe...
Hi to all. We have a Microsoft Access 2002 database that is referencing the ADO 2.5 library (as well as the DAO 3.6 library). On the development machine, the database works exactly as planned and all functions compile and work. Whe...
answer(0) view(560) status()
)
Updating order levels
Hi i am doing a database for a stock system and i would like to know is there any way where you can search for an order using the order number for a example and then input the numbers of stock delivered and one month and then go back to the...
Hi i am doing a database for a stock system and i would like to know is there any way where you can search for an order using the order number for a example and then input the numbers of stock delivered and one month and then go back to the...
answer(0) view(6) status()
)
remove records at bottom of form
I have created a form with buttons to go to and from the records and would like to remove the buttons at the bottom of the form that MS puts in it. Can someone tell me how to get rid of those? Thanks ldt
I have created a form with buttons to go to and from the records and would like to remove the buttons at the bottom of the form that MS puts in it. Can someone tell me how to get rid of those? Thanks ldt
answer(2) view(342) status()
)
MS Access 97 QBF & Reports
I have a QBF on a databse that enables the user to do wildcard searches and this produces the correct data on the form ie selects x number of correct records. I want the QBF to work on the front end of a report so that instead of the res...
I have a QBF on a databse that enables the user to do wildcard searches and this produces the correct data on the form ie selects x number of correct records. I want the QBF to work on the front end of a report so that instead of the res...
answer(2) view(862) status()
)
Programming
Related Pages
- Major Issue
- Import Data From Access To Excel
- Application Installation
- Use List Box to assign multiple values to records?
- Generate a function through Access
- IIF statement
- Help with Sum, Count and Group
- Bug tracking solution
- exporting data from a form to a text doc via a button on the form
- [Forms] Pictures..
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