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.
MS Access Security
I have built a database in Access and have enabled the security side of it, no problems there. However I now wish to share the database with another user and have set-up the share on my PC. Unfortunately when the other users accesses my ...
I have built a database in Access and have enabled the security side of it, no problems there. However I now wish to share the database with another user and have set-up the share on my PC. Unfortunately when the other users accesses my ...
answer(1) view(834) status(
)
)
Please././Form Security - project is due!
Please help - I need assistance securing/hiding fields on a form for one user and not another - do I need 2 different forms with permissions set differently? DB
Please help - I need assistance securing/hiding fields on a form for one user and not another - do I need 2 different forms with permissions set differently? DB
answer(1) view(545) status()
)
Help! Not Sure How to Explain...
I am working on a database for my company, that stores information for the people who use company purchasing cards. I want to store information such as: Cardholder, Card Type, GL Code, Location, Hierarchy, Department, Limit, etc. I have two...
I am working on a database for my company, that stores information for the people who use company purchasing cards. I want to store information such as: Cardholder, Card Type, GL Code, Location, Hierarchy, Department, Limit, etc. I have two...
answer(1) view(240) status()
)
Open Form Mode problem...
Hello, all. I have been working on a simple project in MS Access 97. At this point of the project, I got a problem. When I open a form in acFormAdd mode the properties are not set properly. Same in acFormEdit mode. What is the pro...
Hello, all. I have been working on a simple project in MS Access 97. At this point of the project, I got a problem. When I open a form in acFormAdd mode the properties are not set properly. Same in acFormEdit mode. What is the pro...
answer(3) view(867) status()
)
Interbase blobs from MS Access
I am trying to read interbase 6.0 data with the xtg ODBC driver from MS Access. It works ok with all the fields except with a blob field which just contents text. Is a problem of the ODBC driver which don't convert correctly or Must I do a...
I am trying to read interbase 6.0 data with the xtg ODBC driver from MS Access. It works ok with all the fields except with a blob field which just contents text. Is a problem of the ODBC driver which don't convert correctly or Must I do a...
answer(0) view(33) status()
)
How to modify series name?
Hi! I created a Data Access Page and inserted few charts in it. I also applied a legend, but it looks sth like: Sum of <query_parameter> I would like to remove that string "Sum of", but I don't know how. I tried to ...
Hi! I created a Data Access Page and inserted few charts in it. I also applied a legend, but it looks sth like: Sum of <query_parameter> I would like to remove that string "Sum of", but I don't know how. I tried to ...
answer(0) view(482) status()
)
retriving info from a table using Recordset
Hi everyone, I am trying to access info from a table name "CUSTOMER DETAILS" using the following code:- Private Sub LOGINOKBUTTON_Click() Set dbase = New ADODB.Connection Set dbasers = New ADODB.Recordset dbase.C...
Hi everyone, I am trying to access info from a table name "CUSTOMER DETAILS" using the following code:- Private Sub LOGINOKBUTTON_Click() Set dbase = New ADODB.Connection Set dbasers = New ADODB.Recordset dbase.C...
answer(2) view(49) status()
)
syntax help needed
hey peeps, i keep getting this error msg about data type mismatch in the criteria expression. i was pretty sure that the syntax is correct but keep getting it wrong so i guess its not. here's the syntax: SELECT M.Title, R.Rent_Date FR...
hey peeps, i keep getting this error msg about data type mismatch in the criteria expression. i was pretty sure that the syntax is correct but keep getting it wrong so i guess its not. here's the syntax: SELECT M.Title, R.Rent_Date FR...
answer(1) view(691) status()
)
query
got a table that has got these fields sex, height and study group. i want to create a query that calculates mean, standard deviation,. Maximum and minimum separately for each of males in study group1 females in study group1, males in st...
got a table that has got these fields sex, height and study group. i want to create a query that calculates mean, standard deviation,. Maximum and minimum separately for each of males in study group1 females in study group1, males in st...
answer(1) view(432) status()
)
Need a records trick ???
I want to retrieve specific records as they relate to a specific month or date range in a report. This database tracks court dates for police officers. Court dates may be continued several times before the trail actually commences. The...
I want to retrieve specific records as they relate to a specific month or date range in a report. This database tracks court dates for police officers. Court dates may be continued several times before the trail actually commences. The...
answer(1) view(370) status()
)
Access Form Security
ok..quick question - need some basic security help I have one form for data access and review - there is one field on the form that I want hidden for entry and review for one user, but available to another (manager) Is there a way to hid...
ok..quick question - need some basic security help I have one form for data access and review - there is one field on the form that I want hidden for entry and review for one user, but available to another (manager) Is there a way to hid...
answer(0) view(945) status()
)
Beginner needs help, carrying a value between 2 forms
New with Access. I am building a database and I need to cary a value from one form to another for example: If I have a form that you can enter a persons last name and first name, then you have to go to another form to add personal informa...
New with Access. I am building a database and I need to cary a value from one form to another for example: If I have a form that you can enter a persons last name and first name, then you have to go to another form to add personal informa...
answer(2) view(707) status()
)
Access List Boxes
Here's the scenario I have two listboxes. ONe shows a list of topis and once choosen gives a new list in the other textbox. I have used this code but it doesn't seem to work... suggestions? SELECT tblHeading.HeadingID, tblSubHeading...
Here's the scenario I have two listboxes. ONe shows a list of topis and once choosen gives a new list in the other textbox. I have used this code but it doesn't seem to work... suggestions? SELECT tblHeading.HeadingID, tblSubHeading...
answer(1) view(556) status()
)
Switchboard minimise/maximise
I have created my switchboard to startup when the mdb file opens. The button on the switchboard points to various reports and forms I have created. I need help to configure the switchboard (the simplest way) to disappear from view as soo...
I have created my switchboard to startup when the mdb file opens. The button on the switchboard points to various reports and forms I have created. I need help to configure the switchboard (the simplest way) to disappear from view as soo...
answer(1) view(962) status()
)
Now() Date/Time Not Correct -- Better way??
I'm currently building an simple database connection page for entry and viewing. I have one field that, rather than using ASP code, I was using a Default Value of 'Now()' in the Microsoft Access database to store the current date and local...
I'm currently building an simple database connection page for entry and viewing. I have one field that, rather than using ASP code, I was using a Default Value of 'Now()' in the Microsoft Access database to store the current date and local...
answer(4) view(714) status()
)
Vlookup function in Access?
I have 2 tables in Access 2002 - user_details and email_addy. The primary key in each table is the same. I would like the "email" field from "email_addy" to appear in the "user_details" table. I will then ...
I have 2 tables in Access 2002 - user_details and email_addy. The primary key in each table is the same. I would like the "email" field from "email_addy" to appear in the "user_details" table. I will then ...
answer(2) view(533) status()
)
Simple lookup. Beginner needs help.
I have a table with 3 fields: Category, Group, Type and all possible combinations. I have another table with the same 3 fields, but I want each field to lookup a value dependent on the previous selection. ie: Category offers a lookup wit...
I have a table with 3 fields: Category, Group, Type and all possible combinations. I have another table with the same 3 fields, but I want each field to lookup a value dependent on the previous selection. ie: Category offers a lookup wit...
answer(1) view(155) status()
)
Create View in Access
How do I create a view in MS-Access create view <view-name>( field list ) as select ...<some query>..; does not work. Can anyone pls help me out.
How do I create a view in MS-Access create view <view-name>( field list ) as select ...<some query>..; does not work. Can anyone pls help me out.
answer(1) view(15) status()
)
Compare opening and closing values
I have a form with an unbound text box that is populated with a value by a procedure. If the user overtypes the value in the text box with a new value I want this to trigger an event. The On Change event does not work because it only ...
I have a form with an unbound text box that is populated with a value by a procedure. If the user overtypes the value in the text box with a new value I want this to trigger an event. The On Change event does not work because it only ...
answer(1) view(210) status()
)
Error 3265. Item not found in this collection
I have a query with a parameter that references a form; I need to update the underlying table on which the query is based and have been trying to create some code to do so. First of all I got an error 'Too few parameters. Expected 1' wh...
I have a query with a parameter that references a form; I need to update the underlying table on which the query is based and have been trying to create some code to do so. First of all I got an error 'Too few parameters. Expected 1' wh...
answer(1) view(896) status()
)
check entry with table.
hi, i have a table with a primary key 'filename' where the user cannot entered duplicate filename. how do i compare and check if the filename entered by the user is a duplicate one as compared with my table???? i am not very good w...
hi, i have a table with a primary key 'filename' where the user cannot entered duplicate filename. how do i compare and check if the filename entered by the user is a duplicate one as compared with my table???? i am not very good w...
answer(1) view(46) status()
)
Mail Merge not working properly
I am trying to mail merge data from an access database. In my access table,for a specific date column (date/time data type), some of them are empty. These empty columns are filled with 12.00 AM when I am mail merging that table from MS ...
I am trying to mail merge data from an access database. In my access table,for a specific date column (date/time data type), some of them are empty. These empty columns are filled with 12.00 AM when I am mail merging that table from MS ...
answer(1) view(766) status()
)
Count Only Certain Responses
I am creating a report that has 3 columns of numeric data. The first column totals all the times a patient selected a "goal". The second column totals all the times the goal that was selected was achieved 75% or 100% of the time...
I am creating a report that has 3 columns of numeric data. The first column totals all the times a patient selected a "goal". The second column totals all the times the goal that was selected was achieved 75% or 100% of the time...
answer(1) view(326) status()
)
order level update
hi i have attached a copy of the tables i am trying to update and was wondering does anyone have any ideas on how to update an order level. How i want the database to work is that i will be ordering 200 items and then in three months i wi...
hi i have attached a copy of the tables i am trying to update and was wondering does anyone have any ideas on how to update an order level. How i want the database to work is that i will be ordering 200 items and then in three months i wi...
answer(1) view(47) status()
)
Breaking Date Fields Apart
I have a date field in an access table which I need to split into 2 fields one for month and one for year to allow me to group by the month and year. I have checked in mysql book and a couple of features such as DATENAME and EXTRACT(MONT...
I have a date field in an access table which I need to split into 2 fields one for month and one for year to allow me to group by the month and year. I have checked in mysql book and a couple of features such as DATENAME and EXTRACT(MONT...
answer(2) view(464) status()
)
Deadline
Printing form out with local printer Without knowing anything about access I volunteered to learn and do it for the church web site and would not ask so much if it were not for a deadline date. this is what I want to do. Have a form tha...
Printing form out with local printer Without knowing anything about access I volunteered to learn and do it for the church web site and would not ask so much if it were not for a deadline date. this is what I want to do. Have a form tha...
answer(0) view(551) status()
)
Journal Database I created, looking for ideas.
Hello all, This is a database (my first one) that I have created for my personal use. It is just a basic Journal. I am looking for any ideas I could incorporate into it, and for constructive critisism. As it is my first work, it is v...
Hello all, This is a database (my first one) that I have created for my personal use. It is just a basic Journal. I am looking for any ideas I could incorporate into it, and for constructive critisism. As it is my first work, it is v...
answer(2) view(687) status()
)
Forms: Using pages with Tabs
I have inserted pages with Tabs into my form and it works very well. The only thing that bugs me is the horrible grey back ground the Tabs have. I have got rid of the Grey page that comes with them, but I cant seem to be able to change the ...
I have inserted pages with Tabs into my form and it works very well. The only thing that bugs me is the horrible grey back ground the Tabs have. I have got rid of the Grey page that comes with them, but I cant seem to be able to change the ...
answer(1) view(726) status()
)
Grouping records in a specific order
My database is as follows: Rank............Surname High.............Smith High.............Bloggs Medium........Carter Low..............Blaine High.............Copp Medium........Bates What I need is a report that will group...
My database is as follows: Rank............Surname High.............Smith High.............Bloggs Medium........Carter Low..............Blaine High.............Copp Medium........Bates What I need is a report that will group...
answer(8) view(621) status()
)
listbox multiselect
I have a list box B that is polulated from a query of another listbox's A selection. I am trying to make B be multiselect listbox and have the choices made place inanother list box.?? Here is the code i am using Dim strPara As String ...
I have a list box B that is polulated from a query of another listbox's A selection. I am trying to make B be multiselect listbox and have the choices made place inanother list box.?? Here is the code i am using Dim strPara As String ...
answer(0) view(796) 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