| Subject | Date Asked |
|
| MS Access 2000-adding a new field to a form | 11/21/2009 |
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 ...
|
| Coding in VBA | 11/19/2009 |
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 ...
|
| Mail merge Access 2007 | 11/16/2009 |
Q: I am trying to mail merge in Access 2007 from a query. A few of the fields are look ups. When I run ...
A: Mandy, In your query, add the tables that contain the lookup text and join on the IDs. This way the ...
|
| Help | 11/2/2009 |
Q: When I try to run my code in the code window by pressing Run commad or F5, it opens the Macros ...
A: Code needs to be run by an event related to a form, or form control, or custom function you have ...
|
| form fields | 11/2/2009 |
Q: I am working in Access 2003. The form that i am working on i have to add new information into these ...
A: The "#Name?" indicates that the form control needs the control source property to be set by you, ...
|
| Paint Event procedure in Access 2007 | 10/30/2009 |
Q: I had an old module that I used, which required the "On Print" event, but I cannot find it in ...
A: Julia, The Paint Event occurs when the section is redrawn (On the screen - not in printing). It is ...
|
| Expression Building in Access 2007 | 10/28/2009 |
Q: I am trying to figure out how I can create an expression that gives 4 options in the same field ...
A: Marilyn, You can nest an IIF inside another IIF: IIf([Total ORM] Between 0 And 20,"Low", IIf([Total ...
|
| Save value unbound textbox | 10/28/2009 |
Q: I have a question concerning an unbound textbox. The controlsource of the textbox is the following: ...
A: Sophie, On the AfterUpdate event of the combobox called "Categorypub", place this line of code: ...
|
| calculations | 10/22/2009 |
Q: Can you add two calculated fields from two different queries together in a third query? I have two ...
A: Patrick, Just be sure you have a common field, that you are grouping on, in all queries so you can ...
|
| Open Connections MS access DBServer | 10/19/2009 |
Q: Bob, I provide a lot of code here just so you'll know the context of the question. I use a couple ...
A: ODBC connedtions as well as recordsets that are open can be snapshot or dynaset or other types of ...
|
| Linking Access to Excel | 10/16/2009 |
Q: I created databases to manage a training program that tracks enrollement, classes, courses etc... ...
A: Dawn, Yes Excel has a menu item for data that allows the creation of a query that has Access as it's ...
|
| What to use in recognizing code has been moved to Next Line | 10/15/2009 |
Q: I have this SQL Code I am using in Access 2007. I want to know what to write to let the system know ...
A: Japhet, You could declare a string variable: Dim strSQL as string Then build it like this: strSQL = ...
|
| Maximum Number of Users | 10/15/2009 |
Q: I have a shared Access application where all users should log in & then they have to use the same ...
A: This version requires more RAM memory. I would first look into increasing this resource. Bob ...
|
| Database with multiple lines of up-datable information per record | 10/14/2009 |
Q: I have built basic databases I know the basics but no programming or anything like that. I am using ...
A: Kimmy, You will need a company table and a check table. A field in the company table will be an ...
|
| Access 2007 Append Query generates unexpected error | 10/14/2009 |
Q: I am appending tables within a database. Each table has the same field names and data types. I have ...
A: Thomas, Attribute Maximum Access database (.accdb) file size 2 gigabytes, ...
|
| Pie Chart Design | 10/13/2009 |
Q: I am trying to put a pie chart in a "team report." The chart shows open issues for each team. I ...
A: Anthony, The solution involves making a derived column that uses a custom function or nested IIF() ...
|
| Report | 10/13/2009 |
Q: I have an Access database front end to a SQL database. I have a set of queries that I run each ...
A: Melissa, Just set the recordsource property of the form or report to the desired query. Bob Heifler ...
|
| Copying information into a new field | 10/12/2009 |
Q: I have a database with 1000 entries, with the following fields - CatNo, Name1, Name2, Sex1, Sex2, ...
A: Suketu, You could copy the design only of the table then append to it with two append queries that ...
|
| ms office 2007 suite | 10/10/2009 |
Q: The work I'm applying for requires me knowing MS office 2007 Suite. I assume that means excell, ...
A: Al, Professional version has Access database. There are good beginning books by Microsoft Press, ...
|
| Access 2007 | 10/7/2009 |
Q: How can I use a calculated control to update a field in Access 2007?
A: John, You can write a line of code in the after update event of one or more controls. Let's say a ...
|
| Saving Autopopulated date | 10/6/2009 |
Q: I have 4 autopopulated dates which i need to save into my table. Because i inserted this code ...
A: Jishar, Your form controls need to be bound to fields in the table that is being used for the form's ...
|
| Sum function error | 10/3/2009 |
Q: I am trying to total a field in a report. the rpoert is a list of people who are ordering a tshirt ...
A: Adrienne, Let's say the number field (control on report) is called [SmallsOrdered] . In the report ...
|
| Access 2007 DB size | 9/23/2009 |
Q: Bob, What is the max size that M/S Access 2007 can be. I know 2003 is about 2 mb
A: Richard, 2 gigabytes, minus the space needed for system objects You can work around this limitation ...
|
| Resetting Checkboxes(in tables) to false | 9/8/2009 |
Q: I have two subforms(both in datasheet view) on a Mainform. By selecting a checkbox, on subform1, I ...
A: Kappucino, The value of a check checkbox is -1 and unchecked is zero If the name of the checkbox was ...
|
| Formula Crisis! | 9/5/2009 |
Q: I'm trying to write a formula/query on how to calculate 'total outage time' of our airport ...
A: Annie, There is an Access function called DateDiff() If you go into any code area and type that, ...
|
| Value increment | 9/3/2009 |
Q: Is it possible to have a value increase by 1 in a table each time a certain button is pushed? So, ...
A: Shawn, Have a little form that is bound to the table containing the field up want updated. Let's say ...
|
| Hiperlink to an AVI FILE | 9/2/2009 |
Q: I have a hiperlink leading to a file with the extension "avi". The program automaticaly opens ...
A: Tiago, The program will always open using the default software for that file extension. You need to ...
|
| Data type | 8/31/2009 |
Q: mm:ss:hh minutes:seconds:hundreths for the data type
A: John, The Format()function can take a date/time data type of storage and present it with all but ...
|
| databases | 8/31/2009 |
Q: first, thank you for your time. myi have a group of clients that i need to keep a log for of ...
A: Ralph, Access would be great for this. Just two tables needed, Cients and TelephoneLog Contact me ...
|
| Design issue | 8/28/2009 |
Q: I have a design question. My database has sql backend and access front end. I have multiple users ...
A: Irina, Remember DOS commands? Write a batch file to download the latest Access MDE and run it. The ...
|
| Access Pivot Tables | 8/18/2009 |
Q: I've built a pivot form, but it truncates the decimals even though it is formated to standard. This ...
A: Bill, Be sure that the table field is storing more decimals than you might need. Do not use any ...
|
| How to select Random Records | 8/17/2009 |
Q: I am trying to select random records from a table. I am using Random: ...
A: Sara, Here is some vba code to help: You will need to place to public variables in a module: Public ...
|
| Ms access projects | 8/17/2009 |
Q: sir, Iam happy to see your helping hand reg.Ms Access project designers. Iam designing a ...
A: Manjula, The fastest way is to backup the files first. Then either delete data in tables or just ...
|
| If then | 8/13/2009 |
Q: I´m currently setting up a budget-database, and I would like to know whether the following is ...
A: Sophie, On the Paid check box after update event you would place code to change 'Still to Charge' ...
|
| How to calculate weekdays? | 8/10/2009 |
Q: How can I calculate weekdays in a query? I am using this rite now: Days Open: ...
A: Sara, Weekday([YourDate]) will give you 1 for Sunday, 2 for Monday etc. In your query create a ...
|
| addition in a database | 8/10/2009 |
Q: I have a database that I made for keeping track of expenses for a property i manage. I want to add a ...
A: James, An aggregate query using sum on the field or a DSum() function will do it, if it's an integer ...
|
| change data type | 8/8/2009 |
Q: How can i change data type of csv file from text to date/time in access 2007 database?
A: When you import or link to CSV data use the 'Advanced' button on the import wizard to create an ...
|
| How to use two queries to create a form? | 8/6/2009 |
Q: I am trying to retrieve data from two queries to make a form but when i do that I get this error msg ...
A: Sara, You need to supply only one query or table for the form's record source. If there are two, ...
|
| Linking an excel file to access with a field greater than 255 characters | 8/4/2009 |
Q: I need to link an excel file to access but it has a remark column that has comments longer than 255. ...
A: Nita, Save the Excel as CSV file and use link text wizzard which has an 'Advanced' button that ...
|
| Data not saving correctly | 8/3/2009 |
Q: I've created a database that up until now has been working very well, however, recently random ...
A: Iris, First verify the the data entry form controls have the correct data table field names for ...
|
| Passing a Global variable value to a query | 7/30/2009 |
Q: I already have my Global variable now I need to use it as criteria for my query. I do not know how ...
A: Sam, You need to first pass some value to your global/public variable. This is how you would pass a ...
|
| connect Sql Server through coding | 7/29/2009 |
Q: I want to connect sql server 2000 to access data from MS Access Project WITHOUT Wizard ...
A: Kundan, Here is your code: DoCmd.TransferDatabase acLink, "ODBC Database", ...
|
| query to display missing data | 7/29/2009 |
Q: good day! i have a table containing data of employers remitting their insurance premium monthly. ...
A: Sherwin, If you create a table "Year_Month" table of year and month numbers to cover the dates ...
|
| Message Box | 7/24/2009 |
Q: I am developing a software in Access I prefe to use inbuilt commands available in Access. Can we ...
A: Maybe use timer to change the shade of color or backcolor of text or simple show message for 3 ...
|
| Message Box | 7/23/2009 |
Q: I am developing a software in Access I prefe to use inbuilt commands available in Access. Can we ...
A: UPENDRA, For this need, I usually place a label with transparent back style and borders then use ...
|
| Subform | 7/23/2009 |
Q: When I open a form that contains a subform with mulitple records, how do I get the subform to open ...
A: Julie, A button with DoCmd.GoToRecord , , acNewRec on the OnClick event will do it if placed on your ...
|
| Formatting | 7/9/2009 |
Q: I am trying to get a field to read top to bottom instead of left to right as to create a list to ...
A: Michelle, Access version 2000 and later has as a report control property on the 'Other' tab in the ...
|
| Min Price as a Comparison / SQL | 7/8/2009 |
Q: I am working on an access database system to store product/price information and wanted to write a ...
A: Andrew, Yes a group by on product ID and use the visual query grid. Once you do that you can just ...
|
| Calculate Time Diff in Access | 7/3/2009 |
Q: I am trying to calculate the time difference in Access when the time occurred in the same day, I ...
A: Rachel, Use the DateDiff() function. Use "n" for the minutes argument. If result over 60 minutes you ...
|
| Multiple Subforms, Subforms | 7/1/2009 |
Q: Two questions: I would like my subform to look like an actual form, is this possible? It always ...
A: Ryan, You can change the default view of the Sub Form to 'Single View'. You might also want to ...
|
| Appending data at the end of each month | 6/29/2009 |
Q: Bob, I need to create a trending report that gives a bar graph of all project's status at the end ...
A: Adam, Create a table to store the last date the append query ran. Use a macro you create and name ...
|
| checkbox | 6/26/2009 |
Q: I have designed a form, and it has a CHECK BOX on it, but what i need is, if a data entry check on ...
A: Nay, If your check box is a form control that is bound to a Yes/No data type field, then it can not ...
|
| searchable database? | 6/24/2009 |
Q: I have a table with a lot of data about documents, and i have a form to enter data into the table, ...
A: Sure, Just place the name of your query in the form or report's record source property. If using a ...
|
| searchable database? | 6/24/2009 |
Q: I have a table with a lot of data about documents, and i have a form to enter data into the table, ...
A: Jeanette, Use this in your query criteria: Like "*" & [Enter search word(s)] & "*" Bob Heifler ...
|
| Auto-populate end of month | 6/23/2009 |
Q: Bob, When a user enters the form, I need the date to autopopulate to the end of the current month. ...
A: Adam, The best place to populate your date field is in the On Current Event of the form or as the ...
|
| Access Importing Excel Data | 6/21/2009 |
Q: key violation etc. Cheers Peter
A: Peter, If a field in an Access data table has a data type or size that is preventing data entry to ...
|
| Counting Based on Price Criteria | 6/18/2009 |
Q: I'm new to Access and learning the ropes slowly. I have a database of sales from a bunch of ...
A: Yes Frankie, Create a column in the query for each sold price tier. The first might look like this. ...
|
| Command button to copy text | 6/17/2009 |
Q: I was wondering how I can create a command button that will duplicate text from one textbox on a ...
A: Robert, Place this event code on the OnClick event of your command button to copy the text from ...
|
| Pivot tables or crosstabular queries | 6/17/2009 |
Q: I want to display (for comparison purposes) the # of students registered, the average grade and the ...
A: Cheryl, A cross tab query might do it but it will take several sub queries to get all your columns. ...
|
| Access 2007 IIf Function | 6/15/2009 |
Q: Please review the following IIf statement. I'm not getting the correct results for an employee ...
A: Judy, Shouldn't [GROUP_CODE]=118 be [GROUP_CODE]= 18 Bob Heifler MyAccessProgram.com ...
|
| IIF Statement - Access | 6/12/2009 |
Q: Good Morning, I am in HR and looking to build a report that generates anniversary reminders and ...
A: Melissa, You may place an unbound text box(not bound to your report query or table)on your report ...
|
| IIF Statement - Access | 6/12/2009 |
Q: Good Morning, I am in HR and looking to build a report that generates anniversary reminders and ...
A: Melissa, Place this at the top of a query column to make a derived column: ProbationDateReminder: ...
|
| Access Report - Col datatype conversion | 6/11/2009 |
Q: I want to change the datatype from number to text for one of the field displayed in the detail ...
A: I would have to see the file to debug this for you. Bob Heifler MyAccessProgram.com Find example ...
|
| Access Report - Col datatype conversion | 6/11/2009 |
Q: I want to change the datatype from number to text for one of the field displayed in the detail ...
A: Archana, You did not let me know what the error message said, but it was probably a null or empty ...
|
| runtime for Mac? | 6/10/2009 |
Q: My office assistant uses a Mac and I want her be able to edit my Access data on her system at home. ...
A: Dan, I had a client use a Mac (not sure of the software he used)that did a fair job but most mouse ...
|
| IF Statement for Access | 6/9/2009 |
Q: I need an IF statement for a MS Access report. I want to write an if statement that says IF a ...
A: In the report query, create a derived column: ...
|
| Multiple Records inserts | 6/8/2009 |
Q: I have two tables Table1(TripEventTypes) TripEventyTypeID EventTypeID ...
A: John, This is not a quick simple question, but I will get you going. Make a single form using the ...
|
| MS Access date in text format | 6/5/2009 |
Q: in my table i am storing date in text field because of format; i use dd/MM/yyyy format which is not ...
A: Anand, You will need to convert the text to date data type using first in your query columns using ...
|
| MS Access Storing Calculated fields in Records | 6/5/2009 |
Q: I'm just learning about MS Access so my capabilities are thin on the ground, so I hope this is not ...
A: Stan, There are a few things that could cause a bound field not to be set. The first thing I would ...
|
| Microsoft Access 97 Report | 6/4/2009 |
Q: I have a Microsoft Access 97 database and I want to set the font color, and or back color, of a ...
A: David, Place this code on the OnCurrent event and any other control's AfterUpdate event that has ...
|
| MS Access Storing Calculated fields in Records | 6/3/2009 |
Q: I'm just learning about MS Access so my capabilities are thin on the ground, so I hope this is not ...
A: Stan, First, to save the calculation in a table, you need to add a field to the table and a control ...
|
| MS access Modelling | 6/2/2009 |
Q: I am trying to design a travel requests app in MS Access. The program should be able to take ...
A: John, I didn't see an attached file but you can always run some dummy data through it and then ...
|
| Counting Unique Records in Acces Reports | 6/2/2009 |
Q: I am working on an Access Report which I have grouped by a district. From those Districts I have ...
A: Chris, Make a query grouped by ticket number and district and use the count aggregate built into the ...
|
| Time calculations | 6/1/2009 |
Q: I would like to have Access calculate the difference in 2 time values so I can get a result that ...
A: Bryceson, Use the DateDiff() function (See Access help)and use the "n" argument in the function to ...
|
| MS access Modelling | 6/1/2009 |
Q: I am trying to design a travel requests app in MS Access. The program should be able to take ...
A: John, Good job. "Company" in details relates to supplier ID, I assume. Not sure of your ...
|
| RE; SPLIT DATA BASE MULTI-USERS UNABLE TO OPEN | 5/28/2009 |
Q: I built a database and then split it according to the Split Wizard. However, others users are not ...
A: Mel, This means that the machine having a copy of the program file (front end containing no data ...
|
| =SUM | 5/27/2009 |
Q: please could you help, in my Form i'm trying to get a Total SUM in a Text Box but I need help on the ...
A: Michael, Place a calculated unbound text box in your detail section with this: ...
|
| =SUM | 5/27/2009 |
Q: please could you help, in my Form i'm trying to get a Total SUM in a Text Box but I need help on the ...
A: Michael, You did not tell me what problem this formula is giving you. If you are getting a null ...
|
| reading dynamic data records with VB | 5/26/2009 |
Q: I am looking to produce an Excel report from an Access database table. The data contains numerous ...
A: Neil, You could reset the recordset for each grouping and even set an Excel row column A to the Site ...
|
| MS ACCESS: DATE/TIME DATA TYPE | 5/22/2009 |
Q: I am dhaval shah from toronto. I have excel file linked with Ms Access 2003 table. The date format ...
A: DHAVAL, The format() function can be placed in a query, form control, or report control to reformat ...
|
| MS ACCESS: DATE/TIME DATA TYPE | 5/21/2009 |
Q: I am dhaval shah from toronto. I have excel file linked with Ms Access 2003 table. The date format ...
A: Dhaval, Use the Format() function if you need text or the DatePart()function if you need the result ...
|
| Relating multiple items to eachother | 5/21/2009 |
Q: I work with computer hardware (servers, switches, etc) and I have an asset database to track them. ...
A: Donna, For those people reading this answer, let me first define two terms. The primary key of a ...
|
| MS Access DAvg | 5/13/2009 |
Q: I'm using the DAvg function to calculate a rolling average for a number. The number is tied to a ...
A: Jennifer, Place this code in the criteria of your date field (Data Type must be a date.): ...
|
| Automatically entering a time in a record | 5/13/2009 |
Q: I am trying to develop a time management system. Basically I need to know how to enter a time in a ...
A: James, Here are two different ways depending on the time format you desire: If ...
|
| Automating Access 2007 | 5/12/2009 |
Q: Is there a way to automate a macro that it will run once a week even if Access is not specifically ...
A: Tyson, A macro in Access file can not run without the Access file being open. However, you could ...
|
| Holding reports in Access | 5/11/2009 |
Q: I help a charity organisation with its IT. They have an Access 2003 database in which they hold ...
A: Chris, You can code the path to use the report name stored in your table: Declare a public variable ...
|
| Holding reports in Access | 5/11/2009 |
Q: I help a charity organisation with its IT. They have an Access 2003 database in which they hold ...
A: Chris, You create a table "Reports" perhaps. Place a field in it called "WordDocumentPath" perhaps. ...
|
| Holding reports in Access | 5/11/2009 |
Q: I help a charity organisation with its IT. They have an Access 2003 database in which they hold ...
A: Chris, Yes, just create a query which includes all the data you need and it's criteria to limit it. ...
|
| Access 2003 - hoining three tables in a hierarchial relationship | 5/7/2009 |
Q: I have three tables - Test Plan, Test Functions, Test Cases. The form I would like to develop would ...
A: Since the limit of nesting subforms in Access 2003 and earlier is two levels, you need to have a ...
|
| Copy first two letters of a field into another one | 5/7/2009 |
Q: Hope you can help. I have a field called city and another one called city_abbreviated. I wanted the ...
A: Tiago, Using an Update query, update your city_abbreviated field using this: Left([City],2) Bob ...
|
| Lookup field | 5/3/2009 |
Q: I''m brand new to MS Access. I'm using Access 2007 to create a database to track customers and ...
A: Liz, Use the IIF() function like this: SELECT Customers.Cust_ID, ...
|
| expression builder | 5/1/2009 |
Q: I have 4 different fields, named "Nombre de la escuela o empresa V" "carrera V" and "Semestre V", in ...
A: Gaby, You will want to use IIF function in your query. It works like this: IIf(test_expression, ...
|
| Filtering in a for | 4/30/2009 |
Q: Hy, Im gaby and relatively new to access databases I have a recent proyect and really need to know ...
A: Gaby, You will want to pass the txtSearch value to a public variable then retrieve the value in your ...
|
| refreshing forms and hiding labels | 4/28/2009 |
Q: Please let me know how I can refresh a form with VBA (if possible) and how I can hide a label if the ...
A: Ven, Refresh a form with this VBA code: me.recordsource = "Name of table or query" For hiding the ...
|
| Calculations with an IFF statement in ACCESS 2003 | 4/27/2009 |
Q: I am trying to cause a ACCESS 2003 Query to calculate a value based on an if statement. If the ...
A: Bruce, In the AfterUpdate event of all controls involved in either formula you will place code ...
|
| desktop shortcuts | 4/27/2009 |
Q: presently we have 10 msaccess applications placed in shared drive. users are using these using ...
A: Venkatesh, Right click on the shortcut and edit the target property under properties. Bob Heifler ...
|
| removing spaces in text value | 4/24/2009 |
Q: Would you please let me know how i can remove a space from a concatenated text field. the fields ...
A: Jambo, This example uses the Mid statement to replace a specified number of characters in a string ...
|
| Setting up automated email alerts if conditions are met | 4/24/2009 |
Q: At the moment im building a database for a flash card product for a university project, I have a ...
A: Daniel, Start with a query that has the name and email address of users under 10 pounds. The code on ...
|
| corrupt access database | 4/23/2009 |
Q: how are you. hope all is well. my database got corrupt somehow. when i attempt to launch the ...
A: Ven, Here are a few web pages to look at: http://support.microsoft.com/kb/123588 ...
|
| vba code | 4/22/2009 |
Q: I'm trying to update a txt box to zero if the user forgets to enter a value in the field. I thought ...
A: Ven, If isnull(me.Layer1AnnualPremium) then me.Layer1AnnualPremium = 0 else if ...
|
| Month | 4/22/2009 |
Q: i am asking a lot of questions recently. I am designing a payroll using Access 2007. Now i want to ...
A: Elie, Add a month table that stores how many days in each month. Then lookup the value when doing ...
|
| plz solve my problem | 4/21/2009 |
Q: i am working on a database these days, it has several table for several departments, and every table ...
A: Asif, You would want to open forms using a query for the record source. The query should have as ...
|
| Access and Scanner | 4/20/2009 |
Q: Can Access capture a photo off a scanner John Miller
A: John, Access can not take a feed directly from the scanner. After the scanner has created and save ...
|
| Edit a recordsource in Access | 4/20/2009 |
Q: I have a form in 2003 Access. I designed the form based on the wizrd and binded it to a table.I have ...
A: Anir, Go to the form and view it in design view. You need to open the properties window of the form ...
|
| Microsoft Access Date Field Population | 4/16/2009 |
Q: I am working with a data base which is used to gather data for reporting purposes. There are two ...
A: Wendy, In the design view of the form, highlight the "Visit Date" control. Then right mouse click ...
|
| Microsoft Access Date Field Population | 4/16/2009 |
Q: I am working with a data base which is used to gather data for reporting purposes. There are two ...
A: Wendy, Place this code in the AfterUpdate event of the Visit Date form control. This assumes that ...
|
| MS Access | 4/15/2009 |
Q: I created a database and I hid all my toolbars (for design, etc.) How can I get them back? I used ...
A: Annette, To display or hide toolbars use this code in the OnActivate Event of the form. ...
|
| How to Loop Through all values in a query using VB | 4/14/2009 |
Q: I am trying to get all values in a query which i generate as what I am trying to do is to check ...
A: Ashley, Here is a way to look at each value in the query. Here is some code to do it: Let's say ...
|
| passing an argument from private sub to private sub | 4/13/2009 |
Q: What is the best way for me to get the value of a variable from a subroutine into another subroutine ...
A: Perry, Create a new code module where you will declare your public variables and write a function ...
|
| calculate a value in an access 2003 table | 4/12/2009 |
Q: I have a database table that is used to store orders the tale is called "order_details_a" The table ...
A: Pierre, Place the following code in the after update events of list price and discount fields on ...
|
| MS Access 2007 Expression Builder | 4/10/2009 |
Q: Using =DateSerial(Year([EndTerm])[1st Option],Month([EndTerm]),Day([EndTerm])), 1st Option cell is ...
A: Randolph, Try using the NZ() function to convert the empty 1st Option cell to zero. Example: ...
|
| autonumber as foreign key | 4/9/2009 |
Q: Here's my problem, I have 5 tables in DB. One of them is a guest info table which uses an autonumber ...
A: Adam, The "other 4 tables" require that the "guestID" (foreign key) be numeric long integer but NOT ...
|
| Query | 4/8/2009 |
Q: I have a table imported from excel which has (among other data) over 50 store numbers, the ...
A: Gary, The 22,000 rows is no problem for Access. As for the query, I would need more information ...
|
| Insterting data from form into table | 4/4/2009 |
Q: I'm just starting with coding using VBA so what I learned is basically from examples. I would like ...
A: Author, The close form button could be used to validate to some degree the data and offer to save ...
|
| Insterting data from form into table | 4/4/2009 |
Q: I'm just starting with coding using VBA so what I learned is basically from examples. I would like ...
A: Arthur, Use bound controls in your form. If you fill in the forms's recordsource property with a ...
|
| Accees VBA module to Calculate Elapsed Time in Minutes Only | 4/2/2009 |
Q: I have two fields that are Date/Time fields (TIME IN AND TIME OUT). I want to Calculate the Elapsed ...
A: Greg, Change the: LMonths = DateDiff("m", LDate, pEnd) to Lminutes = DateDiff("n", LDate, pEnd) ...
|
| Access 2003 forms/subforms | 4/2/2009 |
Q: I have a simple form with a sub form. After completing the main form I want to force the user to ...
A: Chris, On the close button, check the subform record before allowing the close. I would open a ...
|
| How to add attachments in e-mails for Access to Send in VBA | 3/27/2009 |
Q: I have a button with the following code: strEmail = "" strSubject = "New Housing Request" ...
A: Stu, File attachements are not allowed with SendObject. It only allows sending the following: ...
|
| Using the DoCmd.OpenQuery and specify filter values of that query | 3/27/2009 |
Q: I am opening a query as below when clicking on a button using the DoCmd.OpenQuery command and ...
A: This is a common need, how to pass a value to a query criteria in order to filter the records ...
|
| Printing | 3/26/2009 |
Q: Is there a way I can print two or more pages of a report by just clicking a print button once? Many ...
A: Peter, On the click event of your print button just repeat the code you see there twice. Bob Heifler ...
|
| VBA / Access | 3/25/2009 |
Q: I have a table called New product with 2 fields. ID (Autoincrement pk) and Product Name. I created ...
A: Naz, The save command is docmd.runcommand acSaveRecord There are three types of form views, you did ...
|
| Linking subforms with parent whilst within a tabbed form! | 3/24/2009 |
Q: I have a Master form and on this sits a tabbed form. Within the tabs there are sub-forms and ...
A: Nicola, Yes, if you look at the design views of your tables, you will see one ore more KEYS next to ...
|
| MS Access Multiple Users | 3/23/2009 |
Q: I have a dozen or so access apps that run on each users' PC. These apps have one common link table. ...
A: Al, This is a tough one. First be sure edited record locking is on data and front end areas, forms ...
|
| Auto calculate | 3/21/2009 |
Q: The expert can't answer your question. Your Question was: I have a field labeled "previous ...
A: Randy, Place this code on the AfterUpdate Event of Previous Balance and Amt Received. [Balance] = ...
|
| Delete Queries | 3/20/2009 |
Q: Can i run a delete query without being asked to confirm the deletion. In other words i want to run a ...
A: Elie, Yes, if you are using code to run your query, just set warnings to false prior to running the ...
|
| data type conversion error... | 3/18/2009 |
Q: . coupon_bbtxt = Format(listbuyback.Column(5), "0.00000%") --> my textbox that get its' value from a ...
A: Mfuada, The Format() function returns a Variant (String). You did not mention the data type of the ...
|
| How to delete an old query without losing info | 3/17/2009 |
Q: Our database has gone through several hands which has resulted in many queries. I'd like to be able ...
A: Audrey, Your data is not stored in a query. A select query just shows what data is stored in a ...
|
| MS ACCESS 2003 | 3/16/2009 |
Q: I am trying to create a subform, that links into the main form. I want to make some choices in the ...
A: Annette, Go to the table design of the table that feeds your subform. If any field has a KEY next to ...
|
| Allowing Edits | 3/15/2009 |
Q: I have this form with all the information. I added a checkbox that is common throughout the form. i ...
A: Cory, Use the OnCurrent Event It triggers every time you land on a different record. Bob Heifler ...
|
| Exporting a Report/Checkboxes | 3/11/2009 |
Q: I have a report that contains checkboxes. I want to export this report to Word, and it is not ...
A: Tina, Place this at the top of a query column: MyCheckBox:iif([CheckboxField]=-1,"YES","NO") Bob ...
|
| Default Value | 3/10/2009 |
Q: I have a question. I have a form with an embedded subform. The form has a combo box with customer ...
A: Kami, This is Access 2002 help file reference: Note it does not require hyperlink paths to web. The ...
|
| Default Value | 3/10/2009 |
Q: I have a question. I have a form with an embedded subform. The form has a combo box with customer ...
A: Kami, Suggest you store the path to a new Word Doc for each record. Using FollowTo method on each ...
|
| query help | 3/8/2009 |
Q: I am having problems setting up this function for a date in access. The instructions state the ...
A: David, >Date() placed in criteria of your date field will only find dates greater than today Just ...
|
| Autofill data in a form based on selection made in Access 2007 | 2/27/2009 |
Q: I am working on a Access 2007 database where I have following tables(s) and a form. Table: ...
A: Sanjay, If you place the last end date in a column in the combo box, you can use the column property ...
|
| Tables Containing People & Orgs | 2/26/2009 |
Q: My db will contain both people and organization records. I have a People and an Organization table. ...
A: Jeremiah, Here is one way: Combine your people and org tables into a table called "Entity_Table" and ...
|
| VBA - Coding - Functions (2) | 2/26/2009 |
Q: I do not have the file with me nor do i have a working microsoft access programme in this computer. ...
A: Cory, Re: "Which event triggers the codes when the user clicks the arrow on the combo box" Just use ...
|
| VBA - Coding - Functions (2) | 2/25/2009 |
Q: I do not have the file with me nor do i have a working microsoft access programme in this computer. ...
A: Cory, First open next form: DoCmd.OpenForm "Name of form to open." Then close current form: ...
|
| Yes/No Selection and Values | 2/24/2009 |
Q: I have built a database that has check boxes for yes and no. I want to know if there is a way in ...
A: Tracey, Since the option control has your assigned value in the value property of the control, just ...
|
| Yes/No Selection and Values | 2/24/2009 |
Q: I have built a database that has check boxes for yes and no. I want to know if there is a way in ...
A: Tracey, When you write a query to view this data, place this at the top of one of the query columns. ...
|
| IIF function | 2/21/2009 |
Q: i'm working on a project for school and i'm having a little problem. the instructions says to create ...
A: Alicia, iif([waiver]=true and [academic]=true","Approved","Not Approved") There you go. Bob Heifler ...
|
| List of value updatable | 2/20/2009 |
Q: I am having a database to enter our requests. Some columns are linked to other tables so that the ...
A: Karima, I am doing a web cast Mar. 1st 2009 on this very area. You need to base your list on a ...
|
| function and table | 2/19/2009 |
Q: right now i have a table that has these fields: No;series;payment_date;price the problem is when a ...
A: You will need to trigger your update query by a button using the button's onClick event with this ...
|
| function and table | 2/19/2009 |
Q: right now i have a table that has these fields: No;series;payment_date;price the problem is when a ...
A: Create an update query. Be sure to change the date by placing # signs in front and back to the date ...
|
| Query Expression in MS Access | 2/18/2009 |
Q: Question I wrote a Query in Access to Count the Quantity of Units sold by Month. The expression ...
A: Dennis, This takes a custom function that requires more than a quick answer here. You would have to ...
|
| Querying Dates using Access | 2/16/2009 |
Q: I have two tables one name Booking with Firstname, lastname sex address Booking Date, Class ...
A: Sherlyann, You could place this in the criteria of the query column containing the booking date: ...
|
| Skipping blank queries when exporting to spreadsheets | 2/13/2009 |
Q: I have a VBA procedure that runs all of the queries of a particular name in a database, and exports ...
A: I am suprised that your code is even waiting for the slow Dcount to return a value. I would open a ...
|
| reports in access | 2/11/2009 |
Q: Nevermind the previous question, I figured it out.
A: Liz, What did you find out re: missing items in 2007? bheifler@gmail.com Bob Heifler ...
|
| MS Access reports, margins | 2/10/2009 |
Q: I need an Access report to print front and back with gutter allowance for three ring binder. I ...
A: Karen, In the design view of the report there is a page setup where you can direct the printer ...
|
| Combo box multiple 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: Imran, You will need two controls on your form that are bound to two field names in your table. ...
|
| Sorting numbers in field when data type is "text" | 2/6/2009 |
Q: Situation: I have a database in which the user assigns a numeric ID. The data type for the ID is set ...
A: Connie, In your query, create an additional sort column by converting the text field [userID] to a ...
|
| Access Database Importing from Excel | 2/5/2009 |
Q: I have a question regarding importing multiple large excel spreadsheets into Access to create a ...
A: Anna, It's possible the the incompatible data type is in an Access table that is to receive the ...
|
| MS Access Union Queries | 2/5/2009 |
Q: I have a database in ms access that I had to create for my job and I am running into problems ...
A: Shirley, You mean join not union "Again, I think it has to do with the UNION" If you join two tables ...
|
| data manipulation | 2/5/2009 |
Q: how do i manipulate and extract data in Microsoft access
A: Josephine, You can manipulate data within forms, tables, programming code, or by using action ...
|
| Access 2007 combo box on report | 2/1/2009 |
Q: I'm new to the forum and also new to Access so please consider this when forming your response. ...
A: Darin, You can create 5 derived query columns, one for each option. CountOfA:Iif([FieldName]=1,1,0) ...
|
| Access 2007 combo box on report | 2/1/2009 |
Q: I'm new to the forum and also new to Access so please consider this when forming your response. ...
A: Darin, I suggest you create a derived column in the query that feeds the report. You could use this ...
|
| Reset / Show VB Code Updated | 1/29/2009 |
Q: My question is regarding the ‘if’ statement which I have within the form combo box. When a selection ...
A: Imran, When you go to another record, an event is triggered. The event is called OnCurrent event ...
|
| Changing field name in a query | 1/28/2009 |
Q: I want to label a field in my query as a time (e.g. 7:30 AM). Currently, the field looks like this ...
A: Tania, There is no way I know of. If this is for a report or form, you simply change the field label ...
|
| Changing field name in a query | 1/28/2009 |
Q: I want to label a field in my query as a time (e.g. 7:30 AM). Currently, the field looks like this ...
A: Tania, The only way is to make the alias name a literal by enclosing it in double quotes like this: ...
|
| Validation Rule | 1/28/2009 |
Q: on a form i placed a date field which validation rule is that the users not allowed to enter more ...
A: Sher, Place your validation in the AfterUpdate event of the date field and use a popup question if ...
|
| Subform not displayed | 1/27/2009 |
Q: I am using MS Access 2003 on Windows XP. I have a form with a subform embedded. I have data that is ...
A: Kami, I find that print preview, as executed by this vba line of code: DoCmd.RunCommand ...
|
| Ranking order cal in Access query | 1/23/2009 |
Q: I need to create a calculated field in Access query which ranks the order of dates. See example. ...
A: Asta, Format([YourDateField], "yyyymmdd") will give you 20090329 for March 29, 2009 Bob Heifler ...
|
| Setting up a query to match from two tables | 1/21/2009 |
Q: We have two tables, one about 20k entries large, the other about 700 entries large. Both contain ...
A: Christine, Create two queries, one for each table, that have a derived column with this formula. ...
|
| Access 2003 - Distributing Reports | 1/20/2009 |
Q: Bob, Good morning. I am fairly handy with VBA, but I need some guidance on this problem. I've ...
A: Robert, Send the report as an attached Word document using the SendObject method of the DoCmd. The ...
|
| transfer of data from text box to table | 1/20/2009 |
Q: got a small problem..... I have created a text box that displays a number based on a Country and a ...
A: Dejan, Make a form bound to the table fields. Add an unbound text box, call the control "TheNumber" ...
|
| MS Access Triggers | 1/14/2009 |
Q: Is there an easy way to add an equivalent of a trigger to a table on an access database? My ...
A: Gareth, Access 2003 and earlier allows full security control but not down to the field level. ...
|
| Microsoft Office Record Navigation Control 11.0 | 1/14/2009 |
Q: I am not able to bind the control to a form. How can I do this? Also, Can I write an event which ...
A: Vikram, You use the controls "Control Source" property to bind the control to a form. You bind the ...
|
| MS access | 1/12/2009 |
Q: how do you define bound and unbound field,how do you bound a field to another field or table,,, ...
A: Aram, If a form has a table or query as it's "Record Source", a bound control would be a control ...
|
| If statement in a form or table | 1/7/2009 |
Q: I am trying to create an IF formula that is calculated when entering information on a form. What is ...
A: Travis, Here is a help screen example: Dim Number, Digits, MyString Number = 53 ' Initialize ...
|
| how to link database and webpage | 1/7/2009 |
Q: I am new beginner to database design and i would like to know how to open a webpage from a form in ...
A: This is how to code it: The following example sets the HyperlinkAddress property of a command ...
|
| sorting and filtering | 1/5/2009 |
Q: This is one of number columns in Access: Some with 4 digits, some with 5 and some with 6. How to ...
A: Bruce, Re: "How to put two 0s front of 4, one 0 front of 5, so that all 6 digits numbers in this ...
|
| Using a filter to contrain queries sent to a spreadsheet | 1/5/2009 |
Q: I'm using a query in VBA that exports the output of a number of queries to an Excel spreadsheet. ...
A: Dan, Create a table with two fields, QueryName and Dept_Owner. Write a select query called ...
|
| Microsoft Access 2007 query | 1/3/2009 |
Q: The attachment is a screen shot showing how I am attempting to create a query. For a table, I have: ...
A: Monica, You need to create three derived columns in you query. Here is example of on of them: ...
|
| Previous number plus one | 12/27/2008 |
Q: I have a field called billno. The value should be 1 plus the previous number, but the initial value ...
A: Kris, You can use autonumber or write a program code to lookup the last value and add one to it. ...
|
| Multi-User Applicatiion | 12/22/2008 |
Q: I've written a time tracking application for remote users to enter their work time. I want to make ...
A: Robert, If you want to prevent a record from being edited if someone else is currently editing it, ...
|
| Force One-to-One relationships | 12/17/2008 |
Q: Is there a way to force a one-to-one relationship between tables? Essentially the data is a list of ...
A: Colin, Using the control key held down in the design view of the table, us can highlight the contact ...
|
| Calculating Days in a Program | 12/15/2008 |
Q: I am a non-profit organization for individuals with disabilities. Part of our program is job ...
A: David, You need to loop through the days from start_date to Placed_date (or current date if ...
|
| search button question | 12/13/2008 |
Q: i want to have a search button with an integrated text field and cancel / OK . means i wil enter the ...
A: Molay, Just make a form that has popup and modal properties set to true. OK and Cancel buttons are ...
|
| Access macros | 12/11/2008 |
Q: I have an access database with a form that has a buttons that calls a macros that calls many ...
A: Paul, Use DoCmd.Setwarnings False Be sure to set back to true and end of code. Bob Heifler ...
|
| Counting records in a report | 12/9/2008 |
Q: This seems so simple but apparently I can not get my grouping right or something. Here is what I ...
A: Gwen, In the footer of your Server grouping to get count of servers, just use the Count() function ...
|
| Removing duplicates from queries | 12/8/2008 |
Q: I'm using an Access database to keep a record of around 15,000 different records. I use queries to ...
A: Glyn, Add a "RemoveThisRecord" boolean YES/NO field to the table. Use the view dups query and create ...
|
| access macros | 12/8/2008 |
Q: what i meant was i am having problems creating a macro that will open the index page of a ...
A: Chahan, This function only requires the web site url to open it: Public Function ...
|
| Access to SQL server update Query | 12/4/2008 |
Q: I am hoping this is an easy one but I am struggling. I have built an Access app that imports a csv ...
A: Kevin, Looks ok. Is this SQL in a "PassThrough" query or are you using docmd.executeSQL? The ...
|
| Acess follow up question | 12/3/2008 |
Q: The data I was trying to centralise was in a query. Brian Hughes
A: Brian, A query does not have an alignment property, however you could convert to a string and pad ...
|
| Using work days versus calendar days | 12/3/2008 |
Q: We are working on revising our scheduling program in Access 2000 and are struggling with generating ...
A: Robert, The WeekDay function will return an integer 1-7 for any date. To check for a company ...
|
| sort query by weekday | 12/2/2008 |
Q: i have a column set up to pull a ship date that is the day of the week (Mon,Tues,Wed,Thurs,Fri). How ...
A: Cathy, Add a derived column to your query: MyWeekDay:Weekday([Name of Ship Date Field]) Using the ...
|
| COMBINING PASSWORD VALIDATION & USER LEVEL PRIVILEGES | 12/2/2008 |
Q: I'm trying to create a database that will screen users and validate each of their pwds. I want the ...
A: SHAMIKA, I would also lookup the permission level of the user that has just past the password lookup ...
|
| Viewing 1 Record per Page in a Report | 11/25/2008 |
Q: I am learning Access 2007. I have set up 2 Tables. 1 with customer name, address, etc. 1 with ...
A: Leilani, Create a report based on a query involving these two tables. Group by Customer and force ...
|
| question on access | 11/25/2008 |
Q: how to input a field of table while running vba code
A: Raj, To trigger the code you will need a form control's event to trigger it. If the form had table ...
|
| Calculated fields in Tables | 11/21/2008 |
Q: I have created a table with a form to match for entering the information. I created a calculated ...
A: Mindy, In the report footer section you can sum a field using Sum([name of field]). Bob Heifler ...
|
| Custom Primary Key | 11/20/2008 |
Q: I have worked with MS Access as a student about 6+ years ago and now I volunteered to create a ...
A: Natalia, The purpose of the key is to join tables. The autonumber in the parent table is the primary ...
|
| Problems in Splitting date and time | 11/19/2008 |
Q: I am working on MS access 2002 and to be frank I'm new to access and getting the grip over it from ...
A: Swaroopkumar, For time there might be none so the lenght is probably less than 10 therefore ...
|
| Custom Primary Key | 11/19/2008 |
Q: I have worked with MS Access as a student about 6+ years ago and now I volunteered to create a ...
A: Natalia, Keep it one to many 1 family to many students. FamilyID - autonumber in Family table and ...
|
| joint queries | 11/17/2008 |
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], ...
|
| joint queries | 11/17/2008 |
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 ...
|
| Selecting a value in a subform | 11/14/2008 |
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] = ...
|
| Automatically Filling in Data in access | 11/14/2008 |
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 ...
|
| sorting two fields togther in the same database | 11/13/2008 |
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 ...
|
| question | 11/13/2008 |
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 ...
|
| Type Mismatch Error | 11/12/2008 |
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 |
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 ...
|
| Query for specified number of records | 11/12/2008 |
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. ...
|
| Access 2007 | 11/10/2008 |
Q: Hey Bob, My name is anthony and I am trying to build an access database that is going to use combo ...
A: Anthony, You need to feed the city combo box from a query that is filtered based on the currently ...
|
| Count with date question | 11/6/2008 |
Q: How can I create a query that gives me a count of records by date? i.e. I have 5 records for ...
A: John, Group by on date and do a Count() on it in a Group by query. Bob Heifler MyAccessProgram.com ...
|
| MS Access 2003 | 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: Navid, Create two new columns that only contain the short date. Make the query a Group By and use ...
|
| Edit Record | 11/4/2008 |
Q: I am creating forms for data entry for folks very unfamiliar with access, so I want them to be ...
A: Jeff, The property sheet of the form has a property called "Cycle". Set this property to "Current ...
|
| Query | 11/4/2008 |
Q: I need to add the records in each column for a total. So for one of my columns, I have a bunch of ...
A: If you make your query a Group By and use the Sum function built into this type of query, it will ...
|
| clear form field | 11/1/2008 |
Q: I am having trouble withthe this code: 'Clear all the controls in the Form For Each ctl In ...
A: It is clearing data from fields in a record that is still going to be existing after the code runs. ...
|
| MS ACCESS MACROS | 10/31/2008 |
Q: I need to attach a macro to a command button to open a web site stored on the hard disk
A: Charles, Here is some simple code to do this: Place this code in the Click event of this control ...
|
| Trasfer text/Copydata | 10/28/2008 |
Q: I have two questions it would be greate if you could answer both. Question1 Is ther another way to ...
A: Mo, The solution is the same for both questions. Linked tables, local tables, linked to text files ...
|
| EMPTY QUERY MSG BOX | 10/26/2008 |
Q: I have a form linked to a query that searches for an account number. I would like to display a ...
A: Adrian, You could write a function that opens a record set on the query and if it finds records, it ...
|
| Creating a Table | 10/26/2008 |
Q: Here's a specific question then. For one of my fields, I used the Yes/No option. However, how do I ...
A: Sonam, You would know because on your form that is bound to the table, you might have created a ...
|
| Answering yes/no to question dictates a new form | 10/24/2008 |
Q: I have seen on another database that depending on how you answer an initial question (either yes or ...
A: Sue, Place the following code in the AfterUpdate Event of the yes/no field ("MyYesNoField"): if ...
|
| access reports | 10/23/2008 |
Q: I have a form with a data grid. the data grid is then populated with results according to the user ...
A: Ali, It requires a button with code behind it to request the parameters or criteria for selecting ...
|
| loosing decimalplaces when exporting to text file | 10/23/2008 |
Q: when I am exporting a number from a query to a text file, such as 0.06543 it exports into the text ...
A: Colin, Try converting to a string using Cstr([The numeric])before export. Bob Heifler ...
|
| Access Query Parameter | 10/21/2008 |
Q: I am trying to run a query for a table with employee training dates. I need the query to prompt me ...
A: Sherri, >Date()-31 is the criteria to use in the date field. To get a query to prompt you for a ...
|
| Record length within a record field | 10/20/2008 |
Q: I have a large database in which I need to do some name parsing, in one of the record fields I can ...
A: Chris, Use the Len() function to get character counts. Bob Heifler MyAccessProgram.com Find example ...
|
| Licence Renewal Form | 10/17/2008 |
Q: I was wondering if you could tell me, is there anyway I can create licence renewal form/page in an ...
A: Clayton, Icon can be replaced. The version of Access determines how. A lookup table that stores ...
|
| Drop down | 10/16/2008 |
Q: I am trying to autofill fields in a form based the choice of a drop down box.
A: MJ, On the AfterUpdate Event of the combobox just reference the different columns in the combobox, ...
|
| Freezing/Change control | 10/16/2008 |
Q: I want to prevent users entering/altering information into a form once it has been completed. Users ...
A: Austen, Yes, locking a control on a form will prevent the editing of the data contained within that ...
|
| Freezing/Change control | 10/15/2008 |
Q: I want to prevent users entering/altering information into a form once it has been completed. Users ...
A: Austen, There is a way to tell if a record that the user is on is a new record or an old one that is ...
|
| clearing bound combo boxes | 10/14/2008 |
Q: I have a for with 4 bound combo boxes and 2 unbound text boxes used for searching a record. I want ...
A: William, The code is this: [NameOfComboBox] = "" Bob Heifler MyAccessProgram.com Find example ...
|
| audit trail disaster | 10/3/2008 |
Q: . i realised yesterday after a day of endless debugging with no success that the allen browne ...
A: Zug, If you are in Access 2000 or later this line needs correcting: Dim rstMain As Recordset should ...
|
| QBE using dates | 10/2/2008 |
Q: I am new to Access and I see plenty of dates that are specific, but I want to create a QBE that ...
A: Robert, You can use Date()-7 a criteria for query column on a date field would have: >Date()-8 Bob ...
|
| Access | 9/29/2008 |
Q: I am a creating a Access program for my company here and one of the reports that I am supposed to ...
A: Saurav, You can use the IIF() function in derived columns in your query. Status One ...
|
| MS Access Data Table | 9/27/2008 |
Q: I have made a table listing movies to rent, including title, director, year, etc. After I have ...
A: Bill, I do not know how you would do that, but you could just create a status field and have a ...
|
| future date calculation | 9/26/2008 |
Q: I have a business form used for employee discipline. There is a field for entering a date of ...
A: Woody, Create a table of current year holiday dates to be skipped. Create a function that loops ...
|
| calculated field | 9/24/2008 |
Q: how to add a calculated field to the query that multiplies the other number field by 50?
A: Neesa, Place this at the top of a blank query column: Calculated_Result:50 * [Name of other number ...
|
| Access Queries | 9/24/2008 |
Q: I need to design a parameter query for a database using customer, product, and rental date tables ...
A: Joseph, If you use brackets in the criteria row of a query column it will pop up when the query is ...
|
| Default value | 9/22/2008 |
Q: i have a field "Sent Date", then i want to set default of my field "Expected Return Date" as 6 days ...
A: This is not a question that I can quickly answer in this email because it requires some steps that ...
|
| Access in network | 8/29/2008 |
Q: I've already developed a VB.net application with ms access as backend locally i.e. not in a network. ...
A: Parameshwaran, First get a hardware/network person to create your local area network. To allow ...
|
| Sorting data in Report by month | 8/29/2008 |
Q: I have been our electricity charges by month for last couple of years. And, when I run the report, ...
A: Saurav, You could use the Access built in function called Month() that accepts a date and returns ...
|
| Using query in access | 8/26/2008 |
Q: I face a difficulty in using query in access. In my case, for example, there are two queries A and ...
A: Howard, Use the NZ()function to convert the null or missing value to zero. NZ([Item#]) If [Item#] is ...
|
| Exlude Status from Report | 8/25/2008 |
Q: I need to exclude a status from showing up in my final report. The report should only show "open", ...
A: Carly, Exclude all but "Open" using this criteria in your status field of the report's query: "Open" ...
|
| Prompting a user for password upon trying to open a form | 8/25/2008 |
Q: I am trying to prompt the user to enter information upon click a form to open. I want to setup the ...
A: Delores, The InputBox() function displays a prompt in a dialog box, waits for the user to input ...
|
| scrolling through a form | 8/22/2008 |
Q: I have a really long form. It is probably three times the length of the my computer screen from top ...
A: Jed, A form has a property called "Cycle" change it from "All Records" to "Current Record" so you ...
|
| MS Access - IIF, AND | 8/22/2008 |
Q: is it possible to modify this formula =IIf([covtype]="PI" And ...
A: Ven, You could try " N/A " padding the right and left sides. Bob Heifler MyAccessProgram.com ...
|
| MS Access - IIF, AND | 8/22/2008 |
Q: is it possible to modify this formula =IIf([covtype]="PI" And ...
A: Ven, Use another nesting of IIF to check for a zero using NZ function. You might also test on NULL ...
|
| Adding zeros to a date m/d/yyyy to mm/dd/yyyy | 8/22/2008 |
Q: I have for formats of dates for my Access database mm/dd/yyyy which is fedd to the DB via and ASP ...
A: Adam, Use the Format() function in Access. Be sure to use two of the letter m and d to ensure the ...
|
| Backend security | 8/21/2008 |
Q: Bob, How can I use ADO/DAO in code instead of using linked tables to connect to the backend while ...
A: Jin, ADO has a connection string available. On line help gives you the arguments. For spelling, set ...
|
| Printing a form | 8/20/2008 |
Q: I have a form created to be a profile for a member in an organization. My problem is that I want to ...
A: Wayne, Create a query of the information and pass a criteria to it that limits it to the member ...
|
| Spatial query in access | 8/19/2008 |
Q: I am trying to develop a simple tool that will allow me to spatially query point data from a map ...
A: John, I know of no built in tools however there might be some 3rd party ActiveX, just Goggle it. I ...
|
| formatting issues | 8/19/2008 |
Q: I am having issues formatting a date in a text box in a report in access. (2007) For some reason ...
A: Katie, Make sure the table field is using Date/Time data type and that the formatting at both table ...
|
| expressions | 8/19/2008 |
Q: I have a table that lists people who have vistited my business and a start time in my table. The ...
A: Tammy, You can use the Format() function on the date/time field. You can create two derived columns: ...
|
| The Refresh Command Button | 8/16/2008 |
Q: I am at present, converting all my old programs to VBA, especially macros. However I have come up ...
A: Terence, You will still have to click or double click on the label and use the events to trigger ...
|
| running serial number | 8/15/2008 |
Q: i am in the middle of developing a barcode recording db. User will input product code, quantity and ...
A: Iota, Parse out the last four characters Right([SN_Field],4) then Convert to integer ...
|
| Multiple click events for textbox control in vba | 8/14/2008 |
Q: I am trying to create the following: Action Wanted: With each click cycle thru “X”, “V”, “” Form ...
A: Rachael, Use the Click OR OnClick event of txtTest using this code: Access 2002/2003 Version ...
|
| Setting a Temp Variable | 8/13/2008 |
Q: I have multiple querys that hit several SQL DBs. The only criteria I need is a from and to date. ...
A: Steve, Set two public variables then use a function to get their values. Declare the two public ...
|
| need a query in MS-Access | 8/12/2008 |
Q: i create a table called empnames. it's having name like: krishna subhash. form this i want to ...
A: Krishna, Use this: Left([FirstName],2) & Left([LastName],2) Bob Heifler MyAccessProgram.com Find ...
|
| help with making expression for company | 8/10/2008 |
Q: i have ms access 2007 and i have a form and i need to make a expression or code that does as ...
A: Dash, Private Function CalculateTheMoney(TheEndDate as date, TheStartDate as date)as currency Dim ...
|
| Creating a button to link to a report | 8/7/2008 |
Q: I am trying to create a button from a form that links to a report. How can I do this? Thank you,
A: Pooja, After you place the button on the form, find the event property called OnClick. Use the three ...
|
| Searching a record by the value in a field, then going to that record | 8/6/2008 |
Q: We are sorry, but Richard Rost wasn't able to answer yourI want to be able to change from the ...
A: Steve, VBA can open recordsets. Be sure to add reference to DAO library. Dim RS as dao.recordset ...
|
| assigning record information as a controls caption property | 8/2/2008 |
Q: i have a database in which there is a table having only two fields; Airline_Code and Airline_Name. i ...
A: Rajiv, Reference the 2nd column of combo using the column property. [NameOfLabel].caption = ...
|
| access question | 8/1/2008 |
Q: I think what my question will probably be fairly easy for you since you're the access professional. ...
A: Tonya, A quick easy way to have a popup user request for criteria data is to place a bracketed ...
|
| Auto Population | 7/31/2008 |
Q: Good Afternoon! Is it possible to have one field auto populate another field based on the data in ...
A: Jennifer, One way that I do this sort of thing is the following: 1) Make a query that contains in ...
|
| custom toolbar | 7/30/2008 |
Q: I'm working in Access 2007. I have a form that I want the user to be able to do a search on by using ...
A: Rachel, The microsoft site has tools to help you customize the ribbon, however you can add shortcuts ...
|
| Access | 7/28/2008 |
Q: Is it possible to show the "keyword" entered by the user? Something like: You searched by: "XYZ" ...
A: Rick, One way is to set up a public variable to store the selection criteria. A simple function can ...
|
| MS Access | 7/27/2008 |
Q: Is there a way to make check and tick boxes where you can only select one box for a field without ...
A: Use option group and use this on form or report: Assumming value 1 of option group is true and 2 is ...
|
| i am not sure if you recieved my previous email | 7/25/2008 |
Q: basically i have created a form which i thus used the "control sauce " to type in this formula =[sub ...
A: Laura, One way would be to add a VAT field and a "VAT Used" field (Yes/No)and on the form show the ...
|
| INSERTING IMAGES IN MS ACCESS FORM | 7/24/2008 |
Q: I have a form for inputing staff details.I have a botton which brings up the dialog box to select ...
A: Henry, Let's say your picture control is called Image85 and your textbox control that stores the ...
|
| Adding an edit record function to a form - follow up | 7/24/2008 |
Q: Many thanks for the code, it works a treat! What I'm hoping for is to only "grey" out certain fields ...
A: Glyn, Individual form controls can be disabled or enabled using the enabled property. ...
|
| i am going to repost my question again to you | 7/23/2008 |
Q: this was my originalmy name is Noor i am using a access in the company i work in. basically i am ...
A: Noor, You have not communicated the actual calculation formula, but here is a free video tutorial on ...
|
| Adding an edit record function to a form | 7/23/2008 |
Q: I'm currently running a database in Access, using a form to show the data. What I'm looking for is a ...
A: Glyn, This is going to be a long answer full of code but you can do it. First make a button control ...
|
| Access Tabs | 7/22/2008 |
Q: I have 5 tabs on a data input form, all reading from the same very large table. I want to separate ...
A: Tim, First copy your fields from big table to 5 new tables and create append queries to populate ...
|
| table data formating access 2007 | 7/21/2008 |
Q: I have data from a form being stored in a field in a table. The problem I have is that the data ...
A: Stan, VBA is needed. See the Round and the Fix functons. Bob Heifler MyAccessProgram.com Find ...
|
| Duplicate data check when transferring from Excel to Access | 7/11/2008 |
Q: I have an Excel spreadsheet that needs to be transferred to Access on a daily basis. There are four ...
A: Terry, This is a big question if you are a beginner, but rather than just reject it, I will get you ...
|
| Irs forms and access | 7/11/2008 |
Q: I am by no means an access guru, however for my job I have managed to make a relational database and ...
A: Joni, Once you have all your Access tables and data entry forms created, you will create an Access ...
|
| Time functionality in query | 7/10/2008 |
Q: I'm building an Access 2003 database to audit security access using card swipes. I need to calculate ...
A: Arnanda, Sure, just add cint(Format(ClockedInDateTime, "h"))> 23 to the criteria of the query that ...
|
| access | 7/10/2008 |
Q: how do I enter keywords to query the database and see the results?
A: Hluphi, You create a query and enter a keyword in the criteria of the column you want to filter on. ...
|
| validation or control based on prior field value | 7/9/2008 |
Q: I need to disallow entry into a particular field on a form based on the value of a prior field being ...
A: Terry, You will use the lock property of the field you want to disallow entry in. Place this code ...
|
| query | 7/8/2008 |
Q: I am trying to create a query that will grab data from between specific dates from closed and open ...
A: Marta, If you want both open and closed (yes/no) then do not add any criteria on this column in your ...
|
| Display user name | 7/8/2008 |
Q: Is there a way to add a button that by clicking on it will display the user name in a given field? ...
A: Wes, I have used the following code from this programmer: ---Posted by Dev Ashish--- ...
|
| multi choice combo box | 7/8/2008 |
Q: Iam designing a database in access 2007 for volunteers i want the combo box in the task page to be ...
A: Jodie, You can use this in a not shown column in a query for the criteria and the value. It's the ...
|
| Order by second-to-last character | 7/7/2008 |
Q: I'm working in Access 2000 and need help with the 'order by' in a form. I have an id code that is 5 ...
A: Patty, Mid([ID],6,1) will isolate that digit. Bob Heifler MyAccessProgram.com Find example files ...
|
| Access Help Required (Please) | 7/7/2008 |
Q: I have 3 fields in my database, Program ID, Order # and File name. File name is number upto 10 ...
A: Roopesh, This will give you the value for your new field: Left([FileNameField],5) Bob Heifler ...
|
| MS Access Form - Where is the data source? | 7/5/2008 |
Q: Good evening! I have been staring at an MS Access 2003 Form and for the life of me cannot ascertain ...
A: Andrew, I am not sure I am clear on all that you want. If you want one or two conditional logic ...
|
| MS Access Form - Where is the data source? | 7/4/2008 |
Q: Good evening! I have been staring at an MS Access 2003 Form and for the life of me cannot ascertain ...
A: Andrew, When you are viewing the form design, find the windows upper left corner square. Click on it ...
|
| access 2003 school database | 7/2/2008 |
Q: We use access 2003 to do health screenings for kids at schools. We acquire the students' ...
A: Sophia, I and others have used the Dlookup() function to check if a pre-existing field value, in ...
|
| Calculating fields stored in bound fields | 7/2/2008 |
Q: Bob! So glad you are here to help me. I brought in some data from Excel that was doing automatic ...
A: Cindy, You will want to trigger your calculation code from all bound form controls that are involved ...
|
| Form_Timing | 7/2/2008 |
Q: Bob, I am using MS Access 2003 (VBA) and am having trouble with the following code. I have a ...
A: Janet, Private Sub Changes_AfterUpdate() Select Case Changes Case 1 ' Assumming value 1 of the ...
|
| MS Access Help | 7/1/2008 |
Q: Hey bob, I am trying to create a section of my current database im working on where I input ...
A: First a few questions: How are you ensuring that the correct General Service ID is being entered in ...
|
| Changing data type with a macro/code | 6/30/2008 |
Q: I want to use a macro/code to change the data type of an imported xls from numeric to date. I saw ...
A: Heather, Using this code requires a code library that needs to be referenced by using the Tools menu ...
|
| Concatenation and unique id | 6/30/2008 |
Q: Bob, First off, I appreciate all the time you put into this sight. I am trying to make a field ...
A: Jasson, Re: "everything but the ID shows up" If the "ID" is the autonumber then it probably is not ...
|
| making a field required | 6/29/2008 |
Q: I have one form where ordering information is entered, but everything can't be entered at the time ...
A: Ray, The Now() function will data and time stamp for you. You can use it in the default property of ...
|
| how to search last number | 6/27/2008 |
Q: i create a table (EmpMaster) with an index of employee id number (empno) type: Integer example is: ...
A: Mart, I have tested this SQL for you. Just start a new query and use this. Be sure to replace with ...
|
| Access Macros | 6/26/2008 |
Q: Bob - How do I create a macro in access and assign it to a button so that when I click the button, ...
A: Aurora, Place this behind a button's OnClick event and be sure to fill in all the < > spaces: Dim ...
|
| Option group parameters for query | 6/26/2008 |
Q: I'm trying to pass a parameter to a query to select records where the field to test holds a Yes/No ...
A: Michael, Using sql statements that are executed will work. Stored queries are optimized and run ...
|
| Option group parameters for query | 6/26/2008 |
Q: I'm trying to pass a parameter to a query to select records where the field to test holds a Yes/No ...
A: Michael, You can place this code in the after update event of the option frame: Select case ...
|
| MsAccess | 6/25/2008 |
Q: how can store multiple rows in Ms Access form
A: Raj, A continuous form view will display multiple rows or records of an Access table. Entering data ...
|
| Concatenation and unique id | 6/24/2008 |
Q: Bob, First off, I appreciate all the time you put into this sight. I am trying to make a field ...
A: Jasson, Create a field "FullID" and "NumericID" Make the first a text and the second an autonumber. ...
|
| Access 2003 | 6/24/2008 |
Q: I had a client database that contained approx 500 records. About half of the records are duplicated ...
A: Gail, Yes, give each detail record a number that corresponds to a client in the client table. ...
|
| Programming Question | 6/22/2008 |
Q: I'm dealing with a rather common problem but since I have never had to program MS Access before it ...
A: Maggy, I can answer the first part here. First use the file menu "Get External Data" and link to ...
|
| Access Query | 6/21/2008 |
Q: I am trying to create a select query from an Access Database to generate a list of all equipments ...
A: Furgan, Make it a group by query and use Max()function to get the last date. Max([NameofDateField]) ...
|
| calculating age from table in ms access 2003 | 6/20/2008 |
Q: hye..I'm creating a web-based app using ASP VBScript in Dreamweaver MX 2004 and a databaase in MS ...
A: Liana, This calculation would need the birthdate as a date data type. The years plus decimal ...
|
| Access 2000 - Option Group | 6/19/2008 |
Q: I have only been using access for a couple of weeks so please forgive the question... I have created ...
A: Cath, There is nothing built in to do this but here is some code I just created that will work. I ...
|
| adding feilds in a form | 6/19/2008 |
Q: i am new to using access and i need to solve a problem. I have created a very basic data base for ...
A: Cassi, If you do not need to store this calculation you can just add a text box in the form and make ...
|
| query problems: currency, duplicate results... | 6/18/2008 |
Q: First I'd like to say THANK YOU SO MUCH for your "myaccessprogram.com tutorials, i would have never ...
A: Deborah, Make your invoice a report and sub-report(for detail lines) The main report just pulls the ...
|
| Exclusion | 6/17/2008 |
Q: I'm working with a database and want to creae a query that will exclude selections that meet ...
A: Michael, In the query designer screen, you can create columns that are based on the result of other ...
|
| Adding a drop down list to a report/query prompt | 6/16/2008 |
Q: I have several reports that when run, the user is prompted to end the Project Name. In the database ...
A: Lisa, I have an example file to send you. Send your email address via my contact page. Request ...
|
| Moving through a table's records in VBA | 6/16/2008 |
Q: I have the following stored SELECT query, which I intend on running as VBA code with the DoCMD ...
A: Travis, Open a recordset and loop through all the records with this code: Dim rs as Dao.recordset ...
|
| Autofill Fields | 6/14/2008 |
Q: I use a combo box to select an item number, this then auto fills several other fields on my forms, ...
A: Carl, First see if data is storing to table. If not, bind the form to the table and ensure the ...
|
| use record set and textbox data to send email | 6/13/2008 |
Q: I'm using a form command button to send an email with a specific subject. It's working fine. But now ...
A: Leslie, Re: The cc on mail. Try this: Dim olApp As Outlook.Application Dim olMail As MailItem ...
|
| Quick question about running a expression builder code | 6/13/2008 |
Q: I am running a database that requires for data to be entered in the same record of the same table ...
A: Matthew, How about an update query to set the "=Round(Timer()/3600,3)" and have it run after the ...
|
| select query to filter instead of Dlook up | 6/13/2008 |
Q: i'm basically trying to create a button in which restricts access to certain users. i've managed to ...
A: Just add additional data to your password user table and store the permission data for current user ...
|
| select query to filter instead of Dlook up | 6/13/2008 |
Q: i'm basically trying to create a button in which restricts access to certain users. i've managed to ...
A: Jonathan, Add two unbound textboxes LogInUserName and LogInPassword then place this code in an ...
|
| Saving data from unbound textboxes | 6/11/2008 |
Q: I have a form with a lot of unbound textboxes. I would like the data entered into the textboxes to ...
A: Justin, That is the purpose of bound textboxes or any bound control on a form. Just bind the form to ...
|
| Outlooks Contacts fields into Access database fields | 6/10/2008 |
Q: I use Access to input data and create documents used for legal case processing. Much of the data in ...
A: Keith, Use a query of your link to Outlook to populate your Combobox with all the fields you want. ...
|
| MS ACCESS info windows | 6/9/2008 |
Q: i am using update command to be update one tabl filed from another table field, and is working ...
A: Atanas, Use docmd.setwarning false After code runs, set to true Bob Heifler MyAccessProgram.com ...
|
| Auto-fill Problems | 6/9/2008 |
Q: I have a table that includes Consultant Employee information. I.e. Consultant ID, First Name, Last ...
A: Gregory, Use the after update event of the combo control and do this [First Name Control Name] = ...
|
| Foreign names entered in records are re-spelled by computer | 6/9/2008 |
Q: I made a database for members of an international community, but when i enter names such as "TEH", ...
A: Benny, Microsoft Access versions before 2007 allow stopping of automatic corrections that occur when ...
|
| Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? | 6/8/2008 |
Q: Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? ...
A: Shani, First make some new table fields and place them on the form. These are your additional bound ...
|
| Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? | 6/8/2008 |
Q: Microsoft Access: How do I calculate the grand total sum using Auto-populated fields in a subform? ...
A: You do not want unbound controls in the subform records. If you make them bound controls, that store ...
|
| Tab oder and query | 6/6/2008 |
Q: I have 2 questions- I hope it is ok to ask 2 at the same time. If it is not, let me know. 1) Tab ...
A: Irina, 2nd Q. Take out the like and the & "*" and have the query just reference the form as in : ...
|
| Combo Boxes | 6/6/2008 |
Q: I'm writing a database for work using dependent combo boxes using the following code: Private Sub ...
A: Wendy, Have you tried a group by on the query that feeds the first combo? Bob Heifler ...
|
| ms access, login access privilege to buttons using VB | 6/5/2008 |
Q: i have created a database for a company using ms access 2007. I created a simple login where users ...
A: Ashadur, In a module write/paste these four lines: Public UserLoginID as variant Public Function ...
|
| ms access, login access privilege to buttons using VB | 6/5/2008 |
Q: i have created a database for a company using ms access 2007. I created a simple login where users ...
A: Ashadur, Store in a public variable the name or id of the person that passed your current login. ...
|
| building an Access form | 6/3/2008 |
Q: I would like to create a form that pulls from separate tables. Is there a way to do this? Right now, ...
A: Julie, Unless the two tables have a one to one relationship that allows you to create a query on ...
|
| Run time error 3021 ( No current Record) | 6/3/2008 |
Q: I was trying to diplay records which calls SerialNumber Sometimes it's working but when the record ...
A: Jay, Use this line of code after opening the recordset to see if any records. If rs.eof and rs.bof ...
|
| pasting excel data into a form field | 6/2/2008 |
Q: My customer service team uses a form (Access 2003) to, among other things, store and track sales ...
A: Leslie, First use the file menu, get external data feature. Here you want to link to the Excel file. ...
|
| Access database lock | 6/2/2008 |
Q: Bob I have develop a small scale Application in Access. But problem is there is security in my ...
A: Ahmed, Access prior to version 2007 allows for full security. You set it by going to tools on the ...
|
| ms access and last week | 5/30/2008 |
Q: would u please check out the following problem I have a current date. i am using it in the qurey ...
A: Lancer, If a query with your date field being called "DateField" you would use this in the field ...
|
| Addition in a form? | 5/30/2008 |
Q: Bob, I'm trying to add 3 text fields with their summation displayed in a fourth. Here's a more ...
A: Adam, Store the three fields to table (3 controls bound to a table). Assuming data is stored in a ...
|
| Using Comboboxes to link to reports | 5/29/2008 |
Q: Bob, I'm trying to create a series of reports from the information in three tables. Each table is ...
A: Adam, You create a query that uses all the data tables you need. You join the tables on (Relational ...
|
| connect access table with external pdf files | 5/28/2008 |
Q: i have a folder in my desktop which has 50 pdf files. i want to search in an access form (by ...
A: Nick, There is a table field data type called hyperlink. If you create a hyperlink field, place it ...
|
| extracting data drom Access 2007 tables | 5/27/2008 |
Q: I have a very simple Access 2007 database -- there is just one table in it. This table has about a ...
A: John, Create a group by query. Group on "Insurance Company" and sum on "Amount Appealed". Set your ...
|
| Storing images in MS-Access database | 5/27/2008 |
Q: there is a VB application through which images are stored in access database. If that image's ...
A: Zephyr, Access has an image frame control. Let the wizzard get you to choose one image to populate ...
|
| New issue, login script problems | 5/26/2008 |
Q: Sorry to bother you again. I have a new issue. Here is what I am working with/on: I have a table ...
A: James, The dlookup function allows you to enter a where clause after the domain.Just look at the on ...
|
| Can't Update Field | 5/24/2008 |
Q: I have an Access database to track when I send proofs to clients. I have two tables - tblCustomers ...
A: You will have to write an update query to the single tblProofs to update that field. You could ...
|
| If statement | 5/23/2008 |
Q: I am working on a database in which I'd like to convert the negative numbers I receive from the ...
A: Sergio, Use this in an empty column of your query. ...
|
| Update Message Box | 5/23/2008 |
Q: I'm using the DoCmd.RunSQL method to update and insert a few records. When the method is executed, ...
A: Heather, Add docmd.setwarnings False before the DoCmd.RunSQL and add docmd.setwarnings true after ...
|
| ms-access | 5/23/2008 |
Q: how to convert ms-access file to exe file
A: Venna, There is no way to convert an Access program to a .exe file by using Microsoft Access. ...
|
| MS Access Database? | 5/22/2008 |
Q: I created a Database using MS Access, Table 1 named PurchaseRequest contains 80 Records with 30 ...
A: Sher, Access Version 2000 or greater has a 2 gigabyte limit per table or per file, which ever comes ...
|
| Access report generation | 5/21/2008 |
Q: I have built a fairly simple database and have within it a couple of simple forms what I would like ...
A: Brendan, It's possible to write code that looks at what is in a text field and conditionally execute ...
|
| Autonumer using Dmax | 5/21/2008 |
Q: Hei I have a small problem and I cant't find the solution - I have a form in whitch I have placed a ...
A: Lars, Add this code to first check if the form already has an id by only running the code if the ...
|
| Prompting for field name | 5/21/2008 |
Q: first. thank you for offering free help. second.. to get straight to the point! Ive been asked to ...
A: Adam, Create a form where the field name, desired column heading name, and the table is requested by ...
|
| Forms - Calculations | 5/20/2008 |
Q: I have created a form thats using a table I need to add 3 fields together which i use this in ...
A: Alan, You first need a field in both the table and the form to accept the result of the calculation, ...
|
| Greater than function in MSAcess | 5/19/2008 |
Q: I have steup a select query in which I have a criteris to find out the no. of days between two ...
A: Neil, Add a new column to the query and use this to derive a true if date difference is greater than ...
|
| Report Color Change | 5/19/2008 |
Q: Basically I have the following: Table Query Form Report On the form I want to have three buttons ...
A: James, There is an event in your report design called On Format. You would place your code here. So ...
|
| Calculating Percentages of a Count Query? | 5/19/2008 |
Q: Please help! I am trying to write a query that will be on a report showing the percentage of repeat ...
A: Lucia, Try using the first query in a second query that divides the results of each field by total ...
|
| access | 5/15/2008 |
Q: on a form, I would like to have a user to fill in two text boxes first. If the user fill in either ...
A: Laura, Place this code on the after update event of both text boxes. if not ...
|
| automatically bring up a form for users. | 5/14/2008 |
Q: Good day Bob, I have two questions for you. I am in need of help with MS Access 2003 (VBA) running ...
A: Janet, Access, all versions, let you set the start up form you want to open when the Access file is ...
|
| Passing and Retrieving Data from Combo Boxes to Forms | 5/14/2008 |
Q: I have a problem with my combo boxes and forms. I have a database that I would like the user to be ...
A: Stuart, First create a query, call it MySearchQuery that will populate the new form or the existing ...
|
| Table is not showing form Expression results | 5/13/2008 |
Q: form design I have a Field The box contain calculations. I am calculating check box values. The ...
A: John, If you have a storage field for the result, call in [mystoragefield], you can write code on ...
|
| security | 5/13/2008 |
Q: On an .mde database, how can I stop users viewing and changing the dign of tables, queries, forms ...
A: Rob, Access versions lower than 2007 have security, see on line help, that you can use. Version ...
|
| Windows User Name in Access 2007 | 5/9/2008 |
Q: I am not sure what else I can say.. I was trying to get a field in a form to automatically fill with ...
A: David, fGetUserName() can be placed in code, or source of unbound textbox. or fGetUserName()placed ...
|
| Windows User Name in Access 2007 | 5/9/2008 |
Q: I am not sure what else I can say.. I was trying to get a field in a form to automatically fill with ...
A: David, This is the code I use with no problems on a wide area network. If a user can not access ...
|
| Updating Reports without Creating New Ones | 5/9/2008 |
Q: I'm building a database for someone with limited Access experience. I would like to build all the ...
A: Elizabeth, If the report is based on the table that was just updated by a form bound to that table, ...
|
| Multi criteria query | 5/8/2008 |
Q: I am desperately needing help with this query. Basically, I have 4 criteria that I want the query to ...
A: Irina, The like ... * sql looks fine. It's the and and or problem that you need to address by ...
|
| today's date updates in table access 2000 | 5/8/2008 |
Q: I am creating a database for my work, and I need to have a constant 'today's date' in one of my ...
A: Scott, Use the Date()function and place it in the table for form and the default, see default ...
|
| compare & replace | 5/8/2008 |
Q: "Hi Bob, I would like to ask a question related to compare and replace action. I would need to ...
A: Silvie, You could use the Dlookup() function in an update query. This would lookup the desired ...
|
| Storage limitation of Access Database | 5/7/2008 |
Q: I have one question about the storage limitation of Access Database. I know the database file cannot ...
A: David, The limitation is for a single file (all tables) or a single table. I do not recommend ...
|
| log in | 5/7/2008 |
Q: i have an Access Database that i have created and i'd like to design a form that will only give ...
A: Festo, Create a user name and password table. Make a login form asking for these two and a button. ...
|
| More than one parent form for one subform | 5/6/2008 |
Q: I am facing a problem in identifying the parent form for a subform as I have one subform with 2 ...
A: Aparna, You can use this code to see if a form is closed: If SysCmd(acSysCmdGetObjectState, acForm, ...
|
| Report Help | 5/5/2008 |
Q: Hope this won't be to confusing. I use MS Access 2007, I’m working on a report in which I need to ...
A: Suzanne, Instead of doing it manually, you could learn how to create a function that created a ...
|
| Ms-Access Rounding Up to the next $5 mark | 5/2/2008 |
Q: I would like to Round UP a field in my table which contains values with and without decimals so e.g. ...
A: Karim, Access has a round function. The 1 tells the function to round to 1 decimal place. ...
|
| MS Access Button | 5/1/2008 |
Q: I am using Access 2003. I have created a button with the intent of it opening a form built from a ...
A: Stacy, Create the button to open the subform using the wizzard where there is an option to open form ...
|
| parameter value | 5/1/2008 |
Q: I am trying to insert the criterion ">6" in a field defined by: formula 2: DateDiff("m",[seizure ...
A: Moataz, Replace: formula 2: DateDiff("m",[seizure date],[formula]) With this: formula 2: ...
|
| Time intervals | 4/29/2008 |
Q: I'm trying to setup an access databae to function as an appointment tracking system however i seem ...
A: Carliste, Use a combobox with list values of the times you want and set limit to list to true. You ...
|
| Table Design/Normalization | 4/28/2008 |
Q: I'm trying to figure out how to design and normalize tables for a 2007 MS Access database that will ...
A: Lou, First create your three tables of crime, sub, subsub Add Date of crime,Officer (name, rank, and ...
|
| MS Access 2007 | 4/27/2008 |
Q: I am trying to write a VBA module that contains Message Box. I have done it many times before in ...
A: Nick, Try msgbox "test" No parenthesis. Bob Heifler MyAccessProgram.com Find example files at: ...
|
| MS Access | 4/25/2008 |
Q: i am working on a module where i am using multiple combo boxes which lookup different fields of the ...
A: Idris, Using the after update event on the first combobox you will have to reset the record source ...
|
| Count number of updates on a record | 4/22/2008 |
Q: I am building this basic database for a bank which will keep track of loan applications. The ...
A: Imran, This depends on how you are undating the re-received field. That is the point in time when ...
|
| MS-Access | 4/20/2008 |
Q: Just wanted to know your opinion I'm planning to develop a multi user application which is used by ...
A: Sachin, Create a user table and an login form. The table could store user preferences metadata and ...
|
| Counting Y/N in a Report | 4/17/2008 |
Q: I need help on how to write an argument to count the number of y's and n's in the Footer section of ...
A: Beverly, In the detail section of the report, create an unbound textbox called "Y_Count" If the ...
|
| expression to only show first 2 numbers | 4/11/2008 |
Q: I need to show only the first two numbers in a 6 number field. Can it be done?
A: Jean, Use a text box control on your form: If the table field name was [MyField] then the code would ...
|
| Access 2000 field list | 4/11/2008 |
Q: I received a database from a client who asked me to add some fields to a table. No problem there. ...
A: Dale, Look at your new form's property called RecordSource ant select the table or query that the ...
|
| Text box in a form | 4/11/2008 |
Q: Can I use a data from text box in a form from last record as default data in text box in a form ...
A: Robert, Yes, one way would be to use the Access Dlookup function. Access help will show you how to ...
|
| Creating a Unique Value Check across Multiple Fields | 4/9/2008 |
Q: I have a table which i want microsoft access to check that there is no duplicating data across 3 ...
A: Alan, Go to the table's design view, select the 3 fields, then use the yellow key icon button at the ...
|
| link msword files with access prog | 4/3/2008 |
Q: i created program for followup of orders, all the details available on the program, but i want to ...
A: Make a hyperlink field and use a follow method to have the user follow the address of it. Bob ...
|
| Calculated field | 4/1/2008 |
Q: How can the result of a form field's data source expression be captured in the database attribute? ...
A: Vinson, If you are calculating something that you want stored in the [Age] field you would simply ...
|
| Calculated field | 4/1/2008 |
Q: How can the result of a form field's data source expression be captured in the database attribute?
A: Vinson, Please define "database attribute" for me. Bob Heifler MyAccessProgram.com Find example ...
|
| Saving and editing data in table | 4/1/2008 |
Q: I have a table with such fields: Book, Book_author, Book_year. And now I am interested in making ...
A: Dennis, You should not have to press a save button if each field control on your form is bound to a ...
|
| ms access | 3/31/2008 |
Q: what are the business applications of MS ACCESS?
A: Nash, They are limited only to non-internet use of less than 10-15 concurrent users. I personally ...
|
| Saving and editing data in table | 3/31/2008 |
Q: I have a table with such fields: Book, Book_author, Book_year. And now I am interested in making ...
A: Denis, Create a query on the table then use the form wizzard to make the form. Drag a command button ...
|
| copy textbox value to 2 fields in table on being primary key | 3/29/2008 |
Q: This is what i am trying to do: I am trying to copy the value in a textbox, possibly the first 10 ...
A: Chris, Here is the concantenation string: [PrimaryKeyName] = "0" & Left([FieldName],10) Bob ...
|
| criteria from form to query | 3/28/2008 |
Q: I have a query and want to establish criteria based on a combo box from a form. When I leave the ...
A: Chris, Use this in the criteria of the query: Like Pick List]![Combo17] & "*" I suggest a better ...
|
| new field | 3/27/2008 |
Q: I want to create a new field for customer numbers. I do not want to use autonumbering as I want to ...
A: Margaret, If there is more than one user adding a new record within the same minute, it gets more ...
|
| Access renewal report | 3/27/2008 |
Q: I have an access 07 database with the Asset template of which I have all our offices IT assets ...
A: Adam, Use this criteria in the RENEWAL DATE field in the query: <= ([RENEWAL DATE] - 30) to see all ...
|
| Inserting blank in number field in table | 3/27/2008 |
Q: I have a user who needs to insert blanks (can't do nulls) in a number field if the source is blank. ...
A: Dick, The numeric data type of size integer or long integer will accept a null value via an append ...
|
| MS Acess | 3/25/2008 |
Q: i have designed a query i need to pull result of this query from 1/03/2008 till today
A: Place >= #1/03/2008# in the criteria of the date field. Bob Heifler MyAccessProgram.com Find ...
|
| Parts Lookup using two criteria | 3/22/2008 |
Q: In order to look up a PartID and Price for a Part, I would like to use two unbound Combo Boxes to ...
A: Brian, Use the afterupdate event on the 1st combo box to reset the recordsource of the 2nd. My ...
|
| Auto resize line in report | 3/20/2008 |
Q: I have put two textboxes in detail section of report. One contains category and another contains ...
A: Sandip, Take out the box and place the line above not below so the memo can grow without hitting ...
|
| Checking names in tables | 3/18/2008 |
Q: On the access database i am trying to do the following, I need to check if the data being appended ...
A: Yu, Create a select query and on the Column 1 field set the criteria to: (NOT "budget") AND (NOT ...
|
| Access 2007 - Comma delimited field | 3/16/2008 |
Q: Is there a simple way to split a comma delimated field into seperate fields? For example, all of ...
A: Anita, Write a function to parse out your values using such Access functions as instr() and mid() ...
|
| query to show date greater than first then show less than | 3/16/2008 |
Q: I have a query where it pulls everything that is greater than current date but after those are ...
A: Jeff, That would be a separate new query with the less than sign < Date() instead of the > sign. ...
|
| unique number using combination fields | 3/16/2008 |
Q: I need to create tracking numbers for projects, by combining information from multiple (3) user ...
A: Martin, In the form's code module write a subroutine : Sub TrackingNo() [TrackingNoField]= ...
|
| Storing calculated values? | 3/15/2008 |
Q: It is my understanding that it is not good practice to store calculated values in a database. I have ...
A: John, You make a good point. Follow your correct evaluation on this and reject data that does not ...
|
| Query Help | 3/14/2008 |
Q: First some background, I have two tables called 2007 Grid and 2008 Grid, in these tables I have a ...
A: Suzanne, You would use append queries with the criteria you specified. I have free video tutorial on ...
|
| How to count Y and N in a report | 3/14/2008 |
Q: In an Access report, I am trying to count the number of projects that are covered with bond monies ...
A: Beverly, Make a derived column is a query, just insert a new column. Place this type of code at the ...
|
| Invalid Service Code | 3/14/2008 |
Q: I have a Microsoft Access table named "Good Service Codes" that has two columns. One is called ...
A: Looking for a null value in the outer joined table, the table with the join arrow pointing to it, ...
|
| Access 2007 | 3/14/2008 |
Q: I have built an access 2007 database for my company regarding fuel purchases for each vehicle in the ...
A: Derek, I suggest a field that contains last recorded mileage. When a new value is entered in ...
|
| Invalid Service Code | 3/13/2008 |
Q: I have a Microsoft Access table named "Good Service Codes" that has two columns. One is called ...
A: Douglas, If your left outer join is including all records from Excel source and only ones that match ...
|
| generating invoices in access | 3/13/2008 |
Q: i have a clients table for the different companies, an epmloyeees table which has employee details ...
A: Link your customer, invoice header, and invoice detail tables in a query that feeds a report grouped ...
|
| Non-Matching value in SAM Testing | 3/11/2008 |
Q: I am doing SAM testing, SAM will not let me use Unmatched query wizard. I don't know what it wants? ...
A: Robert, You can exclude "Smith" by placing this in the criteria row of the field that contains ...
|
| other transaction aside from orders | 3/7/2008 |
Q: i sure you're very much familiar with the northwind database of ms access. i have the same database ...
A: Joan, Yes you will need a separate table for each area that requires many entities that will relate ...
|
| Query Date | 3/6/2008 |
Q: I would like to view employees in a report grouped by month. I am somehow failing to do this in the ...
A: Pride, Use the Month() function: Month[DateField] Use a report grouping based on this derived query ...
|
| linking a form to a Word document | 3/6/2008 |
Q: I am a relative beginner in database use and design. I am currently attempting to build a fairly ...
A: Jennifer, Word's mail merge has linking ability to a saved query in Access. Just set the criteria of ...
|
| Access Sorting Query | 3/6/2008 |
Q: Sample Table: Name Fruits Purchase_Date Benson Orange 01/02/2008 Benson Apple 03/03/2008 ...
A: Keith, If you use three separate fields in you table that store person, fruit, and date separately, ...
|
| Linking nested levels of data | 3/6/2008 |
Q: I hope you can help me. I've created a db for hardware tracking. I have one main table called ...
A: Donna, You need a , a join table which stores many to many relationships. This table stores the ...
|
| This record has been changed by another user since you started editing it. | 3/5/2008 |
Q: The problem that I have is that I created a form in MS ACCESS which has a liked table in MYSQL and ...
A: Elaine, You get this message when someone else has started an edit or has locked temporarily the ...
|
| Calculating sales tax | 3/5/2008 |
Q: I am from the UK and have created a database that works fine except for one thing. Our VAT rate (or ...
A: I handled that with string manipulation techniques using the following functions. cstr() ...
|
| Calculating sales tax | 3/5/2008 |
Q: I am from the UK and have created a database that works fine except for one thing. Our VAT rate (or ...
A: David, If you want to round two 2 decimal places, 2 digits to the right of the decimal point, you ...
|
| ms access | 3/3/2008 |
Q: what are the ms acccess features
A: Varma, For Access 2000-2003 here are the features: http://support.microsoft.com/kb/823089 For the ...
|
| Auto fill from a combo box | 3/1/2008 |
Q: I have populated a combo box on a page, with an ID number, Last name and First name. When you click ...
A: Mike, The visibility of the first column is controlled by the column widths property. To get a ...
|
| Date and time functions | 2/29/2008 |
Q: I have created a simple database for tracking trouble tickets in our office. I need to keep track ...
A: How is the elapse time computed now? Is it in a report query or is it updated with an update query? ...
|
| Date and time functions | 2/29/2008 |
Q: I have created a simple database for tracking trouble tickets in our office. I need to keep track ...
A: Steven, If you were to store the Start and also the End DateTime, then Running a DateDiff() function ...
|
| Checkbox Problem | 2/27/2008 |
Q: I've got a form in an ADP file that has a SQL table as it's record source. I open the form with a ...
A: Rebecca, A yes/no boolean field in Access uses -1 as the stored value for true and 0 for false. In ...
|
| Making an event for a specific text imput | 2/27/2008 |
Q: If you can help that would be great. I am looking to know if you can set an event up for a specific ...
A: Glen, Set your combo box "MyComboBox" limit to list property to true. There is an event called ...
|
| MS Access 2003 | 2/27/2008 |
Q: I am working to create a database that tracks our mortgage clients loans My goal is to create a ...
A: Miller, Place this code in the after update event of [ComboboxOne]: [ComboboxTwo].Requery Base the ...
|
| Last entry made to form | 2/26/2008 |
Q: Just wondering if it is possible to add a field to a form that records the record ID and the date in ...
A: Carla, The table that your form is bound to should have a unique record ID field, I use autonumber ...
|
| Forms | 2/26/2008 |
Q: i have designed a database to store employee details and the company assets e.g. laptops associated ...
A: Collen, First make sure your search controls are in the header section of the form. Leave the Record ...
|
| How do you set up a database for a questionnaire? | 2/25/2008 |
Q: I'm building a database for my questionnaire. I really don't know what to do. I want to make a form ...
A: Rizky, Create a table with three fields, Question Number ( Number data type of Integer or Byte size, ...
|
| ComboBox- selecting records | 2/24/2008 |
Q: I have a ComboBox that lists all active jobs- approx 200 records at any given time. The dropdown ...
A: Pass the first column's value to your query. This working example file will help. ...
|
| replacing autonumber | 2/24/2008 |
Q: i have been reading through a variety of tutorials for replacing access's autonumber, but none of ...
A: David, The Dmax() function can lookup the last, biggest number for you. The only problem you could ...
|
| Importing text | 2/23/2008 |
Q: Imagine one single text file that contains two different fixed-width databases such as the ...
A: Dirk, Good question! Create a link to the text file and don't worry about field/column names. ...
|
| a number of questions.... | 2/22/2008 |
Q: I am currently building a database for the company I work for. I have a computer programming ...
A: Since you are doing multiple criteria at once, I suggest you build SQL statements from what has been ...
|
| Updating data via query | 2/22/2008 |
Q: MS Access 2003, SP3 here I've got a table, imported from a txt file. It has header records, 1 to ...
A: You can create Alias field names for any columns in the select query that is using the linked text ...
|
| Updating data via query | 2/22/2008 |
Q: MS Access 2003, SP3 here I've got a table, imported from a txt file. It has header records, 1 to ...
A: Todd, Try linking to the text file. You can call the link the by the same name each time, even if ...
|
| Filtering selections on a form | 2/21/2008 |
Q: I am trying to create a seminar registration form with the following features. I would like a ...
A: Brodie, In the criteria of the query that feeds the second combo box you can point to the firstcombo ...
|
| GETTING THE MAX VALUE BETWEEN COLUMNS | 2/20/2008 |
Q: I'm new in using access. How do i get the max value from different columns in the same table as a ...
A: Noah, Create a derived column in a query: All_Values:Value1 + Value2 + Value3 ... Then make it a ...
|
| Appending Records | 2/20/2008 |
Q: I am trying to use an append query to append individual records from one form/table to another. I ...
A: Let's say the form has a field that identifies a unique record in the table that is the form's ...
|
| creating a drop down list in a query | 2/19/2008 |
Q: I am trying to create a monthly report, which can be broken down into regions areas by allowing the ...
A: Replace your criteria with a function you create to retrieve a Region value that you have set ...
|
| Multiple criteria in DLookup() | 2/19/2008 |
Q: I have a query called “Finishes” which stores the finishes for each room. E.g. Each room has a ...
A: Here is a much better approach. Use dropdown lists (Combo boxes) on your data entry form that is ...
|
| ms access - appending tables | 2/18/2008 |
Q: need to create one master table of 11 individual timesheets. the excel files are identical as far ...
A: You will need to link to the Excel files and using the link append the data to your Access table ...
|
| Access Query utilizing another table | 2/18/2008 |
Q: Using Access 03. I have two tables in my database. The first contains records on individuals (name, ...
A: Place both tables in a query. Join on last name and make it an outer join to table with just last ...
|
| dlookup | 2/16/2008 |
Q: This is an amazing forum and helped me so much with excel, now I'm trying to tackle access Please ...
A: It looks right but you could test it in an unbound text box first. You might want to even send ...
|
| microsoft access assignment | 2/16/2008 |
Q: i have 3 tables , one is customer, and the other two are order and product.how do i design an ...
A: Dee, Write a query that joins the three tables and supplies all that you want on the invoice report. ...
|
| Some help with MS access | 2/15/2008 |
Q: Is it possible in microsoft access to create several new records at once within a sub form based on ...
A: The answer to both questions is yes. They both require some coding. Bob Heifler MyAccessProgram.com ...
|
| Bring up reports in preview mode | 2/15/2008 |
Q: I would like to creat a button to bring the user back to the previous screen. Not sure what the On ...
A: Place this as the last line of code on your close or back button. DoCmd.Close acForm, "NameOfForm" ...
|
| Bring up reports in preview mode | 2/15/2008 |
Q: I would like to creat a button to bring the user back to the previous screen. Not sure what the On ...
A: Use: DoCmd.OpenReport "ReportName", acViewPreview Bob Heifler MyAccessProgram.com Find example ...
|
| Command button to return user to previous screen | 2/15/2008 |
Q: I would like to creat a button to bring the user back to the previous screen. Not sure what the On ...
A: If the previous screen is a form and you know it's name use: Docmd.openform "NameOfForm" If it could ...
|
| Combo box Null value - plus linked text boxes | 2/14/2008 |
Q: The issue I am having is two fold. I will try to break it into its component parts. Table 1 ...
A: Suleman, The error: "I get the error stating i cannot have a Null Value." is caused because you have ...
|
| MS Access | 2/14/2008 |
Q: I have a table of projects and one field is the customer name. I want to use a lookup table to ...
A: Ruediger, To order the displayed company names alphabetically in the combo box use a sorted query as ...
|
| acsess | 2/14/2008 |
Q: Basically I got a database and when i click on the products button the valuse is then added to a ...
A: Nin, Place a function on the after update event of the controls that would contain possible ...
|
| query | 2/14/2008 |
Q: I want to select a query which may return quite a few records. If I want to see only the last 5 ...
A: Copy the query and convert copy to a Group By query See greek sum symbol on tool bar. Use the Avg ...
|
| Combining Text Fields in Access | 2/13/2008 |
Q: Heifler, I have a table set up with 4 text fields of description for an item (sizes of the fields ...
A: Create an append query to populate your final table. Concatenate the 4 fields like this ...
|
| Input Form | 2/13/2008 |
Q: I have a database with two tables Customer info and Orders joined by a customerID key. What I'm ...
A: Invictus, So what you want to do is: Automatically fill in form information when an id to another ...
|
| Office Access Report | 2/13/2008 |
Q: I have created a table and form to record data for a simple survey. I have created options for each ...
A: Make a Female derived column FemaleCount:IIF(Gender = 2,1,0) Make a Male derived column ...
|
| MS Access query problem | 2/13/2008 |
Q: i need some help on how to use "if" statements in MS Access using queries. i am making a database on ...
A: Rafaya, Iif(date()>[contract renewal date]-31,"YES","Your message if not true") Bob Heifler ...
|
| Appending Records | 2/13/2008 |
Q: I am trying to use an append query to append individual records from one form/table to another. I ...
A: Elizabeth, Assuming you are executing docmd.openquery "Name of Query" on a button onClick event, ...
|
| Expressions in forms not showing on table | 2/12/2008 |
Q: I know that the question has been asked about why expressions made in forms dont show in the tables. ...
A: Glen, You need a bound control that will store the calculated value, for example total price. This ...
|
| Wizard | 2/11/2008 |
Q: When I click on my toolbox to add a button or subform. The Wizard doesn't automatically run. Why? ...
A: Janet, Find the toolbar icon of a wand with what look to me like stars below the wand. This will ...
|
| query | 2/11/2008 |
Q: query to list all database names in MSACCESS not the table names.I need to retrive the database ...
A: I just wrote this code for you and tested it. You could store the Access file name to a table by ...
|
| Incrementing Document ID Number without using Autonumber | 2/7/2008 |
Q: I am not a programmer but have managed to pickup some VBA code. My Question is I developed a small ...
A: Paste this code in a new module. If you want to set a form's text field to the next highest ...
|
| Incrementing Document ID Number without using Autonumber | 2/6/2008 |
Q: I am not a programmer but have managed to pickup some VBA code. My Question is I developed a small ...
A: Create a single text field (LastNo) - single record table. Enter 2700 in the record's LastNo field. ...
|
| Display data instead of ID nr | 2/6/2008 |
Q: My software is MS Office 2003. I have an Access database with a table with several lookup fields ...
A: Ermelinda, You will have to replace those form controls with combo boxes that hide the 1st column ...
|
| Updated Record Alert | 2/5/2008 |
Q: I was wondering if its possible to have a msg box pop up before a form loads that advises a user ...
A: Sure Natalie, You write some vba code on the form activate event that opens a record set on a query ...
|
| Forms - using postcode to populate other fields | 2/5/2008 |
Q: I am designing a database in which I need to fill out a series of geographically defined areas based ...
A: Chantil, You could use a combo box control on the form to automatically fill in the form's ...
|
| Combining Fields from Multiple Tables in Access | 2/4/2008 |
Q: I have multiple tables of contacts(2003Contacts, 2004Contacts, 2005Contacts, etc.)that each have a ...
A: Jeff, You need to create a union query. Make a separate query for each table, but give alias column ...
|
| Access 2003 Field List | 2/4/2008 |
Q: I built a form with an imbedded subform using the forms wizard. I have since added fields to the ...
A: Al, These new fields do not appear in your field list because they are not part of the query or SQL ...
|
| DSum | 2/4/2008 |
Q: I am creating a stock control database, in the database i will ultimately need to update the ...
A: Gareth, You named this derived column "Expr1". If you are appending this summ value, the append ...
|
| How do I print information just encoded in a form? | 2/4/2008 |
Q: I am currently developing an application using Access 2003. I need to print (that is, print the ...
A: Edwin, You will need to create a report based on a query that is filtered to the current record you ...
|
| Update question | 2/1/2008 |
Q: I have the following code Dim db As DAO.Database Set db = OpenDatabase("DSSW.mdb") Dim rs ...
A: The first problem I see is that you have set rs to two different sources and only the second source ...
|
| Subform | 2/1/2008 |
Q: Any help!!!! much appreciated...... I have a main form which is build up with a subform. The form ...
A: Jamil, Place this code in the OnClick event of the button on the record in the subform: ...
|
| Make Table Query adding a count field | 1/31/2008 |
Q: Using Access 2003, I am trying to create a Make Table Query which not only extracts sorted data from ...
A: Pete, You could store your last number used and the current date in a separate table. Then write a ...
|
| Help Ms 2000 | 1/31/2008 |
Q: To simplify : I have one table , consisting of 4 fields. The first field is named CustomerName and ...
A: Place criteria in each date field with the date you want that must match all 4 date fields. If you ...
|
| switchboard related... | 1/29/2008 |
Q: I am working on a .mdb that someone else had done(I am new to ms access). I needed to change a text ...
A: In form design view the design menu has a format menu with the Change To item to change a text box ...
|
| Query Solution including Medium Date | 1/28/2008 |
Q: Bob, My personnel database has a table that records business trips for employees, and includes ...
A: Tony, If you are searching on a date range use BETWEEN [Starting Date of Range] AND [Ending Date of ...
|
| Opening & Closing Balances Access 2003 | 1/26/2008 |
Q: I'm running a inventory system on Access 2003 and want to create monthly reports with opening and ...
A: Heather, If the sum of all incoming goods entered as positives and outgoing goods entered as ...
|
| subforms entry changes ALL records | 1/25/2008 |
Q: I have a set of tables that are accessed by forms and subforms. A couple of the subforms seem to ...
A: Check your Master Link Child link properties on all subforms. These properties control the linking ...
|
| 2 Table Form | 1/25/2008 |
Q: I am trying to create a form that will pull data based on a query for one table and then have a few ...
A: Joseph, Base your form on the table(Table2) to be updated. At the top of this form, create a combo ...
|
| access/vba | 1/25/2008 |
Q: I have an access database with test questions. Which are autonumbered. I am having trouble writing a ...
A: Access has a randomizer function called Rnd. It requires a seed number each time it's used. To ...
|
| Relationship btw form and subform | 1/25/2008 |
Q: I have a main form (stud_details) also I have a subform called (pay_det_sub). I want to create a ...
A: Yes it is necessary to have numhus value stored also in the subform table to create a relationship. ...
|
| SQL Statement | 1/24/2008 |
Q: Is there a function that will allow me remove preceding 0s in a text field escpecially where the ...
A: Not a single Access function. You will have to write a custom function which uses text string ...
|
| receptionist database | 1/24/2008 |
Q: At my work the receptionists need a database to log calls. Right now i have a basic one that just ...
A: My East coast friend and competitor Joseph Dean has an article on his site that goes over the ...
|
| vb.captions | 1/24/2008 |
Q: I have a messagebox that has two options. I don't want vbyesno but rather the captions to refer to ...
A: You are just limited to the Access constants when using Msgbox(), however people have suggested ...
|
| Tables | 1/23/2008 |
Q: Hallo, I am working with access 2003, I have a table called qual_hist. I have added a new field ...
A: Jamil, If you have set the forms recordsource to a query that is missing "qual_hist" this would ...
|
| combo box not selecting what i choose | 1/23/2008 |
Q: i am desperate. i have a combo box that for some reason does not let me select a couple names when i ...
A: It's possibly impossible for anyone to guess correctly what is happening here. Debugging for this ...
|
| Count IIF / Sum | 1/22/2008 |
Q: I am trying to tally the number of products that exist in a query. I have added a text box in my ...
A: Paste this is a query column header: ...
|
| Programming | 1/22/2008 |
Q: I am a beginner with programming... in other words, I have never programmed ANYTHING! But I would ...
A: Get a starter book on Access. Watch some free video tutorials on my site. Keep asking questions ...
|
| combo box | 1/22/2008 |
Q: Hallo, Simple question, is their a way of showing the value on the combo box without saving it in ...
A: Yes if the value does not have to be remembered from the last time you used the Access program. The ...
|
| Forms | 1/22/2008 |
Q: Hallo, I have a form (Qual_hist) with a field named Institution. Also, I have a table with all the ...
A: Here is how I would do it. Use a combo box bound to School_Code. Have a query based on ...
|
| Query and Date Ranges | 1/22/2008 |
Q: I'm trying to build a database to help with client management for my real estate business and would ...
A: Kelly, When you add multiple column criteria on the same criteria line it's saying (Use this ...
|
| Read from another form | 1/21/2008 |
Q: hallo, I have two forms, from one form I can navigate to the other form. What I want to do is ...
A: If the first form is still open you could place in the default value property of the 2nd form this: ...
|
| advantages of Ms access | 1/20/2008 |
Q: I am very much familiar with Ms Excel...and very new to Ms Access...can you just tell me that what ...
A: If you are real good with Excel, there is a lot of power, however the data on one sheet as it ...
|
| Subform/form tab question | 1/19/2008 |
Q: I designed a form with a subform at the top of the form. I need a way to tab out of the subform ...
A: On the lost focus of the last field on the subform use Forms![MainformName].setfocus you can then ...
|
| Split a date/time field in Access | 1/18/2008 |
Q: I am wondering if you can help me. I have linked tables from another database and have created a ...
A: The format function will allow you to parse out the date and the time in any format needed. Dim ...
|
| Prevent duplicat | 1/17/2008 |
Q: I have a form in which I registrate incoming cases (frmRegister), each case has a journanr which is ...
A: Lars, If journalnr is a unique primary key, Access will not accept a duplicate, but to get the ...
|
| Query Prompts | 1/17/2008 |
Q: I need to add a prompt that if the user does not enter a response to the prompt it will return all ...
A: You will be using a like operator before the prompt and a wild card after the prompt. Like & ...
|
| Date or Event Notification in Access | 1/15/2008 |
Q: I was wondering if there is any way to set up a notification or reminder based on a date in Access. ...
A: There is a function in Access that will allow you to add an amount of time to a date value. It's the ...
|
| Print Preview a Report from a Form | 1/13/2008 |
Q: I would like to open a Report from the Form automatically for a print preview. I have a button on ...
A: What if on the form with the button to take you to the report you just had a text box or combo box ...
|
| Query | 1/12/2008 |
Q: First of all I hope you have a good day. At ms access I've two tables; employee and list. Employee ...
A: Please pardon me if I have not duplicated what you want, but if you are trying to write a query that ...
|
| sort query by month | 1/12/2008 |
Q: I have a query that sorts out months in the following format: Field: Month ...
A: Use the Month() and Year() functions. Make year the first column and sort then Month. Bob Heifler ...
|
| Changing a password on a password-protected form | 1/11/2008 |
Q: Bob, I password-protected a form with the following code: Private Sub Command48_Click() 'Attached ...
A: You could create a table, call it PW for password, add a field called "Password". Right click on ...
|
| # of records in a query | 1/10/2008 |
Q: I have two tables with a 1:1 relationship where Table A has 1560 records and Table B has 1610 ...
A: I do not know what else could be causing this. Assuming that you are joining on a common field ...
|
| # of records in a query | 1/10/2008 |
Q: I have two tables with a 1:1 relationship where Table A has 1560 records and Table B has 1610 ...
A: What join type Equal or Include All in Table A or Include All in Table B. If you change the join ...
|
| Combo Box Drop Down List is Blank | 1/10/2008 |
Q: This situation happened on its own and affected other combo boxes in the form but not all of them. ...
A: At risk of getting a bad review, I would rather not just reject this or throw it in the pool for ...
|
| keeping related records together | 1/10/2008 |
Q: How would you keep family information together in order to print a family record. Say you enter five ...
A: Make a table tblFamily and a table tblFamilyIndividules In both tables create a field called ...
|
| How to create emails in Access | 1/9/2008 |
Q: and I need to create emails for managers containing a list of people who are delinquent on certain ...
A: I have an approach for you. Create a report based a query that uses for it's manager criteria a ...
|
| Locking Text Boxes | 1/9/2008 |
Q: I want to lock certain text boxes on a form if the record is not new. On a new Record I want to ...
A: Richard, Here is the code you need (Example uses a single text box call Text0: If Me.NewRecord Then ...
|
| Finding a table in Table Collection. | 1/9/2008 |
Q: How are you.I would really appriciate your concern If you please check out the code. I am trying to ...
A: It's the same code, but here is what I used to test. Dim dbs As Database Dim tdf As TableDef Set dbs ...
|
| Finding a table in Table Collection. | 1/9/2008 |
Q: How are you.I would really appriciate your concern If you please check out the code. I am trying to ...
A: It works for me. I just tested it in Access 97 and 2000 which had an Orders table. The "With dbs" ...
|
| Open report depending on table field criteria | 1/9/2008 |
Q: I'm relatively new to access and vb and was wondering if there is a way to write a case type ...
A: When an item in the combo box is selected, you should have in the column, all the information you ...
|
| Open report depending on table field criteria | 1/9/2008 |
Q: I'm relatively new to access and vb and was wondering if there is a way to write a case type ...
A: Create a query with required fields from the tables. On form create a combo box based on query. ...
|
| Check for Null Values | 1/8/2008 |
Q: Is there a way to suppress the messages provided by action queries so that the user does not have ...
A: There sure is. Docmd.setwarning False (Before docmd.openquery...) and Docmd.setwarning True after ...
|
| Search 2 Tables | 1/8/2008 |
Q: Lisa Sims' answer to this question ...
A: Side note reference first. Yes, try wild cards in some queries. Now How to make a search box on a ...
|
| Clearing a subform after the NEW button is pressed | 1/8/2008 |
Q: I am building an ACCESS 2007 soccer player database for our countywide soccer league I have the ...
A: When you go to a new record in the main form the subform will clear if it is linked on common key ...
|
| Query Calculation | 1/8/2008 |
Q: I am trying to create an expression within a MS Access Query, but am having some issues. I am using ...
A: If you are going to use group by you must group by all selected fields that are not derived by ...
|
| Query Calculation | 1/8/2008 |
Q: I am trying to create an expression within a MS Access Query, but am having some issues. I am using ...
A: This will work James: SELECT Table1.NumericValue, Table2.NumericValue, ...
|
| Update accross tables in msaccess | 1/8/2008 |
Q: I know this is probabally dead simple but it has been bugging me for a couple of days so if you can ...
A: Use an update query. Run it with docmd.OpenQuery "QueryName" Place this in an event such as a click ...
|
| Email filtered data on a subform | 1/7/2008 |
Q: Bob, I need to email information contained on a subform. I am using Access 2007 and have filters on ...
A: If you are letting Access control the data in the email instead of you controlling it using VBA ...
|
| Getting a default value from a previous form field | 1/7/2008 |
Q: I am creating a database to store several dates for a particular record. Once the first date is ...
A: In the default property of IC_training_date place this: [Training_date] or [Training_date]+3 if you ...
|
| Ranking in Databases | 1/7/2008 |
Q: I have a database which is linked to a VB application. The VB application calculates scores and ...
A: I would populate the Place field by opening a recordset on a query that sorted the Scores table by ...
|
| Novice User | 1/6/2008 |
Q: I am trying to learn access on my own. I have a very simple database, and I have written a report ...
A: Add a customer grouping to your report and in the customer grouping footer place an unbound text box ...
|
| Input Forms and Foreign Keys | 1/5/2008 |
Q: How do I create an input form in MS Access? and How can you determine Foreign Keys in a table ...
A: Just make a field in the table that requires a Foreign Key. It needs to have the same data type as ...
|
| Query for checking multiple fields in a row | 1/3/2008 |
Q: I have a table (Diagnosis Table)that has three fields (Diagnosis1, Diagnosis2, Diagnosis3) that I ...
A: Myra, Assuming you have created a table to receive these records, you would create three append ...
|
| Query for checking multiple fields in a row | 1/3/2008 |
Q: I have a table (Diagnosis Table)that has three fields (Diagnosis1, Diagnosis2, Diagnosis3) that I ...
A: Assuming that you can join the tables, create these three columns in a query: ...
|
| vba ms access 2007 | 1/3/2008 |
Q: I have a table that contains the following information. Name,Project Number,dateofwork, hrs worked ...
A: A criteria my have more than one parameter: Add to the criteria a date range restriction: ...
|
| Query | 1/3/2008 |
Q: It's me again...thanks again for your help earlier. I have another query that I need help in ...
A: Assuming that you can join the tables, create these three columns in a query: ...
|
| Total Time Calculation on screen | 1/2/2008 |
Q: I have a Start Time and End Time and I need to add a field on the Access form to calculate the time ...
A: You can experiment with this file using example 3. Please note that the datediff() function has no ...
|
| Access report question | 1/2/2008 |
Q: Happy New Year to you, I have a report that shows information about a person and it works if the ...
A: Assuming you have a table to store the names of the children that relate to the parent, you could ...
|
| Nested If Statements including AND | 1/2/2008 |
Q: I'm trying to build a query where I need multiple if statements with the condition of AND. For ...
A: Criteria: MyDerivedColumn:iif((not isnull([Field 1]))OR (not isnull([Field 2]))OR (not isnull([Field ...
|
| Display current rcord in form | 1/1/2008 |
Q: I am developing a access 2007 database which after entering data, the user presses a button that ...
A: You would want to create a query that uses for it's criteria the field on the form that makes the ...
|
| ElseIf using And | 12/31/2007 |
Q: I am using this code in the YrsCT texbox in the AfterUpdate event procedure property. I am using ...
A: It could be a number of things. Is YrsCT a string data type or numeric? You are testing it as a ...
|
| Dateadd function in Access | 12/31/2007 |
Q: In design view, I have created two fields Start date and Predicted Start Date. I am trying to use ...
A: You needed quotation marks around the ww weeks. Correct code is: [Predicted Start Date]= ...
|
| Help with DB relationships | 12/27/2007 |
Q: I've got an issue I can't seem to get around. I've got a linked table from and ODBC (tbl_1). I then ...
A: If you are sure that your forms and code are insuring that the unique primary and foreign keys are ...
|
| Unbound subform, textbox control source | 12/22/2007 |
Q: I'm pretty much a novice so bear with me. I've got several unbound text boxes on an unbound subform. ...
A: Referencing a control on a subform requires the full syntax which includes the Main form. ...
|
| Need help to create custom form to enter parameters | 12/22/2007 |
Q: Your Question was: Hi, I am designing a database for my school project regarding a bookstore. In ...
A: Create a new form, not bound to any table. Add textboxes for your searches. Then the code I gave ...
|
| Need help to create custom form to enter parameters | 12/21/2007 |
Q: Your Question was: Hi, I am designing a database for my school project regarding a bookstore. In ...
A: In the query criteria, if this is a string data type value, you could use this: Like Forms![Name of ...
|
| division by zero If statement | 12/21/2007 |
Q: I would really appriciate ur concern on this matter.please check out why this code still giving me ...
A: When your program executes: abc = c / d The d value is 0 and you can not divide by zero in the ...
|
| division by zero If statement | 12/21/2007 |
Q: I would really appriciate ur concern on this matter.please check out why this code still giving me ...
A: First convert all integer variables to zero if they are null. Do this by using the Nz() function. ...
|
| Data type mismatch in criteria expression | 12/21/2007 |
Q: I am getting the error 'Data type mismatch in criteria expression' for the statemant "Set Rst = ...
A: You have two data types on either side of >= that are not compatible. If Easy_no is a number and ...
|
| Deletes records in both tables when it shouldn't | 12/20/2007 |
Q: I have three tables: People (PersonID, Name, etc), ClusterAssignments (PersonID, ClusterID) and ...
A: If you remove the relationships this will fix it unless you have written code to cause this. I ...
|
| Passing Information from an option group to a list box | 12/19/2007 |
Q: On a form I have a list box which gets it values from a query. The query is based on a field name ...
A: You need to pass the letter value to a public variable in a module. MyPublicVariable = ...
|
| Ms-access dificulty | 12/19/2007 |
Q: I am creating complaint register in Ms-access. in this reg. i want complaint no. which is depending ...
A: Store the month and year as well as the number in separate fields, as well as the full concatenated ...
|
| Store calculation results in table | 12/19/2007 |
Q: In form design I have two boxes "Time of Diagnosis" and "Time of Catheter Insertion." Into each of ...
A: On the afterupdate event of [timeofdiagnosis] and [TimeCentralLineInsert] you could place this code: ...
|
| MS Access: running a macro from a form | 12/14/2007 |
Q: I am creating a form that will enable the user to run 10 different queries from one button. I have ...
A: VBA Code to place in the Click event of a button: docmd.setwarnings false 'to turn off the message ...
|
| MS ACCESS DLookup function in a query | 12/13/2007 |
Q: I have a simple lookup table with an integer ID field named "RoleID" associated with text string ...
A: Shouldn't SiteRoles_lut be the master contacts table name where you are looking up the role, or is ...
|
| Access Macro Help | 12/13/2007 |
Q: I am working with MS Access 97. I have a local database that was built, not by me, to pull all data ...
A: The “Division by zero” can be handled by first checking if the value if being divided by zero, using ...
|
| Access search function | 12/12/2007 |
Q: I am new to access, I have reverse engineered a sample db to do what I need it to do, except for one ...
A: I generally do not accept a db unless it is for paid service at www.myaccessprogram.com. Since this ...
|
| Calculated field | 12/12/2007 |
Q: I am using Access XP or 2002, Windows XP-Pro. I would rate myself as advanced beginner. With ...
A: Earlier Answer: IIF(type field)=1,Field A + Field B,A * Field B)Place this in your query. Please ...
|
| Auto Fill Field | 12/11/2007 |
Q: I have a form that I am using for Job Searches. I built a table with the list of all the sites I use ...
A: You are referencing the combobox just fine with: [combo33].column(1) You should have the following ...
|
| MS Access Report problem | 12/11/2007 |
Q: I have several reports in a database that are all opened by clicking on menu buttons. I have set ...
A: I have seen this happen. If the report is opened in design, it can lose it's page / printer ...
|
| Date Calculation | 12/11/2007 |
Q: I have a table with 3 fields of date info e.g. (12/01/07) meaning (Dec-01-2007) etc. I need to ...
A: Place this in the criteria of the date field: Between DateAdd("d",-15,[Enter Date]) And ...
|
| monthly membership renewal in ms access. | 12/10/2007 |
Q: i have an access database that has been designed very poorly. i'm a super novice that's trying to ...
A: Please state a specific technical question like: How do you... in a query? Supply all relevant ...
|
| search feature | 12/10/2007 |
Q: I was wondering if you could help me with a problem I'm encountering inside my DB. I have about 12 ...
A: This is a bit involved to do using messages like this. You need a search text box, and a reset of ...
|
| 1. COMBO BOX , 2. QUERY UPDATE | 12/10/2007 |
Q: I would highly appreciate if anyone can help me to sort out the following issues in MS ACCESS: 1. ...
A: Your first question is handled by using a "GroupBy" for the single column query that feeds the combo ...
|
| Comparing criteria in Access query | 12/9/2007 |
Q: Is there a way either in query or reports that I can compare two columns and if they match have it ...
A: Yes, in you query, create a column with this as the derived field: MyAnswer:IIF(G2=K2,"YES","NO") ...
|
| Video Shop System | 12/8/2007 |
Q: I have to create a video shop system in Access, I've done nearly all of it However I would like to ...
A: Guv, please send back survey so I can help others better. Here is your code to open MS Word: Sub ...
|
| Video Shop System | 12/8/2007 |
Q: I have to create a video shop system in Access, I've done nearly all of it However I would like to ...
A: I would like to send you a solution built inside of you program, it would be quicker than me ...
|
| Query for Report with multiple fields to search on | 12/8/2007 |
Q: I need to run a report that calls on data from three combo boxes in a form for three different ...
A: You can use this in the criteria field: Like [Forms]![Task Pop Up]![Combo14]& "*" so if the ...
|
| Access 97 | 12/7/2007 |
Q: I am stuck on this, and could really use some help. I have two tables; a "client table" with ...
A: Just another column in the query, but instead of it containing a single table field, it's values are ...
|
| Access 97 | 12/7/2007 |
Q: I am stuck on this, and could really use some help. I have two tables; a "client table" with ...
A: In a query, join the 2 tables by zip code. Click on the join line and select join type. Include all ...
|
| Sum a field based on another field | 12/7/2007 |
Q: now the sum of all the fees is added to the text box, which is read from the footer of the subform. ...
A: You need to store the data and fee in separate fields to easily do this. You can always use ...
|
| iif Zero Problems | 12/7/2007 |
Q: I'm having trouble with an access iif statement. My fields are :- Number of Opportunities Number of ...
A: Nest another IIF inside the first to check if "Number of Opportunities" is null using ...
|
| Update Query Based On Two Tables | 12/6/2007 |
Q: There are two tables, the Temp_Info and the Info. The temp_info is updated every day. The ...
A: At risk of a poor review, I will give this a try. The only way to join the two tables is by a ...
|
| sum a field in a subform | 12/6/2007 |
Q: Hallo, This is a really basic question but am new to access. I have a subform which is built up of ...
A: Call when you can. The #name is probably because the subform name is probably not the name you see ...
|
| auto calculated field on a report | 12/6/2007 |
Q: I have a report that I created in Access. I need to place a text box on the report for a report ...
A: There is a video on my site www.myaccessprogram.com on how to create a function and also on public ...
|
| Continued: Drop Down | 12/6/2007 |
Q: Had to open a new question of account of exceeding follow-ups. So right now in the After Update of ...
A: First, when I finish the record and create a new record, it doesn't save the "displayed" text to the ...
|
| missing data | 12/6/2007 |
Q: I have a tough problem that makes no sense and need your expertise to figure this out. I use a ...
A: If you want the data from the union query, change it from a select query to a make table query. If ...
|
| sum a field in a subform | 12/6/2007 |
Q: Hallo, This is a really basic question but am new to access. I have a subform which is built up of ...
A: Sorry, you are right, the subform will not display it's footer but you can reference the control you ...
|
| auto calculated field on a report | 12/6/2007 |
Q: I have a report that I created in Access. I need to place a text box on the report for a report ...
A: If your order or invoice table is already generating an autonumber, you could do this ...
|
| VBA Insert Into | 12/6/2007 |
Q: Bob, I have the following code in my app dbs.Execute " INSERT INTO Orientor " _ & ...
A: Suggest you create an append query and make each source column a reference to the form: A right ...
|
| Continued: Drop Down | 12/5/2007 |
Q: Had to open a new question of account of exceeding follow-ups. So right now in the After Update of ...
A: if supplier name is showing then the text box should show that value. Change to column(0) and see ...
|
| Continued: Drop Down | 12/5/2007 |
Q: Had to open a new question of account of exceeding follow-ups. So right now in the After Update of ...
A: The txtSupNam = [IntroSupplierID].column(1) needs to be entered in an event subroutine. When you ...
|
| Record Numbers | 12/5/2007 |
Q: The database I have created is for my training business. In the class form I have a sessions subform ...
A: Use dmax("[session_number]","session_table","studentid = studentid") I always us an autonumber data ...
|
| missing data | 12/5/2007 |
Q: I have a tough problem that makes no sense and need your expertise to figure this out. I use a ...
A: I just got your "memo corruption" data. That is the first thing I thought of but that corruption is ...
|
| stuck with wildcards | 12/3/2007 |
Q: I am stuck on one formula "expression" i can't get it to work and would apreciate your help very ...
A: Well lets take the 001 for example. To select all numbers that start with 001 in the T1 table, I ...
|
| Re: Populate a field in a subform | 12/3/2007 |
Q: I have a subform, which is build up of 3 fields Payer_code, Fee_Amount, Payer_Name. The name of the ...
A: "payer_name is the fifth field" is not important, look at the query that feeds the drop down ...
|
| stuck with wildcards | 12/3/2007 |
Q: I am stuck on one formula "expression" i can't get it to work and would apreciate your help very ...
A: There must be some mis-duplication on my part that cause this unacceptable help. If you do not yet ...
|
| Re: Populate a field in a subform | 12/3/2007 |
Q: I have a subform, which is build up of 3 fields Payer_code, Fee_Amount, Payer_Name. The name of the ...
A: If Payer_code is in the first column and Payer_Name in the second column of the drop down and the ...
|
| Creating Automatic E-mails in Access 2000 | 12/3/2007 |
Q: I am new to database design and am currently working on a database in Access 2000. What id like to ...
A: This question is a bit too complex for emailing back and forth between us. I am only able to answer ...
|
| Automatically create specific additional fields in a record | 12/3/2007 |
Q: I have an MS Access 2003 database with one table and one form which is used as a meeting log. Each ...
A: Possible, until you reach 255 fields. The tabledef object can have new fields added with the append ...
|
| Reg user level security | 12/3/2007 |
Q: I need your help in the user level security wizard. i created a database and i apply the user level ...
A: Vinod, Please read below, my first response, that this question is beyond my expertise, very sorry. ...
|
| Currency Format In A Concatenated String | 12/2/2007 |
Q: Using Access 2003: I have a concatenated string that contains a numeric amount. In the table and ...
A: If you have a decimal now in the sting, say 24.50, you could just concatenate the "$" & ..., but if ...
|
| Using Option Group values to create calculations in reports | 11/30/2007 |
Q: This issue involves 2 related tables. One stores my client information and the other stores ...
A: A rate table with hourly rate as one field and Nurse_Type (1,2,3) fields would help you create the ...
|
| MS Access Forms | 11/30/2007 |
Q: Bob, I am working with a Sign out Db that has one form within a form. When a person signs back in I ...
A: You need to get the user who is signing back in to see the subform record he used to sign out on to ...
|
| MS Access Forms | 11/30/2007 |
Q: Bob, I am working with a Sign out Db that has one form within a form. When a person signs back in I ...
A: If the form is bound to a table of data, the data is saved each time a field is updated on the form ...
|
| Access or Excel? | 11/30/2007 |
Q: I am building a db of data that is going to be used to make selections from data from a form that ...
A: You will capture what the user has selected via a form. You will use the transfer database method ...
|
| Linking a form to a query | 11/30/2007 |
Q: When I try to link my form to a query where it ask you to input a date, it is bringing it a "filter" ...
A: The form's record source is now set to a query that has a criteria that uses [Enter a date]? You ...
|
| Access or Excel? | 11/30/2007 |
Q: I am building a db of data that is going to be used to make selections from data from a form that ...
A: You are on the right track using Access for ease of data entry, validation of data, organizing data ...
|
| Adding a field to the field list | 11/29/2007 |
Q: I've created some fields in a table that I am currently using in a form. I later created another ...
A: If it is not on the field list, this means that the "Record Source" property of the form is showing ...
|
| DCount Function | 11/28/2007 |
Q: I am trying to count/find total issues using the DCount Function, but my query has a parameter. Can ...
A: First try this as a single derived column is a select query ...
|
| Help with a text box | 11/28/2007 |
Q: Is there a way I can show all of the words in a field when the database is in form view (and table ...
A: Expand a field, property box or text box to make it easier to edit Open a datasheet or property ...
|
| Employee/Schedule DBS | 11/28/2007 |
Q: I have a dbs that is used for employee information. We are beginning to use it for schedule ...
A: If you are storing in a table, Employee_ID, DayOfWeek, HourOfDay, you could easily get your answer ...
|
| Counting criteria in a report if met | 11/28/2007 |
Q: I have a database whereas some fields are empty. My task is to count in a yes/no, how many absences ...
A: Ok, let's say "AttendanceDate" is the date field and you want to count all fields where there is an ...
|
| Calculating balances | 11/28/2007 |
Q: One part of my database is to calculate balances. I'm thinking of doing it in a query. I have very ...
A: I would simple store all your transactions as a set of records with amount and transaction type ...
|
| Access97 combo box question | 11/28/2007 |
Q: Bob, I have 2 combo boxes and the first one functioned like I thought. It has one field and when ...
A: Not sure why you would not want the data insert after causing it. The only way I know to reverse an ...
|
| Access reports | 11/28/2007 |
Q: I am trying to put together a pretty complex report which was concatenating lots of fields (some of ...
A: The query has as it's first row "Field" which is the field name. Just let the field name be ...
|
| Access97 combo box question | 11/28/2007 |
Q: Bob, I have 2 combo boxes and the first one functioned like I thought. It has one field and when ...
A: That is how Access works, it shows only the 1st visible column. I assume that you are storing the ...
|
| stock take database and recording | 11/28/2007 |
Q: I want to put all stock info on database EXAMPLE: Barcode ID Make Model Colour. This will be a ...
A: Make a table with the 4 fields add a Inventory_ID field with the data type of Autonumber, and add a ...
|
| Queries that depend on form input | 11/27/2007 |
Q: I have a form (Form2) that has a combo box that contains differe locations (cmb_CitySate). When the ...
A: Assuming Form2 is open and the combobox has a value (IN THE FIRST COLUMN) that will give you a ...
|
| Using Checkboxes | 11/27/2007 |
Q: I have a project that I have been working on for a while. As I learn more, I make changes. I have a ...
A: First, don't worry about "result of calculated fields should not be placed in a table". You are ...
|
| Re: Click to transfer ID rom Combo box list to a field on a subform | 11/27/2007 |
Q: I have a form build up with a subform in access 2003. Then I have an Insert button on this form ...
A: Not sure I have it straight, but the syntax is ...
|
| Automatically updating data | 11/27/2007 |
Q: I'm constructing a database of network resources and devices and I'd like to automatically update ...
A: Join the tables on primary and foreign keys, select your criteria that you mentioned and change to ...
|
| Beginner. Need help importing sales information and managing duplicates. | 11/26/2007 |
Q: First I'm new to access. I have version 2007. I'm setting up a mailing list in our small office. ...
A: To prevent duplicates without having a unique single value for each customer in Quickbooks, you will ...
|
| work schedule | 11/26/2007 |
Q: I would like to create a database to help with nursing scheduling. Any help would be appreciates. I ...
A: First you need a Select query joining Employee and Schedule tables. I assume you have a unique ...
|
| ATTENDANCE SYSTEM | 11/26/2007 |
Q: I am making attendance module to store attendance of an organization. i have made the forms but the ...
A: A control would be any data entry field on a form. Bound means that it is connected to a field in a ...
|
| Repeats in Access | 11/26/2007 |
Q: I am creating two different databases for two completely different things, but the question is ...
A: Q1 Is there a way to overwrite the dates/dosages/meds etc and still keep the original data. A1 No Q2 ...
|
| ms-access | 11/24/2007 |
Q: I want to know all the basic calculations using in ms access. please tell me.
A: -/* All arithmetic calculations and Sum Average Count Standard Deviation See calculated as a key ...
|
| MS Access - Creating Tables | 11/23/2007 |
Q: Here goes: I have a table called Attendance. The primary key of this field is Attendance ID. It has ...
A: Ok Nikki,I would write a query that appends an attendance record for each session for each child due ...
|
| MS Access | 11/23/2007 |
Q: How to add new field in query with default value, not in table?? Suppose I have 4 fields in my ...
A: If the purpose of the query is to populate a data entry form, add the field to the table and on the ...
|
| MS Access - Creating Tables | 11/22/2007 |
Q: Here goes: I have a table called Attendance. The primary key of this field is Attendance ID. It has ...
A: I will need to know what kink of session. Providing you are not involved with Psychiatry or ...
|
| Multiple iff functions | 11/22/2007 |
Q: I'm having a hard time creating a formula with multiple IFF functions that will show qty x the ...
A: You can nest iifs but at the level of 4 nested iifs you might become to complex for the Access query ...
|
| Opening pop-up form from a subform | 11/21/2007 |
Q: I have a main form that contains a subform, with a one-to-many relationship between the two. On the ...
A: Dixie, Would you mind if I looked at your file and gave you a call? The syntax I gave you yesterday ...
|
| date picker in query | 11/21/2007 |
Q: Respected I have a db contains the training data of staff members for diffierent time periods. i ...
A: Access 2007 has a nice date picker that appears on forms with date fields. See MyAccessProgram.com ...
|
| help on database design | 11/20/2007 |
Q: I need to create a database for our 6 to 8 people to tracking time and cost spending on each ...
A: When they enter their name, in the study drop down list. only the study names of the user can be ...
|
| Prevent multiple instances | 11/18/2007 |
Q: I run an Access 2003 application in runtime mode (winXP). I want to prevent users from opening ...
A: What is runtime mode and you can set the mode to exclusive rather than shared. If the data is on a ...
|
| Add data from previous record if blank | 11/5/2007 |
Q: I have a table with "Date" and "Rate" fields. Not every record contains a value in the "Rate" field. ...
A: Manually you can: Repeat the value from the previous record In a field in a record, you can insert ...
|
| Image Scanning Database | 11/4/2007 |
Q: I am creating a database in MS Access 2003 for a school. The database will keep information on all ...
A: I will need the unique student record id field and the pictures files named using this unique ...
|
ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING
QUESTIONS