About Experts Sitemap - Group 54 - Page 16 2015-03-24

Using MS Access: MS Access creating a multi-select list box, strsql, key field
strsql, key field, command button: The problem here is you shouldn t be putting all these selections in a single field. If you have multiple values associated with a record they should be stored in a child table. So your code, in the after Update event of the list box would look like this:...

Using MS Access: MS Access If Function, report header, format date
report header, format date, text frame: =Format(Date() + Choose(Weekday(Date(),vbMonday),1,1,1,1,3,2,1), dddd ) To test this Substiture a Date value for Date(). For example: Format(#11/20/09#+Choose(Weekday(#11/20/09#,vbMonday),1,1,1,1,3,2,1), dddd ) Hope this helps, Scott Microsoft...

Using MS Access: MS Access- Validation Rules, validation rules, microsoft access
validation rules, microsoft access, microsoft office: You can t do this with Validation rules. You need to use VBA. You don t have fields on a form, you have controls that may or may not be bound to fields in a table. This is a subtle but important distinction. In the After Update event of the second control...

Using MS Access: MS Report Design, report wizard, ms report
report wizard, ms report, access report: I suspect the problem here is your database structure. Structured properly this should not be a problem. You should have at least two tables. One for the people and another for grant deeds. You then join them in a query and use the query as the source...

Using MS Access: Multitable databases.
What you need to do is read up on Normalization. This is a key concept in the design of relational databases that has been in place for more than 40 years. The major purpose of normalization is to reduce redundant data. So the time to split data into multiple...

Using MS Access: ms Access
Copy and paste the record as a new record then edit it. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007 VBA One of the drawbacks of getting help on a site like this, is the answerer can only go by what you tell...

Using MS Access: New Project added to old, foreign key, primary key
foreign key, primary key, insurance broker: I suggest you read up on Normalization. Customer name should exist in ONE table and ONE table only, the Customer table. The customer table should have a primary key (not name) that would be used as a Foreign key in the Project table. NO, you have ONE project...

Using MS Access: Please help me, integrity constraints, customer table
integrity constraints, customer table, work assignment: is it homework or work asiignment. If it is work assignment then you should condsider for POS (point of sale) mode of payment Cash/Credit Card and qty available in stock. on your feedback I would be able to design accordingly. but just design no coding....

Using MS Access: Populate field in subform using combo box, combo boxes, control sources
combo boxes, control sources, text boxes: I can understand showing units, but wouldn t the user be entering the quantity? I m assuming here that you are doing an Order entry system. And that your Transactions table records the details of the order. I m also going to assume that the transactions...

Using MS Access: Problems getting forms to work., box id, many tables
box id, many tables, person id: First, you don t need another table. Vistors should be entered in your People table. You should have a flag in your table to indicate whether a person is a member of the church. Anyone not marked as a member is a visitor. Yes you can get the reports you...

Using MS Access: Protecting Record Sheets, code checks, checkbox control
code checks, checkbox control, excel spreadsheet: Yes, you can. Its not totally secure, but it will inhibit most people from doing so. In the ON Current event of the form, you use the Code Builder to enter code like this: If Me.closed = True Then Me.AllowEdits = False Me.AllowDeletions=False Else...

Using MS Access: how do i perform a Count(Distinct) query for 2 different column values using GROUP BY, greek letter sigma, sigma press
greek letter sigma, sigma press, summary query: Well, if you create a simple aggregate query and use GROUP BY for the Rollup and Gap, you can use the COUNT and SUM functions for the other two fields. To do this, use an Aggregate Query... also called a Summary Query or Totals Query. There is a little...

Using MS Access: how do i perform a Count(Distinct) query for 2 different column values using GROUP BY, query in access, column values
query in access, column values, source table: Actually I don t see two columns using DISTINCT. You are Grouping By Rollup_ID. You are counting GAP_ID then using the subquery to count REQ_ID, finally Summing the Cost. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: primary key and foreign key, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, table relationships: The primary key for each of your tables should be: Customers: CustomerID Sales: SaleID Orders: OrderID I don t understand what the difference in your database is between sales and orders, but if you have Customers and Orders, then the Customer table...

Using MS Access: Queries in a table, type mismatch error, company source
type mismatch error, company source, microsoft access: You need to create a Top N of Group query. This article tells you how. You want to create the TOP 1 of each company sorting by event date in descending order. Then join that query top your company query on CompanyID. Hope this helps, Scott Microsoft...

Using MS Access: Query Combo all values, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Sure, just add an IIF function to your query: =IIF(IsNull(Forms!MyForm!MyComboBox),X,Forms!MyForm!MyComboBox) Set X equal to your field name. This way, it will show all records if the combo box is NULL, otherwise it will set the criteria equal to your...

Using MS Access: Query for different records for identical data, query wizard, example plot
query wizard, example plot, acre plots: I m not clear what you want as a result. You can use the Query wizard to create a duplicates query. You can specify multiple fields to show the duplication. So if you specify Plot and Species, you will get all records that have dups in those two fields. ...

Using MS Access: Query before reporting, isnull, gotfocus
isnull, gotfocus, database option: I have uploaded a sample database at : http://rapidshare.com/files/301260984/Mahfuz.zip.html In this database you will find 3 tables tblUpzila/tblDistrict/tblDivision if you open frmZila you will find 3 combos each for upzila, district and division....

Using MS Access: Question about Combo Box Values, dlookup, combo box
dlookup, combo box, microsoft access: Why are you using Append and Delete queries? Just use an Update query and your problem goes away. Also, if your PK is an autonumber, the code should be: If Me.cboEmployee = 8 Or Me.cboEmployee= 9 Then One of the definitions of a PK is that it never...

Using MS Access: query for access 2007, homework questions, database view
homework questions, database view, quick response: Yes this does make sense, but in another way it doesn t. First, let me explain that I generally do not help with homework questions. Second, let me explain that I teach a course on using Access (In fact I just came from there). In my course I teach only best...

Using MS Access: query to trim decimal places, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You ll need to use the ROUND function to round off the number to however many digits you want, and then export that value. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT...

Using MS Access: Report Formating, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, page footer: I can t see your picture clearly, but if that s a REPORT footer, then it s going to appear once at the bottom of all your data. If you want it on the bottom of each page, you need to use a PAGE footer. Let me know if you have any other questions or comments....

Using MS Access: Retrieval of Records based on the Name in login Form, isnull, command button
isnull, command button, project details: First, if you are creating a database for personal use , then why would you need to have a logon. Obviously other people are going to use this. But what you want is easy. I do this fairly often. First replace the textBox for Specialist Name with a...

Using MS Access: rahul.dhoot@monsanto.com, column headings, grid format
column headings, grid format, field names: Not sure what you mean by field names listed vertically. Looking at the attached image I m not following your needs. Why would you want the rows to be field names? Its really not clear what you are trying to achieve here. I assumed the letters were values...

Using MS Access: recovering information, backup copies, external database
backup copies, external database, yahoo: yes this is possible. you can append records from external database to the current database. but before running append query be sure to make backup copies of existing database. if you feel problem in appening you can send me the last year database...

Using MS Access: report layout
First, Do you have only one table? If you do your database is not normalized properly and that is a big part of your problem. If projects can have multiple activities, then the activities should be listed in a separate table. Your report would then group...

Using MS Access: Save button is greyed out..., microsoft access, microsoft office
microsoft access, microsoft office, mvp: Ahh, Ok, first for those to be active, you need to have an object selected that can be saved. The Save and Save As options save an object as another type. But not the database file. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: Saving a query to be imported by another program, query filter, program question
query filter, program question, mdb file: And this goes back to my initial response. You need to contact tech support for this program. Either your third party software allows you to create a link to an Access object or it doesn t. For example, when you create a Mail Merge between Word and Access,...

Using MS Access: A Search Function in Access 2003, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, google search: There is a command button wizard for a simple search. If you want more customizability, you can use the Docmd.FindRecord command to perform a search in VBA. I m sure you can find the syntax with a Google search. I cover creating a custom search button...

Using MS Access: Search mode??, search mode, microsoft access
search mode, microsoft access, microsoft office: Well first you really shouldn t be entering data directly into tables. You should be using forms. But frankly, I m not clear what s happening here. Ma7 VBAybe a screen shot might help. Another possibility would be to create a new table, append all your data...

Using MS Access: Searching for a string in my access form that is made up of text and numbers., run time error, isnull
run time error, isnull, syntax error: The problem here is the value returned by cboSearchfield. As a rule its is not a good idea to put spaces in object names. Doing so has come back to bite you. If you have spaces in field names, but that s not what is being returned. So you have two choices....

Using MS Access: Sendobject to embedded adres, docmd sendobject, mail address
docmd sendobject, mail address, email access: Use either: DoCmd.SendObject acForm, Frm_sendmail , PDFFormat(*.pdf) , Me.EMail,,, Order by mail , , True or DoCmd.SendObject acForm, Frm_sendmail , PDFFormat(*.pdf) ,Forms!Frm_sendmail!EMail,,, Order by mail ,, True Whenever referencing a...

Using MS Access: 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, normalization rules, recordsource
normalization rules, recordsource, button search: The easier way would require a redesign of your database. If you have data fields in your table that refer to similar data, that is know as a repeating group and violates normalization rules. I suspect you should have TWO tables. Table one would have information...

Using MS Access: SQL Table Structure to Access, ms access database, hard palate
ms access database, hard palate, null parents: Frankly, from what you are showing me, I would not try to recreate this schema since its not normalized. Lets take the first table, basic_health_exams for example. What that table looks like is that its using fields names to define data, whihc is wrong....

Using MS Access: Sum Field in Reports, report wizard, recordsource
report wizard, recordsource, table structure: Well, this first indicates that your database may not be designed properly. If you have multiple fields like that, they usually should be in a child table. as a record for each score. Something like this: tblScores ScoreID (PK Autonumber) ParentID (FK)...

Using MS Access: select a record from combo box, dlookup, mouse pointer
dlookup, mouse pointer, static value: No, you don t. Since this is a calculated value, use a DLookup. Set The Controlsource of of a TEXT box to: =Dlookup( [Rate] , [Change Rate] , [Prod ID] = 2 ) There is no need to store this value since its a calculation. You use the expression above anyplace...

Using MS Access: No selectable user. Auto pull-up., recordsource, datasheet view
recordsource, datasheet view, command buttons: First, while I m perfectly capable of writing VBA code (I wrote a book on it after all) I don t use VBA where I don t have to. In this case you don t have to. Set the Recordsource for Form B to a query rather than a table. In the query set the criteria...

Using MS Access: setting out, microsoft access, necessary steps
microsoft access, necessary steps, vba: Setting out what? The more you put into a question the better I can help you with it. Also please be aware that a site like this is best used for answering SPECIFIC questions, not a general tutorial. Hope this helps, Scott Microsoft Access MVP 2007...

Using MS Access: IF/THEN statement, checkbox control, error method
checkbox control, error method, current event: Do you have a check box control named chkfamily on your form? If not, either rename the checkbox control or change your code to reflect the correct name of the control. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: subform links, record source, querry
record source, querry, microsoft access: Yes you are using subforms incorrectly. Also your form is designed incorrectly. You say the main form and subform 1 are bound to the same query . This indicates to me that you may have a multi-table query there. That s not the way to go. You should have several...

Using MS Access: summing data in a ranged query or report, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, greek letter sigma: To do this, use an Aggregate Query... also called a Summary Query or Totals Query. There is a little button on the query toolbar that looks like a wierd E (actually the Greek letter Sigma). Press that and you get a new Total row. Just add the fields you...

Using MS Access: Textbox in an Update Form, date control, register control
date control, register control, text boxes: You still are making this clear. what you are saying doesn t sound logical. If you are saying that the Register Date may be the same as the Actual Date and when it us you don t want to key in the same date twice, that makes sense and is easy to do. In...

Using MS Access: Time Calculation Using Access Query, kind reply, decimal portion
kind reply, decimal portion, dear scott: First, you need to understand how Access stores DateTime values. Access stores date/time values as a double precision number where the integer portion is the number of days since 12/30/1899 and the decimal portion is a fraction of a day (ex: 6AM or 6 hrs =...

Using MS Access: Time Duration, clock example, time duration
clock example, time duration, dispatch office: Yes that is what I needed. In that case its a simple subtraction: =[Time of Return]-[Time of Return] If the calls could go overnight then it would be more complex. You can use that expression as the controlsource of a textbox on a form or report. You...

Using MS Access: make table & checkbox controls, normalization rules, contract numbers
normalization rules, contract numbers, crosstab query: First, your database is not normalized properly. By having fields for each division number you have created a repeating group which violates normalization rules. You should have 2 tables here. One for contracts and one for contract divisions: Example:...

Using MS Access: total profit, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, math operations: Create a calculated field in a query: Profit:[Selling Price]-[Cost Price] It sounds to me like you just need to learn how to properly create CALCULATED QUERY FIELDS. You can make a query that will perform math operations for you automatically. Please...

Using MS Access: Unmatched records query problem, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, unmatched records: A Find Unmatched query will find records in Table1 that don t have a matching record in Table2, like Customers who don t have Orders. For what you need, it sounds like you should just link the two tables together in a normal select query and then compare the...

Using MS Access: Updating FKs in linked tables using forms, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, child relationship: As long as you ve created the relationships properly and set the MASTER and CHILD relationship between the forms, then the ID should populate automatically, but it needs to be on the subform. Just put the ID field on the subform and make it invisible (set...

Using MS Access: User-defined search, search criterion, multiple listing service
search criterion, multiple listing service, tool import: I ve used a variation of Don s concept in a number of apps. But I disagree with two of his processes. First, I would not use a subform here. I would put the controls where you enter criteria in the form header rather than using a subform. Second, I would use...

Using MS Access: Using an Access 2002/2003 database from a link on an expressions web intranet based system, using internet technologies, unc path
using internet technologies, unc path, web intranet: I think you mean UNC path which is: \servernamesharenamefoldernamefilename Is that what they are using? If so, that s not an intranet . An Intranet is using Internet technologies on a closed LAN. Scott Microsoft Access MVP 2007 Author:...

Using MS Access: Using a form for data lookup/entry, blank table, test pressure
blank table, test pressure, test records: You should set up a one-to-many relationship between your ValveInfo table and your TestRecord table. Each value is going to be tested multiple times, so this makes sense. Now, you really shouldn t need to pull up and store the value info AGAIN in the TestRecord...

Using MS Access: usage of ms-access in industrial engineering, management control systems, private fleet
management control systems, private fleet, meaningful statistics: Distribution ============ BACKHAUL. Use of a common carrier or vehicle from a private fleet for a return load to source after completion of a shipment. Maintaining data for all possible sources of distribution viz. Rail/Road/Sea/Air(rarely used due to...

Using MS Access: Validation rule in table, combobox, microsoft access
combobox, microsoft access, categoryid: Unfortunately, no I can t give you step by step, because I don t know how your database is designed. I can give you direction as I ve done. I can also flesh out some of the advice I gave, which I will. But you need to apply the suggestions to your own database....

Using MS Access: VBA, departure location, circular logic
departure location, circular logic, flightschedules: Try this: dtimesource = SELECT FlightSchedules.[Departure Time], FlightSchedules.FlightNumber, & _ FlightNumbers.FlightNumber, FlightSchedules.[Departure Location], FlightSchedules.FlightScheduleID & _ FROM FlightNumbers INNER JOIN FlightSchedules...

Using MS Access: Access 2003 Duplicating a record in form and corresponding subforms, strsql, related records
strsql, related records, foreign key: Take a look at the code more closely, especially the part After this comment: Duplicate the related records: append query. The first line refers to the Subform. It checks to see if there are any records in the subform. If there aren t then it generates...

Using MS Access: Access 2003 Query Logic / Buiding, query logic, 599cd
query logic, 599cd, tips access: You could try a DCOUNT function as a calculated field for each of these entries. Pull this data into a query. Create a new calculated field like this: Overlap: DCOUNT( ID , MyTable , Name= & NameField & AND StartTime = # & StartTime & # AND...

Using MS Access: Access 2003 - Query, greek letter sigma, sigma press
greek letter sigma, sigma press, salary changes: I would need to see your data to tell you exactly what s going on, but I ll assume that there is some field in both of your tables that relates the records together (EmployeeID, SSN, etc.) If so, just import both sheets into their own tables and then create...

Using MS Access: Access 2003 Run error message = Type mismatch, type mismatch, query design
type mismatch, query design, database window: Access is not the most secure platform. A reasonably knowledgeable Access user can get into see the actual tables. But there are some things you can do. First, is convert the MDB file to an MDE file. This psuedo compiles all your code and prevents the...

Using MS Access: Access 2007 - Adding photos to records, bmp files, decent photos
bmp files, decent photos, information answers: Actually I recommend using an Unbound Image control, definitely not a Bound object. But with Access 2007 the Attachment data type also works well even with JPGs. If you use the Unbound Image control,then you store the path to the image file as a text data...

Using MS Access: Access 2007 code question, code question, microsoft access
code question, microsoft access, vba: Access 2007 can be a little odd in running converted code. Try entering the code again. But that code should work. Except that setting the visile property to False hides the form and vice versa. Hope this helps, Scott Microsoft Access MVP 2007 Author:...

Using MS Access: Access 2007 embedded picture files, bmp files, report in access
bmp files, report in access, current event: In the On Format event of the detail band of the report use code like: Me.controlname.Visible = Me.yes/nocontrolname By the way all reports are bound, its only forms that can be bound or unbound. If you are doinf this on a form use the On Current event...

Using MS Access: Access 2007 Security, administrative powers, startup options
administrative powers, startup options, security question: You still have your accdb file so you can make changes and then convert to accde to deploy it. Also you need to split the database into a front and back end. The back end will contain ONLY the tables and be placed on a network share. The front end, which will...

Using MS Access: Access dates, interger, time element
interger, time element, query criteria: at the moment i do not have the file i sent you in this computer so i am unable to comment. send me the file back preferably in zip format. ******Additional******* Because Unique_Records_Query has 1 record for each date ************6th Jan,2010******...

Using MS Access: Access Form Question., microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You can use the DLOOKUP function to look up a specific value from a table or query. Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use DLOOKUP: http://599cd.com/tips/access/dlookup-function?key=AllExperts...

Using MS Access: Access fails to open, blank file, educational establishment
blank file, educational establishment, problem database: Do you have a backup? Does this happen on all databases? What version of Access? You can try holding down the Shift key as you open the file. If that works do a Compact and Repair. If that doesn t work, you can try creating a blank file then importing the...

Using MS Access: Access function same as Excel's SEARCH function, Instr, Instr()
Instr, Instr(), Instr function: If the field is on a form, a control, then this code will do. If [Field/Control Name] = 0 then msgbox It s a zero. end if If [Field/Control Name] = O then msgbox It s an O. end if If there is more than one character in the field/control, then...

Using MS Access: Access ldb file creation, user level security, vba code
user level security, vba code, creation question: Again, its not necessary. This is done automatically. Whenever you open an MDB file whether you open it from an Access front end or a VB.Net front end or whatever, a LBD is created in that folder. I doubt if the LDB was included in the installation, if it...

Using MS Access: Access Query, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, greek letter sigma: In Query1, make a calculated field to show the WEEK of the year for your date: MyWeek: Format([MyDate], ww ) Now, feed those results into a new query, and create an Aggregate Query out of it, using the GROUP BY function. Here s more help on Aggregate...

Using MS Access: Access Query Help, cukes, docmd
cukes, docmd, crop value: can you send me your zipped databse at aziz_abroad at yahoo dot com **********Solution*********** Private Sub cmdCopyData_Click() Delete records for House=1 DoCmd.RunSQL DELETE * FROM Cukes WHERE House= 1 And Crop = 1 Delete...

Using MS Access: Access Runtime, vba script, microsoft access 2003
vba script, microsoft access 2003, database microsoft: I m not sure what is causing the problem, but I will tell you that you are going to run into issues like this trying to design across different versions of Access. If you re going to be distributing the database to people using Access 2007, then you really...

Using MS Access: Access start-up misdirection, parameter value, test field
parameter value, test field, design mode: Often this happens because of a field name change and a query that uses the old name. YOu need to try to figure out where the enter parameter value is coming from and what field. I typically enter a unique number or test field and continue (if there are...

Using MS Access: Add a zero is a select query, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You re on the right track, but you might need to create a query for your data with the NZ function BEFORE you UNION everything together. That way the NULL values are replaced with zeros. Let me know if you have any other questions or comments. Also,...

Using MS Access: Apply filter on subform, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, recordsource property: Instead of setting a filter, how about changing the RecordSource property of the subform: SubFormName.RecordSource = SELECT * FROM MyTable WHERE FieldID= & ComboBoxName This is how I teach it in my Access 311 tutorial: http://599cd.com/site/courselist/access/topic-index.asp?key=AllExperts...

Using MS Access: Automatic Save-as, oscar dela hoya, mary jane smith
oscar dela hoya, mary jane smith, microsoft access: 1. Its possible but would require a LOT of VBA coding. For example. How do you parse the names when you have names like the examples you gave. Is Hoya the last name or Dela Hoya? What is you have Mary Jane Smith? 2. See my other response about having numbered...

Using MS Access: Autonumber formatting, key field, increment
key field, increment, digits: Is Field Size for autonumber ReplicationId ? If so you can not limit it to 5 If Field Size for autonumber is LongInteger, then it will start from 1(you can change the start value but it is somehow lengthy process) and with each increment of record this...

Using MS Access: autofill, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You can use the DLOOKUP function to look up a specific value from a table or query. Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use DLOOKUP: http://599cd.com/tips/access/dlookup-function?key=AllExperts...

Using MS Access: Calculating prior fields, laser printers, mdb file
laser printers, mdb file, day shift: If you have data in your table like : Date Printer Shift StartMeter EndMeter 01/12/2009 HP1 Day 1050 1100 01/12/2009 HP1 Night 1100 1190 Then you can just do it in report or in form I have uploaded a mdb...

Using MS Access: Combo Box, rules of normalization, combo boxes
rules of normalization, combo boxes, address problem: Yes, After you select the project, you can use a DLookup to set the Address: Me.cboAddress = DLookup( [AddressID] , tblAddress , [ProjectID] = & Me.cbo.Project) Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007...

Using MS Access: Combobox AfterUpdate trigger, msgbox, microsoft access
msgbox, microsoft access, current value: I suspect the problem is more the sensitivity of your keyboard or mouse. The mouse may be moving slightly causing the current value to be accepted as your entry. You could put a confirmation in the After Update event like: IF MsgBox( You have selected...

Using MS Access: Comparison of data, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, exact instructions: There is a wizard to create what s called a FIND UNMATCHED QUERY. Check the help system or Google for exact instructions. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT...

Using MS Access: Conditional quary design, scholarship selection, access queries
scholarship selection, access queries, priority basis: I m not sure what you mean by conditional query . A query, by definition, is a filtered view of data from one or more tables. Queries are used to return records that satisfy criteria used to restrict the records returned. The criteria entered as part of a...

Using MS Access: Control in a form, 6 digits, record source
6 digits, record source, dim rs: The above code is ok for retreving first 6 digit to match You should use recordset with table which is record source of the combo suppose your table1 is the record source of your combo Private Sub Barkod_AfterUpdate() Dim rs As DAO.Recordset...

Using MS Access: Copy field value, subform control, staff control
subform control, staff control, staff person: What are you trying to accomplish here? It looks like you want to do a search on a form using the Staff person on the subform. One way to deal with this is to set the default value of the staff control on the search form to reference the subform control....

Using MS Access: Copywrite symbol in label, ascii number, copywrite symbol
ascii number, copywrite symbol, microsoft access: I just tried it and it seems autocorrect doe3sn t work in labels or captions. What I did was was type what I wanted into a text box, then copy and paste into a label and that worked. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: Create input in table row based on input in other rows, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, barcode 39: Instead of making the barcode label with a formula in the control source of your text box, use an AfterUpdate event in one of your required fields instead - or even put it in the code for the button that the user presses to generate the label. Make sure this...

Using MS Access: Creating a Photo Database, printing data, ms support
printing data, ms support, image control: There is a third icon in the Control Toolbox. There is a Bound Object Frame, an unbound object frame and an Image control. In the attached screen shot, the Image control is on the bottom row, one from the right edge. The other two controls that look like pictures...

Using MS Access: Currency to string, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, currency value: You can put the code in the FORM or create a global module for it. I would suggest the latter. HOW you do that depends on what version of Access you have. If you d care to tell me, I ll give you more instructions. Let me know if you have any other questions...

Using MS Access: con't, forney tx, tax receipt
forney tx, tax receipt, mrs jones: Yes, Filter by Form will work, but there is even a better way. As I understand you, while the donor is on the line, they give you their City, State and Zip info and you select the grid. So what you want to do is enter that info ONCE in to the Donor record...

Using MS Access: Data input form, access vba programming, bound form
access vba programming, bound form, text boxes: Ok, first, I would have a third table to list the courses. Then tblTraining would look like this: TrainigID (PK Autonumber) EmployeeID (FK) CourseID (FK) CourseDate CourseHours etc. I would then set up your forms using the Form wizard like so. First,...

Using MS Access: Database relationships (VERY URGENT), database relationships, relational databases
database relationships, relational databases, foreign key: You really need to read up on normalization. You don t make a foreign key, a FK exists by function. You already have a FK by including the employee ID in the orders table. A foreign key is simply a field in a related table that stores the value of the primary...

Using MS Access: Decimals, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, len length: Round won t do it. Round will chop off any zeros after the decimal place. You could dynamically change the FORMAT property of the field to show the total number of decimal places you want: FieldName.Format = 0.00 However the problem is determining...

Using MS Access: Default settings, initial record, empty boxes
initial record, empty boxes, default settings: Hi Arial, You can set the Data Entry property of the form to Yes . After that, anytime you open the form, it will open with empty boxes to enter data. If you want to go to the last record, put this code the the On load event of the form: DoCmd.GoToRecord...

Using MS Access: design/query, software table, adobe reader
software table, adobe reader, word 2: you didn t write how you have stored data in table. i guess you have entered data as follows : ComputerA Adobe ComputerA Winzip ComputerA MS Word you should use table(tblcomputer) fields as follows (if you have only 3 softwares): fldComputerId...

Using MS Access: Erase Log in info from the Logon Box in Secure Database, setting, fields
setting, fields, erase: Resty, Setting the UserName field to an empty text string should do it. [UserName] = If you place the above line of code at the end of the code that logs the person on, the username will be erased. Bob Heifler MyAccessProgram.com DailyAccessTips.com...

Using MS Access: Excel's Like Access, conditional formatting, converting excel data to access
conditional formatting, converting excel data to access, table database: 1) No you can t add a comment to a field, but you can add comments to records. This can be done in several ways. 2) Yes, you can use Conditional Formatting or code to change the formatting of a control on a form 3) Yes, there are several audit trail...

Using MS Access: Excel's Like Access, conditional formatting, learning curve
conditional formatting, learning curve, table database: 1. You can create a MEMO field as part of your table so each record can have comments associated with it. It s not PER-CELL (field) like Excel, but you can have comments. 2. You can use Conditional Formatting in Access just like Excel. If you want to manually...

Using MS Access: Excel's like Access, table database, cell background
table database, cell background, yellow background: 1) Insert comment Like can be done in user interface (form and not directly entering data into table). table appears similar to excel work sheet but it doesn t have flexibility like excel has in its worksheets. but access is a complete database system that...

Using MS Access: Excel's like Access Database, table database, cell background
table database, cell background, access database: Hi Kev, Let me try your questions: 1. You add a separate field in the Access table to keep the comments. You can select data type as Memo - this way you can enter a lot of information in comment. 2. Access will not save color properties in table. You...

Using MS Access: Excel to Access Import with Transformation, drop column, dim rs
drop column, dim rs, rs1: Try with the following code : Private Sub cmdImport_Click() Dim rs As DAO.Recordset, rs1 As DAO.Recordset, rs2 As DAO.Recordset, varChk As String DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, Table6 , C:Base incidence.xls , True...

Using MS Access: Extracting data from a statement, description statement, component description
description statement, component description, microsoft access: Let me just make sure, The pattern is that the data you want is ALWAYS between the word DIA and BILLET? I would do this as a function since it will be easier to debug. Something like this: Public Function ExtractGrade(strDesc As String) As String ...

Using MS Access: essential after checked, isnull, textboxes
isnull, textboxes, microsoft access: Then I would put a SAVE button on your form. In the save button you would use an if statement to first check if the box is checked. If it is, then you nest an If...Else If something like: If Me.checkbox = True If IsNull(Me.control1) Then MsgBox control1...

Using MS Access: FIND statement, query post, mdb file
query post, mdb file, ms access: there is no A and B columns in ms access.columns in access are denoted by field name. can you send me the mdb file which has required postcode data in a table. aziz_abroad at yahoo dot com ********Solution********* try to replace Existing PC: field...

Using MS Access: Finding Record id from line of Report, command button, record id
command button, record id, combobox: even if you use command button on report, you will not get any benefit since it doen t have click event. The command button is only useful in Form. send me your database so that i cna suggest you the best available option. aziz_abroad at yahoo dot...

Using MS Access: Follow up, aggregate queries, time commitments
aggregate queries, time commitments, time projections: You ll have to get a little more creative then. You ll probably have to use a doman function like DSUM to add up the commitment field for each employee by dates. For example: X: DSUM( Commitment , EmployeeTable , EmployeeID= & EID & AND StartDate #...

Using MS Access: Form Edit, notinlist event, strsql
notinlist event, strsql, execut: A lookup table is just like any table except for its purpose. The purpose is to make sure input is standardized. So lookup tables generally have only 2 fields, a code and a description. So, if you have such a table, and you want the user to be able to add...

Using MS Access: Form Search Button, autonumber field, grey border
autonumber field, grey border, log id: Here is an example of my own code, with the code shown being generated by Access button wizard Private Sub Command46_Click() On Error GoTo Err_Command46_Click Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = [client_number]...

Using MS Access: Forms, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, intermediate user: Yes, absolutely. That s basically how Access works. You make a table, use the query to sort, filter, perform calculations, etc., and then build a form based on that query. Let me know if you have any other questions or comments. Also, be sure to visit...

Using MS Access: Subform Not Displaying to Some Users, good solution, 1280 x 1024
Using MS Access: Subform Not Displaying to Some Users, good solution, 1280 x 1024

Using MS Access: form combo box, relational database data, speedy reply
relational database data, speedy reply, med class: Again, you use a query. Look at the example of the RowSource. It includes the Medclass description. This is one of the powerful things about relational databases. If you use query design mode, you add all four tables to a query. Join tblPatient to tblPatientMeds...

Using MS Access: formula in access to calculate first week (Tuesdays)in each month, dateadd, first tuesday
dateadd, first tuesday, job: This is too complex for a simple formula. You need a custom function. This function: Public Function FirstDayofMonth(intYr As Integer, intMth As Integer, intWeekday As Integer) As Date Dim dteMonthStart As Date Dim intDayofWeek As Integer, intIncrement...

Using MS Access: Handling NULL value in MSAccess sql queries, queries in access, sql queries
queries in access, sql queries, exact figure: Your database isn t normalized properly. It should look like this: StartYear SalesMonth SalesAmount From there you can sum anything you want. For example: SELECT StartYear, SUM(SalesAmount) As SumofSalesAmount FROM table WHERE SalesMonth Between...

Using MS Access: Help with fields in separate records of a sub-form., appointment dates, study participant
appointment dates, study participant, study participants: Yep, you did go wrong, there is no need for another subform. All you need is to use a Combobox to populate the InterventionTypeID in tblIntervention on the subfrmIntervention. Lets get our terms straight here. its not called field key its called FOREIGN...

Using MS Access: Hiding screen when another screen is selected, visible property, vba
visible property, vba, dao: Hi Helen, There are many fixes for bugs in Access 2007. But I have not seen this problem before. When people had visible property problem in Access 2003, one of the suggestion was to create a separate code to make the form visual and call that code within...

Using MS Access: Inactive Records, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, inactive records: What do you mean by inactivate a record? Do you mean you want to make it so nobody can edit that record? If so, you ll need a little bit of programming. I would create a new field called IsActive in the table and form for that record. Now, in the OnCurrent...

Using MS Access: Item numbering, number increments, docmd
number increments, docmd, microsoft access: I rarely use macros as they are limiting. This should be done in code. This code should be triggered just before the record is saved or along with it being saved. So what you have is: Me.AgndL1Order =Nz(DMax( [AgndL1Order] , AgendaL1 , [AgendaL1]![ProjectID]...

Using MS Access: Macro Content Blocked, ms acess, center settings
ms acess, center settings, trust center: Sure, Make the folder the app is in a Trusted Location. Press the Office button (upper left corner) and press the Access Options button on the bottom og that window. On the left select the Trust Center then press the Trust Center Settings button. On the left...

Using MS Access: Making a command button that does two operations, combo boxes, command button
combo boxes, command button, search command: strSQL = [Caliber] = 38 SPL And [Bullet Weight] = 158 That s not valid as a recordsource. A Recordsource need to be the name of a table/query or a valid SQL statement. That s definitely causing the error. A Valid SQL statement is: SELECT fieldlist...

Using MS Access: Making a read only Access form, custom ribbons, design mode
custom ribbons, design mode, second person: First, Your database needs to be split. The tables will go in a Back End and everything else in a front end. The front end will be installed locally to each PC with the back end on a shared network drive. Second, under the Access Options when you press...

Using MS Access: MS ACCESS 2007: Picture image shows up with its file name under the image:, image bmp, image question
image bmp, image question, makato: Hi, I will not get that big file. I hope this helps: On form design view, right click on the picture and select insert object. follow through the steps. When you come to the Change Icon Screen, delete what is in the Label box. That should do it. I hope...

Using MS Access: MS ACCESS 2007: Picture image shows up with its file name under the image: One of fields are to show images. When I browse and point to the image (bmp file), the filed shows its image and its file name under the image. I just want to see the image only., image bmp, file bmp
image bmp, file bmp, recordsource: What do you mean by browsing. In Access there is no browsing. I think you mean you have field in table that has reference for the image file(.bmp). Also you didn t write what dta type you have against image field to store. the best way to store image...

Using MS Access: MS Access, mdb file, user level security
mdb file, user level security, acccess: Hi Zahid, As soon as MS-Acccess.MDB file is loaded along with it an .LDB file with the same name gets opened. This .LDB file consists only the names of users and groups who are using your .mdb file on a particular system. You user s aren t suppose to be...

Using MS Access: MS Access - Print Report in Quantity, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, report vb: Here s my secret: I create a TABLE to store my labels, then just copy and paste the label X times. When you run the report (which is based on that table), then X labels will be generated. You can ask the user how many copies they want with an InputBox command,...

Using MS Access: MS Access Reports, project commitment, initial problem
project commitment, initial problem, time range: Hi Barak, I guess you are trying to have a place for people to enter their information and want to be able to pull report by week/month etc. In order to achieve that, you will need to design forms for data entry. When people enter the data in the form,...

Using MS Access: ms access 2000, dd mm yy, ms access 97
dd mm yy, ms access 97, ms access 2000: You can use the After Insert event to do this. Something like this: Dim strSQL As String strSQL = INSERT INTO table (fieldlist) & _ SELECT fieldlist FROM table & _ WHERE keyfield = & Me.keycontrol & ; CurrentDB.Execute...

Using MS Access: Network Database, navigation pane, network database
navigation pane, network database, move data: 1. Not only will it work, but its the best way. After you move the back end to the network share, you relink the the front end to t5he new location. Then make a new accde to distribute to your workstations. I would recommend using Tony Toews Auto Front End...

Using MS Access: Number Generator Using DMax, auto id, number generator
auto id, number generator, microsoft access: I just recently put up a blog entry detailing the procedure. You can find it here: http://scottgem.spaces.live.com/blog/cns!AB37C52C6D3752C!180.entry You can t use an autonumber for this. You need to use an Integer datatype. Other than that, without...

Using MS Access: Personnel Reports, microsoft access help, aggregate queries
microsoft access help, aggregate queries, time commitments: YOu need to have the query containing a field which is unique to each person (person number, concatenated last and first name) and a field for week number. Create your own week number or use an algorithm such as http://forums.aspfree.com/microsoft-access-help-18/how-to-generate-weeknumber-and-begin-of-week-date-in-65766.html...

Using MS Access: Pivot table isn't saving date field, column headings, pivot table
column headings, pivot table, drop column: Hi Sean, It should be saving the dates with the right format in both the column heading and row heading of the pivot tables. Why it is not saving? That is strange. I am sorry, I don t have a definite clue. I am sure you have grabbed the column headings...

Using MS Access: Pls help me on below doubt-Urgent!!, access file, snap shots
access file, snap shots, hisham: Hi Hisham, Access is a database application. So, it is not like a text file. The only objects you can really read are the forms and the reports. Try to open a report or a form (if you have any), then you will see what it does. Data sit in tables. Queries...

Using MS Access: PO Report, requery, recordsource
requery, recordsource, c field: OK, First the code goes in the After update event of ProductDescription. Use the Code Builder. the line of code should be: Me.Ucost = Me.ProductDescription.Column(1) Use Intellisense! When you type Me. it will give you a list of objects, properties and...

Using MS Access: Problem in sql query using date criteria, date time picker, format dates
date time picker, format dates, query criteria: First, dates are not stored in an Access database as a date format. Dates are stored as a serial number representing the number of days since 12/30/1899. How that value is displayed is a matter of formatting. The default format for dates is a function of your...

Using MS Access: one parameter with multiple answers, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, automatic email: You could create a macro to loop through all of the records in the table or query, however I personally would recommend using a RECORDSET. It s a little bit of programming, but it s far superior. Here s a tutorial to get you started: Recordsets are basically...

Using MS Access: passing arguments to subform, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, access dlookup: There are a couple of methods you could use. The BEST method would be to use a DLOOKUP first to see if that record exists. It would be something like: X = Nz(DLOOKUP( ID , frm_memo , ID= & ID)) If X = 0 then record not found else record found...

Using MS Access: How to print results from a form (but not all the pages in the report), combo box, old dog
combo box, old dog, primary key: 1) make a report and place whatever info you want in report. Use the same recordsource as you have for your form 2) place a command button on form and in its click event use the following code : DoCmd.OpenReport urReportName , acViewPreview, , ProspectId=...

Using MS Access: Query, vehicle id numbers, fender number
vehicle id numbers, fender number, service dates: Yes and no. If you are using lookup fields on the table level, that is not recommended. This usually cuases more problems then its worth by masking what is actually in the field. All lookups should be done using list controls on the form level. You then use...

Using MS Access: Recordset not Updateable, recordsource, microsoft access
recordsource, microsoft access, two tables: I do not recommend using a multi-table query as the Recordsource of a form. Create a mainform/subform combination. Since there is a 1:1 relation you can make the subform appear to be part of the main form, buy removing borders, RecordSelectors and Nav bar....

Using MS Access: Reflect table records on a form as label colours in access 2003, openrecordset, endtime
openrecordset, endtime, a03: Ok, Then you need to cycle through all the controls. First create a query like this SELECT Seat, StartTime, EndTime, IIF(Startime Time() AND EndTime Time(),True,False) FROM table; Then use code like the following: Dim db As Database, rs As Recordset...

Using MS Access: Remove duplicate entries from access 2007, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, greek letter sigma: Charles, you can either REMOVE the duplicate entries using a Find Duplicates Query, or if you want to leave that data in the table and just count up the number of unique boxes just create an AGGREGATE query and GROUP BY the boxes. To do this, use an Aggregate...

Using MS Access: Report Design and Printing (cont'd), openreport, long integer
openreport, long integer, exact error: If POID is an autonumber then this code: DoCmd.OpenReport PO ,,, [POID] = & Me.POID should work, assuming that you have a report named PO and the control on your form is named POID. If you get an error message, please give the, exact error. If...

Using MS Access: Report Design and Printing, combo boxes, recordsource
combo boxes, recordsource, rough copy: First, A database is very different from a spreadsheet. So you need to break away from spreadsheet like thinking and think relational data. Second, I told you where to put the WHERE clause. its part of the DoCmd.OpenReport method. You add a button to the...

Using MS Access: Report Format, printing invoices, microsoft access
printing invoices, microsoft access, microsoft office: Ahh, Then I would have create a table like this: tblcopies CopyNum Put three records in that table with the values 1,2,3. Then add this table to the query the report is bound to ass an OUTER join, to any field in another table in the query. Set...

Using MS Access: Restaurant booking, designing a restaurant, double bookings
designing a restaurant, double bookings, time interval: Is this a school project? Because no restaurateur would ever ask a customer how long they plan on staying. You judge based on experience with the restaurant and size of parties. You don t need to redo your tables. Just make the changes I suggested and...

Using MS Access: One to One relationship for security, ms access database, db2 database
ms access database, db2 database, place buttons: Hi Jay, a. You can do that. b. Putting few VBA codes in form to get data to the tables is not difficult at all. You need to VBA little bit. c. You can remove it. Just put the form in design view and highlight the button/box and delete. You will be fine...

Using MS Access: relationships, medication info, patient thanks
medication info, patient thanks, bob smith: YOu can t. What you are asking is how to combine all of this into a single record e.g. single table. Consider just tables 1 and 2. There are multiple table 2 records, e.g. meds, for every table one record. Presumedly table three is the same. What you...

Using MS Access: relationships, medication info, table relationships
medication info, table relationships, query designer: The way you should have this set up is a ClientT table, a MedicationT table, and a HealthInfoT table. Each of your three tables will have a ClientID. In the ClientT table, this is your PRIMARY KEY. In the other two tables, it s your FOREIGN key. I m assuming...

Using MS Access: Searches, free microsoft excel, setting up a database
free microsoft excel, setting up a database, allexperts: Sorry for the previous answer… I accidentally hit SEND before I typed anything in. :) You can perform a FIND in Access by clicking on the little search button that looks like a pair of binoculars. You can search any field, or just a specific field. Without...

Using MS Access: Searching a database using mutiple criteria, city zip code, street suffix
city zip code, street suffix, search routine: None of that precludes using Filter by Form. I understand you are new at this. But did you even bother to search Access Help like I suggested? I really think the Filter by Form feature will help you. And I think you should at least give it a try before rejecting...

Using MS Access: Select on date, microsoft access, vba
microsoft access, vba, microsoft office: Select * FROM tblBoeking WHERE tblBoeking.expiredate = DATE(); NOW returns both date and time. if you just want to check a date use DATE(). Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007 VBA I m just curious...

Using MS Access: Send e-mail, microsoft access tips, e mail address
microsoft access tips, e mail address, free microsoft access: Yes, this is certainly possible using the Docmd.SendObject statement, however it s going to involve some programming to loop through your employees. You ll need a recordset. I cover this exact topic in my Access 329 class (well, almost exact - I send Purchase...

Using MS Access: Sending Email's from Access 07, e mail addresses, christmas carnival
e mail addresses, christmas carnival, mail settings: I do offer help outside the confines of this site, but on a fee based scenario. If you are interested, I can give you an e-mail to discuss that further. However, I ve given you a lot of very specific code samples. Looking at the screen shot, it appears...

Using MS Access: Seq #, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: This is going to require some programming. This tutorial should get you started: http://599cd.com/tips/access/incrementing-your-own-counter/?key=AllExperts Let me know if you have any other questions or comments. Also, be sure to visit my web site...

Using MS Access: Seq #, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Sure, you CAN do it, but I ll warn you it s going to be complex and will involve some programming. Here s a tutorial that explains how to do something similar: http://599cd.com/tips/access/incrementing-your-own-counter/?key=AllExperts Let me know if...

Using MS Access: Set Value Macro, sequential numbering, digit number
sequential numbering, digit number, current value: First, I question the need for sequential numbering in both cases. If you want to get the total number of employees or suppliers, then you just count them. If you want to sort employees by the order they were hired, then sort on Date of Hire. For suppliers,...

Using MS Access: Subform Not Displaying to Some Users, model access, blank area
model access, blank area, shared server: I really can t say why this is happening. Using a local front end should eliminate such problems. I would read up on locking in Access Help and make sure they have the same locking setup as other machines. Hope this helps, Scott Microsoft Access MVP...

Using MS Access: Sum expression, query design, select sum
query design, select sum, qoutes: Hi Al, You need to do a query like below. You can use type in SQL or use query design view to create the query. When you run the query you will have all Quality added. select sum([Quantity]) as Tot_Quantity from YourTableName; I hope this helps. Mar...

Using MS Access: Suppliers Form, variant data type, recordsource
variant data type, recordsource, project address: This probably has to do with the linking fields between main form and the subform as well as the Recordsource of the subform. Since you are using a junction table, the subform needs to be bound to that junction table, not the address table. If you want to...

Using MS Access: select table and subform, count column, recordsource
count column, recordsource, unpaid bills: Ok, so you only want to show shippers in the Main form that have unpaid bills? Create a query from the bills table that filters for unpaid bills and groups on shipper ID and Counts the ShipperID. Set the Criteria for the Count column to 0. Then create...

Using MS Access: If statement in Access 2003, excel vba, hospital appointment
excel vba, hospital appointment, patient appointments: First, for the golden key I suggest you read up on normalization. As you understand normalization more and more you will stop thinking spreadsheet and more database. For example; there are no such thing as adjacent rows in a database table. Database tables...

Using MS Access: summing total hours from time workorder report, recordsource, command request
recordsource, command request, datediff: Almost all my reports are based on queries. The recordsource is a query not the table. I prefer to do my calcs in the query. The reason you are getting this request is because you haven t identified a value named ElapsedMinutes so Access thinks you want...

Using MS Access: Table and Form, object names, table changes
object names, table changes, original guide: Yes, spaces in object names can come back to haunt you, partially because Access doesn t recognize them as object names without brackets around them. But I m even more concerned about the lack of normalization. Hope this helps, Scott Microsoft Access...

Using MS Access: Table and Form (cont'd), description description description, column count
description description description, column count, control source: Try the rowsource like this: Rowsource: SELECT Description.[Description ID], Description.Description, Description.[Price per], Description.Unit, Description.CompanyID, Description.[Product ID] FROM Description WHERE (((Description.[Product ID])=[Forms]![Guide]![combo15]))...

Using MS Access: Text Box, combo boxes, description table
combo boxes, description table, combobox: You should leave the number alone. If you want to display the number along with other data, do it in another control. You can then set the controlsource to: PHP & Format([numberfield], #,###.## ) Hope this helps, Scott Microsoft Access MVP 2007...

Using MS Access: Time Intervals, time intervals, time interval
time intervals, time interval, time label: No, the structure of the database is not a form. A form is an object that is designed based on the structure of the database. The structure of the database is the tables and fields within those tables. That s what I need to know. If your database was designed...

Using MS Access: Time Intervals, time intervals, daily basis
time intervals, daily basis, timely response: Did you follow my instructions to add a column to your query? What I gave you is a function like ANY function. You use it the way you would ANY function. A Dim statement is used to define a variable. So dteTimeSlot is a variable where I store the hour previous...

Using MS Access: True value in a lookup field, parent id, foreign key
parent id, foreign key, two tables: First, I do NOT recommend using lookup fields on the table level. They generally cause more problems then they are worth. Lookups should only be done on forms using list controls. Second, I m not sure I follow what you are trying to accomplish here. I...

Using MS Access: table design, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, firstname lastname: Well, if you could assume that every tennant would only have 3 or 4 dependents, then it would simply be a matter of adding more fields to your tennant table (dep1, dep2, dep3, etc.) However, some families now days have 9, 10, 12 children.. Just look at...

Using MS Access: Unbound Forms, combo boxes, data element
combo boxes, data element, combo box: It seems to me that if it worked once for ethnicity then you must have a syntax error in the Search Gender query. As I mentioned before, make a column in query search gender that sets a temporary field to the value of the combo box tempfield: forms! your...

Using MS Access: Using dates with forms and queries, between, date range
between, date range: Your two text boxes are not date data types so you will need to use a pound sign in the front and back of each date. Example Between #3/15/09# and #3/55/09# Converting to a date using cDate() would also work. Bob Heifler MyAccessProgram.com DailyAccessTips.com...

Using MS Access: VBA, ms access database, dialog box type
ms access database, dialog box type, database utilities: You should ask 1 question and not multiple questions bundled in 1 question. I answer your first question i.e. how can I create a Switch Board Manager? 1)First Create a Form 2)From Tools---- Database Utilities --- Click Switchboard Manager 3)Switchboard...

Using MS Access: Visible, Invisible property - for each record, address record, datasheet
address record, datasheet, name and address: I m not clear what the images are showing, especially since they are blurry. But I stand by what I previously said. Try not using a split form. If you want to be able to use a datasheet to search for records there are other ways. Hope this helps,...

Using MS Access: 3 tables 1 Form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: If you re a complete novice, then I have to warn you that you re not going to be able to do this easily. You might be better off learning that you can press F6 to move from one subform to another in an Access main form. If not, then you need to start learning...

Using MS Access: Access '07 Label Printing Errors, paul holt, mailing labels
paul holt, mailing labels, mailing letters: Sounds like you may have a missing Reference. What s happening is Access is not finding the Trim function. The first thing to check is to open the VBE (press Ctrl+G). Then go to Tools References from the menu. See if there are any missing references and uncheck...

Using MS Access: Access 200 VBA problem, MS Access, Access database
MS Access, Access database, MS Access: Alan Difficult to solve this one without seeing the issue of the blue boxes. I m loading images in my app, but am not seeing the same issue. It could even be something to do with Windows, but it is hard to pinpoint without testing the DB. Thanks...

Using MS Access: Access 2003 date field displays 12/30/1899, microsoft access 2003, field displays
microsoft access 2003, field displays, zero length: Then I would eliminate the assignment altogether: Private Sub BaselineStart_AfterUpdate() If Not Isnull(Me.BaselineStart) Then Me.ScheduledStart = Me.BaselineStart End If End Sub Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: Access 2007 Calendar Form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Setting up a complete calendar iin an Access report would not be an easy undertaking if you want it to LOOK like a properly laid out calendar. You d have to figure out the first day of the week, move over the right number of columns accordingly… it would be...

Using MS Access: Access 2007 Calendar, google search, date picker
google search, date picker, calendar icon: This is built in to 2007. If you have a control bound to a Date/time field when that control gains focus a datepicker icon appears next to the control. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007 VBA This...

Using MS Access: Access 2007 combo box on report, option box counts
option box counts: Darin, You can create 5 derived query columns, one for each option. CountOfA:Iif([FieldName]=1,1,0) CountOfB:Iif([FieldName]=2,1,0) etc.... You then set the query to a group by and place SUM in each of the 5 columns. The 1 s will be summed up to give...

Using MS Access: Access 2007 Macro, autoexec macro, microsoft access
autoexec macro, microsoft access, vba: What you should do (and what I have done in such instances), is create a front end specifically to run your autoexec macro. However there is one way to do this. You may need to create a VBA m,odule to do this and call it from your autoexcec macro. What...

Using MS Access: Access 2007 option group totals on report, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, allexpert: You mean if someone checks A,C, and E you want to just add those items together? Simple… put a textbox on your form (unbound) and use an AfterUpdate event in your group with a little math. You can use an AfterUpdate event to set values, change properties,...

Using MS Access: Access 2007 option group totals on report, allexpert, option group
allexpert, option group, table group: I m not sure what you are trying to do there. Again I would use a subreport based on a Group By query: SELECT optField, Count(PK) FROM table GROUP BY optField; This should give you a list of the options and a count of each record for that option. Then...

Using MS Access: Access 2007 & Query Wizard, query wizard, access query
query wizard, access query, access sql: George, hi, I rarely use the query wizard, so I am not the best person to ask: I do work mainly in SQL both in Access & SQL Server, so I would generate all my queries by writting them in the QBE interface, in SQL mode (like Notepad) The easiest way to...

Using MS Access: Access 2007 subform total by employee, history table, time days
history table, time days, spare moment: First, does the query work? Can you run the query with for form open and get the results for the correct employee? Two possibilities do appear. First, I did forget a close quote, but it goes AFTER the text string: [Restriced or Lost Days]= Lost time...

Using MS Access: Access, step direction, requery
step direction, requery, focus event: You have to make sure you select the tab page first. And if you chose the right linking fields it should work. If you are available now, and want to contact me via Windows Live (MSN) Messenger I will be availalbe for a while and we can work in real time....

Using MS Access: Access Combo Box Wizard, combo box, two choices
combo box, two choices, third choice: Dear Mirza, You need to base your form on a table instead of a query, cause Access assumes that you already are working on a filter. Or else you need to add a Search Combo Box in your forms header to search for a record. Let me know, Best regards,...

Using MS Access: Access Database, information plan, image button
information plan, image button, table structure: Ok, the way I would do this is actually with ONE form and subforms. I would us Client Information as the mainform. I would then add a tab control and put the subforms bound to Billing, Broker and Plan Specs on each tab. Since the subforms would be linked to...

Using MS Access: Access Database Importing from Excel, excel spreadsheets, type conversion
excel spreadsheets, type conversion, access database: Anna, It s possible the the incompatible data type is in an Access table that is to receive the import. If it s text data type, Access will not have a problem. You might have to first bring in the data as text then clean up the records that don t match...

Using MS Access: Access delete query, ms access, microsoft access
ms access, microsoft access, access database: Hello You could try creating a make table query out of the results. You would only need to copy the keywords column to a new table. Alternatively copy the records to a new table in datasheet view, save the table and give it a name. Now you would need...

Using MS Access: Access Expression, microsoft access, current date
microsoft access, current date, vba: As a general rule we do not store calculated values. So NextDataofService should not be a field in the table. I do need one more piece of info to give you a solution. What happens is LOF is No? Hope this helps, Scott Microsoft Access MVP 2007 Author:...

Using MS Access: Access Filter Help, accounting firm, microsoft access
accounting firm, microsoft access, vba: I think part of your problem is your structure. What I think you should have are two fields; ActualDueDate and OriginalDueDate. When the record is first created, you can automatically populate the OriginalDueDate with the ActualDueDate as they will be the...

Using MS Access: Access Form Data with a Query, control names, microsoft access
control names, microsoft access, vba: Any value in a control on an open form can be referenced using the following syntax: =Forms!formname!controlname So you would enter that into the criteria row for the appropriate column, of course substituting your actual form and control names. Hope...

Using MS Access: Access Forms VBA Code, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: A little AfterUpdate event should do it: IF ComboBoxName = Value 1 THEN MyField1.visible = TRUE MyField2.visible = FALSE Else MyField1.visible = FALSE MyField2.visible = TRUE End if You can use an AfterUpdate or BeforeUpdate event...

Using MS Access: Access Queries to Excel, access queries, office automation
access queries, office automation, microsoft access: To place multiple queries into the same workbook, requires using Office Automation. It is doable but only using VBA. I would suggest looking up Office Automation on Microsoft s web site as this is really more than I can cover here. Hope this helps, Scott...

Using MS Access: Access Question Involving DISTINCT, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: If by LINES you mean all of the fields, then just include those fields in your SQL statement. SELECT Field1, Field2, Field3 FROM Table Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute...

Using MS Access: Access search form, button wizard, database in access
button wizard, database in access, tool import: Ken, Bespoke search forms are about the most complicated functionality to develop, so if you are new to Access, this would appear to be somewhat unreasonable and impracticable. So what should you do ??? various options are: 1. Get trained up - long...

Using MS Access: Access text box, numeric data, alpha numeric
numeric data, alpha numeric, provider types: You should have a Provider Type table that lists the code and a text description. Then I would use a combobox bound to the ProviderType field. The relevant properties of that combo would look like this: RowSource: SELECT ProviderTypeCode, ProviderTypeName...

Using MS Access: Access - User ID, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, user level security: The CurrentUser() function does NOT return the user logged into Windows. It returns the user that is currently logged in to your Microsoft Access Workgroup file (MDW) which by default is Admin unless you create user logins. I recommend you create...

Using MS Access: Access use with calender, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, charity project: You might be better off using Outlook if all you re doing is scheduling simple trips for a few drivers. Yes you can do scheduling in Access. I cover it in depth in my tutorials - but it s not easy and will involve significant work. Let me know if you...

Using MS Access: Access VBA Code, access vba code, strsql
access vba code, strsql, form response: Try it this way: strSQL = INSERT INTO DrawingList (DrawingTitle) strSQL = strSQL & VALUES ( & NewData & ); CurrentDB.Execute strSQL The lack of spaces before the VALUES keyword would cause the SQL to not work. Hope...

Using MS Access: Accessing data from different data bases, record sources, record source
record sources, record source, microsoft access: Neither is a problem. You can use subforms to display groups of fields from various tabales. Or you can use DLookups to display values in a single field from a single record. You can create a query that joins data from different tables, even from different...

Using MS Access: Add new column in report based on a query, compact repair, control source
compact repair, control source, properties dialog: What version of Access? Compact and Repair is in different places. Sorry I don t know what I was thinking, Attach the file to an e-mail and send it to dafiles@optonline.net. Or, if you want, you can IM me using Windows Live Messenger (scottgem@hotmail.com)...

Using MS Access: Aggregating Tables, sequence fields, thanks for your patience
sequence fields, thanks for your patience, follow ups: The Me.Dirty = False goes immediately after the DMAX. This is so the record is committed after incrementing the sequence. So the code should look like this: Me.Sequence = NZ(DMax( [Sequence] , tablename . [CategoryID] = & Me.Category),0)+1 Me.Dirty...

Using MS Access: Aggregating Tables in MS Access, office sponsors, separate tables
office sponsors, separate tables, three tables: When you say that each table contains completely different records Do you mean that the table structure is different for each category, that different information is kept for each category? If that s NOT the case, then you should not have three separate...

Using MS Access: When to Allow Zero-Length or Nulls, normalization rules, blank value
normalization rules, blank value, redundant data: First, EVERY table should have a primary key field. I recommend using an autonumber. Second, I prefer to use a lookup table to select the phone type. That s personal preference on my part. Its not absolutely necessary, you can use a combo with a value list...

Using MS Access: Assign a bucket based on range of values, dim rs, zip zone
dim rs, zip zone, city state zip: This is not the proper way to do it. You shouldn t be storing the Zone, but calculating it on the fly. I would create a Custom function, something like: Public Function FindZone(strZip As String) As String Dim db As Database Dim rs As Recordset Set...

Using MS Access: Assign equal sections of a table, manual effort, column titles
manual effort, column titles, record source: OK, So only newly added records get assigned to an employee. First you should make a change in your structure. You shouldn t have Employee name in workingtbl, but instead use employeeID as your foreign key. So what I would do is create a module with a nested...

Using MS Access: Audit DB Access 2003, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, table relationships: It sounds to me like you need to learn a little more about the basic concepts of building a Relational Database, and making relationships between two tables. Watch this free tutorial on my web site for help with this topic: http://599cd.com/tips/access/relational-tables?key=AllExperts...

Using MS Access: Audit Trail Help, ctlc, audit table
ctlc, audit table, database option: Sorry, it took so long, but I think I found it. You set the Audit_ID field as a primary key. But the value you are supplying is the PK of the record you are recording a change for. Since you are appending a record for EVERY changed control, it will reject...

Using MS Access: Autofill data in a form based on selection made in Access 2007, combo box, column
combo box, column, combo box column: Sanjay, If you place the last end date in a column in the combo box, you can use the column property to get the value. It s zero based so column 3 would be referenced as [NameOfComboBox].column(2) Bob Heifler MyAccessProgram.com Contact information:...

Using MS Access: Automated Checkbox on a Form, record button, current event
record button, current event, microsoft access: Me is a shorthand way of specifying the current form. It is a substitute for Forms!formname. In more recent versions of Access its not 100% necessary, but I go back to when it was necessary. I still recommend its use, because it makes your code easier to understand...

Using MS Access: Automated emails from access 2007, barcode machine, email attachment
barcode machine, email attachment, barcode reader: Hi Swabra, I need to know what are the contents of your email, I assume its a report. -To send a report you can use the SendObject Action in the Macro to send your report as an email attachment. -To add the destination email address, you need to have...

Using MS Access: Automatically Displaying Records from one table in another table, expert user, displaying records
expert user, displaying records, service description: Ok, first you don t display records from one table in another table as your subject line asks. You can however display records from multiple tables on a form, using queries and subforms. Second, What you describe is an order entry application. Micorosft...

Using MS Access: Automatically saving a record to a report without add a new record, macro design, vba module
macro design, vba module, macro name: Open the module you saved and copy the code. Then open the property dialong for the button and select the On Click event. Delete what is in the box (should be the old macro name) and press the [...] next to the event. Chose Code Builder and paste the code...

Using MS Access: access 2003 message box, duedate, datediff
duedate, datediff, command button: Hi Eduard, 1. rename the macro to mcrOpenTop5 (say) 2. On your main form, in design mode, insert a new command button, either from the wizard, select the action as run macro, then select mcrOpenTop5 3. Or with the form in design mode, select the...

Using MS Access: When to allow zero length values or nulls, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Excellent question. See: http://599cd.com/tips/access/null-zls?key=AllExperts Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: putting ampersand in label, ampersand, microsoft access
ampersand, microsoft access, single one: The Ampersand is a reserved symbol used for concatenantion. So when Access sees it, it assume you want to concatenate. The solution is to double it. Type in 2 ampersands (&&) and Access will einterpret as the character and show a single one. Hope this helps,...

Using MS Access: Backup of Database, microsoft access, mdb
microsoft access, mdb, vba: You can use the CopyFile method to copy the backend file to a new location or name. FileSystemObject.CopyFile d:foldernameBackend.mdb , d:Backup Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007 VB...

Using MS Access: Blank lines between addresses, city state zipcode, zipcode field
city state zipcode, zipcode field, address fields: Hi Dee, I m assuming your report is based on a query which has the following fields as below: Name Title Address1 Address2 City, STate, Zipcode In your query this is what you should do: - Create a new field in your query which concatenates...

Using MS Access: Calculate working days and dont include public holidays, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, eday: After your SELECT CASE statement. If it s a holiday from your table, add or subtract days accordingly. I don t understand exactly what you ve got going on there, but that s how you d do it. Let me know if you have any other questions or comments. Also,...

Using MS Access: Calculated Fields, logical fields, microsoft access
logical fields, microsoft access, vba: A table with so many Yes/No fields is probably not normalized properly. Also, as a general rule we do not store calculated values. While its easy to determine if all the fields are Yes, I d like to see what your strucutre is to determine whether it should...

Using MS Access: Changing FontBold property on MouseMove, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, onmouseover event: I gave you a different answer a minute ago, but I just played with it and figured out an easier one: Just make the OnMouseOver event for the BUTTON say: Btn.FontBold = TRUE Then have the OnMouseOver event for the FORM ITSELF say: Btn.FontBold =...

Using MS Access: Changing FontBold property on MouseMove, mousepointer, mouse event
mousepointer, mouse event, mouse mouse: Hi Rajiv, Mouse Mouse Event can be programmed in several different methods for different objects. Pls refer to the following link to get the entire object specifications to be used for your scenario. http://msdn.microsoft.com/en-us/library/bb215225.aspx...

Using MS Access: Changing font on mouse move, mousemove event, mousepointer
mousemove event, mousepointer, btn: The answer is the MouseMove event and property. But frankly, I just tried to make it work and I couldn t get it to work properly. I understand what you are trying to do, but a user should be able to tell when the cursor is over an object and changing the object...

Using MS Access: Checkbox on form to change query data, sara jones, case engineering
sara jones, case engineering, privacy case: In other words, you want your report to display the words Privacy Case instead of the employyee s name? If so, you can use an IIF in either the report or query. Something like: IIF([checkbox], Privacy Case ,[Firstname] & & [Lastname]) Hope this...

Using MS Access: Choose Data Source based on Radio Buttons, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, table queries: With a FORM you could just dynamically change the RecordSource property, even with the form open: Me.RecordSource = NewTable However with a REPORT you can t do this once printing or previewing has started. This causes a problem. The EASIEST way...

Using MS Access: Choose Query (sort of), greek letter sigma, sigma press
greek letter sigma, sigma press, summary query: Brenda, all you need to do is create a query and RELATE StudentID from both tables together. I m assuming this is a one-to-one relationship. IF NOT, if you have more than one record in the enrollment table for each student, then you can use an AGGREGATE...

Using MS Access: Claim fees over time, dlookup, query return
dlookup, query return, insurer: You need to play around with DLookup to get the right record. An example might be: DLookup( [Fee] , TCCM_tbl_Fees . [Insurer] = & [Insurer] & AND [FeeValidFromDate] # & [ClaimNotifiedDate] & # ) You may have to use a query sorted by ClaimNotifiedDate...

Using MS Access: Clear Data on Selection, combo box, zero length
combo box, zero length, zero value: The value of True is -1 so that should explain the combo. Access stores dates by counting the number of days since 30/12/1899 so a zero value would be the date showing. Try using a zero length string ( ) instead of Null.Hope this helps,Scott Microsoft Access...

Using MS Access: Code for Opening PDF in Access, adobe reader 8, creating a batch file
adobe reader 8, creating a batch file, pdf in access: Kami, hi, 1. Try locating the PDF file in the D:Prog... folder and try running again... (it may be a network issue...) 2. Try creating a batch file with a single line D:Program FilesAdobeReader 8.0ReaderAcroRd32.exe U:Access Management FormsSafety...

Using MS Access: Collecting Data through e-mail using MS Access, google search, boolean field
google search, boolean field, check boxes: Yes, Access can have check boxes on forms and reports. You just need to create a boolean field and then use the checkbox tool to add it to the form or report. Since you are trying to do a questionaire, I suggest you seriously consider survey software....

Using MS Access: Combining .mdb form data, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, john smiths: You would need to figure out what your common field(s) are. Ideally, the customers would all have the same CustomerID which would be perfect. If not, you re going to have to try and link them together using other fields like address or phone number. I wouldn...

Using MS Access: Combo Boxes and Junctions, ms access help, combo boxes
ms access help, combo boxes, strsql: You added a missing piece of info here. I don t think you ever mentioned that this was a continuous form. I was going under the assumption that this was a single form. You are also saying now that the user shouldn t be able to edit existing records. This is...

Using MS Access: Combo Boxes and Junctions, combo boxes, trial request
combo boxes, trial request, request id: Ok, you are an intelligent person and I think your problem is getting initimidated by coding rather than trying to understand what the code does. So rather than give you a solution, I m going to try and help you see the answer. What you want to do is insert...

Using MS Access: Combo Boxes and Junctions, notinlist, combo boxes
notinlist, combo boxes, trial request: OK, so each trial is composed of a Product and a set of processing parameters. Each set of parameters may be applied to multiple products, and each trial can be composed of the same product but a different set of paramters. Then you need a table for trials,...

Using MS Access: Combo Boxes and Junctions, combo boxes, product ingredient
combo boxes, product ingredient, trial request: 1. Put a Unique multi-field index on the combination of the two FKS (ProductID and ProductprocessingID) that will prevent dups. 2. You could use a popup to call a form based on the junction table where the user can then make changes. Hope this helps,...

Using MS Access: Combo box, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Make a small form with a combo box on it to get the parameter. Then open the results with a command button. See: If you want to refer to a value on a Form, you can use the notation: Forms!FormName!FieldName You can use this notation inside of queries,...

Using MS Access: Combo box multiple entries, combobox, column
combobox, column, columns: Imran, You will need two controls on your form that are bound to two field names in your table. Let s call them Control_A and Control_B The first column in your combobox should be stored in the Combo control called Control_A the second column value in...

Using MS Access: Conditional numbering, mail database, occasional mistake
mail database, occasional mistake, incoming mail: I do not recommend using symbols in object names, That could be your problem. Try changing the control name to txtControlNum (I would also change the field name). Also, your criteria in the DMax is incorrect its should be: [Type] = R See if that...

Using MS Access: Connect email Capabilities to a form, e mail addresses, mail changes
e mail addresses, mail changes, check boxes: Did you try looking up Do While or Looping? Either should get examples of looping. But what you really want is to lookup help on the MultiSelect property of a listbox. That will get you an example of looping through the selected items. You can do this one...

Using MS Access: Contacts Database, Microsoft Access, Access
Microsoft Access, Access, Access Database: Sarah I m guessing that you could use the After Update event of the text box. Bring up the code window for that event and type in ListboxName.requery Hope that works For FREE Access ebook and videos click here http://access-databases.com/ebook...

Using MS Access: Count records of two separate fields, separate tables, microsoft access
separate tables, microsoft access, microsoft office: Ok, these are really two separate issues. The first, how many with the same name is easy. You create a query with whatever columns you need to dientfiy the record, including the two fields. You then add a column with an expression like: NameMatch: IIF([name1]...

Using MS Access: Create a Drill down for a form, perminant, recordsource
perminant, recordsource, combo box: OK, What I would do is put an unbound combo (no controlsource) in the header of the form to select a Program. I would then change the Recordsource of the form to a query based on the table. In the ProgramID column of the query set the criteria to: =Forms!formname!controlname...

Using MS Access: Create Primary Key & Index for Query and Query Table during Runtime, alter table sql, query table
alter table sql, query table, microsoft access: You can use an ALTER TABLE SQL statement to change a table that has meed created by a Make Table query. You can also do a CREATE TABLE to create your table and do an INSERT INTO rather than a SELECT...INTO. Usually, you generate and run these within VBA...

Using MS Access: Creating a checkin button, MS Access, Microsoft Access
MS Access, Microsoft Access, Access database: Hi I would add a yes/no column to your table. This will be the button that you click. Also add a date field to record the date of the check in. Bind the table to a subform and your check box will show for each reservation. In design view go into...

Using MS Access: Creating Fields Based on Two Parameters, code combinations, county names
code combinations, county names, normalization rules: Ok, first the main answer is that you should not have the county names in your data table. That would violate normalization rules. Your state-Country lookup table should be structured like this: tluStateCounty StateCountyID (PK autonumber) StateID (FK)...

Using MS Access: Creating a field from multiple fields, normalization rules, manhours
normalization rules, manhours, personnel requirements: Ahhh, so the 1-20 fields are an employee ID. I m still foggy on how the man hours are allocated. Are they allocated for the subsubproject or to each employee? I need that missing piece and then I can suggest a solution. Hope this helps, Scott Microsoft...

Using MS Access: Creating a query that does calculations between 2 tables, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, stock table: If you are new to Access, this is probably beyond what you should try right now before getting some good tutorials or books on Access. It is certainly possible to build a database with complete inventory management with Microsoft Access. However this isn...

Using MS Access: Creating Reorder Levels, stock database, microsoft access 2003
stock database, microsoft access 2003, inventory counts: Generally an inventory app has a Products table. One of the fields in that table will be a Reorder level. How you flag products that need to be reordered depends on the nature of the inventory app and your work flow. There are basically two types of inventory...

Using MS Access: Criteria [Enter Name:], microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, several different ways: You would need to build a small form with just your combo box on it (and perhaps a button to launch the query). You can refer to the combo box in your query as: =Forms!MyForm!ComboBox See this tutorial: If you want to refer to a value on a Form, you...

Using MS Access: Criteria in Query linked to Excel, requery, excel sheet
requery, excel sheet, microsoft access: Do you want to try and work this out in real time? If so, try contacting me thru MSN Messenger at scottgem@hotmail.com. I can then try to link to your machine and see if I can figure this out. Hope this helps, Scott Microsoft Access MVP 2007 Author:...

Using MS Access: calculation of time, datediff function, time notation
datediff function, time notation, difference in time: Use the DateDiff function. Get the total minutes difference. If you want to display the difference in time notation (hh:mm) Then divide it out. For example: Format(DateDiff( n ,[Signon],[Signoff])/60, 00 ) & : & Format(DateDiff( n ,[Signon],[Signoff])...

Using MS Access: How to change the recordsource of a Pivotchart form from another form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, recordsource: You can t call: Forms!frmPivotChart.caption ??? If you want to refer to a value on a Form, you can use the notation: Forms!FormName!FieldName You can use this notation inside of queries, other forms, or even reports. I have a free tutorial that...

Using MS Access: code required for DoUntil, transferspreadsheet, canned query
transferspreadsheet, canned query, apids: Not quite the code I would have used, but it should do. I think your problem is that you are using the IF statement to check if you should end the loop,, when the Do While condition already does that. Try commenting out the IF and see if it works. Hope...

Using MS Access: combining data in access., vba tips, don hi
vba tips, don hi, don don: Don hi, To help, I need to have details of the table specifications and the queries that currently perform the logging inserts In essence all you are going to do is to append additional columns to the logging table, and adjust the queries to suit......

Using MS Access: combobox, control source, source field
control source, source field, datatype: Hi enrico, sorry to mention but the entire process of fetching automated info is wrong and your question seems rather incomplete to understand what you really need to achieve. - You first need to identify if your source field from where your getting...

Using MS Access: counting in Ms access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, greek letter sigma: To do this, use an Aggregate Query... also called a Summary Query or Totals Query. There is a little button on the query toolbar that looks like a wierd E (actually the Greek letter Sigma). Press that and you get a new Total row. Just add the fields you...

Using MS Access: create a working inventory, expression builder, normalization rules
expression builder, normalization rules, relational databases: First, if you have a new question, please start a new question rather than use the followup option. There is a limit to the number of followups, so that could cut us short. Second, you need to read up on normalization, This is a essential design technique...

Using MS Access: Database Design, questionnaire responses, survey questionnaire
questionnaire responses, survey questionnaire, column text: Hi D, The easiest way is to set up a default value in the table supporting the questionnaire responses, so for example, you could have a QuestionnaireStatus column (Text) with a default value of Not Returned , and on submission this value gets changed...

Using MS Access: Database uploaded, point thanks, design mode
point thanks, design mode, microsoft access: Sorry I couldn t get to this sooner, but I just tried and it appears you are doing something on load to disable Design Mode. So I can t get into the design to see what the problem is. Can you remove that and reupload. Hope this helps, Scott Microsoft...

Using MS Access: DatePart or Datediff, datepart, microsoft access
datepart, microsoft access, vba: First, DatePart returns the Weeknumber within the year for a specific date. Not sure why its returning 53, but that maybe because Days is not a valid date value. Second, the question becomes what constitutes a week. Do you want to know the number of FULL...

Using MS Access: Datepart, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: I don t understand how you re calculating the week-part of a result that s a number of days. What exactly are you trying to derive? Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute...

Using MS Access: De-Select Default Text in Text Box, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, visual selection: I have no idea. Must be a quirk on your system. I even tested this code before I sent it to you and it works fine for me. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT...

Using MS Access: Decimal values in Access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Good question. See this tutorial: http://599cd.com/tips/access/round-int-fix/?key=AllExperts Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL....

Using MS Access: Desiging Form Filter from Text Box, double criteria, inputted
double criteria, inputted, field values: When building a WHERE clause, the field has to be the left part of EACH expression. So you woulde need top use: WHERE field = values OR field = value You have: WHERE field = value OR value However, these can get rather complex with multiple ORs...

Using MS Access: Designing and linking tables, physician participants, insurance contracts
physician participants, insurance contracts, insurance contract: You aren t over your head, you understood exactly what I said. You do need a table of Insurance companies. If you have one already then use that. If that table doesn t have an autonumber PK, then add one to the table. By the way I would not use names as a...

Using MS Access: Displaying multiple recordset results in a pop-up form, movenext, search button
movenext, search button, ms access: I don t think you re using the recordset correctly, but without seeing your database and ALL of your code, I couldn t tell you for sure. If this is just a search form, why not just return the results in a simple query? Why the recordset? Let me know...

Using MS Access: DLookup tip, numeric id, object names
numeric id, object names, numeric value: The issue here is not that the criteria needs to be a number. It doesn t. But you need to match the data that is stored in the related table. The ID field in your tblStates is obviously a numeric value. What I suspect is that the foreign key in your data...

Using MS Access: Document Timeline, microsoft access, access database
microsoft access, access database, ms access: Hello There may be an application out there, but I would not know as I don t tend to develop my own. I guess if you made your own you would need a table of employees and a table of steps. You could record the date and time of each step and then you would...

Using MS Access: Document Timeline, three tables, microsoft access
three tables, microsoft access, dear mr: I don t know of any. You can check the templates offered on microsoft.com, but I don t think there is any with that feature. But this is not a hard app to do. You would need three tables; tblDocuments with info about each document; tblEmployees with basic...

Using MS Access: Duplicate Rows in a Query, manhours, last question
manhours, last question, microsoft access: Phew. I m afraid just looking at that is not going to allow me to spot the problem. But what you might consider is building this slowly. When you have a query with a lot of joins, you can often have a cartesian join which results in duplications. So what you...

Using MS Access: data manipulation, manipulate data extract
manipulate data extract: Josephine, You can manipulate data within forms, tables, programming code, or by using action queries (Update, append, delete type queries.) You can extract data with queries and export data to other formats like Excel or Word. This can be done by sending...

Using MS Access: database design & form interface, interface question, recordsource
interface question, recordsource, patient visit: There are a couple of ways, but it really depends on your table structure. The record in the sync form should have a foreign key related to the record in the main form or vice versa. So what you need to do is pass the key value to the sync form to filter it...

Using MS Access: datepart, integer value, microsoft access
integer value, microsoft access, vba: I thought I answered this question before (see my answer on 2/4). The problem is that Days is not a valid date field. Days is an integer value counting the number of days between the two dates. If you want to know what week out of the year, then you have...

Using MS Access: datepart, nls api, datediff function
nls api, datediff function, string expression: Hi Paul, In a Medical Project it becomes very essential to identify your Working Calendar Schedule. Identify your first day of the Week and the First Day of the Year, then only will you reach a correct DAY for processing Medical records. Follow the settings...

Using MS Access: dates in Ms Access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Make the default value for that textbox: =Year(Date()) Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: default, microsoft access, vba
microsoft access, vba, microsoft office: Add a column to your query with the expression: fieldname: value For example, if you want to assign FiscalYr 2008-2009 to each record you are appending, you would use the expression: FiscalYr: 2008-2009 Make sure you map this to the correct...

Using MS Access: dmax function ACCESS, query design, rental database
query design, rental database, last date: While I don t mind helping, you do need to learn how to find things yourself. Access s Help screen are a very good reference tool. If you look up WHERE clauses, you could have found the answer. I m sure you actually have used a WHERE clause, you just may...

Using MS Access: duplicates in a form, notinlist event, master library
notinlist event, master library, database in access: There is a much easier way. Use the Combobox wizard and put a SEARCH combo (3rd choice) in the forms header. This will allow you to scroll thru the lists of course numbers, plus using Autoexpand to make a match. If the number is found, it will bring up the...

Using MS Access: Edit a record and save as new record, strsql, command button
strsql, command button, record button: If you are duplicating data like that, your database is not normalized properly. You really need to analyze your database strucutre and see how to normalize it better. If you want to post a copy of your relationships window I can advise on that further. ...

Using MS Access: Excel to Access, foreign key, database window
foreign key, database window, question thanks: You would use an update query. Something like this: UPDATE table SET table1.CustomerID = table2.CustomerID WHERE table1.Customername = table2.Customername; Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007 VB...

Using MS Access: one front end with multiple backends, backend databases, relational databases
backend databases, relational databases, object names: I understand your problem perfectly. But I m not sure you are understanding what I m saying. There are three ways one can design a database, the right way, the wrong way, and an in between compromise. Generally anything but the right way will cause problems...

Using MS Access: Less than or equal to, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Use IIF. ThirdField: IIF(Field1 Field2, Less Than , Greater Than ) You can use the IIF function to perform If/Then analyses on your data. Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use the...

Using MS Access: Field with incrementing number Access 2007, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, request entry: 1. Before Insert is a FORM event. Look at the form-level properties. 2. Yep. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: Field Validation, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, field validation: In order to have validation across multiple fields, you ll have to code it yourself in VBA. You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of other cool things. The major difference between...

Using MS Access: Filter by form and Display in a report, noobs, matching records
noobs, matching records, microsoft access: There is a problem with this. You can easily put a button on a form to set it to Filter by Form mode, but doing so disables any buttons on the form so you have to go back to the ribbon to apply the filter. You could create a toolbar that opens with the form...

Using MS Access: Filter by multiple fields in "OR" and select the highest priorty record, sql in access, abc 123
sql in access, abc 123, query filter: This article explains what you need: http://support.microsoft.com/kb/210039 You need to group by the person and sort by priority, then take the TOP 1 of each group. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: Filtering query results, max score, score value
max score, score value, light thanks: You probably do need to put the TOP 1 SELECT in a subquery for the ProductID column. I would test the query first to make sure it works at listing One record for each product, then put it in a Subquery or join it to the Product table on ProductID. The article...

Using MS Access: Flag yes/no field not saved until moving to another record, vba commands, focus changes
vba commands, focus changes, bound form: On a bound form, the current record is not committed until the focus changes to another record or the form is closed. If the record isn t being committed when the form is closed you may have code in the On close event preventing it. You can force a record...

Using MS Access: Follow Up, manhours, now20
manhours, now20, employee id: OK, That s what I expected. That you not only had 20 fields for an employeeID but 20 fields for man hours and # of weeks, etc. OK, users are going to need to adjust, but only slightly. I suspect that what you have now is a form with 20 rows of three controls...

Using MS Access: Foreign Key and Look up Table, lifetime id, address phone number
lifetime id, address phone number, physician insurance: Relationships between tables generally flow between the PK of one table to the FK of the related table. Relationships can be formal or informal (my wording). A formal relationhip is set in the Relationships window by dragging the key field from the parent...

Using MS Access: Form combo box to query injection, combo box, microsoft access
combo box, microsoft access, vba: Access has this built in. Use the combobox wizard and select a Search combo (3rd option). When you select a value in the combo, that record will be displayed on the form. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: Form won't allow fields to be edited, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, hidden flag: Check the AllowEdits property of the form. Make sure your underlying query is editable. Sometimes if you make a complex joined query, you can t edit the resulting recordset. Let me know if you have any other questions or comments. Also, be sure to...

Using MS Access: Format Function, vba module, formatted number
vba module, formatted number, sequential number: Yes no problem in including it in the RowSource. You can also include a field in the ORDER BY, that is not listed in the Fieldlist. Me.cboSearchReq.RowSource = SELECT PROJECTS.ProjectID, TypeRequested & - & Right(FYearReq,2) & - & Format(SeqNumReq,...

Using MS Access: Forms??, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, app version: I don t understand… how do you want to execute this? A drop-down list on a form is probably the easiest. In which case, you could execute a SEARCH or just OPEN another form and show that specific record, or even DLOOKUP the data. Let me know if you have...

Using MS Access: Create a Drill down for a form, john gault, ayn rand
Using MS Access: Create a Drill down for a form, john gault, ayn rand, atlas

Using MS Access: MS Access VBA Version incompatability, index field, initial thoughts
Using MS Access: MS Access VBA Version incompatability, index field, initial thoughts

Using MS Access: how to store calculation information from a form to a table
Using MS Access: how to store calculation information from a form to a table

Using MS Access: VBA Code in Form control, unique names
Using MS Access: VBA Code in Form control, unique names

Using MS Access: When a field is selected display background in color, MS Access, Access database
MS Access, Access database, Microsoft Access: I cover this in my video lessons, but you would do something similar to the following. If you go to the properties of the control, for example a text box. Look for the On got focus event. Click the small button next to it to open the code window. ...

Using MS Access: find record and combo box, recordsource, combo box
recordsource, combo box, microsoft access: Yes, For the third option to be present the form has to be bound to a table or query. Check the RecordSource for the form and you will see that its probably blank. As an aside, you refer to lookup fields . It is not recommended that you setup lookup fields...

Using MS Access: A function to find maximum value of a field, max salary, multiple records
max salary, multiple records, maximum value: Why not make it a totals query (View, totals) and then select Max for salary. If you want the max salary from multiple records for the same person, set the group by for name. If you want it max for all employees, don t have any group by fields. bo...

Using MS Access: function and table, dateadd function, openquery
dateadd function, openquery, docmd: You will need to trigger your update query by a button using the button s onClick event with this line of code: DoCmd.openquery NameOfQuery Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html Find...

Using MS Access: How to Generate a Unique 7 digit key starting at 1000000, Microsoft Access, Access database
Microsoft Access, Access database, Access DB: I ll explain how to do it with a sample and just apply the same to your application. 1) Create a new table and give it an ID field with an Autonumber and Primary Key. 2) Add other fields to it such as firstname, lastname etc...anything really. Make those...

Using MS Access: Generating ID Numbers Through a Form, microsoft access 2003, office sponsors
microsoft access 2003, office sponsors, docmd: Hi Kate Create a table to hold the last index numbers, viz tblIndexNumbers =============== Level1 - numeric - long Level2 - numeric - long Level3 - numeric - long Set the first numbers - a once off SQL: INSERT INTO tblIndexNumbers VALUES (100,200,300)...

Using MS Access: Grouping in Access Reports, report wizard, riverwoods
report wizard, riverwoods, microsoft access: Base the Report on a query. In the query add a column with the expression: GroupBy: Left([fieldname],5) Then use the Report wizard to generate your report and select that column as group by field. Hope this helps, Scott Microsoft Access MVP 2007...

Using MS Access: IIF function, iif, conditional column
iif, conditional column, query: Alicia, iif([waiver]=true and [academic]=true , Approved , Not Approved ) There you go. Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html Find example files at: http://www.myaccessprogram.com/Download.html...

Using MS Access: Incrementing a number in access, audit number, autonumber field
audit number, autonumber field, internal audits: First, users should NEVER directly interact with tables, that s just a recipe for disaster. What you are asking is pretty common and easy to do. Here s the way I do it in a similar situation. The first thing to understand is that your audit number is not...

Using MS Access: Invoices, microsoft access, access database
microsoft access, access database, access db: Hi What do you mean by multiple invoice items? I have an invoice system and it has one invoice per page. You can write a query which pulls many invoices for the report. For FREE Access ebook and videos click here http://access-databases.com/eboo...

Using MS Access: Item Numbers, sequential number, microsoft access
sequential number, microsoft access, vba: I would do this before the report. What I would tend to do is create a temporary table for the report s Recordsource. You would create a loop that would append one record for each item assigning a sequential number for the item. Hope this helps, Scott...

Using MS Access: insert into, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, strsql: Felix, glad I was able to help get you up and running! Enjoy. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: insert an incremental number in access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, access queries: Looks good. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts Cordially, Richard Rost 599CD...

Using MS Access: insert statement, normalization rules, lastname firstname
normalization rules, lastname firstname, survey answer: Well your first problem is that your tables aren t normalized properly. Having fields with numbers like Result1, Result2 is called a Repeating Group and violates normalization rules. A survey database has a specialized structure. What you should have is something...

Using MS Access: inserting into linked table, server back, bbb
server back, bbb, aaa: Lawrence hi, I don t have direct experience using VB, but I have had a similar type of issue whilst in an Access front-end on a SQL Server back-end, and the work around was to add the attrinute dbSeeChanges after the execute command, viz: ... sSQL...

Using MS Access: invoice problem, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: There is no automatically unless you MAKE it happen. You can use the DLOOKUP function to look up a specific value from a table or query. Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use DLOOKUP:...

Using MS Access: Keep items together in Columns in Access 07, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Use a Sorting & Grouping Level with a Keep Together setting. You can use a SORTING & GROUPING LEVEL in a Microsoft Access report to group various like information together in one section and perform calculations like SUM and AVERAGE. For example,...

Using MS Access: Line in Report upto Report Footer, footer section, page footer
footer section, page footer, detail section: Hi Hasmukh, BUT HOW TO GET VERTICAL LINES TILL THE END OF PAGE, WHEN FEW RECORDS ? - You need to insert your line in the Reports Footer. Also checkout the Reports Page Footer section since I m not viewing your report visually. - Also use the Can Shrink...

Using MS Access: Link Email to a Check Box on a form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: It s certainly possible to do this, but I can t explain it all here - it would take far too long. I do cover sending email from Access using Outlook in my Access 329 tutorial: http://599cd.com/site/courselist/access/access329?key=AllExperts Let me...

Using MS Access: Linked mssql database, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, ms access databases: You could do it with source code. I know there is ADO or DAO code (recordset stuff) that you could use to programmatically change the connection information. I don t have it on-hand, and it has been MANY years since I ve done it, but I m sure you could find...

Using MS Access: Linking Child/Master Fields, combo boxes, customer company
combo boxes, customer company, combo box: Try: [tablename].[fieldname] with the brackets. If you have spaces in object names (not recommended) you need to use brackets. And you can t use OR. Whichever combo you are using you need to set the linking field to that value. Hope this helps,...

Using MS Access: Linking one form field to multiple tables, boolean variables, data redundancy
boolean variables, data redundancy, boolean field: A large number of boolean variables is a typical sign of a denormalized database. That you have so many fields is not a sign that you can t normalize but a sign that you haven t normalized. I think your problem is not understanding the entity/attribute...

Using MS Access: Linking forms together, button wizard, table relationships
button wizard, table relationships, relational tables: You need to create a command button from your clients form to open up the billing form (tab) showing specific records - records for just that client. There is a command button wizard that will do this for you (open a form and show specific records). I cover...

Using MS Access: Linking to a linked table and a regular table, combobox, option one
combobox, option one, microsoft access: That s why you use a continuous form subform. The subform would show ALL the considerations assigned to a bank. Again, each record in the table would list one consideration. But you would have as many or as few records as necessary. Some of the advantages...

Using MS Access: Linking PDF's to a table, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Use an OLE object and paste a link to the file in there. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: List of value updatable, combo box, category table
combo box, category table, example request: Karima, I am doing a web cast Mar. 1st 2009 on this very area. You need to base your list on a table. This combo box has an event that will trigger code if the item entered is not no the list. This code, docmd.openform NameOfForm , needs to open the maintenance...

Using MS Access: limit amount of text, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, memo field: I would use a MEMO field. While it is true that you cannot specify a TABLE-level limit on the amount entered, you could always use an AfterUpdate (or BeforeUpdate if you need to cancel) event to check the LENgth of the text entered. Let me know if you have...

Using MS Access: limit text im memo field, fms inc, memo field
fms inc, memo field, ms access: Hi Ron, I m afraid you won t be able to do this in a memo field provided with MS-Access, but there ways of doing this using third party products from FMS Inc. Go to FMS.com for more info. Until then you could create few Text fields which can limit your...

Using MS Access: link types, query design, foreign key
query design, foreign key, man cry: There are two types of Joins in a SQL query; Inner and Outer. Within Outer joins, there are also two types, Right and Left. Joins with an arrow on one end are Outer joins in the direction of the arrow. An Inner join returns records where there is a match...

Using MS Access: log file, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Yes, it s possible. In fact, I spent a good portion of one of my tutorials covering this. It does involve some VBA programming and a recordset, but you could do it with an Append Query if you want to instead: http://599cd.com/site/courselist/access/access322?key=AllExperts...

Using MS Access: Merging .mdb files, query wizard, query design
query wizard, query design, mdb files: When you open Query Design, you first select the table you want to Append FROM. You then add the columns from that table. You then turn the query into an Append query and select the table you want to append TO. This should then list the fields in the destimation...

Using MS Access: Message box and opening a file in a query, obsolete version, access developer
obsolete version, access developer, flie: Yes but such would require an experienced Access developer to build it. In essence, you would write VBa code to run the query with the appropriate selection criteria. Then if there is a record returned, you would then need to determine the file name of...

Using MS Access: Moving test query to QDF, 599cd, select count
599cd, select count, test value: Simplify it first by making a query that filters your data, then make your QueryDef based on that query, not the table. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT...

Using MS Access: Moving VBA app from 2003 to 2007, useable area, background window
useable area, background window, navigation pane: Access 2007 no longer has the Database Window from previous versions. However it has a silmilar but enhanced feature called the Navigation Pane. You can press F11 to display the Nav Pane. If you want to learn more about it and how to use it, Look up Navigation...

Using MS Access: MS Access, colomns, daily numbers
colomns, daily numbers, google: On the form where the values are typed in, you can have an after update action that runs VBA code you create that updates the total field. Access has various functions for date manipulation. Suggest you google microsoft access weekdays or similar...

Using MS Access: MS Access - Reporting with multiple tables, invoicing system, roofing business
invoicing system, roofing business, additional works: You need to set up a SORTING AND GROUPING level for your report. See the free tutorial below. Also, on my web site I have tutorials for building a complete invoicing system in Access. You can use a SORTING & GROUPING LEVEL in a Microsoft Access report to...

Using MS Access: MS Access all read only now, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, ms access databases: Check the READ ONLY attribute of your database file (MDB/ACCDB) and make sure it s not checked on. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL....

Using MS Access: MS Access reports, margins, page setup, printer setup
page setup, printer setup: Karen, In the design view of the report there is a page setup where you can direct the printer specifications. Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html Find example files at: http://www.myaccessprogram.com/Download.html...

Using MS Access: MS Access Union Queries, union queries, sql view
union queries, sql view, place cursor: Shirley, You mean join not union Again, I think it has to do with the UNION If you join two tables where one record in the parent table has many child records in the other table, you can expect repeated data on the Parent table side. To check what your...

Using MS Access: MS Access VBA Version incompatability, tb index, error 3251
tb index, error 3251, red herring: If you select the library at the bottom of the window is a Location which tells you which file. I m also suprised you have never come across it. My book, has a section on References and using libraries. There are other good books on VBA that also have such...

Using MS Access: MSAccess Security, record additions, mdb files
record additions, mdb files, fastmail: Janise, Hi, You can implement Access security, which is not for the faint-hearted - see the security download on my website - www.gmjohns.fastmail.fm (or for a more recent edition, the Microsoft website) Alternatively, as a practical and simple way:...

Using MS Access: Ms Access 2007 - Requery does not work, requery, combo boxes
requery, combo boxes, exact code: Hmm, I ve never used that type of WHERE clause before. Suprised it works. I would use a NOT IN clause with a subquery. Not sure of the exact code since I don t know your structure. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: Ms Access combo box requery, ms access combo box, combo boxes
ms access combo box, combo boxes, select statement: I m not following you. Now, when I select another value in the first combo box, the second combo box does omit the new value in the first combo box, but remains as it is before. I don t understand the remains as it is before . If the value in the...

Using MS Access: Multiple combobox entries, combo box, sorry for any inconvenience
combo box, sorry for any inconvenience, exit code: When you define a combo box, you can define multiple fields of data to be displayed on each row of the combo box. This is the concept of columns. Yes, you select a single row. BUt if multiple data elements are displayed in each row, the use of columns allows...

Using MS Access: Multiple entries in one column in Access 2007, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, relational database design: This goes against proper relational database design. You should have multiple items stored in a separate table linked back to your main table. However, if you want to do this, there s nothing to STOP you - except the fax that a text field can only be 255...

Using MS Access: Multiple Values and Reports, state tables, 3nf
state tables, 3nf, database configuration: Hi Kate, Multivalue columns is contra the doctrine of 3rd Normal Form (ie. Normalised data) so for me, the idea would never be considered. Take time to perform a full analysis of all the data, how it is going to be used (through all stages of the application),...

Using MS Access: merging info from multiple fields to one field, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, four digits: Leave the data as it is in the table. Just make a calculated query field to assemble it as needed: FileName: IMG_ & PicNumber & .JPG Then refer to this when you export. See: http://599cd.com/tips/access/string-concatenation/?key=AllExperts...

Using MS Access: ms access query, MS Access, Microsoft Access
MS Access, Microsoft Access, Access database: Hello 1) Create a new field to hold the data. 2) Create what is known as an update query 3) Select your table Then use this SQL, but replace your parts in here UPDATE TableName SET TableName.FieldNameToUpdate = [FieldNameDataComesFrom]; 4)...

Using MS Access: msaccess prompt table name, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: It s not possible to do this without at least some programming. If you re a newbie as you say, I would recommend just making multiple copies of your query for now until you learn some VBA. Let me know if you have any other questions or comments. Also,...

Using MS Access: multiple databses, ms access databases, cnn cnn
ms access databases, cnn cnn, adodb connection: I often wonder why people sometimes go to such lengths. What you SHOULD be doing is splitting the database between a back end (just the tables) and a front end (everything else). You put the back end on a shared network drive and have the front ends linked...

Using MS Access: Null Value, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Your IF structure is wrong. IF condition THEN stuff ELSEIF condition THEN stuff ELSEIF condition THEN stuff ELSE stuff END IF You should also consider using a SELECT CASE statement for something like this. Let me know if you have...

Using MS Access: Numeric Field Overflow, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, overflow error: I can t tell just from looking at your SQL. It s a mess. Can you simplify it any by making multiple queries? And what s with all of the VAL(0) functions? How about just 0? The 4,000,000 you ve got in there might be causing the numeric overflow if you re...

Using MS Access: looping through all the year, sobia, sql scripts
sobia, sql scripts, question thanks: Hi Sobia, Just change the date range in the WHERE predicate. If you want to make it interactive, you can compose the query like this:- SELECT Count(MainReception.ID) AS NumberOfRecords, MainReception.date, MainReception.test FROM MainReception WHERE...

Using MS Access: OpenForm to a Specific Record, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, call id: Specify a WHERE condition. DoCmd.OpenForm FormName ,,, Value= & FieldName I cover this in my Access 301 tutorial: http://599cd.com/site/courselist/access/access301?key=AllExperts Let me know if you have any other questions or comments. Also,...

Using MS Access: Overwriting Databases, personnel databases, external data source
personnel databases, external data source, query approach: YOu can t really do this with a simple import. However what you can do is import the data and then process it. YOu might even be able to reference the excel file as an external data source and bypass the import step. If you match the excel data with the...

Using MS Access: How to open a word document in Access, case management system, winword exe
case management system, winword exe, open logic: I don t use switchboards so I can t tell you for sure. What I generally do is use the wizard to create a button and have it do something like open a form. then I go into the button VBA created and replace the form open logic with my logic from the text I...

Using MS Access: openning and adding to a form from another form button, poor word, recordsource
poor word, recordsource, animal information: You definitely can t set the default value to 0 since no MenberID of 0 exists. The default value of your MemberID for the synced form needs to the MemberID control on the calling form. Try setting the default to: =Forms!formname!controlname where formname...

Using MS Access: Parameter and Append Query, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, destination table: The EASIEST thing do to would be to add a DataHasBeenPulled value (Y/N) in your sales table. After pulling the data, run an UPDATE query to change all of the unpulled records to Yes. Now, the next time you pull data, just pull the Unpulled (N) values....

Using MS Access: Parameter Search...maybe?, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, notation key: You want to open a form and show a specific record. If you re new to Access, this is going to be a bit of a challenge for you. I do cover it in my tutorials, but it s a bit more than I can explain here in a short answer. Essentially you need to create...

Using MS Access: Pass form values to another form, question thanks, foreign key
question thanks, foreign key, form1: First, the ONLY way this works is through a relationship. The relationship does not have to be formalized in the Relationships window, but it has to exist. So you have two tables a Person table and a Records table. The Persons table contains info about...

Using MS Access: Phantom combo box causing form problem, contract vendor, combo box
contract vendor, combo box, vendor name: Somewhere its still running the query, you need to find where. Step through the ON Open code maybe that will show you where. If all else fails, create a blank form and copy all the controls. Then copy the code, one module at a time and test after each...

Using MS Access: Primary Key Question, verification rule, composite keys
verification rule, composite keys, numeric key: A ReplicationID is used when you will be replicating the database in different locations. Sometimes its not practical to have the database on a shared network drive, so copies are distributed to remote locations, then synchronized back to the master periodically....

Using MS Access: Programming in Access for rowcount, obsolete versions, book versions
obsolete versions, book versions, rowcount: I think you need a good book on Access. I suggest you go to your library or to a local bookstore. Be sure to sit down and read a bit of any book before checking it out/buying it to ensure that it seems readable/understandable to you. YOu can also get...

Using MS Access: problem with insert into command in vba, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, adodb connection: Why don t you attach (link) to the table and then try it with a simple APPEND query? I can see several problems with your code, including that you re trying to insert a date value as a text string. It just seems to me like you don t have enough VBA or SQL...

Using MS Access: problem with insert into command in vba, adodb connection, jet oledb
adodb connection, jet oledb, adodb recordset: Hi Gopinath, I want to insert the user input details from an access form to external database which in access - The above is practised for a Visual Basic Front-end using Access as a Backend. My question is : Why would you like to use the insert statement...

Using MS Access: project, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, ms acess: Create a macro and name it AutoExec. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts Cordially,...

Using MS Access: public functions in VBA - MSAccess, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: A public function needs to be declared in a MODULE (outside of all of your forms) to be available to ALL of your database. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT...

Using MS Access: Quering dates using Access, booking reservation, primary keys
booking reservation, primary keys, microsoft access: I m not following what the tables are, nor do they seem to be designed properly. You should have a table for travelers, a table for bookings and if, travelers are part of a group, then a table for groups. All should be related from Primary Keys to Foreign...

Using MS Access: Query, design wizard, category fields
design wizard, category fields, query design: If using the query design wizard, click on View then select totals. BElow on the grid, in the new line, select group by for date, and group by for category. Be sure date is the first in the list, if you want the dates to be shown first, with all the categories...

Using MS Access: Query criteria altering command button, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, query criteria: Use an unbound text box on a form to simply hold the value for your criteria. See: If you want to refer to a value on a Form, you can use the notation: Forms!FormName!FieldName You can use this notation inside of queries, other forms, or even...

Using MS Access: Query Expression in MS Access, query expression, query in access
query expression, query in access, quantity field: Dennis, This takes a custom function that requires more than a quick answer here. You would have to pass the month field then return a one if it matched. Then sum that column and give it an alias name of that month. You then group by year. Bob Heifler...

Using MS Access: Query Expression in MS Access, query expression, query in access
query expression, query in access, quantity field: Why not set two fields in the query - one with the year and one with the month. Then make this a totals query - view and select totals. Set the totalling row to group by for the year and month. Also group by for the item number. For the quantity field,...

Using MS Access: Query By Form, combo boxes, foem
combo boxes, foem, code structure: If you wanted the form to show the same controls the report does, then create a form bound to the same query. You then use: DoCmd.OpenReport reportname ,,,Me.Filter to filter the report for the current selection. Hope this helps, Scott Microsoft...

Using MS Access: Query Question, manhours, report thanks
manhours, report thanks, query returns: What you need to do is an interim query that groups by CTRID and ExpenseID that sums the hours. So the result is CTRID ExpenseID Manhours 153 9 55 You then join that query to your expense table to get the Cost and finally, join...

Using MS Access: Query using multiple related tables, e mail addresses, microsoft access tips
e mail addresses, microsoft access tips, free microsoft access: I would build a CROSSTAB query and then just bring in all of the information that you need as separate fields. Or... If you just need to see this information on the screen, just bring all of the data together like you re doing, and then use a SORTING...

Using MS Access: Querying Dates using Access, Querying Dates using Access, query parameter
Querying Dates using Access, query parameter, query criteria: Sherlyann, You could place this in the criteria of the query column containing the booking date: = [Enter ending booking date.] When you run the query, a pop up input box will request Enter ending booking date. Here you should enter your date...

Using MS Access: Question about report grouping, walker miller, report grouping
walker miller, report grouping, anderson smith: Like I said, the problem is your structure. Your database is not normalized properly. The people assigned to a project should be stored in a child table like so: tblProjectAssignments ProjectAssignmentID (PK Autonumber) ProjectID (FK) PersonID (FK) ...

Using MS Access: query questions, cat board, zy
cat board, zy, microsoft access: This article has code that will do what you want: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=228834&Zf=f48&Zw=concatenate&Zg=0&Zl=a&Main=228834&Search=true&where=&Zu=66&Zd=l&Zn=&Zt=1&Zs=b&Zy=#Post228834&Zp= Hope this helps, ...

Using MS Access: query value to a form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, dlookup: Use DLOOKUP in an unbound form field OR make a transactions subform with a footer total. See: http://599cd.com/tips/access/dlookup-function?key=AllExperts or: http://599cd.com/tips/access/form-footer-total-sum?key=AllExperts Let me know if you...

Using MS Access: RE: Aggregating Access Tables, followup question, dream scenario
followup question, dream scenario, category field: Don t worry about monopolizing my time. If I didn t want to answer questions I wouldn t be here. If the Sequence number control on your form keeps showing 0 then you didn t follow my code samples exactly enough. Do you know how to step through code? If...

Using MS Access: Reagarding linking two forms through password protection., thsi, security measures
thsi, security measures, thet: Well that s what I gave you. If this is going to be stand alone, Then you have a users table with logon ID and password. You have a popup form where the user enters their loginID and password. with a button to open the protected form. The code behind that...

Using MS Access: Really Stupid Question....but...., microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Send focus to an object like a button. Put a CLOSE button or something in the form footer. In the OnOpen event for the form just say: Docmd.Gotocontrol MyButton Let me know if you have any other questions or comments. Also, be sure to visit...

Using MS Access: Refreshing main form according to subform datasheet selection, datasheet view, access books
datasheet view, access books, google: Hello Serge, I need to update a form based on the selection made in the datasheet As I see your datasheet in the attachment provided it looks like a pure datasheet based on a table. I would advice you to base your datasheet on a form with a datasheet...

Using MS Access: Relationship in MS Access 2K, relationship diagram, option groups
relationship diagram, option groups, meaningful names: Your database design looks good with a couple of exceptions. Looks like you have a circular reference with Validity_ID. Looks like its the PK in the Validity Credit Info table but a FK in Account Info. But you already have a relation between thos two tables....

Using MS Access: Relationship in MS Access 2K, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: I have no idea. Without seeing your database, I can t tell what s going on. Why are you looking up all of these values across tables instead of just LINKING straight to the table and referring to the data that way? Let me know if you have any other questions...

Using MS Access: Relationship in MS Access 2K, Normalisation, 3rdNormalForm
Normalisation, 3rdNormalForm, Database Design: Hi Aftab, You need to review the design of your database to bring it into 3rd Normal Form - this process is called Normalisation . Basically it is a process of looking at all entities and attributes and deciding what are the entities, what are the...

Using MS Access: Removing a check mark after printing a report, report button, microsoft access
report button, microsoft access, vba: Actually I would do this in the On Close event of the Report. Something like this: If MsgBox( Did you print the report? ,vbYesNo) = vbYes Then CurrentDB.Execute UPDATE tablename SET fieldname = No; End If When the user closes the report they are...

Using MS Access: Replication/Synchronization over Serial port, ms access database, ethernet router
ms access database, ethernet router, ethernet cables: The only way to sync two access databases that I know of is to use Access replication. This is available in Access 2003 but apparently not 2007. Of course, if the serial connection allows one computer to run programs on the other computer, by accessing...

Using MS Access: Reports in Access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You can use a SORTING & GROUPING LEVEL in a Microsoft Access report to group various like information together in one section and perform calculations like SUM and AVERAGE. For example, if you want to see all of your sales grouped by State with a total...

Using MS Access: Reset Security settings?, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, user level security: This all depends on what version of Access you have (you didn t specify). Easiest solution: just make sure your ADMIN user and ADMINS groups have access to all of the objects in your database, then simply create a new, blank MDW workgroup file using the...

Using MS Access: Residual Password, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, google search: You need to use the Access Workgroup Administrator to change the password of your admin account. Or better yet… just create a new MDW workgroup file. A Google search should explain how. Let me know if you have any other questions or comments. Also,...

Using MS Access: random table gerneator, random table, random records
random table, random records, random file: I m sure I ve done, just don t remember when. The way I would do it is to create a table of randomly generated numbers within the range of the numbers used as autonumber PKs. So, lets say I have 10K records with Autonumbers from 1 to 12000 (assume some gaps)....

Using MS Access: No record in query, MS Access, Microsoft Access
MS Access, Microsoft Access, Access Database: Can you have in your query something like Temp: IIf(IsNull([YourField]),0,[YourField]) This would return zero if there is no value in your main field, otherwise it would return the value in the field itself. For FREE Access ebook and videos click...

Using MS Access: records 1 thru 3 on same line of report, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, track grades: The only EASY way to do this would be to use multiple columns in your report. I cover this in my Access 205 class: http://599cd.com/site/courselist/access/access205?key=AllExperts Let me know if you have any other questions or comments. Also,...

Using MS Access: reg:data structure, ms acess, memory references
ms acess, memory references, memory reference: Hi Naveen, Over the years, different versions of MS-Access have different methods of memory references to store within their data structures. Infact I would advice you to put forward this question to the Microsoft Access Team at Redmond in their routine...

Using MS Access: reports in access, previous question, video tutorials
previous question, video tutorials, example files: Liz, What did you find out re: missing items in 2007? bheifler@gmail.com Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html Find example files at: http://www.myaccessprogram.com/Download.html ...

Using MS Access: Scanning barcode into Textbox, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Not really. You see, 99% of all barcode scanners that I have worked with send the scanned data (characters) as if they were typed at the keyboard. Since there s really no way for Access to know the difference, you re going to need your text box to be editable....

Using MS Access: Search Combo Box, notinlist event, dim rs
notinlist event, dim rs, column count: There are two ways to use the NotInList event. One where you have a one or two field table (or a Value list) and just need to add the value the user entered. The other is where additional info about the added item needs to be entered. Following is sample code...

Using MS Access: Search Combo Box, user level security, center settings
user level security, center settings, macro code: The Code I needed is in that embedded macro. What that code does, is pickup the PK from the selected record in the combo and use that to find the record in the table the form is bound to. So as long as the query presents a list then the code should work. Check...

Using MS Access: Selecting, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, combo boxes: You re right - a combo box can get unruly when you have thousands of records in it. How about a series of combo boxes? I don t know what kind of fields you re dealing with, but let s say you were trying to pick from a list of TOWNS in the US. If you could...

Using MS Access: Setting path., microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, microsoft common dialog control: Use the Microsoft Common Dialog Control ActiveX object. I cover it in this class: http://599cd.com/site/courselist/vb/vb106?key=AllExperts It works the same in Access 2000/XP/2003 as it does in VB6. Let me know if you have any other questions or...

Using MS Access: Simple Cancel button, cancel button, tips access
cancel button, tips access, query report: Cancelling the input prompt can still cause Access to prompt you for more input from other parameters. You might want to consider entering your parameters as FORM FIELD values instead. It s a much more elegant solution. See: If you want to refer to...

Using MS Access: Size of form, microsoft access, vba
microsoft access, vba, microsoft office: The form has Top, Left, Width and Height properties. You can adjust those properties either directly or via VBA to change the size and position of any form. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007 VB...

Using MS Access: Skipping blank queries when exporting to spreadsheets, vba procedure, qdf
vba procedure, qdf, dcount: I am suprised that your code is even waiting for the slow Dcount to return a value. I would open a recordset on the qdf and get see if there are any records, it is actually fast. Dim rs as dao.recordset set rs = currentdb.openrecordset(qdf) if rs.eof and...

Using MS Access: Sorting events by hour periods of time, crosstab, cross tab
crosstab, cross tab, datevalue: There are a few ways to extract just the date portion of a Date/Time field. DateOnly: Int([DateField]) DateOnly: DateSerial(Year([datefield]),Month([datefield]),Day([datefield])) DateOnly: DateSerial(Datepart( yyyy ,[datefield]),DatePart( m ,[datefield]),DatePart(...

Using MS Access: Sorting numbers in field when data type is "text", sort text numbers
sort text numbers: Connie, In your query, create an additional sort column by converting the text field [userID] to a long interger with the Access function Clng() then sort the column. Here is how: MyNumericUserID:Clng([userID]) Bob Heifler MyAccessProgram.com Contact...

Using MS Access: Subform, entry option, combo box
entry option, combo box, design mode: In Form Design mode you can right click on the title bar of the form and save it as a report. That will give you a starting point, you may have to tweak the report design some. As for limiting the report to the currently displayed record, that s done in...

Using MS Access: Subform Display, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: It should stick. When you save your form, that setting should be saved along with it. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: Suggested reading list for Database Creation, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, access bible: Of course, I recommend my OWN video tutorials and handbooks which you can find at http://www.599cd.com/Access Aside from that, I ve always been a big fan of the Teach Yourself Access books by Sams Publishing, and the Access Bible is good too. Let...

Using MS Access: Sync Combo Box with Form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, microsoft book: I can t really give you more specific help because I m still not 100% sure what you re looking for. What do you mean by how can the combo box and form be sync d? I have no clue what you re talking about. If you re selecting a value from a list and you...

Using MS Access: Synchronizing Combo Boxes, combo boxes, column count
combo boxes, column count, combo box: A Type mismatch error occurs when you are have an expression dealing with different datatypes. I think your problem is here: WHERE PROJECTS.[Status] = Approved Try this instead: WHERE PROJECTS.[Status] = Approved If that doesn t work, you...

Using MS Access: saving a record before adding a new record, docmd, checkmark
docmd, checkmark, print button: Hi Helen, Add this piece of code before your print command line : DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Your record will first be saved in your form prior to printing your report. Best regards, Manish Batola...

Using MS Access: for selecting a row on on entering first name itself, good database design, discrete piece
good database design, discrete piece, john doe: I would strongly urge you to redesign this table. Good database design calls for a field to contain the most discrete piece of data. Its a lot easier to concatenante later on then split them apart. Generally I use 5 fields for a person name; Salutation (Mr,...

Using MS Access: how to store calculation information from a form to a table, step manner, tips access
step manner, tips access, table values: Make a field in your table for the value. Change the ControlSource of the box to that field. Now it s BOUND to the table (stores the value and any changes). Now watch the AfterUpdate tutorial. Let me know if you have any other questions or comments....

Using MS Access: getting the subtotal each month, kind answer, select year
kind answer, select year, loan value: As a general rule we do NOT store calculated values. These should be calculated on the fly as needed. If you have a form showing all the transactions for a specific period then there is no need for a subform, just put a textbox in the form footer with...

Using MS Access: survey count, microsoft access, access database
microsoft access, access database, access db: Unfortunately because of the way the table is structured you would have to use a Union. SELECT qryRESULTS_ALL.A1, Count( A1 ) AS [Count] FROM qryRESULTS_ALL GROUP BY qryRESULTS_ALL.A1 HAVING (((qryRESULTS_ALL.A1)= agree )); UNION SELECT qryRESULTS_ALL.A2,...

Using MS Access: survey count, category table, several records
category table, several records, separate tables: Hi Tikoy, -You need to create separate tables to record your answer[s]for each category such as A1,A2 and A3 -You need to present them on screen using Tabbed Forms or any other method[s] that suit your interface. -You need to place each Category in...

Using MS Access: Tab control, tab control, table structure
tab control, table structure, data tables: I need to see your table structure. You should have at least three data tables here. If you don t then you need some redesign because that is behind your problems. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007...

Using MS Access: Table field concatenations, org records, relational databases
org records, relational databases, separate tables: In re reading, I m not sure of your issue here. I m assuming you have separate tables for People and Organizations but one table for addresses. In that case, you would have TWO queries. One where the address table is joined to People and the other for Organizations....

Using MS Access: Tables Containing People & Orgs, table relationships, table
table relationships, table, tables: Jeremiah, Here is one way: Combine your people and org tables into a table called Entity_Table and add a field called Type (P or O values) Your address table can be the many (child) table. Just store to Address_ID in each record in the Entity_Table....

Using MS Access: Text box displayed from table record, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: My first question would be WHY you have separate forms for each state. But, getting beyond that, I would put a piece of code in the AfterUpdate event for any of your fields to change the LastUpdated value for that table. You can use an AfterUpdate...

Using MS Access: Text box linked to Table entry, state tables, separate tables
state tables, separate tables, queri: That you get data from each state doesn t dictate separate tables, but if the table structure is different for each state, that could justify it. On the other hand, if the table structure is similar and some states may have some different data elements, I...

Using MS Access: Tracking of document lifetime, document correspondence, follow ups
document correspondence, follow ups, sky is the limit: Hello Abd, Your kind of application is known as a Workflow application. These features can be found in ready-made Microsoft Software such as SharePoint Portal Server. If your organisation is big enough then I must consult you to have this solution implemented....

Using MS Access: Transfering a caluclated age to a linked form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, dateadd function: Ssee this tutorial: You can use the DateAdd function to add or subtract date values. Want to add 6 months to a date but aren t sure which months between have 28 or 31 days? DateAdd takes care of that. It s also good for time values. Please see the following...

Using MS Access: True/False on Record comparisons, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, greek letter sigma: How about a Find Duplicates Query? Or you could use an Aggregate Query to get a COUNT of how many of each particular value exists, and if it s more than 1 you know it s a duplicate. To do this, use an Aggregate Query... also called a Summary Query or...

Using MS Access: tables having people & orgs, microsoft access, access database
microsoft access, access database, access db: It does not break normalisation rules because each address relates to a seperate entity. In other words a person is a fact and an organisation is a fact. Each has seperate data relating to it. The address for a person is unique to that fact and the same with...

Using MS Access: Having trouble entering code for SeqNum, dmax, sequential number
dmax, sequential number, microsoft access: Try it this way: Me.SeqNum = Nz(DMAX( [SeqNum] , PROJECTS , [Type] = & Me.Type & AND [DateRequested] = # & Me.DateRequested & # ),0)+1 You need to assign this value immediately before you commit the record. Hope this helps, Scott Microsoft...

Using MS Access: Update a field in a table based on value choosen in combo box, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, notation key: Just use an Update query. The values are already on your form. If you want to refer to a value on a Form, you can use the notation: Forms!FormName!FieldName You can use this notation inside of queries, other forms, or even reports. I have a free tutorial...

Using MS Access: Update Query, query design, open query
query design, open query, design mode: Did you try using Query Design mode? Open Query Design mode and select the two tables to add to the table pane. Select the FacilityName field in tblProjects and drag it onto the FacilityName field in the lookup table. Add the Facilitycode field...

Using MS Access: Update Query, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of other cool things. The major difference between the two is that BeforeUpdate runs BEFORE the data is saved to the table, which allows you to CANCEL...

Using MS Access: When to Use 0 Length, MS Access, Access database
MS Access, Access database, Microsoft Access: A null is actually a value, although not one that you can see in the table. As for allowing zero length......it s really down to your business requirement. For instance, in a payroll system it would be safe to say everyone would have a payroll ID so there...

Using MS Access: User/Pswd/Workinggrp, issue database, dear scott
issue database, dear scott, group user: Before I get into the solution, you might want to rethink this if you plan on eventually putting it on the WEB. Access is not the best database for a WEB appplication. To put an Access application on the WEB generally involves a nearly complete rewrite. The...

Using MS Access: Using a query result to determine the value for a control, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You d be better off with a DLOOKUP statement instead of a Find Duplicates query to see if that itemNo exists. See this tutorial: You can use the DLOOKUP function to look up a specific value from a table or query. Please see the following FREE video...

Using MS Access: Using IF statements in queries, microsoft access, ms access
microsoft access, ms access, access database: Try using DCount Example In the click event of a button you could add MsgBox DCount( Age , YourTableName , Age = 30 ) If you want to put the statement in a text box Go to the properties of the text box and in the control source add =DCount(...

Using MS Access: updating a table without affecting previous records of query, previous records, current unit
previous records, current unit, sample database: I don t think your structure is correct for your application. If you are recording payments, then you should have a payments table like so: tblPayments PaymentID (PK autonumber) SupplierID (FK) PartID (FK) PaymentDate UnitPrice Quantity Generally,...

Using MS Access: updating a table with a form, application version, table structure
application version, table structure, microsoft access: I m not quite following what you want here. I think what you are looking for is to use an Outer Join. If you want to display ALL functions whether a record for that function exists, then an Outer join is the answer. To provide more help, I would need to...

Using MS Access: VB code to load specific file from different locations, spath, bbbb
spath, bbbb, daily basis: Hi Martin, Yes - use and If - Else construct, as per Dim sPath As String If Weekday(Date()) = 2 Then Weekday() 1=Sunday, 2=Monday etc. sPath = C:AAAA Else sPath = C:BBBB End If ... now use sPath as your folder I hope...

Using MS Access: VBA Code in Form control, control question, control 1
control question, control 1, microsoft access: That doesn t sound right. Maybe I m not visualizing what is happening. Can you send me a copy of the file to dafiles@optonline.net. In your cover note copy in this correspondence and let me know the name of the form. Hope this helps, Scott Microsoft...

Using MS Access: VBA - Coding - Functions (2), access programme, combo box
access programme, combo box, microsoft access: Cory, Re: Which event triggers the codes when the user clicks the arrow on the combo box Just use the after update event of the combo box. That fires when a new item is selected. Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html...

Using MS Access: VBA - Coding, code snippet, discount id
code snippet, discount id, transaction form: Hi Cory, I am going to answer what I think is the question !!!! - I m only a simple guy... I assume you want to update the line (extended) price as the following numbers are entered - Quantity, Discount, Price ie the Extended price will be either...

Using MS Access: VBA in Form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Unlesss your controls are named exactly the same (Button1, Button1) which is technically impossible, this should not be happening. What are the names of your two controls? Let me know if you have any other questions or comments. Also, be sure to visit...

Using MS Access: VBA to send mass email to multiple recipients, mass email, mailing labels
mass email, mailing labels, cognoscente: What you are looking for is the SendObject method. One of the argument for this method is the TO parameter. You can use this in one of two ways. You can either loop through your selected records creating a comma separated string of e-mail addresses. Then use...

Using MS Access: SOLVED: Vba to requery a subform from another form's OnClose event, subform control, proper syntax
subform control, proper syntax, onclose: Glad you got it working. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts Cordially, Richard...

Using MS Access: viewing all fields from a lookup table, click scroll, input table
click scroll, input table, cat board: It really depends on how many fields you want to display, There are several methods. I wrote an article for another site that details this: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=1265454 Hope this helps, Scott Microsoft...

Using MS Access: Web Form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, ms access database: This is not a Microsoft Access question. This is a web-design question and all depends on what technology your web site is using (ASP, PHP, FrontPage, etc.) I would recommend using ASP to query your MS Access database. You could then use ASP to email the...

Using MS Access: Last week Date According to Date Entered, ww 1, sorry for the inconvenience
ww 1, sorry for the inconvenience, microsoft access: Let me see if I understand you. You have a report based on the dates entered in the form. One of the subreports needs to be for the week prior to the dates entered on the form?In that case, set the criteria for the subreport to:BETWEEN DateAdd( ww ,-1,[Forms]![frmDateRange2]![txtStart])...

Using MS Access: Yes/No Selection and Values, option control, value
option control, value, control.value: Tracey, Since the option control has your assigned value in the value property of the control, just add up the values. Place the code on the AfterUpdate event of each option control. [TheSumControl]= [OptionControl_A].value + [OptionControl_B].value +...

Using MS Access: Yes/No Selection and Values, option group, check boxes
option group, check boxes, yes box: Your structure doesn t make sense. If you are rating something then you should only have ONE field to store the rating and use an option group to set the rating. With an option group you can assign a numeric value to each answer. Hope this helps, Scott...

Using MS Access: ACCESS, record button, s system
record button, s system, microsoft access: 1) I told you how to do this. I m sorry, but I m not going to do your work for you. Access has very good Help screens. If you lookup the OpenForm method, it will show you how to do what I said. 2) This does not make any sense. If haven t entered the data...

Using MS Access: ACCESS QUERY BY FORM, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, table relationships: Creating a subform is not EASY, but its not incredibly hard either. In fact, there is a wizard for it. Just make sure your tables are properly related (sounds like you need to use CompanyID) and then build your company form. Drop a subform on it and the wizard...

Using MS Access: Access 2003 "If and" argument, place case, highest score
place case, highest score, hi john: Hi John, This is a real tease.... I think you need to pass another parameter, which is the HO status of IntPosition=3 team - I have called this BooPos3. try it out... Kind regards Geoff :-) Public Function Placing(IntPosition As Integer, BooHO...

Using MS Access: Access 2003: create stoplight chart, isnull, yellow case
isnull, yellow case, elseif: You don t need a With. Use a SELECT Case: SELECT CASE Me.ScheduledFinish Case Date() Me.Status = Red Case DateAdd( d ,7,Date()) Me.Status = Yellow Case DateAdd( d ,7,Date()) Me.Status = Green Case Else Me.Status = Complete ...

Using MS Access: Access 2007, birthdays anniversaries, group header
birthdays anniversaries, group header, visible property: Group by the numeric month column that you added to your query. But add the actual Date field to the Group header. Set the visible property of the numeric month control to No and format the actual date to show the month name. Alternatively you can create...

Using MS Access: Access-2007 Combo Boxes, combo boxes, pc professor
combo boxes, pc professor, microsoft master: That s not what I suggested. Don t import the object, create it from scratch. If there is code behind the object, you want to use, then copy and paste from the original. I don t know of any specific patches that deal with this issue. As I said, I ve never...

Using MS Access: Access 2007 Report, docmd, openreport
docmd, openreport, microsoft access: I just tested this and it worked fine. Here s the code I used. Do Until Me.NewRecord DoCmd.OpenReport rptSearch DoCmd.RunCommand acCmdRecordsGoToNext Me.Refresh Loop This printed all the records cuirrently displayed by the form. ...

Using MS Access: Access, concurrent usage, novell network
concurrent usage, novell network, xp3: First, even if there will only be TWO concurrent users, the database should be split. The only time a database shouldn t be split is if there is one user and that user is also the developer. So your problem would probably be solved by by spliting and storing...

Using MS Access: Access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, business in ghana: I would transfer everything over into your Access database. Excel is very limited for tracking sales. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL....

Using MS Access: Access - creating a Report, report wizard, listboxes
report wizard, listboxes, itom: You should NOT be using listboxes on a report. Listboxes are for input. They will not show up the selected itom on the report. Not sure how you created the report, but you should be using the Report Wizard. If you did use that, then I suspect that you have...

Using MS Access: Access Databases, billing clients, health applications
billing clients, health applications, workgroup database: First, every multi-user app NEEDS to be split between front end and backend. A front end can connect to tables in multiple back ends and a back end can serve mutliple front ends. What you should NOT be doing is having the same data in different back ends....

Using MS Access: Access email addresses, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, extraneous garbage: Hyperlinks are actually stored in multiple parts in the table because they support a visible portion. I always recommend storing email addresses as TEXT not hyperlink data types. I would use the CSTR function in a query to convert the hyperlink to a...

Using MS Access: Access Formula, dateadd function, due date
dateadd function, due date: Typically this is done in a query. first you have to find the due date. Then you calculate the spread around the due date. Use the dateadd() function to calculate the date +5 and -5 days from the due date. then compare now() to those dates. HTH...

Using MS Access: Access- Groups/Favorites, object groups, microsoft access
object groups, microsoft access, vba: I never use that feature, but the only way I could see it disappearing is if they were somehow deleted or NO groups are being displayed. First check to make sure you are set to have Groups displayed (if none shows). Not sure how to do that but looking up Object...

Using MS Access: Access previous record data sent to new records, followup post, relational databases
followup post, relational databases, data input: Sorry, but the problem here is your structure. If you havge to repeat large amounts of data from record to record then you do not have a normalized structure. Normalization is a key concept in designing relational databases. Nor should you be using subforms...

Using MS Access: Can Access pull up Word documents?, open word documents, hyperlink field
open word documents, hyperlink field, hyperlink type: you can make it in two ways: a) create an hyperlink type field in the Students main table, put it in a form. Inside the form, wright click in the hyperlink field and edit the hiperlinck, navegate till you find your word document and click on it. Go back...

Using MS Access: Access Query, strsql, access query
strsql, access query, insert into table: With a Loop. Something like this should work: Dim dteCurrDate As Date Dim intNumDays as Integer, curDailyRate As Currency Dim i As Integer Dim strSQL As String intNumDays = DateDiff( d ,[StartDate],[EndDate]) curDailyRate = [TotalRate]/intNumDays...

Using MS Access: Access Query, access query, question thanks
access query, question thanks, mde: It is generally recommended that you create a FE separate from the BE. Access develops FE quickly and powerfully. YOu can always add VBA to Access when needed. I would go with Access for your front end. YOu develop an Access front end as an MDB. Then...

Using MS Access: Access query - Getting the latest date from multiple date fields, max function, access query
max function, access query, mother company: You can use either the DMAX function to determine the last call date, or build an Aggregate Query with the MAX function in it. I would probably go with DMAX. DMAX works just very similar to DLOOKUP. Here s a tutorial: You can use the DLOOKUP function...

Using MS Access: Access question, macro name, msaccess
macro name, msaccess, click of a button: Hi Raman, Set up a shortcut on Access, then edit the target box to include the access application, followed by /x followed by the macro name. Eg C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE c:AppsMyAccessApplication.mdb /x mcrMyMacroToLaunch...

Using MS Access: Access Time in Minutes Query Error, query error, negative numbers
query error, negative numbers, access time: Are you storing BOTH the date and time in the same field? Sounds like you are only storing the time. That would make the result of the DateDiff a negative number. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007...

Using MS Access: Adding up check box totals for query, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, greek letter sigma: To do this, use an Aggregate Query... also called a Summary Query or Totals Query. There is a little button on the query toolbar that looks like a wierd E (actually the Greek letter Sigma). Press that and you get a new Total row. Just add the fields you...

Using MS Access: Allowing Edits, countermeasure, checkbox
countermeasure, checkbox, video tutorials: Cory, Use the OnCurrent Event It triggers every time you land on a different record. Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html Find example files at: http://www.myaccessprogram.com/Download.html...

Using MS Access: Assigning an order/sequence number in a query, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, table relationships: You should have a separate table to track this, perhaps call it VehicleArrival: VehicleID ArrivalOrder (1,2,3,etc.) TimeDate etc. Now just link it to your Vehicle table. It sounds to me like you need to learn a little more about the basic concepts...

Using MS Access: Attaching Documents, open dialog, api code
open dialog, api code, access api: You were specific enough ;), not a problem. I also ways store the path. Using OLE fields can bloat the database. Also depending on the type of documents, it may be easier to open them using Application.FollowHyperlink. What I use is the code found here:...

Using MS Access: Auto calculate, Calculated Values, calculations
Calculated Values, calculations: Randy, Place this code on the AfterUpdate Event of Previous Balance and Amt Received. [Balance] = [Previous Balance] + [Amt Received] My site shows bound and unbound examples on the Calculated Values Video It s free to watch. Bob Heifler MyAccessProgram.com...

Using MS Access: Autofill data on form, relational databases, two tables
relational databases, two tables, normalization: Yes I can help, but your database is not designed properly. You need to to normalize your data better. Normalization is an essential design concept for relational databases. The main prinicple of normalization is that data should exist in ONE place only. Therefore,...

Using MS Access: Automatically populate information in a form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, shoestring budget: You can use the DLOOKUP function to look up a specific value from a table or query. Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use DLOOKUP: http://599cd.com/tips/access/dlookup-function?key=AllExperts...

Using MS Access: Autonumber Generator, dmax, sequential number
dmax, sequential number, field names: Not a problem. Its a common question that I have answered several times. First, your table should have a date field already. Second, I don t know if the DF is static or variable based on other stored information. If its static (meaning you always use the DF...

Using MS Access: access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Sure, you don t need the rest of Office (Word, Excel, etc.) to use Access. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: access reports VS queries, airline group, airline code
airline group, airline code, dcount: 1) Yes, Create a query that set up a form to enter criteria into. In the query reference the values on the form using the following syntax: =Forms!formname!controlname using the correct form and control names. For example the date column can have criteria...

Using MS Access: access -updating a table, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: JoAnn, I don t understand your question. Are you saying that there is a password needed to get into a part of your database? If so, there are programs on the market you can buy that will attempt to crack into your database and retrieve the password. I...

Using MS Access: How to add attachments in e-mails for Access to Send in VBA, email, attachments
email, attachments: Stu, File attachements are not allowed with SendObject. It only allows sending the following: acSendForm acSendModule acSendNoObject (default) acSendQuery acSendReport acSendTable Using acSendNoObject just allows sending a message with nothing sent....

Using MS Access: how to add one information in two table, pasta sauces, recipe table
pasta sauces, recipe table, recipe name: This is a structural issue. The way I would handle this would be with another table: tblAllIngredients AllIngredientsID (PK autonumber) IngredientID (FK) IngredientType (either Recipe or stand alone) This table would include a record for all ingredients...

Using MS Access: appending a query, dups, microsoft access
dups, microsoft access, vba: First you don t append a query to a table. You either USE an Append query to add records or you Append records from another table. The message that tells you that 4 records will be appended also tells you why. Its either that message or the next one that...

Using MS Access: appointment database, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, table relationships: It sounds to me like you need to learn a little more about the basic concepts of building a Relational Database, and making relationships between two tables. Watch this free tutorial on my web site for help with this topic: http://599cd.com/tips/access/relational-tables?key=AllExperts...

Using MS Access: auto generate ID, asset tags, numeric id
asset tags, numeric id, hardware inventory: Very possible. The only kicker here would be generating the first number for a location. Also are you sure 1000 possible numbers per location is enough? Because of the complexity of determing the first number of a location, I m going to recommend just doing...

Using MS Access: autocomplete text box based on combobox, control source, error control
control source, error control, microsoft access: I m not following what you need. You want to type a value in a textbox and have it fill in the match as you go? While its possible, it will take some coding. Why bother when a combo does it for you? Hope this helps, Scott Microsoft Access MVP 2007 ...

Using MS Access: autofill data?, store id, relational databases
store id, relational databases, foreign key: This article I wrote should help: Displaying Data from related tables on a form This is a very frequently discussed issue. But before I get into the methods, you need to understand one of the principles of relational databases. That principle is that...

Using MS Access: How to autoincrement existing database field, database field, microsoft access
database field, microsoft access, vba: Yes: Me.txtECPNumber = DMAX( [ECPNumber] , tablename )+1 The left side of the expression is a control on your form bound to the ECPNumber field. Note, that you have to save the record IMMEDIATELY after executing this bit of code. The reason for that,...

Using MS Access: automatic populating fields in different tables, existing records, record key
existing records, record key, tab control: I wouldn t do it that way. I would use a main form with subforms. You can use a tab control for the two subforms is space is an issue. With an embedded subform (use theSubform wizard), you create a linking field between the main and the sub. You would use...

Using MS Access: Block design view and code, code question, vba code
code question, vba code, question thanks: The steps outlined in that article, do a more thorough job of locking down the database and can be used in conjunction with converting to MDE. But your original question was how to block Design View and protect your code. The fact of the matter is that when...

Using MS Access: Bound Frame, option select, active text box., score range, correct option
score range, correct option, frame option: Does it really matter? Since, the score can be anything (0 to =15) does the grouping really matter? But if it does, In the After Update event of the score I would put code like this: Select Case Me.optScoreCategory Case 1 If Me.txtScore 8 Then MsgBox...

Using MS Access: Cat and SubCat, choosen category, allexperts
choosen category, allexperts, requery: If I understand the first question, you are trying to pull the Category/subcategory names from the tables to display when the ID fields are stored as foreign Keys. You should have shown me the Dlookup you are using, but it should look something like this:...

Using MS Access: Cate and SubCat, category system, microsoft access
category system, microsoft access, vba: Not really sure what s going on here. When you choose a category, you have to requery the subcategory control so the newly selected category will be used. Can you send me a zipped copy of the database to dafiles@optonline.net? let me know what form is...

Using MS Access: Changing a number, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, input mask: Use a FORMAT or INPUT MASK in your table / form / report. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts...

Using MS Access: Changing text color and background on individual cells, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, looking for a new job: You re probably going to need to write AfterUpdate events for your fields if there are complex algorithms that decide what colors to make them. You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of...

Using MS Access: Check Box, datasheet view, check boxes
datasheet view, check boxes, microsoft access: Add a column to your query like so: alias: IIF([fieldname], Yes , No ) where alias is any name you want for the column and fieldname the name of the Yes/no field. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: Columns in Access reports, report in access, column headings
report in access, column headings, report doesn: Yes, you have to copy and paste the column headers and align them over the other 2 columns in the Page Header. I frequently do this to save paper when the data in the report doesn t occupy a lot of space. Hope this helps, Scott Microsoft Access MVP...

Using MS Access: Combo Box, strsql, true response
strsql, true response, 599cd: I m not sure. Your code looks fine to me. Without reproducing it, I couldn t tell you for sure. Make sure you have a space before the word VALUES or better yet just get rid of it and say: INSERT INTO TableName (FieldName) SELECT Value So for you...

Using MS Access: Combo Boxes, notinlist event, combo boxes
notinlist event, combo boxes, column widths: You can t enter an autonumber. So, while the bound column of the combos needs to be the correspodning foreign key field on your Order record, those fields would be a Long Integer datatype where the corresponding field is an autonumber. The combobox shouldn...

Using MS Access: Combo box to text box, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, work desc: You can use an AfterUpdate or BeforeUpdate event to set values, change properties, run macros, and do lots of other cool things. The major difference between the two is that BeforeUpdate runs BEFORE the data is saved to the table, which allows you to CANCEL...

Using MS Access: Combo boxes, microsoft access, access database
microsoft access, access database, access db: You need to store the name of the report in the table with the cruise names. Otherwise you will need to write code to match the report with the item in the combo box. First store the report name in the table. Return that column in your combo box, but...

Using MS Access: Command Button - Open Form Wizard, unbound controls, recordsource
unbound controls, recordsource, remote assistance: Would you like to setup a remote assistance session? You can contact me thru Windows Live Messenger at scottgem @ hotmail.com (no spaces). I would suggest downloading the free tool at www.teamviewer.com. When you install and run it, it will give you an ID...

Using MS Access: Command button to exchange data, combo boxes, command button
combo boxes, command button, satellite equipment: Hi Chris, Yes you can do this, but I need to know more about the structure of your data and the forms Do the two forms relate to 2 tables or a single table ? Please provide the table specifications for the table (or tables) - by this I mean, colummn...