| Subject | Date Asked | Expert |
|
| Textbox in an Update Form | 11/6/2009 | Scottgem |
Q: I have 2 text boxes in my updatable form that I want ask about. 1st one is "Register Date" and the ... A: You still are making this clear. what you are saying doesn't sound logical. If you are saying that ...
|
| make table & checkbox controls | 11/6/2009 | Scottgem |
Q: I have a contract database that lists contract numbers, sections, and divisions (checkboxes). A ... A: First, your database is not normalized properly. By having fields for each division number you have ...
|
| Microsoft Access 2007 Form Editing | 11/6/2009 | Scottgem |
Q: I am trying to edit the borders on my forms. Normally when it pops up, the whole page is showing. I ... A: Access 2007 has two modes for displaying documents (forms, reports, queries, etc.); Tabbed documents ...
|
| Find Record Text Box Entry | 11/6/2009 | Scottgem |
Q: I have access 2007 and I would like to creat text box entry on the switchboard that would allow ... A: Very good. You referred to a document number, so I assumed it was a number datatype. I still think ...
|
| New Project added to old | 11/6/2009 | Scottgem |
Q: Good morning Scott. I have a database that is complete in Access 2003. My boss wants to add a new ... A: I suggest you read up on Normalization. Customer name should exist in ONE table and ONE table only, ...
|
| Find Record Text Box Entry | 11/6/2009 | Scottgem |
Q: I have access 2007 and I would like to creat text box entry on the switchboard that would allow ... A: First, you shouldn't use the Click event of the Text box, I said to use the After Update event. ...
|
| New Project added to old | 11/6/2009 | Scottgem |
Q: Good morning Scott. I have a database that is complete in Access 2003. My boss wants to add a new ... A: You should never use tablenames (or even fieldnames) to define data. If your database had been ...
|
| Find Record Text Box Entry | 11/6/2009 | Scottgem |
Q: I have access 2007 and I would like to creat text box entry on the switchboard that would allow ... A: Frankly I wouldn't do it that way, but you can by using the After Update event of the textbox. Use ...
|
| Columns in MS Access Form | 11/6/2009 | Scottgem |
Q: I have an assignment for my computer science class - we created a database in Access, and we have to ... A: I suspected you are using 2007. You have two choices here. 1) Redo the form using the Form wizard ...
|
| Textbox in an Update Form | 11/6/2009 | Scottgem |
Q: I have 2 text boxes in my updatable form that I want ask about. 1st one is "Register Date" and the ... A: First, the condition will never be true. Now() changes every tenth of a second. Second, I'm not ...
|
| Filtering Report by Form | 11/6/2009 | Scottgem |
Q: I am using a form to filter a report. On the form there are two unbound combo boxes to filter the ... A: If Not IsNull(ctl.Value) Then If sqlString <> "" Then sql String = sqlSttring & " AND " End If ...
|
| Link - Table & Form | 11/6/2009 | Scottgem |
Q: I created a update form for my table. In the form, I created a text box (client's name) which ... A: A bound control is one where the ControlSource is set to a filed in the form's Recordsource. If, in ...
|
| Access 2007 runtime and older versions of excel | 11/6/2009 | Scottgem |
Q: I have an Access 2007 database with VBA code to transfer specific data to an excel spreadsheet ... A: Yes that is a different issue. If you are using Office automation then you need to include ...
|
| Filtering Report by Form | 11/6/2009 | Scottgem |
Q: I am using a form to filter a report. On the form there are two unbound combo boxes to filter the ... A: I'm not sure why you are using the code you showed. What you need is something like this: Private ...
|
| Using an Access 2002/2003 database from a link on an expressions web intranet based system | 11/5/2009 | Scottgem |
Q: I have generated a link on the intranet site that is using a full UDC path. The database that I am ... A: I think you mean UNC path which is: \\servername\sharename\foldername\filename Is that what they ...
|
| SQL Table Structure to Access | 11/5/2009 | Scottgem |
Q: I am trying to assist a medical mon-profit that supports kids africa by building a database to ... A: Frankly, from what you are showing me, I would not try to recreate this schema since its not ...
|
| Columns in MS Access Form | 11/5/2009 | Scottgem |
Q: I have an assignment for my computer science class - we created a database in Access, and we have to ... A: What version of Access are you working in? Also, you don't put "fields" on a form. You place ...
|
| On dbl click open form where combobox value is equal clicked value | 11/5/2009 | Scottgem |
Q: when a project name in my continous form "Open Opportunities list" is double clicked another form ... A: You seem to have misunderstood my solution. The problem is that you are not using the WHERE clause ...
|
| Link - Table & Form | 11/5/2009 | Scottgem |
Q: I created a update form for my table. In the form, I created a text box (client's name) which ... A: Sounds like you created a "search" combo using the wizard. This creates an UNBOUND control so any ...
|
| Populate field in subform using combo box | 11/5/2009 | Scottgem |
Q: I am trying to redesign a current database using MS Access 2007. I have data from 3 tables ... A: I can understand showing units, but wouldn't the user be entering the quantity? I'm assuming here ...
|
| input data | 11/4/2009 | Scottgem |
Q: I have create text box on my access form. This text box allows users to input numeric data such as ... A: Ok, so I imagine the Rowsource of that Combobox looks something like this: SELECT CountryID, ...
|
| SIngle field entry for " what re you looking for" that will search 6 fields in database to find values that comntain parts of the info and return the records | 11/4/2009 | Scottgem |
Q: I have a very simple database that has a table that contains 10 fields. I would like to set up a ... A: The easier way would require a redesign of your database. If you have data fields in your table that ...
|
| setting out | 11/4/2009 | Scottgem |
Q: can you please guide me on the necessary steps in setting out? A: Setting out what? The more you put into a question the better I can help you with it. Also please be ...
|
| Generate Alphanumeric ID in Access Form | 11/4/2009 | Scottgem |
Q: I found where Scottgem had helped another Access 2007 user with generating an alphanumeric ID ( ... A: Do you have a control on your form named txtLngAutoNo? Is it bound to the ContractNumber field or a ...
|
| Generate Alphanumeric ID in Access Form | 11/3/2009 | Scottgem |
Q: I found where Scottgem had helped another Access 2007 user with generating an alphanumeric ID ( ... A: It would help to see exactly what you have done. If I follow you are using a button to generate the ...
|
| Multitable databases. | 11/3/2009 | Scottgem |
Q: My question is regarding MS Access multitable databases. Could you please tell me when it is ... A: What you need to do is read up on Normalization. This is a key concept in the design of relational ...
|
| ms Access | 11/3/2009 | Scottgem |
Q: I am having a record in a table and would like to edit that record and save it as a new record and ... A: Copy and paste the record as a new record then edit it. Hope this helps, Scott<> Microsoft Access ...
|
| report layout | 11/3/2009 | Scottgem |
Q: I have set up a database containing information on the projects we conduct (title of project, start ... A: First, Do you have only one table? If you do your database is not normalized properly and that is a ...
|
| function for my query | 11/3/2009 | Sayedaziz |
Q: I am sending you an image of my present query. You will notice that I have rows for ZONE "5+7" and ... A: Use Recordset then like : Dim rs as DAO.Recordset,rsPrevVal1,rsPrevVal2,rsPrevVal3 Set rs= ...
|
| Inventory tracking database | 11/3/2009 | Sayedaziz |
Q: I am very curious to make an inventory tracking database.I have created tables such as Product ... A: In my opinion Stock Table should be removed and add 2 fields in Product table like OpeningQty (every ...
|
| Queries in a table | 11/2/2009 | Scottgem |
Q: Scott, I have an "Events" table uses a separate "Companies" table for its company source (using ... A: You need to create a Top N of Group query. This article tells you how. You want to create the TOP 1 ...
|
| Help | 11/2/2009 | Bob Heifler |
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 ...
|
| embedding and making PDF files searchable | 11/2/2009 | Richard Rost |
Q: Beginner level I have too many magazines with only a few pages of projects of interest. I intend to ... A: My recommendation for any database like this is always to save the scanned images as FILES in a ...
|
| form fields | 11/2/2009 | Bob Heifler |
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, ...
|
| IF/THEN statement | 11/2/2009 | Scottgem |
Q: good day ok i know i made you crazy with me constantly asking questions but this time i got it ... A: Do you have a check box control named chkfamily on your form? If not, either rename the checkbox ...
|
| function for my query | 11/2/2009 | Sayedaziz |
Q: I am sending you an image of my present query. You will notice that I have rows for ZONE "5+7" and ... A: Run 2 update queries as follows : To change date 1 day earlier: ============================= ...
|
| Query before reporting | 11/2/2009 | Sayedaziz |
Q: I have more than 3000 data in a table in access. I have created a report format with which i can get ... A: I have uploaded a sample database at : http://rapidshare.com/files/301260984/Mahfuz.zip.html In ...
|
| access and expiry date | 11/2/2009 | Scottgem |
Q: I am a beginner Access 2003 user, I create a subform showing employees in company but each employee ... A: Use Conditional formatting, look that up in Access Help for specifics on how to use it. Hope this ...
|
| MS Access Cross Tab Query Reporting | 11/2/2009 | Scottgem |
Q: i want to make report for the tracked attendance which i stored in a table through append query. i ... A: First create a query that filters for the date range. In that query add a column with the ...
|
| A current answer you put up | 11/1/2009 | Scottgem |
Q: "Pop up form not in sync with current record: - Hello! I want to do EXACTLY what this guy wanted ... A: First I wouldn't use the Macro Builder, I would use the Code Builder. Second, no I can't tell you ...
|