| Subject | Date Asked | Expert |
|
| Save button is greyed out... | 11/26/2009 | Scottgem |
Q: Not sure why this all of audden happend today. Can you help me out here? I tried running other ... A: Ahh, Ok, first for those to be active, you need to have an object selected that can be saved. The ...
|
| Filtering data from more then two tables of same format | 11/25/2009 | Scottgem |
Q: I have three data tables of same format containing yearly data data. The number of records in all ... A: First, you really shouldn't need to separate data tables by year. Unless you encountered some ...
|
| Access Macro (naming of files) | 11/24/2009 | Sayedaziz |
Q: Hey, thx for taking Access questions! I'm trying to automate a database process that outputs a ... A: make a form place a commandbutton say cmdExport in its click event paste the following code : ...
|
| Double Booking Query | 11/24/2009 | Scottgem |
Q: At present I am trying to make a database for room bookings at work. I'm at the point where I need ... A: I see, so you were using a self join hence the _1. Should have thought of that. OK, I would do this ...
|
| Double Booking Query | 11/24/2009 | Scottgem |
Q: At present I am trying to make a database for room bookings at work. I'm at the point where I need ... A: First, what you showed me is not a query, it looks like a column in a query. Second, what is your ...
|
| Sendobject to embedded adres | 11/24/2009 | Scottgem |
Q: MS Access 2007 Hello Scottgem, I am trying to make a form in Access that after completion can be ... A: Use either: DoCmd.SendObject acForm, "Frm_sendmail", "PDFFormat(*.pdf)", Me.EMail,,, "Order by ...
|
| access, synchronize, database | 11/24/2009 | Scottgem |
Q: I have a Access db that is used by multiple users, some of the users have laptops and make ... A: You need to learn about replication. If you google MS Access replication, you will find several ...
|
| access, synchronize, database | 11/24/2009 | Bob Heifler |
Q: I have a Access db that is used by multiple users, some of the users have laptops and make ... A: Prem, All Access versions have synchronization ability however conflict resolution is always a ...
|
| Date Conversion | 11/23/2009 | Sayedaziz |
Q: I have a formula in access VB set up to convert text to MS Date. The date on our system appears as ... A: I am unable to understand what calculation u mean ? your function returns vdate = 1091123 as ...
|
| On closing a MDB, automatically open a .DOC file | 11/23/2009 | Scottgem |
Q: I am using MS Word and Access 2007. Can you please show me how I can get MS Access to open up a ... A: Part of this depends on how you close Access. Do you have an Exit button on a switchboard? The ...
|
| User-defined search | 11/23/2009 | Scottgem |
Q: I have a database I have created for a school project which is a "Multiple Listing Service" DB. The ... A: I've used a variation of Don's concept in a number of apps. But I disagree with two of his ...
|
| extracting queries to reports | 11/23/2009 | Bob Heifler |
Q: How can i connect the data i extracted in the queries to reports which is the final output. A: Every version of Access has a report wizard and the first thing that is asked in the wizard is what ...
|
| access & word | 11/22/2009 | Sayedaziz |
Q: I am using access 2007 & office 2007 I have a record per employee saved in access table and the ... A: Have you enable macro ? follow these steps : 1) Click Office Icon on left corner. on right bottom ...
|
| Adding a record to a subform when it's based on a query | 11/22/2009 | Scottgem |
Q: Help... I wrote an Access 2003 app 2 years ago and all of a sudden, on October 29th, 2009, it ... A: In the VBE go to the Edit menu and choose Find. Do a find in the current Project and you can search ...
|
| Adding a record to a subform when it's based on a query | 11/22/2009 | Scottgem |
Q: Help... I wrote an Access 2003 app 2 years ago and all of a sudden, on October 29th, 2009, it ... A: The answer is in my last post. I said I was assuming that StudentID was a number datatype. But based ...
|
| MS Access 2000-adding a new field to a form | 11/21/2009 | Bob Heifler |
Q: I have an existing Access 2000 database where two new fields were added to a table. The large and ... A: Tony, The recordsource of the form is probably a query that does not include these fields. Check out ...
|
| usage of ms-access in industrial engineering | 11/21/2009 | Sayedaziz |
Q: I'm afshin.I'm a student of industrial engineering in Uni.Please help me to know that what are the ... A: Distribution ============ BACKHAUL. Use of a common carrier or vehicle from a private fleet for a ...
|
| MS Access If Function | 11/21/2009 | Scottgem |
Q: I run a report on Monday, but display Tuesday in unbound text frame in the report header using a VBA ... A: =Format(Date() + Choose(Weekday(Date(),vbMonday),1,1,1,1,3,2,1),"dddd") To test this Substiture a ...
|
| Time Calculation Using Access Query | 11/21/2009 | Scottgem |
Q: again i need your help regarding calculating difference of time in ms access query. i have a table ... A: First, you need to understand how Access stores DateTime values. Access stores date/time values as a ...
|
| MS Access AutoNumber feature | 11/20/2009 | Scottgem |
Q: I have a database that contains two tables (Activate %26 Wirelist) with a "auto-number" column (WID) ... A: If I follow you, you have two tables in one to many relationship. What's not clear is which is the ...
|
| How to connect a text field to combo box | 11/20/2009 | Scottgem |
Q: "Yes", "No". There's a text box underneath it "Incident number". If user selects "Yes" I want the ... A: I would not use a combo in this case. I would use either an Option Group or a Check box. But the ...
|
| usage of ms-access in industrial engineering | 11/20/2009 | Sayedaziz |
Q: I'm afshin.I'm a student of industrial engineering in Uni.Please help me to know that what are the ... A: Industrial engineers determine the most effective ways to use the basic factors of ...
|
| To calculate gross,Net salary for an employee in Access | 11/20/2009 | Scottgem |
Q: I need to calculate the net and gross salary for an employe in Ms Access..that to by writing the ... A: Depends on the structure of your database. The proper structure would be using three tables like ...
|
| ACCESS - modify date | 11/19/2009 | Scottgem |
Q: I've implemented the suggestion to add the date modified to a table that is changed via a form. But ... A: Users should NEVER interact directly with tables. All interaction with the data should be done ...
|
| Search mode?? | 11/19/2009 | Scottgem |
Q: I'm new to Access 2007 and have a problem. I've created some tables, queries and reports. I was ... A: Well first you really shouldn't be entering data directly into tables. You should be using forms. ...
|
| recovering information | 11/19/2009 | Sayedaziz |
Q: Someone accidentally deleted information from a table and we have the information from last year. ... A: yes this is possible. you can append records from external database to the current database. but ...
|
| Donations Database | 11/19/2009 | Scottgem |
Q: So what i did was create a couple of databases and made sure that nothing overlaps. Here are my ... A: Good start, but room for improvement. First, I recommend naming your PKs using the convention ...
|
| Problems getting forms to work. | 11/19/2009 | Scottgem |
Q: I am not totaly good with access. The problem is: I have many tables setup and working like I need ... A: First, you don't need another table. Vistors should be entered in your People table. You should have ...
|
| Searching for a string in my access form that is made up of text and numbers. | 11/19/2009 | Scottgem |
Q: e. "COMM-125" and other simple text strings? Here is my coding for it thus far: Option Compare ... A: The problem here is the value returned by cboSearchfield. As a rule its is not a good idea to put ...
|
| coding vba | 11/19/2009 | Scottgem |
Q: Please advice on this code What i am trying to do is i have a todo list, and promt me when there is ... A: So what you are trying to do is check periodically if a new task has been added and pop up a ...
|
| Coding in VBA | 11/19/2009 | Bob Heifler |
Q: Please advice on this code What i am trying to do is i have a todo list, and promt me when there is ... A: Shermund, The form probably shows new records without the me.requery since it's probably bound to a ...
|
| Problems getting forms to work. | 11/19/2009 | Scottgem |
Q: I am not totaly good with access. The problem is: I have many tables setup and working like I need ... A: I have one word for you: Subforms! You should find this blog of mine useful: ...
|
| MS Access 2003, Filtering Data Using Forms | 11/19/2009 | Scottgem |
Q: MS Access 2003, I have one table like this with 4 fields, AdmissionDate: AdmissionTime: Discharge ... A: Use the Filter By Form feature. Create a form in Tabular format using the Form Wizard. Then use the ...
|
| Query for different records for identical data | 11/19/2009 | Scottgem |
Q: I have a multi-record table of plant species canopy cover data for 1/10 acre plots/sample areas. ... A: I'm not clear what you want as a result. You can use the Query wizard to create a duplicates query. ...
|
| DLOOKUP AND RUNTIME ERROR 3075 | 11/18/2009 | Richard Rost |
Q: I am trying to autofill a sales reps information based on a selected company name from the main ... A: What kind of a field is Company. My DLOOKUP example just uses an ID field. If you're dealing with a ...
|
| how do i perform a Count(Distinct) query for 2 different column values using GROUP BY | 11/18/2009 | Richard Rost |
Q: I have this "source" table like this.... |------------------------------------| |ROLLUP_ID | ... A: Well, if you create a simple aggregate query and use GROUP BY for the Rollup and Gap, you can use ...
|
| how do i perform a Count(Distinct) query for 2 different column values using GROUP BY | 11/18/2009 | Scottgem |
Q: I have this "source" table like this.... |------------------------------------| |ROLLUP_ID | ... A: Actually I don't see two columns using DISTINCT. You are Grouping By Rollup_ID. You are counting ...
|
| Dollar per mile problem | 11/18/2009 | Scottgem |
Q: I have two tables: Table: Petty Cash Register Fields: PCVDate, Vehicle (This is a lookup with ... A: Actually your problem is more on the back end. Since you are recording mileage BEFORE pumping gas, ...
|
| Form appending info to a Table | 11/18/2009 | Richard Rost |
Q: I'm a beginner at Access 07 trying to develop a user friendly database. I'm trying to develop a ... A: Cory, this is normally how bound forms work. Your form is automatically attached to a table. When ...
|
| Searching for a string in my access form that is made up of text and numbers. | 11/18/2009 | Scottgem |
Q: e. "COMM-125" and other simple text strings? Here is my coding for it thus far: Option Compare ... A: You have the right idea, just the wrong execution. I don't understand why you are using the Replace ...
|