You are here:
- Home
- Computing/Technology
- Business Software
- Using MS Access
Using MS Access/Questions Answered by Expert Bob Alston
| Subject | Date Asked |
| visual basic help | 1/4/2011 |
| Q: I am not a programmer but no how to do all the other stuff on Microsoft access such as creating the ... A: What you propose is not a good approach. Instead make the primary key for the record an ... | |
| Access Forms and a vba module. | 9/16/2010 |
| Q: I would like to display the values of my variables in a module in a Form. Sounds easy enough. I have ... A: Normally you do it the referse of what you are saying. YOu define fields on a form that will later ... | |
| Database Structure Design | 8/5/2010 |
| Q: Are you able to offer assistance? I have started to design a database that would track purchaser ... A: I am available to answer specific questions of a technical nature. I am not available for free to ... | |
| DateValue | 7/20/2010 |
| Q: my query statement reads - Expr1: DateValue([CreationTime]) Receive the following error "Extra ) ... A: It does work for me. I found the following in the HELP within Access Visual Basic for Applications ... | |
| Limiting the Records shwon on a report | 7/20/2010 |
| Q: I have a number of people who are doing placements at various departments around the company. I am ... A: Yes. YOu can create a query to place limits on the records returned by the query. sounds like you ... | |
| Access Passwords | 7/19/2010 |
| Q: I have a database form that asks for a password when you click on a given field. If the password is ... A: Yes you can. YOu need to create an If then else with elseif. suggest you find a book on Access or ... | |
| How to show full length of characters in a text field? | 7/7/2010 |
| Q: How can I show them all? A: If viewing the query, drag the right edge of the column you want to expand to the right, like you ... | |
| Access 2003 Query | 6/17/2010 |
| Q: Good day, I am currently running a query at work where I have two fields in a table I want to query ... A: Use the access query builder. In the lower section show a column for each field you want in your ... | |
| Re: Access Child > Parent > Update | 6/14/2010 |
| Q: I have a small query for you in regards to updating a Parent Field with a entry in the Child ... A: As I told you previously, you can refer to a control on a form that is the top level form via this ... | |
| Add a record button | 6/4/2010 |
| Q: I am teaching Ms Access 2003. My students have created a form in design view to add a record using a ... A: Sounds like they may have a different version of Access and they don't have all of the add-on ... | |
| Extracting or trimming data from a field in Access 2007 | 5/7/2010 |
| Q: I have a field that contains both the City and State, I am able to create another field with just ... A: If you believe there is always a comma separating the city from the state, you could identify the ... | |
| Use of count function in reports | 4/29/2010 |
| Q: I am programming in access for a very long time. I am stuck in a report having multiple rows of ... A: Why not use a cross tab query to create columns for each grade A, B, C. then you can use a totals ... | |
| Adding data to an existing databse | 4/28/2010 |
| Q: I have an excel sheet that I want to use in Access so I can add a bin location to an added field. I ... A: The input screen would be called an Access form. Here are some free Access tutorials: ... | |
| Run-time error '3070' | 4/26/2010 |
| Q: I'm trying to run an access report using the set of guidelines prepared by a data analyst who no ... A: YOu have not given me enough information to solve the problem. but the error is telling you that ... | |
| Two different tables | 4/5/2010 |
| Q: I have a database which looks up client details for a particular service, it is nearly finished but ... A: Yes. If you are doing a union query in SQL code, you can specify a new field, specified differently ... | |
| How to synchronize two Access 2007 forms | 4/1/2010 |
| Q: I have 2 forms, What I would like to do is from the first form select a record and then another form ... A: I am unclear if you actually have to different revision fields. I am assuming that you do. I ... | |
| HELP!!! MS ACCESS | 3/29/2010 |
| Q: I have to create a database using Access and this is my first time. I have to complete it for my ... A: I am willing to help you but not do it for you. to do it for you, my fees would be $75 an hour in ... | |
| Corrupt database error message | 3/29/2010 |
| Q: I use Access on a very limited basis. Occasionally, when I create a query, I forget to join the ... A: Likely your query is causing the problem because it is accessing all data in both tables and making ... | |
| Dlookup troubles | 3/27/2010 |
| Q: I am working in Access 2000 and am fairly experienced with Access, but self taught so have limited ... A: If you include the phone number in the combo box, after you select the lease from the combo box, you ... | |
| access form into web page | 3/26/2010 |
| Q: I have an access data base fed from a single Exel spread sheet with forms and all. My boss wants me ... A: No, with current versions of Access this is not possible. However, later this year, when Access ... | |
| Complex query construction | 3/24/2010 |
| Q: I have a project table with fields for the completion date and category of each projectID. I'm ... A: How about a two part query. First query. Set a selection criteria to select only projects with a ... | |
| Consolidation DB | 3/20/2010 |
| Q: I was wondering if you could help me in creating a MS Access DB , someone suggest that it could sort ... A: I can help you in creating the db by answering specific questions that you have. It is not clear ... | |
| Non editable ..... | 3/20/2010 |
| Q: I made a form including fields like 1. ID 2. NAME 3. DATE etc. Now my question is how do I make ... A: YOu can create a form that allows input only. Be sure to specify the Data entry = yes attribute for ... | |
| designing a View with large amounts of Data | 3/19/2010 |
| Q: I have a table that is 20 fields across. I would like to create a quick view off of a query to look ... A: Yes you can. sounds like you need some basic Access training. Hee is a link to Microsoft's Access ... | |
| Auto run macro | 3/17/2010 |
| Q: I am attempting to produce a macro that will run a working query before I come into work every day ... A: I use the windows Task Scheduler (Accessories, Systems tools) to schedule the running of an Access ... | |
| comact and repair | 3/16/2010 |
| Q: access creates a new database "db1". then i have to rename it to the original one and delete the ... A: When you open the database and use compact and repair from within the database, it should return the ... | |
| Preventing double bookings | 3/12/2010 |
| Q: I am creating a database system for a dentist. I have my entity relationship diagram sorted and ... A: This gets complicated if the time periods do not exactly correspond to each other. If all ... | |
| ODBC--call failed. | 3/9/2010 |
| Q: I keep getting this error when I try to open a form. It says, "[Microsoft][ODBC SQL Server ... A: brackets are commonly used in field names to distinguish a control. If the name is all ... | |
| ODBC--call failed. | 3/9/2010 |
| Q: I keep getting this error when I try to open a form. It says, "[Microsoft][ODBC SQL Server ... A: It could be the after change event. It is common to refer to other columns of data shown in a ... | |
| List the latest data available | 3/8/2010 |
| Q: I have several queries listing in a column (e.g. column FY2010) the item price available for a ... A: This will be quite difficult to do. Suggest instead you revise your process of having multiple ... | |
| Tables and Forms | 3/5/2010 |
| Q: I just want to know whether is it possible to add fields from four different Tables to a Form? Once ... A: Relate tables ------------- when you create a query, you can specify to use multiple tables and ... | |
| confirm | 3/3/2010 |
| Q: Hey im running a macro and ive turned the warnings off on the delete and append querys. However, i ... A: http://www.fontstuff.com/ebooks/free/fsMessageBoxes.pdf ... | |
| Replication | 3/1/2010 |
| Q: I have used 2003 replication but I am now using 2007 is there a replication in this version. I like ... A: As I recall, Access no longer supports replication. Yes you can still use replication in an Access ... | |
| How to create a field that records the "Date" for the updates made on any of the fileds in the current table ? | 3/1/2010 |
| Q: I want a create a AutoupdateFiled which records the "Date" for the fields in a Table which has been ... A: Best way to capture the date of update is to automatically enter it in the fields when saving the ... | |
| Access Form problem | 2/26/2010 |
| Q: I have a dbase that I carry over year to year by making a copy and then deleting the records..I then ... A: YOu need to make sure that no other user is using the database. Before you open it, make sure there ... | |
| Auto Fill | 2/24/2010 |
| Q: Well then.... I've been working in databases for 10 years, I've just never had the need to build a ... A: I am sorry you did not find my unwillingness to provide the extent of help you requested as ... | |
| Linking Tables | 2/5/2010 |
| Q: I am trying to create a database with one master table and several sub tables that all find the ... A: Yes you can do this. The expenditure table must have a field, call it CustomerNumber that is the ... | |
| Query parameters | 2/2/2010 |
| Q: Bob, Using Access 2003. What to write a query with use input for date range. However, is it ... A: I tend to put the date range on a form from which the user will run the report via a button. The ... | |
| how to create a lookup on access 2007 | 1/30/2010 |
| Q: I would like to ask a question.How can I create a lookup table on a form on access 2007 that will ... A: I typically use a multi column combo box and let the user select the stock item from this. Then ... | |
| Event Management Database | 1/29/2010 |
| Q: I have downloaded the Event Management Database (2003) from Microsoft's website. I am opening it in ... A: I could not retrieve your attachment. Please send it to me directly at bobalston9 AT yahoo ... | |
| Event Management Database | 1/29/2010 |
| Q: I have downloaded the Event Management Database (2003) from Microsoft's website. I am opening it in ... A: Can you enter any data into the new database? If not, then mayb e the location where you have the ... | |
| How to hide empty fields? | 1/28/2010 |
| Q: There are some empty Fields in my MS Access program's Report. So it's very ugly to print the Report ... A: The link I gave you includes the following: How to get labels in an Access report to ‘shrink’ when ... | |
| How to hide empty fields? | 1/28/2010 |
| Q: There are some empty Fields in my MS Access program's Report. So it's very ugly to print the Report ... A: In the report detail section, or whatever other section the fields are in, set the property "Can ... | |
| OLE problem Access 2000 windows xp | 1/25/2010 |
| Q: I just reinstalled Access 2000 and it wont accept Jpeg pictures. My database includes many pictures. ... A: The only idea I can give is to search the message you get via google and see what you come up with. ... | |
| OLE problem Access 2000 windows xp | 1/25/2010 |
| Q: I just reinstalled Access 2000 and it wont accept Jpeg pictures. My database includes many pictures. ... A: You got to give me more specifics other than "it wont accept Jpeg pictures". Error messages? ... | |
| multiple query selections from a form text box | 1/19/2010 |
| Q: I have built a form with a text box for criteria from one field. I have added a command button ... A: The method I mentioned works well when there are a single value in each field. since you have ... | |
| Access 2007 commands | 1/14/2010 |
| Q: I have a form that I want to add a command button to, this command button would open up another ... A: Add a command button using the wizard. Set it to open the form with all records. Then open up the ... | |
| Linking fields | 1/11/2010 |
| Q: I have 2 fields on a form, one named Store Manager and the other Personnel Interviewed. I would like ... A: check carefully, my yes/no fields - displayed as checkboxes - do have the capability of an after ... | |
| MS ACCESS 2002 "Write Conflict" on form | 1/5/2010 |
| Q: I googled this question, but found nothing that helped. I have build a form that uses to option ... A: Try to see if you get the error without displaying the report. Is the form bound to any data ... | |
| Personnel Reports | 12/23/2009 |
| Q: I am working on crafting personnel time reports that sum total time commitments by week AND by ... A: YOu need to have the query containing a field which is unique to each person (person number, ... | |
| relationships | 12/12/2009 |
| Q: After 30 years of marriage I thought I understood relationships, them I met Access. I have 3 ... A: YOu can't. What you are asking is how to combine all of this into a single record e.g. single ... | |
| Form Search Button | 12/11/2009 |
| Q: First of all I'm totally new to MS Access, am learning as I go... I have designed a single form ... A: Here is an example of my own code, with the code shown being generated by Access button wizard ... | |
| Unbound Forms | 12/5/2009 |
| Q: I just started using MS Access 2007 and am having problems with the forms. While I was using Access ... A: It seems to me that if it worked once for ethnicity then you must have a syntax error in the Search ... | |
| Access start-up misdirection | 12/5/2009 |
| Q: (Access 2002 on Windows XP. Someone else designed it; I inherited it. It's not a complicated ... A: Often this happens because of a field name change and a query that uses the old name. YOu need to ... | |
| Unbound Forms | 12/4/2009 |
| Q: I just started using MS Access 2007 and am having problems with the forms. While I was using Access ... A: I have an app that I run in both Access 2003 and Access 2007 and it has multiple combo boxes that ... | |
| After entering date, update another field to the end of the month entered | 4/20/2009 |
| Q: I need information automatically entered in another field after entering a date in a field. ... A: YOu have to do a bit of VBA code. YOu haven't given me enough to go on, unless it is whatever date ... | |
| access VBquery | 4/13/2009 |
| Q: Hai- I would like to write an append query and insert into VBE code in access.I also would like put ... A: When you need help writing a query, I suggest you use the built in query wizard to help you write ... | |
| using forms to edit table | 4/13/2009 |
| Q: I've just transferred our inventory sheet into access. Each type of item has a barcode and its stock ... A: You need to get a good intro book on Access or do some online tutorials. for a book, I suggest you ... | |
| After Update question | 4/9/2009 |
| Q: I would like to enter a date in one field, and after entering that date, I need another field, which ... A: YOu need to code some VBA code. with the form in design mode, right click on the "one field" and ... | |
| Access 2003, calculating dates | 4/7/2009 |
| Q: I have a database and I need the following to calculate based off a date field. My problem is that ... A: Why not calculate workdate1 = date + 7 months. Then calculate workdate2 = Year(workdate1) ... | |
| Access Query | 3/31/2009 |
| Q: I want to develop an simple application which will have a form with some buttons to retrieve and ... A: It is generally recommended that you create a FE separate from the BE. Access develops FE quickly ... | |
| Access Query | 3/27/2009 |
| Q: I want to develop an simple application which will have a form with some buttons to retrieve and ... A: 1) Yes you can use MS Access as the front end. Access cannot be an exe. 2) yes 3) Access cannot ... | |
| Access Formula | 3/24/2009 |
| Q: How can I tell access to pull a range between -5 days and 5 days past due? A: Typically this is done in a query. first you have to find the due date. Then you calculate the ... | |
| Filtering a table using comboboxes on the form | 3/10/2009 |
| Q: I am new to MS Access programming.I'm trying to apply a form filter using a combo box to my "Carrier ... A: To use a combo box, you need to capture the key field from the combo box. You can do that via ... | |
| entering data | 3/9/2009 |
| Q: I have different tables set up with employee info. Is there a way I can enter the emplyees first and ... A: YOu really are going to have to read quite a bit about access to do what you want. The primary key ... | |
| entering data | 3/9/2009 |
| Q: I have different tables set up with employee info. Is there a way I can enter the emplyees first and ... A: Yes you can. You create a table with the employee names and a key to that table. Then your other ... | |
| Table Structure | 3/7/2009 |
| Q: I'm doing a database for our church. I originally set up a Family table with FamilyLastName, ... A: It really depends on the structure you want. In a similar database, I set up a record for "head of ... | |
| Extension Change | 3/3/2009 |
| Q: Sir, I need to change the extension of mdb file at the close of Application. P.help A: Don't have any idea why you want to do this, as changing it to anything other than mdb or mde will ... | |
| A function to find maximum value of a field | 2/27/2009 |
| Q: Respected Sir, I've used the following query, in order to find maximum value of "salary" field; out ... A: Why not make it a totals query (View, totals) and then select Max for salary. If you want the max ... | |
| Overwriting Databases | 2/20/2009 |
| Q: I work with personnel databases. I get spreadsheet updates that I import into Access. This creates ... A: YOu can't really do this with a simple import. However what you can do is import the data and then ... | |
| Replication/Synchronization over Serial port | 2/19/2009 |
| Q: I have the following scenario: - Machine A has a MS-Access database being updated all the time - ... A: The only way to sync two access databases that I know of is to use Access replication. This is ... | |
| Query Expression in MS Access | 2/18/2009 |
| Q: I wrote a Query in Access to Count the Quantity of Units sold by Month. The expression is: January: ... A: Why not set two fields in the query - one with the year and one with the month. Then make this a ... | |
| MS Access | 2/18/2009 |
| Q: I have a couple of questions related to access. I am making a table which automates the reporting of ... A: On the form where the values are typed in, you can have an after update action that runs VBA code ... | |
| Message box and opening a file in a query | 2/17/2009 |
| Q: I am designing a database for my work place. what I would like to do is to run a query that will ... A: Yes but such would require an experienced Access developer to build it. In essence, you would write ... | |
| Message box and opening a file in a query | 2/16/2009 |
| Q: I am designing a database for my work place. what I would like to do is to run a query that will ... A: I am sorry but I can't really answer your question. You can run a query and use selection criteria ... | |
| Collecting Data through e-mail using MS Access | 2/16/2009 |
| Q: I would like to conduct a survey of my customers. In my survey I want to a series of questions ... A: Yes, Access can have check boxes on forms and reports. You just need to create a boolean field and ... | |
| How to open a word document in Access | 2/12/2009 |
| Q: I have a database that we use to track processes (ex. how to build a motor). Often times there are ... A: I don't use switchboards so I can't tell you for sure. What I generally do is use the wizard to ... | |
| How to open a word document in Access | 2/12/2009 |
| Q: I have a database that we use to track processes (ex. how to build a motor). Often times there are ... A: This is code from one of my apps Private Sub Command33_Click() Dim LWordDoc As String Dim oApp ... | |
| Multiple combobox entries | 2/10/2009 |
| Q: My question is in regards to a combo box within the form. In my table there are six columns in which ... A: When you define a combo box, you can define multiple fields of data to be displayed on each row of ... | |
| Multiple combobox entries | 2/9/2009 |
| Q: My question is in regards to a combo box within the form. In my table there are six columns in which ... A: I am sorry if I was confusing. I guess I really don't understand how you are trying to use the ... | |
| Multiple combobox entries | 2/9/2009 |
| Q: My question is in regards to a combo box within the form. In my table there are six columns in which ... A: I think you want to set up your combo box as unbound and then use VBA code to handle moving the ... | |
| Query | 2/8/2009 |
| Q: I need some help for a specific query. I have a table with 3 fields ( category , Date , Ticket#). ... A: If using the query design wizard, click on View then select totals. BElow on the grid, in the new ... | |
| Programming in Access for rowcount | 2/6/2009 |
| Q: How do I right properly code in access 2000: I need to: select * from table1. If rowcount >1 then ... A: I think you need a good book on Access. I suggest you go to your library or to a local bookstore. ... | |
| Access printout format | 1/28/2009 |
| Q: Where in Access would I create how the report should look like? A: Move to the Reports type of objects and select NEW. YOu clearly need a good book on Access and/or ... | |
| insert query | 1/27/2009 |
| Q: i created a button woth no help of a wizard. it worked out well until the save part, it doesn't save ... A: So that means there is an error in your sql statement. I am no expert. What I tend to do is create ... | |
| ACCESS HELP | 1/22/2009 |
| Q: I am asked to create a data entry screen, Here is the requirement which i have with me Create the ... A: You are asking me to tell you step by step how to build something fairly basic in Access. I think ... | |
| MS ACCESS 2000 | 1/14/2009 |
| Q: I have created a database in Access 2000, I want the database on closing down to 'save' the last ... A: It is standard practice for Access to automatically save anything you have entered, provided there ... | |
| Prevent users from viewing tables and queries | 1/9/2009 |
| Q: I am working an MS Access 2007 accounting platform. How do I keep users from accessing the ... A: I don't think so other than to prevent the user's ability to get access to the MDB file in native ... | |
| Prevent users from viewing tables and queries | 1/8/2009 |
| Q: I am working an MS Access 2007 accounting platform. How do I keep users from accessing the ... A: I just answered something very similar for one of my clients: 1) Put the database data in a ... | |
| Exporting from an Access Form to a Table | 1/5/2009 |
| Q: I have created a stock system and so far its going really well! :) I have 1 or 2 questions that i ... A: Normally you create a form or a subform that is bound to, that is has as its record source, the ... | |
| Dividing an Access Table | 12/21/2008 |
| Q: I have an 2007 Access Table with 880,000 records that I am trying to bring into a MySQL table. My ... A: What I have done in a similar situation is to select part of the records using a select query and ... | |
| Access Querry | 12/17/2008 |
| Q: I have been reading some of your answers and I have a question I am hoping you can help me with. I ... A: You need to use the like comparator to compare the two fields. Here is an example I did. The two ... | |
| appendquery | 12/4/2008 |
| Q: I've got a single form wich is bound to query to populate it's fields. when the user makes changes ... A: A form with fields and a record source of a table or query will always update the record ... | |
| Access 2003 | 12/2/2008 |
| Q: It's simple. How do I take control and store it in a global variable and then use this global ... A: 1) Create or open a module and define the global variable as the first line of the module Global ... | |
| repication and splitt DB | 11/29/2008 |
| Q: i am completelty confused here ,please help .. i have created and splitteda DB. Now i am trying to ... A: Just send them the front ends as usual. If they are on a LAN you might want to develop a BAT file ... | |
| SubReport | 11/20/2008 |
| Q: I have made a report with a sub-report on it. Well for some reason it is showing the sub reports ... A: When you insert a subreport into a report, the wizard adds the label for the subreport by default. ... | |
| Sum costing | 11/19/2008 |
| Q: ! Thank you for checking my question I am appriciated your time. RecipeID IngredientID ... A: Use a totals query. Create a normal selection query. List receipeID and cost Change the type to a ... | |
| VBA Shell function | 11/18/2008 |
| Q: I use the shell function to launch ms office programs and open the user selected file. I have my ... A: Very difficult to debug code by only looking at it. Initially I do not see where OPpath and CPPath ... | |
| Can you set passwords to different forms in a database | 11/17/2008 |
| 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 ... | |
| Lookup list dependent on other data | 11/12/2008 |
| 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 ... | |
| Speeding up search access 2000 | 11/11/2008 |
| 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 ... | |
| update different records with a batch script? | 11/10/2008 |
| Q: In Oracle I could write a script in toad like 'UPDATE my_table, set field_1 = "a" where field_2= ... A: Never used toad. Yes you can do this fairly easily in Access. You can create an SWL query in ... | |
| MS Access 2003 query | 11/6/2008 |
| Q: Bob, I was hoping you could give me some insight on a query I need to make in Microsoft Access ... A: Yes that complicates things a bit. That is why I pointed that out. What you need to do is convert ... | |
| MS Access 2003 query | 11/6/2008 |
| Q: Bob, I was hoping you could give me some insight on a query I need to make in Microsoft Access ... A: First off, check to make sure that in the design of your table, the date field in question is ... | |
| MS Access Programming | 11/5/2008 |
| Q: I am new to MS Access programming. I am creating a form with four criteria combo boxes so basically ... A: What I typically do is to add a button on the form labeled "Run" that they must click after they ... | |
| Delete a part of a table | 11/5/2008 |
| Q: Please help me with an info. I use Access for several years but I don't know how to delete a part of ... A: It depends. If you want to remove the end date permanently and never use it again, you can go into ... | |
| Making a Calculation in a Query | 11/4/2008 |
| Q: I just realized that a Table does not store calculated values (from my form). How do I then make a ... A: You can easily add calculated fields in a query. Just define a new column in the query ... | |
| subform | 11/3/2008 |
| Q: I've got a form with three subforms, where each subform recordsource is set to a query(three ... A: Since I don't have your database I cannot tell you WHAT exactly the code is. But I can tell you ... | |
| creating a formula to calculate time units | 11/2/2008 |
| Q: Could you help me create a formula that calculates a number units from the following rules, for the ... A: You need to open up a module, create a new one if you need to, and cut and paste the function into ... | |
| creating a formula to calculate time units | 11/1/2008 |
| Q: Could you help me create a formula that calculates a number units from the following rules, for the ... A: I will leave it to you to calculate the difference in minutes using Datediff function. Google it ... | |
| Single Records | 10/29/2008 |
| Q: New Access User here - so I apologize for any absurd questions in advance. I've heard this is a ... A: To select one record, in the query designer window, enter into the selection criteria for the field ... | |
| Single Records | 10/29/2008 |
| Q: New Access User here - so I apologize for any absurd questions in advance. I've heard this is a ... A: Yes a report can include only a single record. Base the report on a query that uses the record key ... | |
| Covert multiple columns from rows | 10/23/2008 |
| Q: I have some data, like the following (and its the only way I can get it) and every row holds unique ... A: I masy be able to help. IF the detail data is the same things, applied to all the parts, then you ... | |
| Seperate the data and program | 10/23/2008 |
| Q: I made a program on ms access for followup 6 peoples are using it through network, WHEN I need to ... A: You are right - having the DATA in one MDB and having the queries, forms, reports, macros and ... | |
| Information | 10/22/2008 |
| Q: I have a form that has a field I just added, called "Fiscal Year." Since I just added it, a lot of ... A: I'll try. Put this as one column in your query: Fiscalyear: FnGetFiscalYear(datefield) Put the ... | |
| Information | 10/22/2008 |
| Q: I have a form that has a field I just added, called "Fiscal Year." Since I just added it, a lot of ... A: Why not calculate the fiscal year value in the query and then you have it for all records. YOu can ... | |
| query | 10/21/2008 |
| Q: I am looking to write a vba macro in excel to update a database in access. THe condition is I Have a ... A: Use the query builder wizard and build a normal select query on the table of interest. Add the ... | |
| Design master restructuration | 10/20/2008 |
| Q: i am working on an existing Replicas and design master. I need to do some changes on the data base ... A: Firct sync the replicas with each other. Next sync the design master with the primary replica. ... | |
| Access 2007 | 10/17/2008 |
| Q: I have a form with one of the fields as 'Reason'. I want to create a drop down for it with the ... A: YOu need to get a good Access book from the library or bookstore. Read about "list boxes" and ... | |
Using MS Access
Answers by Expert:
Bob Alston
Top Expert on this page
Expertise
I can answer general Access questions and also specific ones about Replication. I am not a good person to ask Access 2007 specific questions. For free online Access tutorials, look here: http://webpages.charter.net/bobalston/AccessDB.htm#Free_Access_Online_Tutorials
Experience
Have worked with Access for over 10 years. Built one application for nonprofits that is used in over 235 nonprofits in the USA and Canada.
Built an application using replication involving 25-30 laptops and three servers in three business sites each having three replicated master copies of the database.
Publications
www.techsoup.com - community - software forum
Education/Credentials
B.A. Mathematics; MBA
Awards and Honors
Phi Beta Kappa
©2012 About.com, a part of The New York Times Company. All rights reserved.