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.
Update Field Automatically
All, I am having trouble on how to automatically update a field in one table by combining the data from 2 fields in a seperate table. Example: Table1 has 2 fields, Part# and PartType Table2 has 1 field, Fab Part (which is a comb ...
All, I am having trouble on how to automatically update a field in one table by combining the data from 2 fields in a seperate table. Example: Table1 has 2 fields, Part# and PartType Table2 has 1 field, Fab Part (which is a comb ...
answer(2) view(385) status(
)
)
Passing select list values to a db
Please help! I am trying to pass a value from a select list to Access database using ASP. The value selected is not being recognized by the db. My first thought was that the select list was not passing the values> However, on t...
Please help! I am trying to pass a value from a select list to Access database using ASP. The value selected is not being recognized by the db. My first thought was that the select list was not passing the values> However, on t...
answer(1) view(383) status()
)
Stock Control system - Access 2000
I'm a relative newcomer to Access so don't really know where to start. Basically I'm looking for any kind of tutorials or help files that could take me through, step by step, creating an example stock control system. This way I'd have some ...
I'm a relative newcomer to Access so don't really know where to start. Basically I'm looking for any kind of tutorials or help files that could take me through, step by step, creating an example stock control system. This way I'd have some ...
answer(2) view(877) status()
)
Aggregate function with Select Statement
How do I combine the following statements: SqlJunk = " SELECT SUM(MSD+Methods+Analysis+Architectures+Models+Stud io+Elective1+Elective2+Elective3) As PersonTotals FROM tblpersons " SqlJunk = "SELECT FirstName, La...
How do I combine the following statements: SqlJunk = " SELECT SUM(MSD+Methods+Analysis+Architectures+Models+Stud io+Elective1+Elective2+Elective3) As PersonTotals FROM tblpersons " SqlJunk = "SELECT FirstName, La...
answer(5) view(509) status()
)
dlookup
Hello, I trying to create a form that consist of 6 fields. The first field "JobNbr" will be were a user will input a numeric job number, and the remain fields will be automatically field in by information related to field (1) ...
Hello, I trying to create a form that consist of 6 fields. The first field "JobNbr" will be were a user will input a numeric job number, and the remain fields will be automatically field in by information related to field (1) ...
answer(6) view(438) status()
)
Access 2000 and xml???
Please help someone!!!! I need to output my database as an XML document....does anybody know how to do this with MS Access 2000?
Please help someone!!!! I need to output my database as an XML document....does anybody know how to do this with MS Access 2000?
answer(4) view(936) status()
)
Table Relationships/Update Calc query and Subform Calculation
Hi, I am having trouble trying to setup 2 tables. I am not sure of how they should be related. I have one table Inventory and one table Product Request Details. The Product Request Detail table contains LB1, LB2, LB3, etc. each of these...
Hi, I am having trouble trying to setup 2 tables. I am not sure of how they should be related. I have one table Inventory and one table Product Request Details. The Product Request Detail table contains LB1, LB2, LB3, etc. each of these...
answer(1) view(51) status()
)
Help and Advice- Helpdesk Relationships
I have been tasked with designing an IT helpdesk database, but to be honest i am not sure what sort of things are usually included in this type of project. Any ideas please... my company has around 400 computers 8 technicians - c...
I have been tasked with designing an IT helpdesk database, but to be honest i am not sure what sort of things are usually included in this type of project. Any ideas please... my company has around 400 computers 8 technicians - c...
answer(3) view(932) status()
)
If *this* is not equal to *this*
The syntax would be If varOption_A <> varOption_B then do this... else do this end if Right? How does this work when trying to query a DB? Same way? I am trying to pull info from a DB based upon if the criteria match...
The syntax would be If varOption_A <> varOption_B then do this... else do this end if Right? How does this work when trying to query a DB? Same way? I am trying to pull info from a DB based upon if the criteria match...
answer(4) view(904) status()
)
Table Relationships in order to update field with math calculation
Hi, I am having trouble trying to setup 2 tables. I am not sure of how they should be related. I have one table Inventory and one table Product Request Details. The Product Request Detail table contains LB1, LB2, LB3, etc. each of these...
Hi, I am having trouble trying to setup 2 tables. I am not sure of how they should be related. I have one table Inventory and one table Product Request Details. The Product Request Detail table contains LB1, LB2, LB3, etc. each of these...
answer(0) view(491) status()
)
random function
Hello all, We have a problem... We are trying to build a random function into one of our queries which will enable us to allocate one out of five possible rooms to a person on a random basis. Could somebody give us a hint how this...
Hello all, We have a problem... We are trying to build a random function into one of our queries which will enable us to allocate one out of five possible rooms to a person on a random basis. Could somebody give us a hint how this...
answer(1) view(916) status()
)
**Urgent** Please Help
I have designed an access database and after i made a copy of it, it now won't run a switchboard or any model pop-up forms. It comes up with the error, Error accessing Network a connection may be lost. It also comes up with a missing form...
I have designed an access database and after i made a copy of it, it now won't run a switchboard or any model pop-up forms. It comes up with the error, Error accessing Network a connection may be lost. It also comes up with a missing form...
answer(4) view(111) status()
)
Problem with Order by clause...Help needed
Dear experts, I use MSAceess 2000 DB. I have two tables named Emp and dept. I need to produce a list that contains the deptName,deptCode and Manager name of that dept. I used the folowing query: select deptName,deptCode,(sele...
Dear experts, I use MSAceess 2000 DB. I have two tables named Emp and dept. I need to produce a list that contains the deptName,deptCode and Manager name of that dept. I used the folowing query: select deptName,deptCode,(sele...
answer(2) view(846) status()
)
help with fields in a form
I started with excel and have a list of user accounts and properties. Then i imported into access when i figured out how and created a form to give a front end on adding new users. My question is how can i use one of the fields to bring...
I started with excel and have a list of user accounts and properties. Then i imported into access when i figured out how and created a form to give a front end on adding new users. My question is how can i use one of the fields to bring...
answer(1) view(234) status()
)
Employee Time Sheet
I need help.......PLEASE! I am trying to build a table that can track our employees hours worked. I found an example on here that someone had posted but it only works well on even hours and not with quarter or half hour.... Our employees ge...
I need help.......PLEASE! I am trying to build a table that can track our employees hours worked. I found an example on here that someone had posted but it only works well on even hours and not with quarter or half hour.... Our employees ge...
answer(2) view(334) status()
)
Get the current subform value inside a form
Hi All, I have created a form called [Stock Reserved Activation]. Inside this form, it contains a subform called [Child0]. This subform shows all the records in a table called [Stock Transaction]. This table contains a field [RefNo]. ...
Hi All, I have created a form called [Stock Reserved Activation]. Inside this form, it contains a subform called [Child0]. This subform shows all the records in a table called [Stock Transaction]. This table contains a field [RefNo]. ...
answer(3) view(363) status()
)
info window on report
I have a monthly report and I would like to show a window everytime the monthly report is empty telling the user that there are no reports for that month. how can I do this? I've tried with IF but I keep getting error. hope you can hel...
I have a monthly report and I would like to show a window everytime the monthly report is empty telling the user that there are no reports for that month. how can I do this? I've tried with IF but I keep getting error. hope you can hel...
answer(3) view(968) status()
)
building an faq list
I have created a database with two fields. First field is 'Question' and the second field is 'Answer'. Now i want to build a list of the frequently asked questions from this database. The problem is that a question that is same may not be '...
I have created a database with two fields. First field is 'Question' and the second field is 'Answer'. Now i want to build a list of the frequently asked questions from this database. The problem is that a question that is same may not be '...
answer(0) view(390) status()
)
trying to make report
I'm trying to make a monthly report. I have a form with a combo box where the user selects the month that he/she wants in the report and after clicking the ok button the report should show all of the information the table has with that mont...
I'm trying to make a monthly report. I have a form with a combo box where the user selects the month that he/she wants in the report and after clicking the ok button the report should show all of the information the table has with that mont...
answer(4) view(242) status()
)
Drop Down list
Hi, I am trying to pull out a date field from Access 97 to be in a drop downlist using Php and ODBC. Could anyone help me out? The query is SELECT DISTINCT format(mid(Time, 2, 11), 'dd/mmm/yyyy') FROM IPlog WHERE TIME<>'...
Hi, I am trying to pull out a date field from Access 97 to be in a drop downlist using Php and ODBC. Could anyone help me out? The query is SELECT DISTINCT format(mid(Time, 2, 11), 'dd/mmm/yyyy') FROM IPlog WHERE TIME<>'...
answer(4) view(666) status()
)
OpenReport
I'm running office 2000 and created a dataase that had a form which produce a record with filters, in the code i had DoCmd.OpenReport, but when i run it an error appear saying: "Wrong number of arguments or invalid property assignme...
I'm running office 2000 and created a dataase that had a form which produce a record with filters, in the code i had DoCmd.OpenReport, but when i run it an error appear saying: "Wrong number of arguments or invalid property assignme...
answer(1) view(300) status()
)
"ADODB.Connection.1 error '800a0bb9'
Here is my error: "ADODB.Connection.1 error '800a0bb9' The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. mydbconn.inc, line 8 " Here is the...
Here is my error: "ADODB.Connection.1 error '800a0bb9' The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. mydbconn.inc, line 8 " Here is the...
answer(0) view(660) status()
)
access 97 graphing
Hi, I have a table which has data like so: table = "tblInspections" being date.....end date..........INSP ---------------------------------------- 09/26/2003...09/10/2003.......CO12 10/01/2003...10/03/2003.......CO9 11/...
Hi, I have a table which has data like so: table = "tblInspections" being date.....end date..........INSP ---------------------------------------- 09/26/2003...09/10/2003.......CO12 10/01/2003...10/03/2003.......CO9 11/...
answer(1) view(236) status()
)
autonumber length
is it possible to set the length of an autonumber. i really need all of my autonumbers in a field to be 8 in length, but i can not find a way of doing this
is it possible to set the length of an autonumber. i really need all of my autonumbers in a field to be 8 in length, but i can not find a way of doing this
answer(1) view(16) status()
)
Updating Database from Asp page
Hi, I would like to know how I can include a submit button or a check box to approve/disapprove or update database results?
Hi, I would like to know how I can include a submit button or a check box to approve/disapprove or update database results?
answer(1) view(983) status()
)
Turning off "editing" in forms last record.
Hi guys, I'm in a picle here. I can't seem to fina any info on turnong turning off "editing" or is it, "adding new record" in my forms last record. Here is my case. In the code below, I have some calculations...
Hi guys, I'm in a picle here. I can't seem to fina any info on turnong turning off "editing" or is it, "adding new record" in my forms last record. Here is my case. In the code below, I have some calculations...
answer(1) view(403) status()
)
Access 2002 openform date format
using XP and Access 2002 in UK. Date defaults are for format dd/mm/yy. Trying to docmd.openform with a where selection by date, however, it will only accept US format dates in the docmd operation. UK format dates work if I put them dire...
using XP and Access 2002 in UK. Date defaults are for format dd/mm/yy. Trying to docmd.openform with a where selection by date, however, it will only accept US format dates in the docmd operation. UK format dates work if I put them dire...
answer(2) view(410) status()
)
File Name Returned Problem
I am trying to paste a FileNameReturned String into an filed on my form but I receive the following error: Run-time error '3163' The filed is too small to accept the amount of data you attemped to add. Try inserting or pasting less dat...
I am trying to paste a FileNameReturned String into an filed on my form but I receive the following error: Run-time error '3163' The filed is too small to accept the amount of data you attemped to add. Try inserting or pasting less dat...
answer(2) view(167) status()
)
a quick question...
I know I'm doing something wrong because I'm gettin the error message "The expression is typed incorrectly, or is too complex to be evaluated...". Basically, its an example of a stock control system and the guide I'm using says...
I know I'm doing something wrong because I'm gettin the error message "The expression is typed incorrectly, or is too complex to be evaluated...". Basically, its an example of a stock control system and the guide I'm using says...
answer(1) view(299) status()
)
AutoMatic Filename into Field
All, How can I create a button that opens a dialog box that can select a file, automatically copy that file into a designated folder, then store the filename into a field in some table (for later reference in a report that can pull up th...
All, How can I create a button that opens a dialog box that can select a file, automatically copy that file into a designated folder, then store the filename into a field in some table (for later reference in a report that can pull up th...
answer(7) view(363) 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