| Subject | Date Asked |
|
| 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 ...
|
