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.
adding columns
I want to add or delete columns or fields from a table in execution time, i mean, without editting the table design manually, i think it is maybe possible by code, i would like some help on how to do this. I also want to edit some column...
I want to add or delete columns or fields from a table in execution time, i mean, without editting the table design manually, i think it is maybe possible by code, i would like some help on how to do this. I also want to edit some column...
answer(6) view(7) status(
)
)
type mismatch error
Quote: Const dbsLoc As String = "I:\A1136\" Dim dbsTES As Database Dim rstFound As Recordset Dim OldSearchText As String Option Compare Database Option Explicit Private Sub Form_Load() Set dbsTES = OpenDataba...
Quote: Const dbsLoc As String = "I:\A1136\" Dim dbsTES As Database Dim rstFound As Recordset Dim OldSearchText As String Option Compare Database Option Explicit Private Sub Form_Load() Set dbsTES = OpenDataba...
answer(4) view(210) status()
)
Restricted Records
How do you restrict users to select 搑ecords.? I will have several people using the same tables, queries , forms and reports, but I want a user to enter a user name password and then see only his/her records. I know how to write queries to ...
How do you restrict users to select 搑ecords.? I will have several people using the same tables, queries , forms and reports, but I want a user to enter a user name password and then see only his/her records. I know how to write queries to ...
answer(3) view(682) status()
)
Security of database
I have a database that has a front end and back end linked together. I need to install this database for someone else to use, but I don抰 want them to be able to see anything behind the scenes (tables, queries, forms, reports, relationship...
I have a database that has a front end and back end linked together. I need to install this database for someone else to use, but I don抰 want them to be able to see anything behind the scenes (tables, queries, forms, reports, relationship...
answer(4) view(281) status()
)
Access won't connect
I'm tring to connect to an Access DB with this code: Code: 'Open database connection Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") connstr="DSN=manual_info" objConn.Open(conns...
I'm tring to connect to an Access DB with this code: Code: 'Open database connection Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") connstr="DSN=manual_info" objConn.Open(conns...
answer(2) view(500) status()
)
Columns in Reports
Access97: Is it possible to have data printed out in columns? I have only 3 pieces of data per record but 100s of records, it is very wasteful just printing 3 pieces per line. Thanks
Access97: Is it possible to have data printed out in columns? I have only 3 pieces of data per record but 100s of records, it is very wasteful just printing 3 pieces per line. Thanks
answer(1) view(758) status()
)
Reports Problem
Hi Folks, I need some help. I am hoping the regulars at this forum can help me. I tried my post in another forum and the answer I got was not to my satisfaction, so I am looking for another perspective on fixing this. Here is the situ...
Hi Folks, I need some help. I am hoping the regulars at this forum can help me. I tried my post in another forum and the answer I got was not to my satisfaction, so I am looking for another perspective on fixing this. Here is the situ...
answer(1) view(77) status()
)
Open another Access Db
I would like to use a command button/event procedure on a Form in DB1 to Open a Form and add a record in DB2. They are 2 separate Access .mdb Databases. Once this is done I need to return to the Form in the First DB. Is this possible?
I would like to use a command button/event procedure on a Form in DB1 to Open a Form and add a record in DB2. They are 2 separate Access .mdb Databases. Once this is done I need to return to the Form in the First DB. Is this possible?
answer(2) view(368) status()
)
adding new records via forms....
Hi. I have a simple db table which holds a code(autonumber) and distributor name, address etc. I have a form which allows me to add new records to the table. My problem is that when i click on my 'add new record button' on my form, i'd like...
Hi. I have a simple db table which holds a code(autonumber) and distributor name, address etc. I have a form which allows me to add new records to the table. My problem is that when i click on my 'add new record button' on my form, i'd like...
answer(2) view(977) status()
)
Data Duplication Check
Hi, very new to access!! I am attempting to develop a database for my brother. I want to add some form of validation to prevent the same information from being input more than once in the customer table. I thought a good way to do this was ...
Hi, very new to access!! I am attempting to develop a database for my brother. I want to add some form of validation to prevent the same information from being input more than once in the customer table. I thought a good way to do this was ...
answer(6) view(570) status()
)
Avoiding message
Is there any way to avoid the message i get when i run a table create query?. The point is that if i run this kind of queries and the table it creates already exists, then i get a message asking if i want to overwrite that table so i have ...
Is there any way to avoid the message i get when i run a table create query?. The point is that if i run this kind of queries and the table it creates already exists, then i get a message asking if i want to overwrite that table so i have ...
answer(6) view(333) status()
)
Drawing Number
I have created drop down menu's in a table for multiple drawing number selection e.g. AP / A / 01 / L / 53 / 001 (each back slash denotes a drop down menu) I have used the following code to bond the numbers together which works in a query. ...
I have created drop down menu's in a table for multiple drawing number selection e.g. AP / A / 01 / L / 53 / 001 (each back slash denotes a drop down menu) I have used the following code to bond the numbers together which works in a query. ...
answer(0) view(348) status()
)
access, query, sum
SELECT [IMTAnsatte].[Ansatt type], Count([IMTAnsatte].[Ansatt type]) AS [CountOfAnsatt type] FROM IMTAnsatte GROUP BY [IMTAnsatte].[Ansatt type]; Above is from a query made in access. In addition I'd like Access to make a summary of al...
SELECT [IMTAnsatte].[Ansatt type], Count([IMTAnsatte].[Ansatt type]) AS [CountOfAnsatt type] FROM IMTAnsatte GROUP BY [IMTAnsatte].[Ansatt type]; Above is from a query made in access. In addition I'd like Access to make a summary of al...
answer(2) view(129) status()
)
Willing to pay
Hello everyone. I am trying to figure out a way to automate data input from an asp form to a php form. Basically data on asp form contains name, address etc which needs to be passed to php form. The php form has a userid and password inf...
Hello everyone. I am trying to figure out a way to automate data input from an asp form to a php form. Basically data on asp form contains name, address etc which needs to be passed to php form. The php form has a userid and password inf...
answer(2) view(110) status()
)
Locking behaviour
I have an access application with a split FE (forms) and BE (tables). There are also several read-only data access pages using the BE as a data source. Most users only view the data via the data access pages. These users have read-only ...
I have an access application with a split FE (forms) and BE (tables). There are also several read-only data access pages using the BE as a data source. Most users only view the data via the data access pages. These users have read-only ...
answer(4) view(179) status()
)
Time
Is there a way to create a button that when clicked it inserts the current time into a bound field? If so is there a way that once that field is filed the same button would go to another unbound field? I'm trying to learn to write code from...
Is there a way to create a button that when clicked it inserts the current time into a bound field? If so is there a way that once that field is filed the same button would go to another unbound field? I'm trying to learn to write code from...
answer(9) view(945) status()
)
command button
I have two command buttons on a form for selecting "next" and "previous" records. Each button runs a simple one line macro - eg goto record, next. Works fine except when you click "previous" when on first recor...
I have two command buttons on a form for selecting "next" and "previous" records. Each button runs a simple one line macro - eg goto record, next. Works fine except when you click "previous" when on first recor...
answer(4) view(170) status()
)
Run-Time error 424
I am trying to show records of a table from c:/atul/db1.mdb database in a form and I am writing the code in the OnClick event of a button but I keep on getting error. Code used is: ------------------------- Dim connstring Dim connconn...
I am trying to show records of a table from c:/atul/db1.mdb database in a form and I am writing the code in the OnClick event of a button but I keep on getting error. Code used is: ------------------------- Dim connstring Dim connconn...
answer(3) view(16) status()
)
YES/NO function
I'm working on a database which contains IP Address, i want to program the database so that when a user save a IP Address, the used IP Address is taken off a combo box, so the next user won't use the same IP Address again. I know i should u...
I'm working on a database which contains IP Address, i want to program the database so that when a user save a IP Address, the used IP Address is taken off a combo box, so the next user won't use the same IP Address again. I know i should u...
answer(8) view(803) status()
)
Running a querry from a form in access
I'm trying to find the code that lets me type in information in a text box then after update run a querry from my table and give me the answer. Example: AcctNo Acct Des 1111 Assets 2222 ...
I'm trying to find the code that lets me type in information in a text box then after update run a querry from my table and give me the answer. Example: AcctNo Acct Des 1111 Assets 2222 ...
answer(1) view(964) status()
)
Access code for running query in Forms
I'm trying to find the the right code for inputing number in a text box in a form and after update run a querry that gives me the result. Example I have a table with accountnumbers AcctNo AcctDes 1111 Asset 1112 Liabilities ...
I'm trying to find the the right code for inputing number in a text box in a form and after update run a querry that gives me the result. Example I have a table with accountnumbers AcctNo AcctDes 1111 Asset 1112 Liabilities ...
answer(0) view(487) status()
)
Picture
hi everybody, I am developing a knowledge based system in AutoCad and is using DAO objects for transferring data and running query in VBA. I have database in Microsoft Access. I have some picture explaining some concept. I want when a us...
hi everybody, I am developing a knowledge based system in AutoCad and is using DAO objects for transferring data and running query in VBA. I have database in Microsoft Access. I have some picture explaining some concept. I want when a us...
answer(1) view(483) status()
)
Deleting a temporary table
I have a form which contains pushbuttons to run reports. One of the reports is based on multiple queries which create and update a temporary table, and then the temporary table is used to create the report. I want to delete the temporary...
I have a form which contains pushbuttons to run reports. One of the reports is based on multiple queries which create and update a temporary table, and then the temporary table is used to create the report. I want to delete the temporary...
answer(4) view(884) status()
)
referential integrity - more than one primary keys?
Hello, We are trying to create a database and are confronted with some (for us) major problems as we are no experts at all. In our little 'project', we have to design a system in which different pupils want to learn different instrum...
Hello, We are trying to create a database and are confronted with some (for us) major problems as we are no experts at all. In our little 'project', we have to design a system in which different pupils want to learn different instrum...
answer(4) view(245) status()
)
Access Problem(s)
Hi everybody, this is what I am trying to do: I have a database where you enter informations (through forms) about employees (name, address...). In another table you can choose the employee, the project, hourly rate and hours he's worked fo...
Hi everybody, this is what I am trying to do: I have a database where you enter informations (through forms) about employees (name, address...). In another table you can choose the employee, the project, hourly rate and hours he's worked fo...
answer(9) view(379) status()
)
converting ms access data to ms excel
hi, is there any vbscript for converting the data in MS Access to MS Excel format. Warm Regards, Aniruddha Sahasrabuddhe
hi, is there any vbscript for converting the data in MS Access to MS Excel format. Warm Regards, Aniruddha Sahasrabuddhe
answer(1) view(221) status()
)
Hyperlinks
My hyperlinks, when selected, are not locating the image. I created a hyperlink field, populated it globally using a query and when selected nothing happens. I opened the properties window and the path is in the "text to display" ...
My hyperlinks, when selected, are not locating the image. I created a hyperlink field, populated it globally using a query and when selected nothing happens. I opened the properties window and the path is in the "text to display" ...
answer(5) view(717) status()
)
Duplicate msgbox pop-up
Hi all, I have created a form which contains many records. There is a valid date in this form. I want to add a validation checking on the valid date such that if the valid date is earlier than current date, a msgbox will be pop-up to ale...
Hi all, I have created a form which contains many records. There is a valid date in this form. I want to add a validation checking on the valid date such that if the valid date is earlier than current date, a msgbox will be pop-up to ale...
answer(7) view(93) status()
)
Using FormatCondition object in VBA
Hi Everybody, I have a continuous form with several fields bound to a table containing a couple of thousands records. I'd like to cahnge the color of a field for records returning False for a specified expression. I know, that cond...
Hi Everybody, I have a continuous form with several fields bound to a table containing a couple of thousands records. I'd like to cahnge the color of a field for records returning False for a specified expression. I know, that cond...
answer(1) view(790) status()
)
MS Access
Hi I have a dropbutton list in a form. I want it to be update when a filter is applied in the requery (from which it takes it information). I have tried to use the fonction "requery" in the visual basic code, but it doesn't work...
Hi I have a dropbutton list in a form. I want it to be update when a filter is applied in the requery (from which it takes it information). I have tried to use the fonction "requery" in the visual basic code, but it doesn't work...
answer(2) view(481) status()
)
Programming
Related Pages
- How does one select the largest value in a field
- problems making a field in a record with a unique value
- How do I Dynamically Create & Execute Subform Query?
- Opening a Form in a Specific Field?
- Updated Problem ! with Not In List on a combo box !
- Display message based on query result.
- Cascade Delete Alternative
- Populating data from one form to a continous form
- Creating Job's using scheduler in Access
- Access 2003 export to Excel missing gridline
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