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.
option group
hi all,, can my command button works within a option group??? i have a form and there are command buttons. it works perfectly untill i place the command button in the option group and it can't works anymore. pls advice nono
hi all,, can my command button works within a option group??? i have a form and there are command buttons. it works perfectly untill i place the command button in the option group and it can't works anymore. pls advice nono
answer(1) view(618) status(
)
)
Add record
hi all, i have a form with subform. i create the add record button using the wizard and it cannot works. i think it is due to the subform. it always gives me a error msg "You can't go to the specific record." when i click on t...
hi all, i have a form with subform. i create the add record button using the wizard and it cannot works. i think it is due to the subform. it always gives me a error msg "You can't go to the specific record." when i click on t...
answer(0) view(656) status()
)
Major Design Decision
Hi all! I'm having a problem finding a way to design my database. I'm making a database for the quality assurance dept. at a local packaging plant. They want a database to store all of their test data. As of right now, there are appr...
Hi all! I'm having a problem finding a way to design my database. I'm making a database for the quality assurance dept. at a local packaging plant. They want a database to store all of their test data. As of right now, there are appr...
answer(1) view(115) status()
)
Grouping Text Fields
I have a few tables in MS Access. The first table is a users table with an USERID field and other fields for the user. The second is a Groups table which has a USERID as a Foreign Key and a Name field. I need to group the Name field of t...
I have a few tables in MS Access. The first table is a users table with an USERID field and other fields for the user. The second is a Groups table which has a USERID as a Foreign Key and a Name field. I need to group the Name field of t...
answer(1) view(289) status()
)
How to deal with multi-value fields?
I'm exporting data from Lotus Notes into tab-delimited format that can be imported into Access This is great for single value fields but in multi-value fields, queries treat the contents as a single value, i.e. "value1 value2 value3...
I'm exporting data from Lotus Notes into tab-delimited format that can be imported into Access This is great for single value fields but in multi-value fields, queries treat the contents as a single value, i.e. "value1 value2 value3...
answer(7) view(854) status()
)
Printing reports to network printers ?!
Hello, Is it possible to print a report to different network printers? I've used the PrintDevMode type to set the devicename of the printer but it doesn't work. When I walk through my printerpool i see all the different network printer...
Hello, Is it possible to print a report to different network printers? I've used the PrintDevMode type to set the devicename of the printer but it doesn't work. When I walk through my printerpool i see all the different network printer...
answer(1) view(10) status()
)
Access and wireless networks
Has anyone had any experience running Access over a wireless network. Any information will be appreciated
Has anyone had any experience running Access over a wireless network. Any information will be appreciated
answer(9) view(297) status()
)
switchboard
hi, how can i activate my switchboard vai vb code??? pls advice nono
hi, how can i activate my switchboard vai vb code??? pls advice nono
answer(2) view(850) status()
)
need help on cmdsearch
I want to make a search command that takes one field of a table searches the one th user typed in the txtbox and in same form show all info field user searched. I'trying with a macro but can't seem to get it right. I'll appretiate the h...
I want to make a search command that takes one field of a table searches the one th user typed in the txtbox and in same form show all info field user searched. I'trying with a macro but can't seem to get it right. I'll appretiate the h...
answer(0) view(452) status()
)
Making a selection from a combo box.
I have a combo box where the user chooses the state. I would like to have it act like the combo box everyone is familiar with where if you hit the same letter, it cycles through the choices in that letter. For example, if I hit "O"...
I have a combo box where the user chooses the state. I would like to have it act like the combo box everyone is familiar with where if you hit the same letter, it cycles through the choices in that letter. For example, if I hit "O"...
answer(2) view(241) status()
)
A selective Combo Box
I want to use a Combo box on a sub-sub-form that only shows a selection from a table depending upon a value on the Master Form. ( in Access97) I have setup the Combo box to obtain its values from a query. That query refers to the control...
I want to use a Combo box on a sub-sub-form that only shows a selection from a table depending upon a value on the Master Form. ( in Access97) I have setup the Combo box to obtain its values from a query. That query refers to the control...
answer(3) view(479) status()
)
Help Please :)
I've got a field (ie- mark), and when data is entered into it, I want it to define what goes into another field (ie- grade). the grade would be dependant on which subject was entered, and what mark was entered. Any ideas? In very si...
I've got a field (ie- mark), and when data is entered into it, I want it to define what goes into another field (ie- grade). the grade would be dependant on which subject was entered, and what mark was entered. Any ideas? In very si...
answer(7) view(342) status()
)
Hyperlinks
Can you globally populate a "hyperlink" field with the path to a file. Or do you have to do it one right click at a time. Please help... I have over 1000 images I need to link to. Thanks in advance, RH
Can you globally populate a "hyperlink" field with the path to a file. Or do you have to do it one right click at a time. Please help... I have over 1000 images I need to link to. Thanks in advance, RH
answer(3) view(607) status()
)
Control displays null as zero (0)
I have a control populated by a procedure that can produce a null value. Under this circumstance I want the control to be blank but it displays a zero. How can I force the control to display nothing if the value is null? Mike Collard...
I have a control populated by a procedure that can produce a null value. Under this circumstance I want the control to be blank but it displays a zero. How can I force the control to display nothing if the value is null? Mike Collard...
answer(5) view(116) status()
)
Please Help! Event Procedure
Please help! I have created a form in which a user can enter information into several fields, the primary key for each file is created via an Auto Number.... On this form I would like to create a Command Button that links the information ...
Please help! I have created a form in which a user can enter information into several fields, the primary key for each file is created via an Auto Number.... On this form I would like to create a Command Button that links the information ...
answer(1) view(923) status()
)
Relationship Problem
Hi everyone! First of all i have a problem with access I have two tables, a CRUST table and a CRUSTPRICE table! In the CRUST table i have 'crustName' as one of the fields. In the CRUSTPRICE, i have 'crustName' as a part of a c...
Hi everyone! First of all i have a problem with access I have two tables, a CRUST table and a CRUSTPRICE table! In the CRUST table i have 'crustName' as one of the fields. In the CRUSTPRICE, i have 'crustName' as a part of a c...
answer(1) view(21) status()
)
Track Changes in DB
I'm looking for suggestions as to the best way to implement a "record change event log." I'd like to store the value of a particular field or fields if it is changed (by means of a Form). Please see table structure below. tb...
I'm looking for suggestions as to the best way to implement a "record change event log." I'd like to store the value of a particular field or fields if it is changed (by means of a Form). Please see table structure below. tb...
answer(3) view(356) status()
)
save records
hi, i have a main and subform which allow for editing. i have also create a save command button using the wizard but however when i click on the save button, it prompts me a msg, "the save command/action save record is not available...
hi, i have a main and subform which allow for editing. i have also create a save command button using the wizard but however when i click on the save button, it prompts me a msg, "the save command/action save record is not available...
answer(7) view(125) status()
)
import text file
hi, how do i import a text file with deliminator '|' into my database?? i have attached a text file for your reference. please give me some ideas of doing it. thanks nono
hi, how do i import a text file with deliminator '|' into my database?? i have attached a text file for your reference. please give me some ideas of doing it. thanks nono
answer(1) view(697) status()
)
search with text box
hi, i have a form that has an unbound field where it is the search criteria. when the user enter the text field, it will retrieve the records under this criteria specify. i am not very sure about recordset/recordsource......... ho...
hi, i have a form that has an unbound field where it is the search criteria. when the user enter the text field, it will retrieve the records under this criteria specify. i am not very sure about recordset/recordsource......... ho...
answer(12) view(698) status()
)
Adding images to an Access database
Hi all! I am setting up a MS Access database for use with a website. The database will contain all my computergames. What I want to do is add a picture of the CD cover to the database. This way people have a clearer picture of it all. ...
Hi all! I am setting up a MS Access database for use with a website. The database will contain all my computergames. What I want to do is add a picture of the CD cover to the database. This way people have a clearer picture of it all. ...
answer(1) view(776) status()
)
Querys in ms access xp
i made a query with this code in the criteria [search for game:] but i want it to have widl cartds on so it dosent have to be a igsact match is it posible
i made a query with this code in the criteria [search for game:] but i want it to have widl cartds on so it dosent have to be a igsact match is it posible
answer(1) view(362) status()
)
SubForm questions
I have two questions involving the use of a subform. The background: I have a form with all the detail about a company and licensing information. At the bottom of the form I have a subform that lists previous licenses (if a new feature...
I have two questions involving the use of a subform. The background: I have a form with all the detail about a company and licensing information. At the bottom of the form I have a subform that lists previous licenses (if a new feature...
answer(5) view(185) status()
)
Can't assign value to combo box
I have a combo box whose RowSource is some SQL. When the form opens I want the combo box to display a value assigned by some code. I have tried the following me.Combo = strMyValue AND me.Combo.Column(0) = strMyValue But the ...
I have a combo box whose RowSource is some SQL. When the form opens I want the combo box to display a value assigned by some code. I have tried the following me.Combo = strMyValue AND me.Combo.Column(0) = strMyValue But the ...
answer(1) view(572) status()
)
Control displays 0 or -1 not value
This is associated with the problem I reported re. the combo box but I now think it's nothing to do with the control being a combo because if I change it to a text box I get the same problem i.e. the control displays 0 or -1 not the string ...
This is associated with the problem I reported re. the combo box but I now think it's nothing to do with the control being a combo because if I change it to a text box I get the same problem i.e. the control displays 0 or -1 not the string ...
answer(1) view(74) status()
)
How to get the Oracle's Decode Functionality in MS Access
Hi, I need the Decode Functionality of Oracle in MS Access... I have a field with four values and I have to display as 1,2,3 and 4 for that instead of A, B, C and D.. Pls. send the code ASAP.. Regards, Raja
Hi, I need the Decode Functionality of Oracle in MS Access... I have a field with four values and I have to display as 1,2,3 and 4 for that instead of A, B, C and D.. Pls. send the code ASAP.. Regards, Raja
answer(1) view(24) status()
)
Compound fields?
I have two fields, FirstName and LastName, that I would like to combine into a field, Last_First, does access have any specialized way of doing that, or does it just take some manipulating with vba?
I have two fields, FirstName and LastName, that I would like to combine into a field, Last_First, does access have any specialized way of doing that, or does it just take some manipulating with vba?
answer(3) view(786) status()
)
email format access 2000
hi, I got the problem with microsoft access 2000 in send email. My problem here is, how i can send email by subject, body text and open microsoft outlook automaticcally with subject and body text record......... Then how i can make ...
hi, I got the problem with microsoft access 2000 in send email. My problem here is, how i can send email by subject, body text and open microsoft outlook automaticcally with subject and body text record......... Then how i can make ...
answer(0) view(401) status()
)
bringing records to a printable form
Hi... need help... I want to bring a record to a printable form... to be more specific I have a datagrid with a few columns from an access table and for each record i want to be able to print a form filled out with the specific record via b...
Hi... need help... I want to bring a record to a printable form... to be more specific I have a datagrid with a few columns from an access table and for each record i want to be able to print a form filled out with the specific record via b...
answer(0) view(764) status()
)
Need HELP! Trying to limit data in a chart among other things
My project is to try and limit the number of samples on my Access chart. In my current version I am using replication to update my chart on another machine. My problem here is that I would like to limit the data for the chart to say the las...
My project is to try and limit the number of samples on my Access chart. In my current version I am using replication to update my chart on another machine. My problem here is that I would like to limit the data for the chart to say the las...
answer(1) view(760) status()
)
Programming
Related Pages
- insert new record to an autonumber field?
- Query.
- Help with export picture on report to text file
- Split DB
- Make time count
- Union Query/Report
- Validation Rule error 2107
- Duplicacy in report: Error in sum
- Using Devices, such as barcode scanners, to input data in a record
- Report crashes in Windows 2000, Access 2000
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