| Subject | Date Asked | Expert |
|
| Can you set passwords to different forms in a database | 11/17/2008 | Bob Alston |
Q: I am setting up a database with multiple users. I would like different users to only have access to ...
A: If you are in a LAN environment where everyone signes on to the LAN, I like to capture the user name ...
|
| joint queries | 11/17/2008 | Scottgem |
Q: I would like to ask the question about jointing queries for instant: if i have 2 queries like this ...
A: This would be easier in a report. But if you want to do it in a query: SELECT UCase([Ingredient]), ...
|
| joint queries | 11/17/2008 | Bob Heifler |
Q: I would like to ask the question about jointing queries for instant: if i have 2 queries like this ...
A: Use the UCase and Format functions: SELECT UCase([Ingredient]), [Unit], Format([cost], ...
|
| Creating append query to remove duplicate records | 11/17/2008 | Scottgem |
Q: I believe its simple but I am missing a logic somewhere. I have an Access database which I use to ...
A: Like I said, all you need to is set the Order_Number field to No Duplicates. When you try to run an ...
|
| joint queries | 11/17/2008 | Bob Heifler |
Q: I would like to ask the question about jointing queries for instant: if i have 2 queries like this ...
A: You need a union query. Here is an example of the SQL that you will need to past in a SQL view of ...
|
| joint queries | 11/17/2008 | Scottgem |
Q: I would like to ask the question about jointing queries for instant: if i have 2 queries like this ...
A: Are these tables or queries? If they are tables this is not good design. You shouldn't have separate ...
|
| Creating append query to remove duplicate records | 11/17/2008 | Scottgem |
Q: I believe its simple but I am missing a logic somewhere. I have an Access database which I use to ...
A: That doesn't quite answer my question. However, if you are appending records to a table and you ...
|
| future value function in access | 11/17/2008 | Scottgem |
Q: How do you do the future value function that you normally use in Excel but in Access 2007?
A: The following is from Access VB help: FV Function Returns a Double specifying the future value ...
|
| Ms-Access Database connectivity | 11/17/2008 | Scottgem |
Q: I am using Ms-access 2000.I created a table in Access.I have to access table fields in ms-access ...
A: Why do you need to use ADO? I'm not clear what you are trying to do. Do you just want to create a ...
|
| If statements | 11/17/2008 | Scottgem |
Q: I am trying to group a bunch of names and call it Other holds her is my if statementHolds: ...
A: Try IIf([HOLD_CODE] = ("PH") Or [HOLD_CODE] = "BMU",'OtherHolds',[HOLD_CODE]) Since you are ...
|
| project | 11/15/2008 | Scottgem |
Q: I am making a questionare about student's school problems,in which questions about different type of ...
A: First you create a query that sums the answers by problem type. Next you join that query with the ...
|
| Selecting a value in a subform | 11/14/2008 | Bob Heifler |
Q: I am currently working on an interface for my database. I have two forms - Soldier_Information and ...
A: Try adding the word Form: Forms!Soldier_Information!History_Subform![Form]![Reason] = ...
|
| Referencing Query Data | 11/14/2008 | Scottgem |
Q: I have a table of an equipment inventory. I want to generate a report from a form I;ve also ...
A: You don't generate a report from a form. You can use a form to enter criteria for a query that will ...
|
| Automatically Filling in Data in access | 11/14/2008 | Bob Heifler |
Q: In Microsoft Access, I have a PART NUMBER column and a COST column. I have a part number that is ...
A: Mark, Two ways to go: 1) Make a form. Place a button on the form. Place this code on the click event ...
|
| query | 11/14/2008 | Scottgem |
Q: There are two tables and a form, when the user types in the number into the text box and choose the ...
A: At some point, maybe when you call the form or do the search, you need to test (using a Dcount) ...
|
| no record returned | 11/14/2008 | Scottgem |
Q: i need to find out how to show a msg box if a record is not returned from a paramater query. all is ...
A: I almost never use paramter prompt queries because they are so limiting. This is one example. What ...
|
| sorting two fields togther in the same database | 11/13/2008 | Bob Heifler |
Q: I am building a database for couples addresses and other data. I want to build a report that lists ...
A: Your report design area allows for sorting and setting the sort order of the fields. The icon on the ...
|
| How adding (personal) photos to Ms Access | 11/13/2008 | Scottgem |
Q: I make a table which is having, ID Num, Name, Date of Birth and ect... in this table i want to add a ...
A: The best way is to add a text field that contains the path to the image file. You then use an ...
|
| question | 11/13/2008 | Bob Heifler |
Q: I add a pviot chart to a report and it works fine just when I change the color and run the report ...
A: The color should not change unless you have used some kind on Conditional Formating built into ...
|
| counting number of c's I's and n/a's | 11/13/2008 | Scottgem |
Q: I found a access survey database that Im using called at your survey. I remember you said to change ...
A: Ok, the key here is tblReponses. When a user fills in a survey. the first thing they do is create a ...
|
| Entity relationship design in Ms Access | 11/13/2008 | Scottgem |
Q: sorry for my English, I am not a native English speaker.I am trying to simulate citizens of a ...
A: That's fine. Its a one to many because one country can have many citizens. Referentail Integrity ...
|
| Unique sequential numbering in Access 2007 | 11/13/2008 | Scottgem |
Q: I am a access newbie (1 month) and have created a database that tracts our staff members that apply ...
A: Either you are misunderstanding what you have read or you need to use different sites. Every Access ...
|
| query | 11/13/2008 | Geoff |
Q: There are two tables and a form, when the user types in the number into the text box and choose the ...
A: Zsolt hi, This is a "design" feature of Access ! No records = blank form. The only solution is to ...
|
| How can i fetch data relative to data filled in the current form | 11/13/2008 | Geoff |
Q: I have two tables in my DB, one is main table and another one is lookup table. I have two fields in ...
A: In the [Name] text box Control Source property enter an expression based on the following - you will ...
|
| Password protecting an access button | 11/13/2008 | Scottgem |
Q: I need a way to simply password protect a button on the form I use as my front page via input box ...
A: In the On Click event of the button use code like: IF InputBox("Enter Password") = "password" Then ...
|
| Unique sequential numbering in Access 2007 | 11/12/2008 | Scottgem |
Q: I am a access newbie (1 month) and have created a database that tracts our staff members that apply ...
A: Why do you need a sequential number? what you should be doing is have an autonumber field as your ...
|
| Lookup list dependent on other data | 11/12/2008 | Bob Alston |
Q: Greetings. I am working in Access 2000 on a db to capture all the basketball results for this coming ...
A: I assume you are creating an entry in the games table with the game date and selection of the home ...
|
| Type Mismatch Error | 11/12/2008 | Bob Heifler |
Q: Bob, First and for most thanks for taking my question! I can't figure out why I keep getting a "type ...
A: If you really want to delete the records matching your WHERE then replace ...
|
| peramiter query | 11/12/2008 | Bob Heifler |
Q: I have a form based off of a peramiter query and when there is no answer for that query the form ...
A: Erik, You can open a recordset on the form's recordsource first to check if any records. Code: Dim ...
|
| Multiple Entries in an Access table field | 11/12/2008 | Geoff |
Q: How can I allow several entries in an Access table field? I have a field called 'associated ...
A: I would not advise this in a database application - of course if you want to manually type in ...
|
| Obtaining next available Member ID | 11/12/2008 | Geoff |
Q: I am trying to determine how to best set my form up to obtain the next available member number. How ...
A: Why don't you use the Autonumber data type for the MemberID - it was made for exactly this ...
|
| Search Function for a subform | 11/12/2008 | Scottgem |
Q: What is the best way to search for data in a subform? I have a simple database that logs calls and ...
A: Add an unbound textbox to your MAIN form. Make the subform bound to a query. In the query set the ...
|
| Query for specified number of records | 11/12/2008 | Bob Heifler |
Q: I am working in Access 2003. I constructed a select query that tells me how many times in the past ...
A: Gaye, Yes, in the query on the missed times column set the criteria to: >=5 or >4 both will work. ...
|
| format two tables in same report differently | 11/12/2008 | Scottgem |
Q: I am a novice in Access and was hoping you could help. I have a Union query that returns calculated ...
A: Access uses a "banded" report writer. Each section in Report design is considered a band. By default ...
|
| Multi Field Search Function in Access | 11/11/2008 | Geoff |
Q: I'm new at using access, and really hope you can give me some detailed instructions. I have set up ...
A: Set the subform based on a query, say qrySF - anything just to get going. Next under the search ...
|
| format two tables in same report differently | 11/11/2008 | Scottgem |
Q: I am a novice in Access and was hoping you could help. I have a Union query that returns calculated ...
A: First what you describe in Design view is SOP. There is only one set of controls to represent the ...
|
| Speeding up search access 2000 | 11/11/2008 | Bob Alston |
Q: I have a database which works fine BUT as I add more records it is slowing down during search. The ...
A: YOu should be able to define indices on the key fields that distinguish the different logical types ...
|
| Multi Field Search Function in Access | 11/11/2008 | Geoff |
Q: I'm new at using access, and really hope you can give me some detailed instructions. I have set up ...
A: Proramming a search form is one of the most complicated tasks for any developer, so if you are new ...
|
| File Browse Feature | 11/11/2008 | Scottgem |
Q: I noticed that this question has been asked before and you directed the person to the API website ...
A: First, the code doesn't go behind a button, it should all go into a global module. The only thing ...
|
| Access 2007 - Linking data | 11/10/2008 | Scottgem |
Q: Having an issue with trying to link data and then closing the original form. I have the following: ...
A: So you are creating a new record in FRM_SALES? If so, you can pass the ECID in the OpenArgs argument ...
|
