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

Using MS Access: Report Title, drop down list, microsoft access
drop down list, microsoft access, vba: Add a text box to the form where you want the Title. Set the Controlsource of the textbox to: =Forms!formname!controlname where formname is the name of the form and controlname the name of the combobox. Hope this helps, Scott Microsoft Access...

Using MS Access: Report using parameters, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, dropdown boxes: Sure. This is going to, of course, require some VBA programming. Here s a tutorial on Recordsets to get you started: Recordsets are basically objects you can use in VBA code to edit, add, and delete records. They give you the power to do pretty much anything...

Using MS Access: Resetting Checkboxes(in tables) to false, checkbox, check box
checkbox, check box, uncheck: Kappucino, The value of a check checkbox is -1 and unchecked is zero If the name of the checkbox was CheckBox1 then the code to uncheck it would be CheckBox1 = 0 Just place that code in the on click event of the button. Bob Heifler MyAccessProgram.com...

Using MS Access: Running Sum in Query for Count Field, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, dcount: This tutorial does something similar: http://www.599cd.com/tips/access/dcount/?key=AllExperts I think you might be better off with DSUM though. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch...

Using MS Access: Running Sum in Query, dsum, control source
dsum, control source, record source: You can not use running sum in query but you can display running sum in Report. if you want to add running sum in table (not advisable) you can do it through recordset. I am describing here the procedure to display running sum in Report ( Al;so screen shot...

Using MS Access: Most recent row for each person record, lab test results, blood test results
lab test results, blood test results, person record: First, forget about doing this in one query. Often it is necessary to use what I call interim queries to build towards your final result. So the first thing you need to do is create a Top N of Group query. This article can help you do that: http://support.microsoft.com/kb/210039...

Using MS Access: About record number??, graduation certificate, sequential number
graduation certificate, sequential number, access query: Again, you seem to have this fixation on Record Number that is inaccurate. What you NEED is the Primary Key for the record. All data tables (and most tables) should have a primary key, almost always an autonumber. THAT is what you need to identify a record....

Using MS Access: The record number ??, bootleg copy, microsoft access
bootleg copy, microsoft access, microsoft office: The screen shot doesn t show what you mean. But it does show you may be using a bootleg copy of Office. So you need to explain, in greater detail what you want. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007...

Using MS Access: About record serial number??, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: I don t know what you mean by a record serial number. Do you mean the Autonumber? If so, it should just be a field in the table like any other bit of data, and it should be visible in a column if you view it in table form. Let me know if you have...

Using MS Access: many to many relation, quantity unit, three tables
quantity unit, three tables, combo box: Can a component be used in multiple Products? If so, then you do have a many to many. You should not be including all three tables in your query. The Main form should be bound to either the Products or Components tables. The subform should be bound to...

Using MS Access: about report ??, awaw, report in access
awaw, report in access, person names: First, in my previous answer, I mentioned about names. Unless you are only storing a first name you should use at least first and last names as separate fields. Second, you should NOT be using text data as foreign keys. Using text data in joins slows down...

Using MS Access: about report ??, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, awaw: Just join them together in a query, and use that query to create a report, grouped by adviser. 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...

Using MS Access: A request for Access 2007, oracle programmer, deployment tools
oracle programmer, deployment tools, recordsource: Here is the link to download Access Developer Extension : http://www.microsoft.com/downloads/details.aspx?FamilyId=D96A8358-ECE4-4BEE-A844-F81856DCEB67&displaylang=en Overview ======== The Access 2007 Developer Extensions provide packaging and deployment...

Using MS Access: Search in Access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, parameter field: You could create a parameter field for your listbox. Make a text box called MyParameter and put a * in it as the value. Now in the SQL statement for the list box, add that parameter: SELECT * FROM MyTable WHERE ProductName LIKE MyParameter Now, if...

Using MS Access: Search in Access, product tab, microsoft access
product tab, microsoft access, vba: Sounds like you have a setup similar to the Form wizard, where you select the fields you want from one list and they appear in the selected list. This can be a nice interface when you have a reasonable short list on the left. In your case, I would scrap...

Using MS Access: Search form using ID, run time error, machine id
run time error, machine id, command button: If you arre getitng a parameter prompt, that means that somewhere in the process you are asking for a variable or object that Access can t find, so it assumes you want the enter the value. This could be a misspelled criteria in a query or a sort on a deleted...

Using MS Access: Security without using User Level Security, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, user level security: You can t really protect back-end tables in Microsoft Access. Microsoft wants you to use SQL Server to protect your data. See this post in my blog for details: http://www.599cd.com/blog/display-article.asp?ID=372&key=AllExperts Let me know if you have...

Using MS Access: Select & Record Count, report wizard, percentage calculations
report wizard, percentage calculations, query design: Ok, this is a survey. Is that your query or the underlying table? What do the numbers mean? A survey database needs a very specific structure. Something like this: tblQuestion QuestionID (Primary Key Autonumber) Question tblRespondent RespondentID...

Using MS Access: Sequential Numbers - update after deletion of record, query key, access query
query key, access query, sequential numbers: This sounds like it s certainly possible, but without knowing more about how your database is structured, I really can t give you any specifics. You need to just loop thruogh all of the records and decrement the counter fields. Personally, I would use a...

Using MS Access: Show $0.00 in blank currency fields, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, currency fields: Just set the DEFAULT VALUE for your field (in the table or form) to 0. 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: SQL Statement, inventory transactions, query expression
inventory transactions, query expression, circular logic: Because that s not a valid SQL statement. Try looking up SQL SELECT in Access Help. Nor is that even close to what I gave you. A basic SQL SELECT statement takes the form: SELECT fieldlist FROM table WHERE condition What I gave you was the WHERE clause....

Using MS Access: If/Else Statement, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Instead of using an IIF function, just use a little bit of VBA code in the button that prints the report (I m assuming you re using a form to select Yes/No and a command button to launch the report). In the button just say: IF MyCheckButton=TRUE Then...

Using MS Access: Storing an array, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Yes, it s possible. You can DIM an array in VBA just like normal Visual Basic. You ll have to use VB code to fill the array, however. I would recommend using a Recordset to loop through your table records. Recordsets are basically objects you can use in...

Using MS Access: Sync Combos on a Subform, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, combo boxes: I m not sure what you mean by sync 2 combo boxes. Do you mean you re trying to use one to filter / reduce the options available in a second one? If so, see this tutorial: I get asked this question all the time. You ve got two or more combo boxes and you...

Using MS Access: search in a query by two criterias, rude behavior, criterias
rude behavior, criterias, field names: I assume by Time you mean Date range SELECT fldOrderId, fldOrderDate, fldCustomerid, fldOrderValue FROM tblOrder WHERE fldOrderDate Between Forms![Order Report]!BegDate And Forms![Order Report]!EndDate And Customerid=Forms![Order Report]!cmbCustomer;...

Using MS Access: setting subform properties using VBA, failure point, subform control
failure point, subform control, recordsource: No its not, I m using a . instead of a !. Did you try it that way? The Invalid reference message indicates Access can t find the property you are referencing. This article contains the correct ways to reference: http://www.mvps.org/access/forms/frm0031.htm...

Using MS Access: sorting multiple fields in a listbox, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, dynamic sql statements: There are two ways you can do this. Both will involve some programming. The BEST way to do it is to set the ROWSOURCE property of the listbox using some VBA in a button (or two). For example: MyList.RowSource = SELECT ID, FirstName, LastName FROM CustomerTable...

Using MS Access: sorting multiple fields in a listbox, command buttons, microsoft access
command buttons, microsoft access, sql statement: You can t do it on a list box. What you can do is have a sort combo to select the column you want to sort on. Then generate a SQL statement with an ORDER BY clause for the selected sort. Set the RowSource of the List to the generated SQL and requery the control....

Using MS Access: storing data from user form into log table, strsql, setting the table
strsql, setting the table, work flow: Depends on your work flow. You bind a table to a form by setting the table as the form s Recordsource. You bind the controls on the form by setting the ControlSource to a field in the Recordsource. But this may not work for you depending on how you...

Using MS Access: Table Design, bound controls, sales statistics
bound controls, sales statistics, design question: Again, without knowing the data its hard for me to advise. But based on what you have told me, you are tracking vehicle sales, I m assuming cars. Unlike other sales models, cars are generally a one item per sale situation. So I would envision at least three...

Using MS Access: Table Issues, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, rev level: Well, I would suggest trying to figure out a one-table solution with a field to indicate re-training, but without seeing (or knowing more about) your database, I don t know what to suggest. If you do decide to go with two tables, you could always use a...

Using MS Access: Time problem in access 2003, decimal portion, integer portion
decimal portion, integer portion, database example: First, you have an issue with your structure. I know you said you are trying to keep it simple, but there are some rules that should be followed. When designing a relational database, there are rules of normalization. One of the principles of these rules is...

Using MS Access: Update Query Properties in code, odbc connection string, global constants
odbc connection string, global constants, constant hope: If you had setup your database using best practices this wouldn t be an issue. Generally, if you are going to hard code a connection strings instead of using linked tables then you should set a global Constant for that connection string. So I would suggest...

Using MS Access: Update records in MS Access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Use an update query. To add one second you would add: 1/24/60/60 So then just multiply that number by a RND() random number. You can use an Update Query to change records in a table. See this FREE tutorial on my website for more information and...

Using MS Access: Value increment onclick, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, looking for a new job: I would need to know more about how your database is set up, but if you want to click a button on a form and have a value on that form (in a field) incremented, just put some VBA code in a button: MyField = CInt(MyField) + 1 Easy enough? Let me know...

Using MS Access: Value increment, video tutorials, increment
video tutorials, increment, example files: Shawn, Have a little form that is bound to the table containing the field up want updated. Let s say the table field and/or form control is called Incrementor Now place a button on the form and use this code in the On Click event property of the button:...

Using MS Access: Variable not defined in access, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, looking for a new job: You haven t defined strMessage anywhere. 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: VB run report and download to flat file, vb knowledge, visual basic for applications
vb knowledge, visual basic for applications, openreport: First, with Access, you use VBA (Visual Basic for Applications) which is a superset of the Visual Basic language. Second you have some problems with structure. Name is a reserved word in Access and shouldn t be used as an object name. Also people names...

Using MS Access: VBA to lookup matching table values, run time error, query parameter
run time error, query parameter, digit combination: OK, then that s your problem. Try it this way: ntPatternMatchID = DLookup( [PatternID] , _ [SubTbl-Patterns] , [BasePattern] = & strPatternLookup & ) The 3rd part of the DLookup is essentially a WHERE clause. When you build a WHERE clause...

Using MS Access: value increment onclick, Access 2007, flexible approach, possiblity
flexible approach, possiblity, microsoft access: I doubt if anything you can tell me would make me change my mind. I will ALWAYS go for the more flexible approach. Its easy to simply get a count of the calls from my method and you don t have to use any of the flexibility I m suggesting. You asked for a certain...

Using MS Access: Working access for inventory control., microsoft access, inventory control
microsoft access, inventory control, vba: Of course you can. The question of HOW to do it depends on your structure. If your application tracks transactions, then you shouldn t be storing quantity on hand. It should be calculated in a query that adds all the incoming transactions and subtracts the...

Using MS Access: What is wrong with this expression?, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, expression level: That looks like it should work just fine. Are you having a problem with it or getting an error? If so, what is the error? 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: About the, recod, dim rs
recod, dim rs, currentdb: create a field in your table and name it fldSerial in load event of your first form use the following code : Private Sub Form_Load() Dim rs As DAO.Recordset, varSerial As Integer Set rs = CurrentDb.OpenRecordset( SELECT * from urtblname ORDER...

Using MS Access: 1re: answer 11/24/09 Double Booking Query, dlookup, double booking
dlookup, double booking, microsoft access: If you are copying and pasting the code exactly you are going to hit yourself. The error message tells you the problem. You are missing a ). You have two open parentheses, but only one closing parentheses. Try: If Not IsNull(DLookup( [MeetingID] , qryAppointments...

Using MS Access: Access 2003 SubReport linking problem, report in access, operation id
report in access, operation id, microsoft access: You need to set a grouping on Operation ID and place the subreport in the detail band within the grouping. However, I don t think you need a subreport. It might be better to create a query that joins the two data sources on OperationID. then group on that...

Using MS Access: Access 2007 command button, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: I think this tutorial will answer your question: 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 explains...

Using MS Access: Access 2007 command button, command button, key field
command button, key field, primary keys: Hi Helen, Many thanks for the question. To do this: Make a query based on the table that the original form is based on. Using the fields required for the new form. Add any other tables also needed. Join the tables in the query using your primary...

Using MS Access: Access 2007 commands, command button, command buttons
command button, command buttons, parm: Add a command button using the wizard. Set it to open the form with all records. Then open up the completed command buttons and go to the code behind the on click event. Create the criteria as a string for the stLinkCriteria string. Then add a parm...

Using MS Access: Access 2007 - Draw controls at runtime, ado reference, activex component
ado reference, activex component, error 429: So far my research says you can t do it. You would have to be able to open the form in Design view to add controls. But I did get a suggestion for creating the controls to be tiny and out of the way. Then set the properties at runtime. Frankly, I still...

Using MS Access: Access 2007 INSTR Function, instr function, exact expression
instr function, exact expression, memo field: I asked for the EXACT expression. But it should be something like this: Lastname: Left([Apdesc],Instr(1,[Apdesc], / )-1) If that doesn t work, make sure you have no Missing References. Hope this helps, Scott Microsoft Access MVP 2007 Author:...

Using MS Access: Access 2007 - Sequential Numbering, sequential numbering, combo box
sequential numbering, combo box, current event: use the following code (you must change the control name as required) ===================================================================== *********unbound combo box to select ProjectNumber****** Private Sub cmbPid_LostFocus() Dim NextId As...

Using MS Access: Access 2007 If Then Else If Statement, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, numeric variables: Well, first of all thru isn t a valid word in VBA. Second, it s always better to get those text values into numeric variables. Try this instead: Dim X as Double X = CDbl(TextBox1) If X 18.0 then TextBox2 = Low Elseif X = 18.0 AND X 20.0 then...

Using MS Access: Access Calendar Monthly dropdown, microsoft calendar control, dropdown boxes
microsoft calendar control, dropdown boxes, google: I don t believe you can change the behavior of that calendar control. It doesn t get a value until someone selects an actual date. If all you need is just a list of months, then why not just create two drop downs - one for year (2000, 2001, etc.) and then...

Using MS Access: Access Dates Formats, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, group header: If you create a group header or footer and then place the date field in there, it should show you the current date that it s on. So for the week ENDING date, put it in the group footer. This should be close enough for most situations. Anything else will involve...

Using MS Access: Access Form, access api, password control
access api, password control, startup options: If Me.Password = default Then Docmd.OpenForm frmResetPassword Else If Me.Password = DLookup( [Password] , tblUser , [LogonID] = & Forms!frmLogin.LoginID & ) Then DoCmd.Openform frmMenu Forms!frmLogin.Visible = False ...

Using MS Access: Access filter based on multiple criteria, combo boxes, adhoc reports
combo boxes, adhoc reports, canada region: Seeing the code doesn t help. You need to put a break point in the code that builds the Buildfilter variable and make sure that its correct. If you ve done that then I m not sure what you want me to look at. Hope this helps, Scott Microsoft Access...

Using MS Access: Access - filter by form, 3 dots, expression builder
3 dots, expression builder, record button: Hi Frank, Many thanks for the question. To do what you ask, you will need to write a small amount of code,to do this: Open the properties for the form, by right clicking in the upper left hand where the two rulers meet and selecting properties from...

Using MS Access: Access Query, input mask, access query
input mask, access query, guidence: Hi ABC, Sorry,I should have asked you to use validation rule too in addition to the input mask: So in the space for Validation Rule type in this if you want it to be able to remain blank too: Is Null Or Like ???????????????? Or if you always need...

Using MS Access: Access Reports IIF then Statement, microsoft access, vba
microsoft access, vba, microsoft office: IIF(Sum([Impressions])=0, 0 ,Sum([Impressions])) But really if you are summing Impressions it should = 0 if there are none. I would really need to see the whole query to understand what s happening. Hope this helps, Scott Microsoft Access MVP 2007...

Using MS Access: Adding a value to a field when a yes box is checked., pet fees, yes box
pet fees, yes box, applicable fee: Sorry, but your database is not normalized properly. You really need to redesign. You might want to do a search on normalization to learn more about this essentially design technique. There are two specific problems here. The first is having a total field...

Using MS Access: Auto populate other fields based on a text box, notation key, history tables
notation key, history tables, types of drugs: If you have the VisitID on the main form, and then you have tabs with subforms on that form, then just set the Default Value of the ValueID on the subforms to: =Forms!MainFormName!VisitID This will set the value when data is first entered into a new...

Using MS Access: access 2007 question, control session, question question
control session, question question, question thanks: Hi Kay, We can do this one of two ways. You can send me a copy of your database and I can quote you a price for making it work. Or we can hookup in a remote control session and I can help you do it. For the latter, my hourly fee is $40/hr. I think this...

Using MS Access: how to add a new field in ms access, mail id, record source
mail id, record source, zip format: I expect you are using different table. check the record source of the form and then check the table wheather it has the field you need or not. if not you can send me your db in zip format to check at my end, my mail id is aziz_abroad at yahoo dot com...

Using MS Access: adding/editing data from 2 tables, column count, relevant properties
column count, relevant properties, employee database: Why not use an embedded subform? If you use the subform wizard the subform will be linked on employeeID. It will display records associated with that employee and automatically assign new records to that employee. Hope this helps, Scott Microsoft Access...

Using MS Access: adding a new column in a form to an existing database, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: It s pretty much the same. Just open the form in Design View and then open the Field List (button on the Ribbon). Pick the fields (columns) you want to add and drag them to the form. Let me know if you have any other questions or comments. Also, be...

Using MS Access: Best Metch Area Codes, metch, destination area
metch, destination area, carrierrate: You could use that function in Access with only minor changes. What I need to know first is what the function returns. Can you give me a couple of examples of what the 3 values that go into it would be and what value the function would then return. In...

Using MS Access: Calculating Cohorts in Access, getting health care, track improvements
getting health care, track improvements, health care industry: Hi Eric, The most common way to do this is: 1. design a form and have comboboxes in the form to select date ranges. You can even put calendars to enter dates from. 2. Have a list box or combobox on the form to select categories. 3. have a command button...

Using MS Access: Calculations in Queries, volume column, percentages
volume column, percentages, many thanks: Hi Andrew, Many thanks for the question. I hope I have understood it correctly. The easiest way, but I am not sure if this fits in with your end objective, is to have both percentages in the one record, rather than separate records. Then all you...

Using MS Access: Calendar-style report, plant bloom, bloom time
plant bloom, bloom time, flower species: What you would do create a query that lists the plant name, the month and a field that returns a true or false depending on whether the plant blooms during that month (alternative, it can display a blank or an X). You then use that query as the source of your...

Using MS Access: Change texbox background by button, windows xp sp3, filter records
windows xp sp3, filter records, key field: 1. What code did you use? A shortcut I have advocated is: Me.controlname.Enabled = Me.checkboxname If you are using code like that, it won t work. You have to use an IF statement. If Me.checkbox Then Me.Controlname.Enabled = True Me.Controlname.BackColor...

Using MS Access: If/Then Checkbox code again, current event, dumb question
current event, dumb question, microsoft access: if both controls are bound to fields in the table then changing the value in one record shouldn t affect all records. But yes, use the On current event of the form. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: COMBO BOX, control source, text boxes
control source, text boxes, combo box: make a form right click on form and select properties in property you will Record source fro the drop down select the table name having required information. now place 3 text boxes on the form and again right click on each textbox select ptoperties and...

Using MS Access: Combo boxes & Subforms, combo boxes, recordsource
combo boxes, recordsource, combo box: Still doesn t answer all my questions, but it helps more. So you have a record on your mainform that contains a field for State. And the subform then shows all records related to the State value for that record. Now I need to know more about what the application...

Using MS Access: Complex Query, boolean field, when in rome
boolean field, when in rome, query design: For the first issue, I think (since I don t know the SQL for the query) that a Subquery would work. For example; if you have have a query that returns a value of 0 (is this a boolean field) when a course has expired, then you could use something like this:...

Using MS Access: Creating paychecks on microsoft access, sequential numbering, four tables
sequential numbering, four tables, microsoft access: Ok, you use a report. As for numbering them you do that when you create the records for each pay period. I wrote a blog on how to do sequential numbering. You can find it here: http://scottgem.spaces.live.com/blog/cns!AB37C52C6D3752C!180.entry?wa=wsignin1.0&sa=282926770...

Using MS Access: Criteria in Access 2007, thyroid scans, cartesian product
thyroid scans, cartesian product, urine analysis: First, you have a problem with design and privacy laws. Names should not be used as linking fields because a) they may not be unique, b) text fields don t work well in joins and c) joining on two fields can result in a Cartesian product. In addition, since...

Using MS Access: Custom Auto Generated ID #, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, intermediate user: Whenever someone asks me to create a custom counter, I have to ask them WHY they need it. Remember, counters and Autonumbers are INTERNAL pieces of data that YOU shouldn t need to care about. Access uses them to track relationships between tables. However,...

Using MS Access: how to create a lookup on access 2007, combo box, good luck
combo box, good luck, stock: I typically use a multi column combo box and let the user select the stock item from this. Then have the combo box fill in one of the fields. the use VBA code in the AfterUpdate event for the combo box to update other fields as: me.field2 = me.combobox.column(1)...

Using MS Access: how to create task scheduler, autoexec macro, attendance system
autoexec macro, attendance system, task scheduler: You are confusing me. Are you doing this ALL in Access or are you using VB? VB and VBA are different animals. If you are working only in Access, then you will need to create a separate front end for this. This means you need to split your database into...

Using MS Access: custom sort in VBA, ms access 2000, database background
ms access 2000, database background, custom sort: First, you can simulate the rotating nature of the button. Something like this: SELECT Case Me.cmdSort.Caption Case Sort1 Me.cmdSort.Caption = Sort2 setup sort Case Sort2 Me.cmdSort.Caption = Sort3 setup sort etc. End Select ...

Using MS Access: how to custom sort in vba, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, recordsource property: What I would do is to create a table with your values and their preferred sort order. 1, Confirmed 2, Pending 3, Cancelled etc. Then, create a link between your data table and this status table. You can then use the Sort Order field to control which...

Using MS Access: Data entry link to table, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, using ms office: James, you should use a DLOOKUP function for this. Here s a tutorial that will explain it: 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...

Using MS Access: Database development, develop, development
develop, development, database development: Yes Camie, I do develop Microsoft Access databases. Please contact me, if you need my assistance. Bob Heifler MyAccessProgram.com DailyAccessTips.com Contact at: http://myaccessprogram.com/Contact.html Find example files at: http://myaccessprogram.com/Download.html...

Using MS Access: Designing Travel Itinerary Database, flight itinerary, travel itinerary
flight itinerary, travel itinerary, address city state: The structure I gave you will do what you want. The tblitinerary can be used to mark whether its one way or a return. The tblItineraryDetail records each leg of the trip. All you need is a FK to link to the flight info. Hope this helps, Scott Microsoft...

Using MS Access: DLookup to edit information on form, keeps creating new autonumber on search, search choice, acquirer
search choice, acquirer, new question: Again, this is not the way to do it. This method would work only if you are using an UNBOUND form. If you are not using an unbound form, you can t use this method. Have you tried using the combobox wizard to create a search combo as I suggested. I use that...

Using MS Access: DLookup to edit information on form, keeps creating new autonumber on search, bound form, search question
bound form, search question, access programming: What is the code behind the edit button? Using DLookups is NOT the way to do this, All you are doing is either changing the current record or adding a new one. You want to use the search combo to select a record and THEN setup for editing. Hope this helps,...

Using MS Access: Dlookup with a DMax, dmax, sequential numbering
dmax, sequential numbering, microsoft access: Please check out my blog entry that details how to do Sequential Numbering: http://scottgem.spaces.live.com/blog/cns!AB37C52C6D3752C!180.entry The main problem is that you are supplying Criteria incorrectly. That s why it returns nothing. Hope this...

Using MS Access: DropdownBox LookUp, customer field, parameter field
customer field, parameter field, query criteria: To see the full SQL of a query, you can select SQL View, then copy and paste into a response. Did you put that criteria into the ID column or the Customers column? Based on the RowSource of cboCustomer, the bound column would be the ID field so that s the...

Using MS Access: DropdownLookUp, customer field, datatype
customer field, datatype, microsoft access: OK, the first issue is the column. Check the properties of cboCustomer. Make sure that a) the Controlname IS cboCustomer and b) see what the Bound column is. If the Bound column is 1, then that means the combo is returning the first column in the Rowsource...

Using MS Access: Duplicating a record, strsql, related records
strsql, related records, foreign key: I asked to be clear on the point. Because what you describe is denormalized and shouldn t be done. You should have one table that identifies the itinerary. something like: tblItinerary ItineraryID (PK Autonumber) PersonID (FK) DepartureDate ReturnDate...

Using MS Access: docmd.runsql update problem, runsql, input boxes
runsql, input boxes, sql statment: Try it this way: DoCmd.RunSQL UPDATE testtable SET testtable.submitted = & Me.txtsubmitted & _ WHERE fieldname = & Metext346 & ; You need to use the fieldname the combo is bound to. A WHERE clause has to compare a field in a table with...

Using MS Access: Email individual reports to employees, pagebreak, loop through
pagebreak, loop through, microsoft access: You can use the SENDOBJECT method to send the report. What you do is create a recordset of employees with their e-mail addresses. You then loop through this recordset running the report filtered for the employee. Then send it. You can kick this off with one...

Using MS Access: Email loop in VB, currentdb, tips access
currentdb, tips access, ubound: I wouldn t recommend doing it that way. I prefer starting at the beginning of the recordset and then looping until I hit the RS.EOF which is end of the records. While Not RS.EOF E = rs!EmailAddress RS.MoveNext Wend See this tutorial for more...

Using MS Access: Equipment Booking data base, equipment booking, base question
equipment booking, base question, double booking: You chose which piece of equipment from a combobox, correct? If not, you should be. The Rowsource of that combo should be something like this: SELECT EquipmentID FROM tblEquipment WHERE EquipmentID NOT IN(SELECT DISTINCT EquipmentID FROM tblLoanInfo...

Using MS Access: ETL, ms access forum, followup question
ms access forum, followup question, interview question: I m not sure what you are looking for. I m assuming, since you posted this in the MS Access forum, that the question had to do with creating a query. I don t see any real need for a followup question. If you want a count of the number of employees per department...

Using MS Access: Event Management Database, blank registration, center settings
blank registration, center settings, click office: I could not retrieve your attachment. Please send it to me directly at bobalston9 AT yahoo DOT com Also answer each and every of these questions: 1) Can you add data to the notes field for the first record which shows up when you open...

Using MS Access: Excluding weekends in a query, isnull, gotfocus
isnull, gotfocus, zip format: send me your db in zip format to aziz_abroad at yahoo dot com ********Code added on 31st January, 2010********* ****To check date validity*********** Private Sub EndDate_GotFocus() If IsNull(Me.StartDate) Or Not IsDate(Me.StartDate) Then...

Using MS Access: Exporting multiple queries into single Excel workbook, transferspreadsheet, office automation
transferspreadsheet, office automation, input window: 1. You need to make sure the correct Reference is installed for using FileDialog. 2. I would approach it from a different angle. I would use a file dialog to capture the path and file, then store that and reference it in the OutputTo. Hope this helps,...

Using MS Access: Fields not returning data, vba code, query report
vba code, query report, leila: Hi Leila, Did you chaek the table to see if there is really data (a record) for the forst item in the dropdown box. It is possible that there is no data to fetch - of some VBA code is restricting the first record to be fetched. That is all I can think ath...

Using MS Access: Find common part numbers in 2 ACCESS Tables, query design, open query
query design, open query, gmail: Open Query Design mode. Add the two tables. Drag the Part number from one table onto the part number in the other. Then add the fields you want to display by double clicking to add them as columns to your query. Hope this helps, Scott Microsoft Access...

Using MS Access: Form not accepting input, performance analysis tools, query fields
performance analysis tools, query fields, database fields: Right, the Allow properties are on the Data tab for the Form. Ok, so we ve eliminated the multi-table aspect. But I still think you should redesign at least this aspect of the app. The issue here is one of Entity/Attribute. You seem to have an Entity where...

Using MS Access: Form Filter, combo box, combobox
combo box, combobox, microsoft access: Use a Combobox to select a valid asset number. In the After Update event of the combo use code like: Me.Filter = [AssetNumber] = & Me.cboAsset DoCmd.Runcommand acCmdApplyFilterSort Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: Form fields with autofill but editable, firstdate, second date
firstdate, second date, tips access: Reno, I assume that you re using a query with a calculated field to automatically fill in the SecondDate field so that it s: SecondDate:FirstDate+10 What you need to do instead is to make a FORM where you have an AfterUpdate event for the FirstDate field...

Using MS Access: Form to Query to Report, healthcare information systems, bagram afghanistan
healthcare information systems, bagram afghanistan, information systems tech: Ahhh That s easy then. First, you create a query that returns all the data you want on the report, forgetting the filtering for location and dates right now. The second step is to build a report using that query. You probably want to group on Location...

Using MS Access: Form Table Select, query criteria, dear scott
query criteria, dear scott, mini phone: Ok, if I follow you, you want to open a form and and find a single person, either by name or phone number, then print out their listing. Is that correct? If so, then you are doing way more than you need to. First thing, is to have ONE report bound to the...

Using MS Access: Access 2003 SubReport linking problem
Using MS Access: Access 2003 SubReport linking problem

Using MS Access: Access 2007 - Draw controls at runtime, checkboxes
Using MS Access: Access 2007 - Draw controls at runtime, checkboxes

Using MS Access: docmd.runsql update problem
Using MS Access: docmd.runsql update problem

Using MS Access: Exporting multiple queries into single Excel workbook, docmd, export button
Using MS Access: Exporting multiple queries into single Excel workbook, docmd, export button, query name

Using MS Access: Form not accepting input
Using MS Access: Form not accepting input

Using MS Access: filter by form, clear boxes, data entry
clear boxes, data entry, question mark: Hi Frank, 1. Open the form in design view. 2. Click the Code icon. You will see all codes behind the form. 3. Add new code like this: Private Sub Form_Open() End Sub 4. Copy the code (do not copy the first line and last lines like above) within...

Using MS Access: Help with a form please, cylinder number, visible property
cylinder number, visible property, history table: Here s what I would do… make your main form like you have it, and DON T bind the fields for Effective Date, In/Out, or Customer to any fields. Now, for the history subform, include those fields and set their DEFAULT VALUES to be equal to the fields on...

Using MS Access: Hyperlinks, customer record, customer id
customer record, customer id, microsoft access: Ahh, Sorry I didn t get that. Store the location of the file in a text field in your customer record. In the double click event of the control bound to that field use code like: Application.FollowHyperlink Me.contractcontrolname Hope this helps,...

Using MS Access: How to hide empty fields?, access programmers, google search
access programmers, google search, format parameter: The link I gave you includes the following: How to get labels in an Access report to ‘shrink’ when its control is null * Set control to shrink. * Convert label to textbox, enter the label name as control source ( =”Label name” ) without the parentheses...

Using MS Access: Invoice Numbering, inum, invalid use of null
inum, invalid use of null, long integer: Hi Foti, 1. LONG means that it is integer that can accomodate many many digits. Access table uses the terms Long Integer . So, in the table design for tblInvoiceNumber you need to select Long Integer as Field Size for the field InvNum. Your use of number...

Using MS Access: Key Combination + One button Many Reports, setfocus, area c
setfocus, area c, cbox: I disagree with your interface. Instead of a text box, use a combobox to select the values. Then you don t need to make a new hotkey anytime the list changes. In the On Load event use VBA to set the focus: Me.controlname.SetFocus. You set the tab order...

Using MS Access: Keyword Search with access 2003, command button, microsoft access
command button, microsoft access, tabular form: Create a form using the query as the recordsource (use the Form wizard). I assume you want a tabular form to display all records that match. In the form header, but your text control to enter the keyword. Add a button (or put it in the After Update event of...

Using MS Access: Linking checkboxes to a combo box, relative newbie, combo boxes
relative newbie, combo boxes, simplified setup: That s very different from the question you initially asked. Its also not the best way to go. What you seem to want is to set a status for a project. Not uncommon, but a project could never have a status of Completed and Urgent at the same time, correct? So...

Using MS Access: Linking fields, combo box, design mode
combo box, design mode, select properties: check carefully, my yes/no fields - displayed as checkboxes - do have the capability of an after update event vba code. in form design mode, right click on the checkbox and select properties. Scroll down to AFter Update. Left click in the immediately...

Using MS Access: Moving text boxes within forms, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, text boxes: In Access 2007, the form designer locks the text boxes together in a group. You can right click on the group and select Layout Remove and that will allow you to move them around freely. That s one of the things in Access 2007 I really don t like. Let...

Using MS Access: MS ACCESS 2002 "Write Conflict" on form, string filter, option groups
string filter, option groups, access 2002: Try to see if you get the error without displaying the report. Is the form bound to any data source. If so is there any code that runs on the form to update data in bound fields. When you get the Write conflict error, can you click on Debug to get more...

Using MS Access: MS Access 2007: Deleting Duplicate Records, csv data, query wizard
csv data, query wizard, duplicate records: OK, so there is no unique ID imported from the phone system? When you run the find dups wizard how many records are returned of the total records? Generally, the find dups will display one record for every dup. So lets say there are three dups of this record:...

Using MS Access: MS Access 2007, 3 dots, tab place
3 dots, tab place, brick wall: Hi Frank, My apologies for missing this. Too late at night :0) I suppose. Yes you can do what you ask. Access can handle concurrent users, but it does slow down considerably if more than one person tries to access it at a time. Also each of the workstations...

Using MS Access: MS Access 2007 relationships, autonumber field, primary key
autonumber field, primary key, foreign key: Let me try to explain this, because your understanding is incorrect. You need to understand what a primary key is and what a foreign key is. A PK is a unique identifier for a record. That s why Autonumbers are perfect as PKs. A FK is a field in a related table...

Using MS Access: MS Access buttons, garment type, tailoring shop
garment type, tailoring shop, relevant field: Ok, that s what I thought and you are going about this the wrong way. What you propose is cumbersome and difficult to maintain. What you should have is at least two tables here: tblTailoring TailoringID (Primary Key Autonumber) GarmentTypeID (Foreign...

Using MS Access: MS Access Reports, page answer, bottom margin
page answer, bottom margin, raw format: No that s not going to work, Access reports don t work that way. But I don t understand why you think my suggestion won t work. The external company needs the reports to have no more than 27 rows, what does it matter how you get it that way? But frankly,...

Using MS Access: MS Access Make-Table Query, urban search and rescue, destination table
urban search and rescue, destination table, normalization rules: I could tell you how to do this but I won t. I will, however, explain why I won t and offer you a better alternative. The problem with your method is that it does not follow normalization rules. Normalization is a key concept in designing relational databases...

Using MS Access: ms access query, access query, time field
access query, time field, group time: Hi harold, Many thanks for the question. You can do this by formatting your dates and times differently. i.e. to group by the hour. Build a query with the fields you require For the time field; In the first row type the following: TimeByHour:...

Using MS Access: multiple query selections from a form text box, query selections, search values
query selections, search values, query criteria: The method I mentioned works well when there are a single value in each field. since you have multiple values in one field, you will need to: 1) Use vba to split out the values into separate fields and use the method I mentioned. or 2) Use VBA code...

Using MS Access: Numbering a report - Record Count, report, record count
report, record count, Sum(): Tom, In the report footer, if you just need a record count, add a text box and use this for the control source: =Count(*) If not all the records contain people who have achieved employment, you would add a derived column with some statement like: Achieved...

Using MS Access: OLE Object, microsoft access, access database
microsoft access, access database, vba: I do not recommend using OLE Object fields. They cause bloating of your files. Especially since you want to keep the file open while you work with the form I would not use them. What I would do is store the path to the file in a text field then add a button...

Using MS Access: OLE Objects in Access 2003, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, unc paths: Yes, unfortunately without some programming you are going to have to reestablish all of your links. You could write a program to loop through all of the records and using VBA code change those links, but that might take more time than just re-inputing the...

Using MS Access: OLE problem Access 2000 windows xp, ms photo editor, microsoft changes
ms photo editor, microsoft changes, installation disc: The only idea I can give is to search the message you get via google and see what you come up with. Of course you could try another one of the Access folks on this site. I did a google search and came up with one possible fix: http://support.microsoft.com/default.aspx?scid=kb;en-us;896865...

Using MS Access: OpenReport, recordsource, strsql
recordsource, strsql, invalid use of null: First, check the number of commas in the OpenReport method. Second, make sure you add a semicolon to the end of the StrSQL. Eliminate the first MsgBox. Change the code to: If Not IsNull(Me.OpenArgs) Then MsgBox Me.OpenArgs Me.RecordSource = Me.OpenArgs...

Using MS Access: Option groups & command Buttons, option group, option
option group, option, command button: Andre, Here is the code to place on the Click Event of a command button or even on the After Update Event of Frame21. Select Case Frame21.value Case 1 DoCmd.OpenReport 1Delaware_rpt Case 2 DoCmd.OpenReport 2Maine_rpt Case 3 DoCmd.OpenReport...

Using MS Access: open form using parameter query w/ combo box, parameter query, open query
parameter query, open query, combo box: There is a better way to do this: DoCmd.OpenForm formname ,,, [AgentID] = & Me.cboAgent This will open the form filtered for the agent selected in the AgentSelect form. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office...

Using MS Access: Please solve this query, temp table, matching records
temp table, matching records, microsoft access: You want to delete records from both tables where they match? Create a query that joins both tables so you have a list of matching records. Use a Make Table query to create a tempoorary table of the PKs of the matching records. Then create a Delete query...

Using MS Access: populate data from two tables, lastname field, key field
lastname field, key field, foreign key: You have design issues that need to be fixed first. I m assuming that those are the only two columns in Excusal. If so, you should not be using Lastname as a key field. What happens if you have two employees named Smith? If those are not the only columns then...

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: Queries, fish bird, microsoft access
fish bird, microsoft access, vba: Try SELECT * FROM table WHERE datefield IN(SELECT TOP 1 datefield FROM table ORDER by datefield DESC); or SELECT * FROM table WHERE datefield = DMAX( [datefield] , table ); Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: Query, query wizard, mammo
query wizard, mammo, 1000 names: Ok, you will need to use what I call interim queries to get the results you want. You can use a query within a query so you build on your queries to get the final results. So the first query you want is physicians who have ordered an exam prior to three...

Using MS Access: query pulling all tables & fields, query wizard, data dictionary
query wizard, data dictionary, microsoft access: Unfortunately no. The closest you can come is to use the Data Dictionary feature. This produces a document listing all tables and their fields. You can then massage that into a spreadsheet to import into a table. Hope this helps, Scott Microsoft Access...

Using MS Access: R.E: Using MS Access - Printing Select Lables, mail labels, field thanks
mail labels, field thanks, happy new year: 2. If you want to eliminate labels that have already been printed, then you need to place a flag in the table to indicate. Use the query that lists the labels you want to print to run an Update query to set the Printed flag to True. Then filter the query for...

Using MS Access: Record Sort not working, sort fields, record source
sort fields, record source, nothing works: Hi Julie, Did you use the grouping/sorting menu in Access. That will allow you to sort in any order. If nothing works, you can always build a new query to pull info from a table or query and you can sort in this new query any way you want (sort preference...

Using MS Access: Record Source question, record source, recordsource
record source, recordsource, ellipsis: For reports I always use a named query. This way the query can be used elsewhere. For forms I tend to use the table as the recordsource, but again, I would prefer a named query so it can be used elsewhere. Hope this helps, Scott Microsoft Access...

Using MS Access: Running reports, 3 dots, report names
3 dots, report names, switchboard: Hi, Many thanks for the question. My apologies for the delay in answering your question, I have been travelling from Australia to Canada and it has taken me a bit longer to get organized than expected. But I am now back on deck. I am sure there is...

Using MS Access: Running Totals, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: There is a Running Sum property you can use in Reports. This tutorial explains it: http://www.599cd.com/tips/access/counter-over-group/?key=AllExperts Otherwise, you could also use the DSUM value to add up all of the items in your table that are LESS...

Using MS Access: record source, sqlcode, record source
sqlcode, record source, sql code: Do you end each SQL statement with a ;? Access requires that. If that doesn t work, I would use saved queries that return the records you want and set the RecordSource to the named query. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: record source, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, sqlcode: The problem is when your form opens, ChoiceList doesn t have a value (even though you might specify a Default value, it doesn t have one). I would just set the RecordSource to something in the form itself (perhaps show all the records?) and then when the...

Using MS Access: regarding database, microsoft access, microsoft office
microsoft access, microsoft office, mvp: Again, if you link the table then you just use it as a regular table. Without knowing how the tables relate, I can t give you any code sample. If you want to query an external, non-linked table you can use code like this: SELECT MyTable.Field1, MyTable1.Field1...

Using MS Access: Many-to-many relation, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: This is a little more complicated, but I believe this tutorial will get you started: I get asked this question all the time. You ve got two or more combo boxes and you want the first one to filter the second one. I get asked this so much that I recorded...

Using MS Access: Scheduling Database, appts, microsoft access
appts, microsoft access, multiple users: It certainly is. But this is a complex type of database to create. The complexity lies in managing the drivers. You have to account for how much time they need in transit. I would check to see if Microsoft has some templates that could help you get started....

Using MS Access: Searchable form, patent program, relevant officer
patent program, relevant officer, relevant event: I m sorry, but your database is not designed properly which is going to make your task much harder. There is no reason for separate tables for each box . Your Master List is all you need since it has Box Number as a field to identify the box. 1) By just...

Using MS Access: SendObject macro, hi matthew, thanks in advance
hi matthew, thanks in advance, qid: Hi Matthew, Many thanks for the question. There is another way around this by using SMTP rather than outlook. This will send an email without using outlook. I went down this road quite a few years ago, at the time it was all a bit too complicated...

Using MS Access: How to Shrink a Lable?, caption property, blank fields
caption property, blank fields, microsoft access: That s the problem with your request. You can use the Can Grow/Shrink properties to hide blank fields, but you still have to deal with the labels. You can try setting the caption property of the label to and see if it will shrink then. Hope this helps,...

Using MS Access: Sorting Records, sorting, report
sorting, report, report sorting: Julie, The report design has a grouping / sorting button to bring up a Grouping and Sorting window where, even with no groupings, you may add report fields to to sorted. This is the valid area to control your report sorting. Do not use the: Order By=[NameOfQuery].[NameOfField],...

Using MS Access: Split Form, but having the datasheet change based on selection, intermediate user, tips access
intermediate user, tips access, separate tables: Chris, you are absolutely correct. The way you should handle this is by making a main form where you pick the tech, and then have the subform below show the equipment for just that tech. The subform would have the techID and any equipment information that...

Using MS Access: SQL Union/Report Problem, sql union, detail summary
sql union, detail summary, running into trouble: I think part of the problems is your design. Why do you have two tables with roughly the same structure? What you should do is split your databases into front ends and back ends. The back ends will have all your data tables, the front ends everything else....

Using MS Access: separate multi-recordset in 1 field to columns, sql code, task id
sql code, task id, customer name: Hi Kara, Many thanks for your question. I think what you need to use is a crosstab query. This option is available is you click on the New button in the Query section. The Crosstab wizard will open when you choose this option. You may need to...

Using MS Access: IF statements in Access 2003, global module, field 3
global module, field 3, microsoft access: What you need to do is use a query. As a general rule you don t store calculations. You can try adding a column to you query using nested IIF functions. But I would use a custom function for this. its a lot easier to debug. Something like: Public Function...

Using MS Access: Timesheet form, proper labels, dateadd
proper labels, dateadd, date selection: First is this an unbound form? If its not then you have design problems in your database. A properly normalized database would have a timesheet table like this: TimesheetID (PK Autonumber) EmployeeID (FK) WorkDate ProjectID (FK) TaskID (FK) TimetypeID...

Using MS Access: top values by group, group question, microsoft solutions
group question, microsoft solutions, microsoft access: Try this: SELECT Students.StudentID, Students.[First name], Students.LapsActual FROM Students WHERE StudentID IN(SELECT TOP 2 StudentID FROM Students WHERE Grade = Students.Grade ORDER BY Laprsun DESC); Hope this helps, Scott Microsoft Access MVP...

Using MS Access: transferspreadsheet and DoCmd.OpenQuery tutorial, little misunderstanding, transferspreadsheet
little misunderstanding, transferspreadsheet, attendance system: Ok, this helps. But it tells me you are doing things incorrectly, you do not need separate tables. If I understand you, you want to issue a daily list of students registered for each course. What I don t follow is what you are doing with that list. You also...

Using MS Access: Unable to create new record in form, numerical score, record source
numerical score, record source, numerical scores: Ok, so you don t need the courses and sessions tables. But you do need a separate table for entering the scores. tblScores ScoreID (PK autonumber) StudentID TestDate Score ScoreLevel The Score is the numerical score, the ScoreLevel is level name....

Using MS Access: Update Table/Query, details table, foreign key
details table, foreign key, table button: Hi Parli, OK I will try again :0) sorry but there was no mention of a form in your question. To do what you ask. Open the DocDetails form in design view. Right click on the foreign key field on the form Properties Data Default value In here...

Using MS Access: Using DLookup on an option group, syntax error missing operator in query expression, microsoft access tips
syntax error missing operator in query expression, microsoft access tips, free microsoft access: You ve broken a rule that I tell my students very early on in my Access 101 class: don t use SPACES in your object (tables, queries, forms, etc.) names. It makes things VERY hard later on. In this case, put square brackets around [Course Title] and you...

Using MS Access: updating fields based on another field, business logic, combo box
business logic, combo box, initial registration: I m not clear what you are doing. If you want to automatically mark set the Ready To test field to True, then you would use an IF...Then...Else statement. You would use the After Update of the control where the Test date is entered. You would enter code...

Using MS Access: Access 2003 Invoice Due Date Set, zero sets, due date
zero sets, due date, alias: First, as a general rule we do not store calculated values. There is no need to do so as this value can be calculated on the fly. The following expression should return the next 5th of the month: IIF(Day([datefield]) 5,DateSerial(Year([datefield]),Month([datefield]),5),DateSerial(Year([datefield]),Month([datefield])+1,5))...

Using MS Access: Access 2007, database normalization, database designers
database normalization, database designers, drop down boxes: Well there is a right way and a wrong way. If the users what to see check boxes, then you should be using an unbound form. The data structure remains the same as I suggested (btw PK = Primary Key, FK = Foreign Key). But you would then need to wrote code to...

Using MS Access: Access 2007, option group, group user
option group, group user, command button: This is very easy, but I would not use an Option Group, That requires more programming. Instead, create a table like so: tblForms Formname (PK) FormDescription Enter a record for each form with the formname as it appears in the Nav Pane and a...

Using MS Access: Access 2007 Split Database, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, workstation pcs: I ll be honest, I ve never tried working off of an Access database on a flash drive before, let alone a flash drive that s plugged into a router. So my hat s off to you for a unique solution to your problem. Nevertheless, all of the file I/O is handled by...

Using MS Access: Access 2007 to scan part of an email column, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, instr function: You can t use wildcards in a statement like that. Use the InStr function: =IIF(InStr(Email, .ctr )=0, GOV , SETA ) This tutorial should help: http://599cd.com/tips/access/break-up-text-string-instr/default.asp?key=AllExperts Let me know if you...

Using MS Access: Access, address text, key change
address text, key change, address records: First, each line DOES show in the table, you just have to expand the height of the row to see it. Second, you also change the size of the control on the report to show multiple lines or set the Can Grow property so the control will grow with the number of...

Using MS Access: Access Form, form1, kary
form1, kary, microsoft access: Easier to use two different forms. One with the Data Entry property set to Yes for new records and another with AllowAdditions set to No to use for editing. You can use one form, by listing the calling form as the OpenArgs argument in the OpenForm method....

Using MS Access: Access Multiple Field Index, field index, composite keys
field index, composite keys, foreign key: Correct. Whether the field being included in the index is a FK or not is immaterial. The purpose is to ensure uniqueness for a combination of fields. Some people will create a composite primary key for this. I m not a fan of composite keys, I prefer to...

Using MS Access: access and forms using formulars, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, query fields: I would need to know more information about exactly WHAT you re trying to calculate and how your form fields are set up. I have a feeling, however, that you might want to use calculated QUERY fields instead of form fields. See this tutorial and let me know...

Using MS Access: auto-fill time in Access 2007, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, input mask: I think you mean you re using the Default Value property, not a validation rule. If you want to have the time updated when you LEAVE a record, then you could put this line in the BEFORE UPDATE event for that form: MyDateField = Now() Now, whenever...

Using MS Access: barcode, reader hope, alternate input
reader hope, alternate input, barcode reader: A barcode reader is an alternate input device. Each reader is different. You need to talk to the manufacturers of your reader to determine how it interfaces with your PC. Some readers will just type the barcode into the current selected focus object. Others...

Using MS Access: CDate() in Access, bdate, cdate
bdate, cdate, microsoft access: First, you are saying that in Excel the data is stored as a text value that is the count of the number of days since an arbitrary date? Do you know the exact date that is the starting point? Do you have another column that tells you what the date is? Have...

Using MS Access: Coloring in specific rows, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Where exactly do you want to highlight this name? In a form field? On a report? If you can please be a little more specific I ll try to help you. Let me know if you have any other questions or comments. Also, be sure to visit my web site and watch my...

Using MS Access: Combo boxes, combo boxes, support microsoft
combo boxes, support microsoft, microsoft: I m not Julie, but what you are asking is a standard technique called cascading or synchronized combos. This article: http://support.microsoft.com/kb/289670 describes how to do it. I m not sure what you mean by Access holding the info. If the Controlsource...

Using MS Access: Compare, attendees, attendee
attendees, attendee, contact name: Just do a join between the two queries. You should include AttendeeID in both queries so you can do a third query that joins the two on AttendeeID. You can filter the second query to only show events after the missed date. Hope this helps, Scott Microsoft...

Using MS Access: Conditional printing of Report, docmd, command button
docmd, command button, notations: Dim strDocname as String If Me.controlname = B215 then strDocname = rptWorksheet2 Else strDocname = rptWorksheet End If DoCmd.OpenReport strDocname, acViewNormal The WHERE condition of the OpenReport method allows you to filter the...

Using MS Access: Cumulitive field with 2 id's and lots of data, access programmers, forumns
access programmers, forumns, dsum: Hi Jeffrey, Sorry for the delay with this, i did send a response immediately but it must not have gone through. The next page did not refresh immediately, that should have alerted me to a problem. Anyway, check out this link: http://www.access-programmers.co.uk/forums/showthread.php?t=169951...

Using MS Access: On click event button
Why do both? The datetime stamp indicates that the mail was sent. Having a yes/no field as well is superfluous. Just add: Me.txtMailsent = Now() Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007 VBA ...

Using MS Access: create dropdown list that links to different reports, msysobjects, openreport
msysobjects, openreport, switchboard: There are two ways. The easier way is the set the Rowsource of the combo to: SELECT Name FROM MSysObjects WHERE TYPE = -32764; Then, in the After Update event of the combo use code like: DoCmd.OpenReport Me.cboReportlist cboReportlist is the name...

Using MS Access: Data Entry Form for a Many-to-Many Relationship, record pointer, professional machine
record pointer, professional machine, primary keys: First, create your main form bound to tbl_Projects. Put any controls you want about projects. Add a header to the form, then use the Combobox wizard to add a search combo (3rd option). This will allow you to select a project from a combo and set the record...

Using MS Access: Dates and week of the year, first day of the week, week 1
first day of the week, week 1, calendar year: The key here is how you define the first week of the year. You say you translated to Week number but don t say how. That s important. If you use the DatePart function it will return the number of weeks into a year for a specified date. But that number depends...

Using MS Access: database one to one, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, beard style: I don t believe that s possible to set that up anywhere at the database relationship level. You could easily perform a DLOOKUP in your form when you go to add a record for either M or W, but I don t think the tables can be set up that way directly. Let...

Using MS Access: database, field names, using design
field names, using design: Hi Ray, Thanks for the question. I am not sure I understand fully the question, but try the following: Add an unbound textbox to the form, then type in theis text box the following (substituting) the field names for your field names =[Field1] +...

Using MS Access: date in excel to access, string 4, string 3
string 4, string 3, inti: First a txt file is not an Excel file. It may be able to open in Excel but generally its plain text. There are a few thing you can try to convert this dates. The first I would try is using the Datevalue function. I just tested it and DateValue( 02/OCT/2010...

Using MS Access: Eliminating Duplicates, street address city, address city state
street address city, address city state, employee database: Your problem is that you don t exact duplications. Your best bet is to provide some additional info that might be unique. A Phone number, will not ideal is often a good way to filter out dups. You also mention the names are employees, if that s the case,...

Using MS Access: enabling/disabling tabs, true case, example case
true case, example case, desired outcome: Hi Anna, Thanks for the question. Add the following code, to the after update event of the field that has the value you wish to use to display or hide the fields. You will need to chang TabCt10 to the name of your tabs. The 1 2 and 3 refer to the...

Using MS Access: Filter by Date Range on Form, microsoft access, vba
microsoft access, vba, microsoft office: In the form header add two text controls; txtStart and txtEnd. In the query set the criteria to: BETWEEN Forms!formname!txtStart AND Forms!formname!txtEnd Add a Me.Requery in the After Update of txtEnd. Hope this helps, Scott Microsoft Access...

Using MS Access: Forms, strsql, multiple records
strsql, multiple records: Use an Update query. You can add an unbound text box to the form to enter the date. You can then add a button to update the records. Something like this: Dim strSQL As String strSQL = UPDATE table SET datefield = # & Me.datecontrol & # & _ ...

Using MS Access: form and report references, control names, report references
control names, report references, object names: You can reference a value in a field on an open form using the syntax: Forms!formname!controlname The brackets are only necessary if there are spaces in either the form or control names. Access will automatically supply the brackets in some cases, but...

Using MS Access: Global Procedures in Access 2003-2007, vba procedures, global module
vba procedures, global module, cmd button: Hi, Thanks for the question. A couple of things you would need to do. Copy into a module. Change any private functions/subprocedures to public Be careful with the names of the functions/subprocedures you have copied, as you cannot have the same...

Using MS Access: hyperlinks, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, hyperlink field: A Hyperlink field is really just a special kind of text field in this format: visible_text#URL So to jump to my page, you would say: Click here#http://www.599cd.com You can create this dynamically in your form s code using something like a button...

Using MS Access: Importing Data for a particular month, recongnition, consistent format
recongnition, consistent format, tardiness: That doesn t really answer my question. What would be best is if each dept supervisor submits the data in the same format or layout. If that format/layout can be dictated, then it becomes easy to import the data. Even if they can t dictate, if the submission...

Using MS Access: LINKING MS Access to Lotus Notes, developerworks lotus, odbc dsn
developerworks lotus, odbc dsn, lotus products: You can link to a Notes database from Access. You need to get the ODBC drivers for Notes from IBM s website. http://www.ibm.com/developerworks/lotus/products/notesdomino/notessql/ You then create an ODBC DSN for the Notes database and you can link to...

Using MS Access: Massive Database Design, network engineer, inventory database
network engineer, inventory database, fks: You have a good start here, you have identified the data you need to capture about an item being inventoried (not clear what that item is). So all you need is a table to capture those elements. Something like this: tblInventory InventoryID (Primary Key...

Using MS Access: Merging columns, distinct piece, service pack 2
distinct piece, service pack 2, column table: While there are exceptions, since its far easier to combine fields for display using concatenation, its almost always better to use separate fields for different data. One usual exception is a street address. Usually the street name and number is stored...

Using MS Access: MS ACCESS - Eliminating Part of a Text String, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, string manipulation: Watch this tutorial on text string manipulation, and if you still have questions, let me know: http://599cd.com/tips/access/break-up-text-string-instr/default.asp?key=AllExperts Let me know if you have any other questions or comments. Also, be sure...

Using MS Access: MS Access Total $ Field, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, many different ways: You don t need DLOOKUP for this job. All you need is a calculated query field. Yes, you can do it right on a form (and with the new versions of Access, right in a table) but I prefer doing it in a query. See this tutorial: It sounds to me like you just...

Using MS Access: Ms Access 2007, Multivalue combo box as a query criteria, selection fields, query criteria
selection fields, query criteria, dear scott: If you are looking to filter a combobox based on the selection in another control then the Forms!formname!controlname should work. You may need to requery the combo when it gets focus. What does the RowSource of your combos look like? Hope this helps,...

Using MS Access: Next and Previous Buttons, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, button wizard: You should be able to do this with the Command Button Wizard. Drop a command button on your form, and then when it starts up, select Record Operations, and then Next Record. Create another one for Previous Record. Let me know if you have any other questions...

Using MS Access: Open form and set specific ID Value, docmd, contract id
docmd, contract id, contracts: Something like this should work Behind your button use code like: If DCount( * , tblShipment , [ContractID] = & Me.txtContractID)=0 Then DoCmd.Openform frmShipments ,,,,acFormAdd End If Then set the default value of the ContractID control...

Using MS Access: Page breaks in a report, report, Access
report, Access, force page break: Nancy, Suggest you group the report by the letter on a footer and header too. In the report grouping window you can set a force new page after each footer. Bob Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html...

Using MS Access: Passing multiple selections from a form to a query, comma delimited string, magic combination
comma delimited string, magic combination, recordsource: You are correct. Theoretically, you should be able to enter: IN(Forms!formname!controlname) as the criteria in a query, and have the query filtered assuming the control contains a comma delimited string of values. But it doesn t work. So the answer...

Using MS Access: Pop Up Reminder in Access, checkbox control, reminder notes
checkbox control, reminder notes, object names: You have the chkReminder control set to Triple State which allows Nulls. First run an Update query that sets the value of the filed to 0 if its not True. This will eliminate any Nulls. Then set the default value in Table Design mode to No (or 0) so it won...

Using MS Access: Pop up Reminders, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, switchboard: Try this instead: DCount( [CSJ] , [FrmReminder] , [ExpectedCompletionDate] = # & Now() & # AND [Complete] =0 ) You need to enclose the VALUE for the current date/time inside of # signs. Let me know if you have any other questions or comments....

Using MS Access: Populating a text box/memo box, text memo, check boxes
text memo, check boxes, option group: Your design does not appear to be properly normalized. Having a lot of Yes/No fields is a sign of a denormalized database. If you want to show a list of items selected in a report, you should be using a child table. Use a subform on your main form and add...

Using MS Access: Query, missing something, all sorts
missing something, all sorts: First, Is this column in a Group By query? Otherwise there is no need for the Sum() Second, an IIF statement needs a true or false result, you only have one result. So it should look like this Ours: Sum(IIf(Left([oursorbrinker],7)= 650.710 OR Left([oursorbrinker],7)=...

Using MS Access: query for access pls help, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, query fields: You could create a calculated query field to do this using an IIF function. It would be something like: MyValue: IIF(X =.3, low ,IIF(X =.6, med , high )) Notice I ve got TWO nested IIF functions in there. Here are two tutorials that will help you with...

Using MS Access: Reference to form controls, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: 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 explains how to use this: http://599cd.com/tips/access/forms-formname-field-notation?key=AllExperts...

Using MS Access: Report Problems, report button, strange problems
report button, strange problems, object names: Check your WHERE condition. I suspect that you are using a combobox to display the name of the company or individual, but the bound column for that combo is the key field of the table. So there is a data type issue. You need to check the Bound column of the...

Using MS Access: Running VBA in Excel from Access, csv data, csv file
csv data, csv file, access macro: You can use the TransferText method to link to the csv file. If the csv is always the same name and location then link to it once manually. If you don t need to link to a different file each time, then you can do this without ANY VBA coding at all. Its all...

Using MS Access: restrection for some item, column model, combo box
column model, combo box, microsoft access: I m not sure I follow what you need here. If you want to make sure the user records only items in the first table, then use a combo box to select the part number and set the LimitToList property to yes. Hope this helps, Scott Microsoft Access MVP 2007...

Using MS Access: cannot run VB expression in different computers MS Access 2003, version ms, regional settings
version ms, regional settings, regional setting: I think I understand the problem. One computer has different regional settings than the other. The Regional Settings in Windows govern how Currency is displayed. So Access doesn t seem to like the regional setting on the other computer. Not sure, however,...

Using MS Access: searching db, word apple, question response
word apple, question response, survey database: Yes, a survey database requires a special structure. It looks something like this: tblQuestions QuestionID (Primary Key Autonumber) Question tblRespondent RespondentID (PK Autonumber) Firstname Lastname other info about respondent tblResponse...

Using MS Access: If statement in Access, reply thanks, microsoft access
reply thanks, microsoft access, drop down menu: This isn t an IF statement. What it sounds like you are talking about called Cascading or Synchronized comboboxes. Where the selection of one combo filters the selection in another combo. This article: http://support.microsoft.com/kb/209576 shows you...

Using MS Access: User Input "Criteria", jet database engine, types of queries
jet database engine, types of queries, input criteria: I m not Julie, but the solution to your problem is twofold. First, do not use a Parameter prompt query, second use an interim query. I very rarely use parameter prompt queries because they are very limiting. So what I suggest you do is create an unbound...

Using MS Access: User input, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: The best way to do this is with a second form that asks for their input. Here is a tutorial that will show you how to do this: http://599cd.com/tips/access/forms-formname-field-notation/?key=AllExperts Let me know if you have any other questions or comments....

Using MS Access: Using DateDiff to calculate how late a student is to class, datediff, decimal portion
datediff, decimal portion, integer portion: First, you need to understand that 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 = .25) To help you I need to...

Using MS Access: Yes/No Boxes Versus Lookup Tables, Yes, No
Yes, No, option boxes: Tana, Both work. It is a matter of preference. Speed of user selection would be the deciding factor. If user is on a mouse already when entering the form control s focus, then radio or check boxes or toggle work faster. A combo box requires from a mouse...

Using MS Access: "0" <> "0" in Number Data Type, numeric fields, null set
numeric fields, null set, numeric field: What are the numerical subdatatypes for the two fields? For example: If one is Long integer and the other Integer, they may not be equal. Especially if one is Double and the other Integer its unlikely they will be equal. If you need to have different subdatatypes,...

Using MS Access: Access 2007, network folder, sequence of events
network folder, sequence of events, microsoft access: No, the back end is shared. If you haven t split yet, then make sure you split the back end to the shared network folder. So each local copy is linked to the single, shared, back end. Generally, I develop in a unsplit DB until I m ready for user testing....

Using MS Access: Access 2007, data tables, access database
data tables, access database, backend: Not only practical, but its what Sharepoint was designed for. This is especially true if the primary role of the support centres is to enter data. You can put the data tables then need to input on Sharepoint and have additional tables locally for your processing....

Using MS Access: Access 2007 image control source, control source, image control
control source, image control, database knowledge: If the image is BOUND to the table (in other words, the picture is STORED in your database) then it should automatically update each time you move from record to record. However, if you re just storing the path and filename of the image in your table (as...

Using MS Access: Access 2007 Report AfterUpdate calculation, text details, combo box
text details, combo box, combobox: If YearMonth is an unbound combobox on your form, it might still be returning a TEXT value which could throw off your Dsum. Try using CLng(SelectYearMonth) in your Dsum statement to convert that value to a number (long) beforehand… unless the data is...

Using MS Access: Access Asset Template Question, design mode, filter button
design mode, filter button, new values: Hello Kev. o When I type in text and hit enter. The list datasheet will refresh. How did they do that? - Well the subform is based on a query which refresh s on the OnAfterUpdate Event. - The subform will then bring you new values based on the On Form...

Using MS Access: Access Asset Template Question, global module, combobox control
global module, combobox control, filter button: The code for that would probably be an embedded macro in the After Update event. The picture initially changes in the After Update event, and then changes back and clears the filter in the On Click event The Default view is probably set to Datasheet...

Using MS Access: Access DB, four tables, table structure
four tables, table structure, project id: Its not pre-populate, its filtering. If the user is adding a new record then all they should need is to select the project ID within the new record (unless its a new project). Doing weekly and monthly reports depends on your table structure and the data...

Using MS Access: Access Runtime - read only message, autoexec macro, folder c
autoexec macro, folder c, target: Ok, So you have checked that a) He has a folder named C:Program filesMydatabase on his PC b) that he is putting the files in that folder c) that the user he (or you) is logging in as has full rights to that folder Also what is the Target behind the...

Using MS Access: Access SQL statement using DISTINCT, greek letter sigma, sigma press
greek letter sigma, sigma press, summary query: Well, you could do it this way... create a query (Sample2) which looks like this: SELECT Customer, PatientID FROM SampleT GROUP BY Customer, PatientID; That will give you a list of unique patient IDs: Customer, PatientID Bowsers, 101 Bowsers,...

Using MS Access: Access stability, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, knuckle dragger: Some versions of Access have been unstable in the past. Access 95 was horrible. Access 2002 had a lot of bugs until they released the first service pack. However, overall it has been a very reliable platform. I have been running my business on an Access 2000...

Using MS Access: AfterUpdate() calculation, employee id, combo box
employee id, combo box, accurate count: I m not Manish, but I think I can help. Your DSum should work depending on where you put it. If the expression is used in a code module to assign a value to a control, it should work. I.E. Me.txtPages = DSum( Pages , HBELP_FINAL_Q , YEARMONTH = & Me.[SelectYearMonth]...

Using MS Access: Audit Trail, audit trail, vba
audit trail, vba, extent: A comprehensive audit trail that will record any and all changes to data in specified fields requires VBA. There are many audit trail examples out there using VBA to different levels. But you have to use VBA to some extent. Hope this helps, Scott ...

Using MS Access: Auto Email alerts, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, google search: Yes, this is certainly possible, but it s a little more complicated than I can go into here. You might be able to find some sample code with a Google search. I cover sending an email through Outlook in my Access 329 course, however if you re using any version...

Using MS Access: Automatically assign a value to a text field when a button command is selected, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, choice button: 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: access runtime, registry mechanic, private question
registry mechanic, private question, access runtime: I saw you posted on Microsoft s Answers forum. I started reading that thread because I thought it might have some tips for you. I m glad you did. The only thing I can offer at this point is to send me a copy of the file and see what I can do with it. If...

Using MS Access: Composite Key Reference, focus event, chicago office
focus event, chicago office, combobox: Not the way you are doing it. You don t want a city and department to be unique. Can t you have multiple issues from the same city and department? What it sounds like is that you want to make sure they can t choose a department from a City where that department...

Using MS Access: Creating a list with sequential numbers 0 - 5000 or more..., sequential numbers, sequential number
sequential numbers, sequential number, arbitrary number: This would be easier to do in Excel. Just start a sequence and drag the sequence until completion. Then import as an Access table. But frankly, I don t understand the purpose of this. What value is there to assigning an arbitrary number to a record? If...

Using MS Access: cancelling onformat event, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: If you can cancel an event, you ll see Cancel as an incoming parameter. I don t believe, however, that you can cancel the footer before the header. The header gets built first. You d have to evaluate the condition beforehand. Let me know if you have any...

Using MS Access: combobox goes blank, microsoft access, vba
microsoft access, vba, microsoft office: I m drawing a blank. I can t duplicate this and it looks like you have everything setup correctly. The last thing to try is to delete the control and recreate it. Hope this helps, Scott Blog: http://scottgem.spaces.live.com/blog Microsoft Access MVP...

Using MS Access: Database setup, database setup, computer hope
database setup, computer hope, pr business: While Filemaker is a great product, since you already have Access, it makes sense to use Access. Access is very stable, easy top modify and has the largest support around. You can start with the Contact template that comes with Access and customize it from...

Using MS Access: Default value, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, blank fields: You can use a calculated field in your query to change blank fields to say Applicant or go the other way. MyField: IIF(IsNull(FirstName), Applicant ,FirstName) This says create a field called MyField. Set it equal to Applicant if the FirstName field...

Using MS Access: Email transmission, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, sendobject: There is no way that I know of to bypass the Office 2007 security popup that appears when you try to send automated email. That s a security feature that Microsoft insisted upon to cut down on spam. If you want to send automated BULK email from Access without...

Using MS Access: 'File Integrity Violated', network environment, error message
network environment, error message, locks: HI Sukhbir, What kind of file are you trying to copy. Is it the front-end or are you moving an entire back-end .MDB file ? Please make sure no user s are still working on that file if on a network environment, this still leaves behind the locks on that...

Using MS Access: Getting a field to autosearch for dupe records, dlookup, patient number
dlookup, patient number: Is the main form bound to the patient table to enter new patients? If so, use a DLookup in the After Update event of the Patient number control to lookup the enter entered #. Something like: If Not IsNull( [PatientID] , tblPatients , [PatientID] = & Me.PatientID)...

Using MS Access: Group Concat, access databases, multiple records
access databases, multiple records, mvps: You need a custom function for this. You can find a function that will concatenate values from a field in multiple records based on a group value here: http://www.mvps.org/access/modules/mdl0008.htm So your query would look like this: SELECT tblLicences.FilingNumber,fConcatFld(...

Using MS Access: HELP ! combobox goes blank, student details, focus event
student details, focus event, cursor: So the ProfID should show after a selection is made. Is it possible the ProfID is blank for the record selected? Otherwise I can see no reason this shouldn t work. Hope this helps, Scott Blog: http://scottgem.spaces.live.com/blog Microsoft Access...

Using MS Access: Help! my combobox goes blank, combobox, student details
combobox, student details, focus event: Why are you using an On Got Focus event? Just put an AfterUpdate event in Combo2 and refresh Combo3, just like you said you re doing for Combo1 and 2. See this tutorial for how I use cascading combo boxes: I get asked this question all the time. You...

Using MS Access: Help trouble-shooting a query, credit card transaction, currency reference
credit card transaction, currency reference, credit card transactions: My Fault. I forgot the Alias in the SQL Statement I gave you: SELECT Travel_Card_ID, Vendor_ID, Transaction_Date, Amount, Nz(DLookup( [User_Travel_ID] , User_Travel , [Travel_Begin] # & [Transaction_Date] & # AND [Travel_End] # & [Transaction_Date]...

Using MS Access: Inventory database, inspection dates, inventory database
inspection dates, inventory database, four tables: First, your design has flaws. When designing a database you first design as much of the tables as possible before you start in on forms. Also you have fields in your Inventory table that should not be there. A principle of a relational database like Access...

Using MS Access: List Box, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Yes, this is certainly possible. You have to understand how to code a multi-select listbox however. It will require some VBA programming. I have a free tutorial on my web site that covers this EXACT topic: http://599cd.com/tips/access/recordsets/?key=AllExperts...

Using MS Access: List Box to update table, onclick event, different perspective
onclick event, different perspective, command button: Hi Jessica, This won t be possible with your approach. Infact you need to look at your problem from a slightly different perspective. Instead you can have a subform listing all the employees with an additional check box & a DatePresent field, this check...

Using MS Access: MS Access 2007, incoming values, production quantity
incoming values, production quantity, daily basis: You need to create a transaction table that lists any movement of raw materials both in and out. You then need to populate this table with the usage from each mix. You don t make your workflow clear, so I don t know whether it is practical to enter each production...

Using MS Access: MS Access, calculated, calculated expressions
calculated, calculated expressions, calculations: You should place calculations in queries, forms, reports. In a query place a name for the calculation at the top of a column follow by a colon and the calculation. For example, Extended Item Cost:[unit price] + [quantity] The query can then feed a report....

Using MS Access: MS Access append table not working, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, tim tate: Wow… that s interesting. I ve never seen that happen before. Do you have some kind of data validation or indexing in place that s preventing Access from appending records to a table that already exists? That s about the only thing I can think of. Without looking...

Using MS Access: MS Access Quarters, q1 q2, sort orders
q1 q2, sort orders, field structure: Hi Amir, Creating a table with Generic fields isn t advisable for dynamic content[s] such as yours. Your table should contain only a single Date field and other fields for which you want to calculate/project performance. For example. Field 1= Product...

Using MS Access: MS Access Query IF Statement, many different ways, access query
many different ways, access query, ms access: If you are looking to add a column that identifies whether the field contains SPSP try: SPSP: IIF(InStr(1,[textfield], SPSP ) 0,Yes,No) If you are looking to just return a listing of records that have SPSP then set the Criteria for that column to: Like...

Using MS Access: Multiple record entry, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, charitable orgs: If you re going to have multiple bids per bidder, then yes, you should have another table. 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...

Using MS Access: macros to modules, screen buttons, vba
screen buttons, vba, microsoft access: Without seeing the code, its hard to know what s going on. But I suspect, from the message, that your code is trying too make some changes to the design of the application. This may be as simple as saving a form with a filter or sort order. So you need to...

Using MS Access: ms access 2007, Last record, record sort
Last record, record sort: Jason, Make a query to feed form 2. Have the query sorted by auto number descending order or date / time sort. Then set the top property of the query to one, so only one record shows. Bob Heifler MyAccessProgram.com Contact information: http://www.myaccessprogram.com/Contact.html...

Using MS Access: open form to last record added, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: I m assuming both of your forms pull data from the same table. You d need to save the data in Form1 first, then open the same record in Form2. You could put something like this in your button: Me.Refresh save the record on Form1 Docmd.OpenForm Form2...

Using MS Access: Product ordering database, customer query, customer visit
customer query, customer visit, dry storage: First, in reference to populating other tables, you shouldn t be doing that. One of the principles of a relational database is that data should exist in ONE place only. So, in your visit table you have a field for CustomerID, that is the ONLY info about the...

Using MS Access: Re-Used Login ID for Telephony Data, greek letter sigma, sigma press
greek letter sigma, sigma press, summary query: This makes sense, but do you have a separate field to track the EmployeeID as well? If so, you just need to use an aggregate query to sum up the values. To do this, use an Aggregate Query... also called a Summary Query or Totals Query. There is a little...

Using MS Access: Recommendations, allison balter, alison balter
allison balter, alison balter, jeff conrad: I tech edited Roger Jennings new book from Que Publishing whihc will be released next month. You can find out more about it here: http://www.quepublishing.com/store/product.aspx?isbn=0789743078 Also Jeff Conrad is another friend who s books are very good...

Using MS Access: Relationship Diagram, relationship diagrams, relationship diagram
relationship diagrams, relationship diagram, performance implications: I ve never heard of any performance issues either way. Generally I only formalize relations to enforce referential integrity. Otherwise its not necessary. If you are using unbound forms mostly, then you can probably enforce referential integrity through...

Using MS Access: Reports and many-to-many relationships, document c, project 1
document c, project 1, document control: I don t believe you can do this from the perspective of projects. You can go the opposite router and produce a report grouped by Document and listing all projects associated with them. But if you group or sort by project, each project is going to be listed...

Using MS Access: runtime - VBA not working, requery, menu functions
requery, menu functions, backward compatibility: What about the rights to the folder where the front and back ends reside. Do you have full read/write rights? How are you launching the app? From a shortcut or Windows Explorer or what? Hope this helps, Scott Blog: http://scottgem.spaces.live.com/blog...

Using MS Access: Single form for different Reports, tips access, different reports
tips access, different reports, text boxes: Here s what I would do… Make a combo box that contains all of the names of your reports. You can have two columns - one for the system name of the report AccountsPayableR and the english name Accounts Payable that s visible - if you want. Now, make...

Using MS Access: Splash Page, form timer, timer
form timer, timer: Great question peter. The form has a timer event. That s were you ll put code to close the splash screen in open the next form you want open. You can set the timer to trigger every so many milliseconds by setting that value in the form s property sheet....

Using MS Access: Subreports, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, auto size: Look for the CAN GROW property for the subreport. Set it to YES and it will be able to grow vertically. Also make sure the CAN GROW property for the SECTION its in is also set to YES. Let me know if you have any other questions or comments. Also, be...

Using MS Access: a select query in vba, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Use DLOOKUP instead. 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: shedule updates at night, windows task scheduler, oracle discoverer
windows task scheduler, oracle discoverer, autoexec macro: You can set a form to load on default and run code in the On Load or On Open events. But that seems overkill for this purpose. Hope this helps, Scott Blog: http://scottgem.spaces.live.com/blog Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: Make Table query - variable name, peoplesoft tables, table queries
peoplesoft tables, table queries, query design: You will have to generate the SQL code in VBA to do this. What I would suggest is to create one Make Table query using Query Design mode. When you select a Make Table, it prompts you for the table name, that same dialog allows you to select an external database...

Using MS Access: Update table based on text boxes in Form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, combo boxes: You can use an Append Query to add records from one table onto another. See this FREE tutorial on my website for step by step instructions: http://599cd.com/tips/access/student-attendance-append-query/?key=AllExperts Let me know if you have any other...

Using MS Access: using IIF in query criteria, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, query criteria: You re using the IIF statement incorrectly. Plus, Is Not Null can t be used to set a value like that. Here s what you should do: make an AfterUpdate event for your checkbox. In it say: If ShowOnlyJobSheetsData = TRUE then Me!RecordSource = SELECT...

Using MS Access: 2010 - needed features?, gut instinct, intermediate user
gut instinct, intermediate user, greek characters: As far as your Greek question goes, I don t know. I would have to set this up and test it for you, and the laptop I m on right now doesn t have Office 2010 on it. My gut instinct tells me YES, but I m not sure. The good news is that you can download and install...

Using MS Access: Access 2007, what are the datatypes, survey results
what are the datatypes, survey results: First question is what are the datatypes for Imp Business Needs and Geographic Region. In the Dusm and Dcount you are treated them as text fields and trying to SUM a text field will result in an error. So will comparing a number field to a text field. ...

Using MS Access: Access 2007, relationship question, primary key
relationship question, primary key, eventid: First, You should NOT be using Event Name as a key field. Using text fields for joins slows performance. That s why I suggested an EventID field to use as the Foreign Key. Use Autonumber fields for your keys. Second, in reviewing this, I misstated the...

Using MS Access: Access 2007, microsoft access, vba
microsoft access, vba, eventid: It doesn t matter that an event may not have a payment, in that case, you just don t create a payment record. But it does matter that a payment may not be tied to an event. So a payment is always tied to a person, but may not be tied to an event. In that...

Using MS Access: Access 2007 Query Results, query design, open query
query design, open query, design mode: If you are are using Query Design mode to create your queries, then you just add the query to the table pane. When you first open Query Design mode it asks you to select a table or query. If you have gotten past that, you can right click on the Table pane...

Using MS Access: Access 2010, sales pipeline, option groups
sales pipeline, option groups, column count: Is this database to manage the orders made through the website or to allow customers to place orders? If its the latter than Access is not the right tool. Access is not usable as the back end for a WEB site. But if you are doing the form, Access is fine....

Using MS Access: Access changes data type when linking to Excel spreadsheet, conversion function, query in access
conversion function, query in access, common element: Marsha and you will use a data conversion function in the Derived column of the query. In excel you will then link to that query that you have created. If you do not know how to use the conversion functions of access let me know. My first answer had a link...

Using MS Access: Access, Drop-Down Box, Data not Displaying, question row, column count
question row, column count, drop down boxes: Is that the RowSource TYPE? If the Rowsource just says query, that could be the problem. The RowSource needs to be the name of a table or query or a SELECT statement. Hope this helps, Scott Blog: http://scottgem.wordpress.com Microsoft Access MVP 2007...

Using MS Access: Access input masks and auto tab, input masks, input numbers
input masks, input numbers, command buttons: Need more details about what you are trying to do. If I m following you there are buttons arranged as a numeric keypad. So instead of pressing the number keys, the user can use a mouse. So how do you get the characters into the control? What is the code...

Using MS Access: Access Parameter Query Syntax, proper syntax, notation key
proper syntax, notation key, query syntax: Here s a tutorial I have on my web site for the proper syntax: http://www.599cd.com/tips/access/forms-formname-field-notation/?key=AllExperts As far as showing ALL records goes, if you want the user to be able to leave the field blank and have the query...

Using MS Access: Access Reporting Design, three tables, best choice
three tables, best choice, realtor: First I have to say that almost reports I do are based on queries. Basing a report on a query gives you much greater flexibility. Second, I also have to say that if you have a Yes/No value you should use a Yes/No field rather than a text field. Had you done...

Using MS Access: Access report won't save, blank report, query tables
blank report, query tables, recordsource: First, have you done a compact and repair of the database? When you say it can t be edited or saved can you go into Design mode? Do you get any error messages? If you can open the report in design mode opening a blank report in design mode and set the Recordsource...

Using MS Access: Auto populate a cell, lastname firstname, column count
lastname firstname, column count, relevant properties: You have to use YOUR field and table names in the RowSource. You may need to put brackets around the field names. Whenever you get a parameter box like that when you don t expect it, it means that Access can t find the referenced name so assume you want...

Using MS Access: attendance system, attendance system, video lecture
attendance system, video lecture, primary key: This was posted to a general pool, so I m not sure who s video you were referring to. When I setup an attendance tracking app, I track absences, NOT attendance. Its easier that way. So basiczally you have a table like tblAbsence AbsenceID (Primary Key Autonumber)...

Using MS Access: Converting formats, serialnumbers, mrp system
serialnumbers, mrp system, 012345: If you are Updating the data then I would run 2 passes to remove the double leading zeros. If you are just looking to display the converted value, then you can use a Nested IIF to first check for 2 zeros, then for only one. Its probably 6 of one, half a dozen...

Using MS Access: Counting Items from a Combo Box, tips access, sum function
tips access, sum function, combo box: It sounds to me like you don t want a combo box, you want a TEXT box to show that number. The easiest way to do this is to create a continuous form that shows all of the records, and then you can just use a form footer with a COUNT function to add them all...

Using MS Access: creating a comments history field, history field, foreign key
history field, foreign key, primary key: Not sure where you got that solution, but its NOT what I would recommend. Instead I would recommend a Comments table: tblComments CommentID (Primary key Autonumber) parentID (Foreign Key -- this will be the primary key of the parent record) CommentDate...

Using MS Access: Database Design, 20 amino acids, prototype database
20 amino acids, prototype database, gene mutation: The problem here is I don t know enough about the subject to be sure of certain things. Much of the structure looks OK. But the Mutations table may be off. I m assuming here that BP1, BP2 etc are types or classes of mutations. If that s the case, then a better...

Using MS Access: Display dropdown values based on contents of another field, category table, dropdown list
category table, dropdown list, microsoft access: This is a standard procedure called Cascading or Synchronized combos. This article explains how to do it: http://support.microsoft.com/kb/289670 Even though its for Access 2002/2003 the techniques work the same in 2007. Hope this helps, Scott ...

Using MS Access: Filter on Signing In, security wizard, current user
security wizard, current user, vba: So you are using ULS. I m not a big fan of ULS. In fact Microsoft has dropped it for 2007 (when using the accdb format). I believe the expression: =Environ( Username ) will return the name of the logged in user. You can then base your forms on a query...

Using MS Access: Filtering to a record from another form, allison balter, code snippets
allison balter, code snippets, posno: The first Code should work assuming that PosNo is a number datatype. The second code should also work if you are changing things after frmProforma is opened. But its not the way I would do things. If neither of those code snippets is working does anything...

Using MS Access: Finding the difference between two dates in microsoft access, firstdate, datediff function
firstdate, datediff function, dsum: You can use the DateDiff() function to determine the number of calendar days between two dates: DateDiff( d ,firstdate,seconddate) You can do this in a query by adding a column: DaysBetween: DateDiff( d ,firstdate,seconddate) You can use a DSum...

Using MS Access: Form Entry Issue, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, button wizard: Access automatically saves the data in your table as soon as you move off the record or close the form. So in order to present the illusion of a save button, all you have to do is really just issue the command to move to a new blank record. You can do this...

Using MS Access: filtering subform using radio buttons, radio buttons, object names
radio buttons, object names, case 2: The first question is what is stored in the Pass or Fail field (btw using spaces in object names is a bad idea). It would appear that its a text field storing the words Pass or Fail or a blank?If so you need to wrap the words in single quotes Ex: Me.Filter...

Using MS Access: HELP - need to unhide table in Access 2010, hidden objects, navigation pane
hidden objects, navigation pane, navigation options: Right click on the title bar of the Navigation pane and choose Navigation Options. You can select to show Hidden objects there. Hope this helps, Scott Blog: http://scottgem.spaces.live.com/blog Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: Lookup to two tables, referenced tables, redundant data
referenced tables, redundant data, foreign key: There are two things you can do here. The first is to use only one lookup table and add a field to identify whether they are a Foreman or Inspector. Then you can filter your combos to show one or the other or no filter for both. In fact, if you have an employee...

Using MS Access: linking data, linking data, three tables
linking data, three tables, foreign key: I also asked for the structure of these tables. Based on what you have told me so far. I would have a single table like this: tblCompanyContact CompanyContactID (Primary Key Autonumber) CompanyID (Foreign Key) Firstname Lastname Title Phone Primary...

Using MS Access: linking tables, allexperts, tips access
allexperts, tips access, three tables: If all of your records are PEOPLE (employee, main manager, alt manager) then you really only need ONE table. You can make a table refer back to itself... just have ID fields representing those two managers. However, if you really want to three tables to...

Using MS Access: MS Access 2007, usage database, first hope
usage database, first hope, libray: You really don t need to do this. Basically you are duplicating data which is a no-no. This is handled more in queries or reporting. However, you can do it with the expression: =DMax( [CloseoutMiles] , Transactions , [VehicleID] = & Me.VehicleID) You...

Using MS Access: MS Access 2007, vertical cells, horizontal cells
vertical cells, horizontal cells, macro cell: First stop thinking in terms of a spreadsheet. Access is NOT a spreadsheet its a relational database. A spreadsheet is the most suitable tool for tracking large amounts of data. The scenario you describe (incompletely) does not work in a relational model....

Using MS Access: MS Access (Calculating Average Start Time), time hh, initial query
time hh, initial query, datepart: You are close. Try this: SELECT [QUERYA].wknbr, [QUERYA].NME_JOB, AVG((DatePart( h ,[StartTime])*60)+DatePart( n ,[Start_Time]) AS fieldavg1 FROM [QUERYA] GROUP BY [QUERYA].wknbr, [QUERYA].NME_JOB; This will give you an Average of the number of minutes...

Using MS Access: New record on form based off a multi-table query., example tables, division organization
example tables, division organization, school divisions: Honestly, unless you re dealing with a LOT of records (hundreds of thousands) or a LOT of different, unique fields (dozens) then I would just put all of the fields in the same table. If you only have a few (10 or so) fields that will ONLY be used for one company...

Using MS Access: Number from date, date control, control source
date control, control source, numbering system: If I understand what you need, you want to have an identifier on a report. That identifier will combine the date in a date field with the employee number. You can use the following as the control source of a control on your report to do this. =Format([datefield],...

Using MS Access: Parameter Query, parameter query, text boxes
parameter query, text boxes, default values: The way I handle this is to set the default values of the two text boxes to: =DMin( [datefield] , table ) =DMax( [datefield] , table ) This way it will return all records. Hope this helps, Scott Umm, How much clearer do you think I could have...

Using MS Access: Print Report From Form, docmd, datatype
docmd, datatype, input data: The code you posted should work if there is a field named ReportNumber and that field is a numeric datatype. If ReportNumber is text (whihc I suspect it might be at 13 characters) then try: DoCmd.OpenReport stDocName, acPreview, , [ReportNumber]= & Forms!frmReport!ReportNumber...

Using MS Access: Quantity on Hand, material fields, page tabs
material fields, page tabs, qoh: Ok, here s your initial problem. You have duplications in your tables. This is what I think your tables should be. Tbl_Materials MaterialNumber (PK – double – formatted 000000-0000-000;0 ) MaterialDescription OpenStockQty Tbl_DeliveryOrder DeliveryOrderID...

Using MS Access: Report Page Break, Access report page break, Access report footers
Access report page break, Access report footers, Page break: In the grouping area of the report design, set force page break after that groupings footer. You will find these properties in the grouping specifications. Since this is not a question that I can quickly answer in this email because it requires some steps...

Using MS Access: Reports and grouping, csw report, aggregate function
csw report, aggregate function, text boxes: Yes, If you put an expression with an aggregate function (i.e. Sum, Average, Count, etc.) in a Group footer, it will do its totals on each group. Alternatively you can use Domain Aggregate functions (i.e. DSum, DCount, etc.) And set the criteria to the...

Using MS Access: refreshlinks, autoexec macro, global module
autoexec macro, global module, lal: Sorry to not answer sooner. Somehow notice of the question got lost. As I recall, I referred you to the fRefreshlinks() function at www.mvps.org/access. I also gave you an addition function; CurrDBDir(). What you should do is put all those functions into...

Using MS Access: replication of database for new year, database icon, recordsource
database icon, recordsource, blank area: And then you have to do this EVERY year? That is NOT good design. You should have a field in your table that indicates what year each record is for. Then you don t need to archive the old data every year. If you insist on fostering this bad design its fairly...

Using MS Access: Saving an attachment using the attachment control on forms, access programmers, attachment type
access programmers, attachment type, question thanks: Application.FollowHyperlink Me.Controlname where Me.Controlname is the name of the control bound to the text field. You can put that line of code in a button, or the double click event of the control. This will open the file with the default application...

Using MS Access: Sequential numbering by Job, vba examples, sequential numbering
vba examples, sequential numbering, sequential number: If JobNumber is a text datatype, then it should be: Me.txtOrderNumber = Nz(DMax( [OrderNumber] , tblNCRReport , [JobNumber] = & Me.[JobNumber] & ), 0) + 1 txtOrderNumber should be bound to the OrderNumber field in your table and should be hidden.....

Using MS Access: Sequential numbering using several controls, format date, sequential numbering
format date, sequential numbering, dmax: First, you shouldn t be storing RecordNumber. Since its a concatenation of the other three no reason to store it. Second, you shouldn t be storing Inspector Name in tblReport. Just the Employee number. Third, you don t need a lot of the code you are using....

Using MS Access: Sorting (Alphabitizing function), ms works, list of names
ms works, list of names, text documents: This also has nothing to do with MS Access, and I m not very familiar with Works, but I may have a suggestion here. Try copying your list into Work s spreadsheet, sort it there then copy the sorted list into your document. Hope this helps Scott ...

Using MS Access: Summing In a from, dsum, control source
dsum, control source, object names: Then adding a text box control to the footer and setting the Controlsource to: =Sum([Pressure Loss]) should work, assuming the field is a number datatype.p Hope this helps, Scott Blog: http://scottgem.wordpress.com Microsoft Access MVP 2007 Author:...

Using MS Access: Tricking the clock, time hope, microsoft access
time hope, microsoft access, vba: Actually it is. In the After Update event of the control where you enter the date, you can put code like: IF Datepart( h ,Me.[timecontrol]) 6 Then Me.timecontrol = DateAdd( h ,-6,Me.[timecontrol]) End If This will subtract 6 hours from the entered...

Using MS Access: Unsaved Data, split database, recordsource
split database, recordsource, unsaved data: Yes you can copy and paste. But AutoFEUpdater makes it easier. Check it out at autofeupdater.com If you get the 3.14 version its free. Hope this helps, Scott Blog: http://scottgem.wordpress.com Microsoft Access MVP 2007 Author: Microsoft Office Access...

Using MS Access: Unsaved Data, unsaved data, access xp
unsaved data, access xp, connec: Hi Scott, I checked out the actual tables to see if the data is being entered there and it is. So the problem must be with the form then. What do I need to do now to figure out the problem? Also, I still need to run the splitter wizard correct?? I...

Using MS Access: Updating table, with form.., external data source, access help
external data source, access help, google: There are two ways to build forms. The first and easiest is with a bound form. With bound forms, Access handles all the I/O between the form and the table. The other way is with an unbound form. With such a form, you have to use VBA to code the I/O. I...

Using MS Access: Using a Form to filter a Query, source requirement, date shop
source requirement, date shop, combo boxes: A couple of possibilities. First on the date range, set the default values of the start and end date controls to: DMin( [Order Request Date] , Shop Orders ) DMax( [Order Request Date] , Shop Orders ) This will include all records. For the three comboboxes,...

Using MS Access: Using IF function between 2 tables, quantity number, quantity control
quantity number, quantity control, isnull: I wouldn t do this as a validation rule. In the After Update event of the Quantity control on your Order form use code like: Dim intQOH As Integer If IsNull(Me.ProductID) Then MsgBox Please select a product first! Me.ProductID.SetFocus Else...

Using MS Access: using one access form to interface more than one table of the same type, multiple records, separate tables
multiple records, separate tables, open table: Wrong structure! There is NO reason to create separate tables for the same data. All you need is a field in your table to identify the project. It sounds like you have multiple records per project so you really need TWO tales. One table with records for...

Using MS Access: Verify Item Number not Duplicate, vba code, single quotation marks
vba code, single quotation marks, frma: My fault, I missed that comma after MsgBox. It shouldn t be there. Lets say you want the number to always be 6 characters with leading zeros. The expression: Format([fieldname], 000000 ) will display 6 characters with leading zeros, if needed. You...

Using MS Access: vb.net, connection strings, access connection
connection strings, access connection, microsoft access: I[ m not a VB.net developer, but if you are using an Access database (either MDB or ACCDB) as your data engine, then you need to create a connection to the data source. In addition, you need to code all the I/O between your interface and the tables but that...

Using MS Access: ACCESS 2007, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, table relationships: It s not only a bad candidate, it s IMPOSSIBLE. An Autonumber gets assigned by Access each time you add a new record to a table. So it s great for a PRIMARY key, like CustomerID in the CustomerT table: ID, Name 1, Joe 2, Fred 3, Bill etc. However,...

Using MS Access: Access 07 User-Level Security, user level security, security question
user level security, security question, microsoft access: It can be anything you want. I would tend to use numeric values. As for retrieving the restrictions us a DLookup. But I really don t think you need to fine tune that much. Most forms fall into specific categories. Like manages get some access and supervisors...

Using MS Access: Access 2003 issuse, please help., microsoft access 2003, column width
microsoft access 2003, column width, combo box: I already told you to RIGHT CLICK PRODUCT COMBO AND AT LAST OPTION YOU WILL SEE PROPERTIES CLICK PROPERTIES. Send me your db ... i do not want to hang with a single question. aziz_abroad at yahoo dot com *********Update **** no need to send db...

Using MS Access: Access 2007 Auto-populating Combo Boxes, notinlist event, combo boxes
notinlist event, combo boxes, strsql: To do this right you need to set up a lookup table for the titles. Like this: tluTitle Title Creating a lookup table is no different then creating any table, the difference lies in the function and naming. Next create your combobox, using the combobox...

Using MS Access: Access 2007 field value dependant on lookup field, column c, quick reply
column c, quick reply, joe bob: I m not sure what the bottom form is. That shouldn t be there. But the main form with the shares subform looks correct. Generally, I create my subforms as a separate form, (using the wizard) then embed the form on the main form. You should be able to enter...

Using MS Access: Access 2007 Multi User same front end, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, network folders: Make sure that none of your databases are opened in EXCLUSIVE mode. Ideally, you should have a copy of the FRONT END database on each PC. That way you can avoid conflicts with THAT specific file being opened. But, if your data is all in the BACK end,...

Using MS Access: Access converting to upper, lower proper, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Tom, if you have a large number of records to convert, you want to use an UPDATE QUERY with the appropriate function. See this tutorial for more information: You can use an Update Query to change records in a table. See this FREE tutorial on my website...

Using MS Access: Access Database date reminders, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, access dlookup: Yes, it s possible, but it s going to involve some programming. For example, you could program something into a startup form so that when you start the database, it performs a lookup to see if any records match your criteria (I ll include a tutorial for DLOOKUP...

Using MS Access: Access Equivalent of Excel's HLookup, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Use the DLOOKUP function. It will accept multiple criteria: X=DLOOKUP( FieldName , TableName , ID= & SomeID & AND DateField # & SomeDate & # ) Here s a tutorial to help you: You can use the DLOOKUP function to look up a specific value from a...

Using MS Access: Access Form Control Source?, survey questionnaire, group setup
survey questionnaire, group setup, control source: On the main form you will have a control bound to TestID. This can be an option group or a combobox, whatever you prefer. This is how the user selects the test. You use tblResponse to record each time a test is taken. So tblResponse tells you who took the...

Using MS Access: Access Form problem, google searches, previous condition
google searches, previous condition, google: YOu need to make sure that no other user is using the database. Before you open it, make sure there is no LDB file present, which there would be if others were connected. Then open it with the open exclusive option and make your changes. After making...

Using MS Access: Access Full Info Export, relevant tables, database field
relevant tables, database field, many tables: Why would you want to do that? Also what do you mean by custom fields . And how many tables are in this database? You could create a query that joins all the relevant tables. You can then display that query in datasheet view which would be the same as...

Using MS Access: Access Macro message, access macro, query name
access macro, query name, hi chris: Hi Chris, Many thanks for the question. You will need reference the query as well as the field: try for the Macro condition Not IsNull(DLookUp( practices , qryPractice2 )) and for the message box = DLookUp( practices , qryPractice2 ) Change...

Using MS Access: Access Recipe Database, searchable recipe database, database window
searchable recipe database, database window, allexperts: The ribbon is an Access 2007 feature. I don t see where I referred to the Home Ribbon, but I did refer to the Create ribbon. The Form Wizard is actually on the Database window in Access 2003. Hope this helps, Scott Microsoft Access MVP 2007 Author:...

Using MS Access: Access Subforms, foreign key, tjx
foreign key, tjx, combobox: You need more tables. At least two more. What you should have is : tblPeople PersonID (Primary Key Autonumber) FName, LName, other info about the person tblTraining TrainingID (PK Autonumber) CourseName, other info about course tblSession SessionID...

Using MS Access: Access Tables, report numbers, command button
report numbers, command button, combo box: place a command button on the where you have combobox. then select report number , press enter and click command button (but first you need to place given code in click event of the command button. if you can not do that send me your db in zip format to...

Using MS Access: Access tabels, foe example, query reports
foe example, query reports, front end tools: Divide your mdb file into Front End and Back End. All tables will be in BackEnd and Forms/Query/Reports/Modules would be in Front End. Password protect BackEnd Link tables in FrontEnd using File--- Get External Data----- Link Tables(you will be asked...

Using MS Access: Adding multiple passengers to a booking form, class pilot, combo boxes
class pilot, combo boxes, co pilot: You need a child table. You have aq table for the flight information and a table for passengers like so: tblFlightPassenger FilghtPassengerID (Primary Key autonumber) FilghtID (foreign Key) PassengerID (FK) PassengerTypeID (FK) The PassengerTypeID...

Using MS Access: AUTO NUMBER, test6, test4
test6, test4, foreign key: you can not do it directly in table but you can do it from code and if the datatype is number and not autonumber. but it is not a good practice to change the primary key since it will consume too much resource to reassign id to all other records below the...

Using MS Access: Auto Fill, validation logic, google search
validation logic, google search, combo box: I am sorry you did not find my unwillingness to provide the extent of help you requested as unpolite. I tried to give you ways of getting your problem addressed. I am not personally familiar with an auto fill function in Access. However just now I did...

Using MS Access: Auto Fill field in form, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, document id number: 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 database size, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, excel spreadsheets: You should be able to open the table in DESIGN VIEW and then change the propery for each text field to less than 255 characters. If you re getting a not enough memory error then either there is a problem on your system, or your database might be corrupted....

Using MS Access: Back to Basics, motor vehicle fuel, blank query
motor vehicle fuel, blank query, memo account: You need to show me the SQL you are using. Also I do NOT recommend using lookup fields. Lookups should only be done on forms using list controls. I suspect that is the root of your problem. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft...

Using MS Access: Carriage Return in text box in 2007, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, address city state: You can use CTRL-ENTER to insert a line break in a text box. HOWEVER, you really should make separate fields for all of that data (FirstName, LastName, Address, City, State, ZIP). Let me know if you have any other questions or comments. Also, be sure...

Using MS Access: Carrying one number from one record to next record, rapid share, time head
rapid share, time head, table structure: I have uploaded a sample file at rapid share. http://rapidshare.com/files/357423615/CBsample.zip.html From this file you can have an idea how to display balance. In this file you will find 3 tables - tblCBMain, tblCBSub and tblLedger It also...

Using MS Access: Carrying one number from one record to next record, microsoft access, vba
microsoft access, vba, microsoft office: You should NOT be storing closing and opening balances. Those are calculated values and, as a general rule, we do not store calculated values. You calculate the balance by adding all the incoming transactions and subtracting all the outgoing ones. Hope...

Using MS Access: Checkboxes, recordsource, checkbox
recordsource, checkbox, microsoft access: I do not recommend using a multi-table query as the recordsource for a form that requires editing. To often you create an uneditable query. Use a subform instead. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office Access 2007...

Using MS Access: Columns in a form, many thanks, page setup
many thanks, page setup: Hi James, Many thanks for the question. To do what you ask, you will need to add 2 or 3 subforms to your form. Each subform will be based on a query, that divides the records up. Not sure of your fields to do this, but some examples could be ID s...

Using MS Access: Combo Box on Repor, combo box, repor
combo box, repor, new question: You include the linked table in your query and pull the value from there. For example; you have a field in your query that is a department code. But you want to display the department name. So you add the dept codes table in your query and pull the department...

Using MS Access: Combos And Text Boxes, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, combo boxes: If you have all of that data in your combo box columns, then what you have there should work OK in the AfterUpdate event for your combo box. If not, I would have to see your database to tell you for sure. Personally, I prefer using a DLOOKUP statement instead...

Using MS Access: Compare two date and put the value in a different colum, field 3, colum
field 3, colum, many thanks: Hi Shahajahan Miah, Many thanks for the question. You will need to do this in a query. Create a query by following the wizard and adding field1 and field2. Then open the query in design view. In the third column of the query in the first row type...

Using MS Access: Compare two date and put the value in a different colum, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, query fields: How are you doing this? In a query? If so, you ll have Field1 and Field2 in your table, and then you can create a CALCULATED QUERY FIELD for Field3 like this: Field3: IIF(Field1 Field2, Field1, Field2) For more help on these topics, see these tutorials:...

Using MS Access: Counting tasks late or on schedule, query design, two tables
query design, two tables, many thanks: Hi Dave, Many thanks for the question. First query would be those that have not started their task by PlannedStart Date Add the two tables to the query, linked by the join as per above. But right click on this join and select Join Properties choose...

Using MS Access: Create monthy query, fawad, record source
fawad, record source, ali: send me your db at aziz_abroad at yahoo dot com **************Added on 17/02/2010********** Open CustomerStatus form in design view right click on customerQ0 subform In property sheet of the subform locate Record source. you need to replace...

Using MS Access: Creating a form with rows that have calculated fields from a query, current stock price, dlookup
current stock price, dlookup, stocks and shares: Here s the answer I posted: Ok, bind your subform to the Holdings table. On that subform use Combo boxes for the Account and Ticker fields. Shares will be bound to nShares field. The relevant properties of the Account combo will look like this: RowSource:...

Using MS Access: Creating SUM of Sorted Records, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, crosstab query: How about an aggregate query where you can group by user and date, and then show totals? Or you could use a crosstab query… or you could use sorting and grouping levels in a report. There are several ways to do this. Here are a few tutorials to get you...

Using MS Access: Culculation of fields in table, tolal, table calculation
tolal, table calculation, field calculation: Iqbal, Use an update query or on a form place the calculation in the AfterUpdate Event of the two fields. [3rdFormControl] = [1stFormControl] + [2ndFormControl] Bob Heifler MyAccessProgram.com DailyAccessTips.com Contact at: http://myaccessprogram.com/Contact.html...

Using MS Access: checking to see if a record is currently being edited, onkeydown event, database mdb
onkeydown event, database mdb, page a page: Hi Vanesai, Many thanks for the question and my apologies for the delay. Try the following: Forms( YourForm ).RecordLocks = 2 Change YourForm to the name of your form. The 2 locks a page: A page is the following: (page (data storage): A...

Using MS Access: copy and increase rows in the table, strsql, profie
strsql, profie, detail description: Sorry, my fault on the first issue. It should have been: Dim i as Integer But the second issue is you have to use your exact object names. My example used the table, field and control names I suggested. You have to make sure you have a control named...

Using MS Access: create an inventory data base, incoming stock, excell spreadsheets
incoming stock, excell spreadsheets, base question: The template I linked to does so it would be a good idea to start there. But a simplistic example would be like this: Assistant cook removes a jar of mayo (industrial size of course) from storage. He makes a note of that somehow. Eventually a transaction...

Using MS Access: Date calculation, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: For help working with calculating the difference between two times in Access, please see this tutorial: http://599cd.com/tips/access/difference-in-dates-times?key=AllExperts Let me know if you have any other questions or comments. Also, be sure to...

Using MS Access: Date Range search on Calculated Date, ms access database, numeric expression
ms access database, numeric expression, query column: Place Stop after DoCmd.OpenReport strReport, lngView, , strWhere Stop run the report and when code breaks at Stop open immediate window and type ?strWhere copy the strwhere value from immediate window and paste here so that i can check the...

Using MS Access: Date/Time data entry, dateadd function, duedate
dateadd function, duedate, discrete data: The DateAdd function can be used to add second, minutes or hours to a date/time value. You don t have to extract anything. For example, if you want to round up and add 4 hours you could use: DateAdd( n ,(60-DatePart( n ,datefield))+240,datefield) ...

Using MS Access: Display Username on Form, ms access database, user level security
ms access database, user level security, command button: use public variable in any module and store value to this variable after succcessful user login. suppose in your form you have combo box to select user from drop down and a textbox for user password. Click event of LogIn command button will use code something...

Using MS Access: DLOOKUP FUNCTION, recordsource, number person
recordsource, number person, callid: A couple of points first. You don t have fields on a form, you have controls that may or may not be bound to fields in a table. So your table should look like this: tblCalls CallID (PK Autonumber) CallDate Phone CallerID CallerID and Phone should...

Using MS Access: Docmd.outputto, OutputTo, InputBox
OutputTo, InputBox, file path: John, The InputBox Function displays a prompt in a dialog box, waits for the user to input text or click a button, and returns a String (String data type: A fundamental data type that holds characters, one character per 2 bytes. A fixed-length string can...

Using MS Access: Document Coding System, box rec, invalid syntax
box rec, invalid syntax, sequence field: The blog explains this. You can t use the default value for the voucher because you have to know the project first. So you have to wait until you enter data. You also need to save the record immediately after generating the voucher or you risk duplications....

Using MS Access: How to NOT Duplicate Data, dlookup, primary key
dlookup, primary key, microsoft access: There are a few ways to do this. One way would be to use a Dlookup in the After Update event of the control: If Not IsNull(Dlookup( [fieldname] , tablename , [fieldname] = & Me.control)) then MsgBox duplicate Me.control.setfocus End if Hope this...

Using MS Access: Expression Builder Help!, string literals, expression builder
string literals, expression builder, excel formula: Another question though is now the amount auto calculates in the form but how do I get it to then put that figure into the table? The table now just shows a zero? Is there even a way to do this? You don t. As a general rule we do not store calculated...

Using MS Access: Can not edit data from form, immense problem, hr database
immense problem, hr database, recordsource: Is the Data Entry property of the form set to Yes? If so, the form can only be used to add new records. Also is the form a bound form, meaning the Recordsource of the form is a table or query? One other possibility is that you are opening the form in Add mode,...

Using MS Access: Filtering a query on two date fields?, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, intermediate user: Assuming both your parent and child are listed in the same RECORD (parentDOB and childDOB) then you could just create a new calculated field in a query to show you the difference between those two dates. Here s a tutorial that explains how to do that: ...

Using MS Access: Find a specific number is a string of numbers, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, math operations: Create a CALCULATED QUERY FIELD using the MID function, like this: NewField: MID(OldField,8,2) That should do the trick. For more help, see this tutorial: It sounds to me like you just need to learn how to properly create CALCULATED QUERY FIELDS....

Using MS Access: Form again, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, default colours: If you have a one-to-many relationship, then set up a form-subform relationship (not a listbox). You don t need to have the subform in DATASHEET view. Put it in FORM view. You can then change colors, positions of the controls, etc. This will also enforce your...

Using MS Access: Form filter, column counts, product species
column counts, product species, product location: There are two ways of viewing a query. Either Query design mode which is what you tried to emulate (its better to use a screen shot) and SQL mode, where you can copy and paste the SQL statement. OK, I see what s happening. You need to reconstruct your...

Using MS Access: Form Validation with VBA, dropdown boxes, combo boxes
dropdown boxes, combo boxes, form validation: You need to put an AfterUpdate event in all three of your combo boxes which sets the other combo boxes to be disabled: ComboBox2.enabled = FALSE ComboBox3.enabled = FALSE Then in the OnCurrent event (which runs when you move to a new record) you will...

Using MS Access: Forms, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You could use DLOOKUP and DMAX to get that data. Let s say you have a table called MyT that has your data: ID, Amount 1, 250 2, 375 3, 478 You can use DMAX function to determine the most recent ID in your table: MaxID = DMAX( ID , MyT ) Now...

Using MS Access: Forms Edit Mode, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Try this command in the OnOpen event for the form: ID.SetFocus 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: Multi-user access
Using MS Access: Multi-user access

Using MS Access: Global Function, global function, microsoft access
global function, microsoft access, microsoft office: The Public keyword is valid for procedures as well as functions. You put the code where you said, in the On Open event or whatever event you want to use to trigger the code. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office...

Using MS Access: Grouping Unique customer id's and their transactions by month, many different ways, customer id
many different ways, customer id, question thanks: If you are using a Group By query and setting the CustomerID column as the first column then they should be grouped together. You should see: 1...Jan...3...300 1...Feb...2...200 2...Jan...5...500 2...Feb...6...600 If you are not getting this then...

Using MS Access: Help, score value, query in access
score value, query in access, date1: I m not sure if this question is related to the previous ones or not. If you have a new question you should start a new question rather than use the followup options. Why would you have the same data in two places? One of the main reasons to use a relational...

Using MS Access: IMAGES_ACCESS, foreign key, image control
foreign key, image control, current event: What version of Access. If you are using 007, you can use the Attachments datatype. If using an earlier version, then don t use a subtable like this: tblImage ImageID (PK Autonumber) RecordID (Foreign key to parent record) ImagePath (the full path and...

Using MS Access: Incremental ID being stored as field, sequential numbering, microsoft access
sequential numbering, microsoft access, vba: Not sure what my answer said, but it probably said that you don t store the combined field value. since the value is calculated by concatenating existing fields, there is no reason to store it. You display the combined value wherever you need to. For a...

Using MS Access: Invalid Qualifier error, udfs, elseif
udfs, elseif, microsoft access: You need something like this: Public Sub procSysPermissions(frmForm As Form) A string variable doesn t have the AllowEdits or AllowDeletions properties, only a Form object does. That s what the error message means. You may also need to change the Call...

Using MS Access: identifying lowest prices for products, wholesale suppliers, query design
wholesale suppliers, query design, wholesale price: Hi Roger, Many thanks for the question. This is not as straightforward as you would expect it to be. Access is a bit different to Excel, whereas Excel copes well with information in different columns, Access copes better with this information in rows/records....

Using MS Access: import/append, ms access 2000, transferspreadsheet
ms access 2000, transferspreadsheet, column headings: Again, not without knowing why its failing. Do you get some error message? Are you importing directly to a table? Do the column headings in the import file match the field names in the table? You can look at the TransferSpreadsheet and TransferText methods...

Using MS Access: insert tables, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: You ve got two completely different methods for trying to do the same thing here. Either use a Recordset OR an SQL statement. You don t need both. Personally, I would use the Recordset. Set db=CurrentDb() Set rs=db.OpenRecordset( TableName ,dbOpenTable)...

Using MS Access: Limiting combo box based on another combo box, combo boxes, combo box
combo boxes, combo box, microsoft access: I wouldn t use combos for this I would use checkboxes bound to a Yes/No field. Then I would use code in the After Update even of HaveDonated like this: If Me.HaveDonated THEN Me.MultipleDonations.Enabled = True Else Me.MultipleDonations = False Me.MultipleDonations.Enabled...

Using MS Access: Linking a form to a table in 2007, bound form, time kevin
bound form, time kevin, data source: Kevin, this is how forms are supposed to work. It sounds to me like you created the form from scratch using the designer and didn t give the form a DATA SOURCE. It might be easier for you to just rebuild it from scratch instead of trying to fix the form you...

Using MS Access: Linking forms based on 2 criteria, type mismatch error, link criteria
type mismatch error, link criteria, composite keys: OK, I m not sure what is happening but I m getting funny characters. This is what I m seeing: stLinkCriteria = [ECR_NUMBER] = %26 ECR_NUMBER %26 AND [ECRIssue] = %26 ECRIssue I m wondering if the %26 is the ampersand (&) being converted. What...

Using MS Access: Linking Tables, customer number, google
customer number, google, primary key: Yes you can do this. The expenditure table must have a field, call it CustomerNumber that is the same type of field as is the customernumber key in the main customer number. Set the expenditures as a form. Open the customer form and below the customer...

Using MS Access: List box for Reports, List box for Reports, Combo box for reports
List box for Reports, Combo box for reports, list reports: Carla, If you use this code in the OnOpen Event of the form and replace Combo0 with the real name of your combo box or list box, then it will be populated with all the report names. The code to use is: Private Sub Form_Open(Cancel As Integer) Dim intNumOfReports...

Using MS Access: Listbox help, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, button wizard: Carla, the EASIEST solution is real simple, and involves almost NO programming. Just create a Table called MyReports (or whatever you want to call it). Have two fields in the table: the actual NAME of the report, and then the English description of the report....

Using MS Access: Locking Controls Upon Pressing Submit Button, hi bob, video tutorials
hi bob, video tutorials, example files: Kristen, Add a field to the data table feeding the subform. Call the field Locked and make it s data type yes/no. Add this field to the subform s data source and also add it to the subform as a checkbox control. You can delete the label for the checkbox...

Using MS Access: How to limit number of records, query design, question thanks
query design, question thanks: you can add both the tables in query design and under criteria for CalculateCommission Column Put YES ( if it is text field or True if it is Yes/No type field.) if you cannot get the result, send me your db(zip format) at aziz_abroad at yahoo dot com...

Using MS Access: linking combo boxes on a form, combo boxes, control source
combo boxes, control source, combo box: I get asked this question all the time. You ve got two or more combo boxes and you want the first one to filter the second one. I get asked this so much that I recorded a video tutorial explaining how to do it: http://599cd.com/tips/access/two-combo-boxes?key=AllExperts...

Using MS Access: Main switchboard, search tab, microsoft access
search tab, microsoft access, switchboard: Use the Combobox Wizard to add a Search combo to your form (3rd option). What I generally do is place such a combo in the header of the form to set it apart. You can then use the combo to select a contact and that record is then retrieved in the form. ...

Using MS Access: Making a label visible on report based on textbox value, visible property, sum function
visible property, sum function, zero value: Each band has an On Format and On Print event. Set the Visible property for the control in either of those events for the appropriate band. Me.controlname.Visible = Me.controlname Since a 0 is considered a False value and any other value is a true,...

Using MS Access: MS Access, multiple table queries, access query
multiple table queries, access query, datasets: Hi NDH, Many thanks for the question. OK, hopefully I can explain this clearly. Try the following Build your query, adding the fields you need. Then in the first row of the criteria, add the following criteria. Note: Not sure if the fields are...

Using MS Access: MS Access database question, ms access database, input change
ms access database, input change, hi doug: Hi Doug, Thanks for getting back to me. To do what you I suggested then: First as mentioned previously: Add an unbound text box, to store the outgoing/ingoing quantity. make the outgoing/ingoing fields invisible. Right click Properties Format...

Using MS Access: MS Acess (2003), microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, ms access database: How are you opening the database? If it s a shortcut, look at the properties to find where it s pointing. 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...

Using MS Access: MsgBox in vb, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, access dlookup: Alex, this is not just a simple one line of code. First, you d need to create a startup form (which every good database will have). Now, in the OnOpen event for that form, you ll have to check your variable. What kind of variable is it? Is it something...

Using MS Access: Multi User Database, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, database offline: Not really. If you open the Master database and are editing a TABLE, then no other users will be able to save records to that table while it s open. That s one of those things you have to take the database OFFLINE for. You could work on your copy of the FRONT...

Using MS Access: Multi-user access, front ends, microsoft access
front ends, microsoft access, vba: Whoever told you that was incorrect. If the data is only saved on your PC then you didn t split it right. Look in linked table manager and see if the files are linked or not. Its possible the other front ends may not be linked properly and yours is. Hope...

Using MS Access: Multiple Front End Users, senior citizen, pc access
senior citizen, pc access, microsoft access: Yes Yes Yes Access is, by design, a multi-user platform. But there is a proper way to set this up. You need to split the database into a back end with all the tables and a front end with everything else. The back end will reside on network share and the...

Using MS Access: Multiple forms pulling data from one form, personnel reports, long integer
personnel reports, long integer, foreign key: First, you don t pull data from a form, you pull data from a table or query. Second, you do NOT want the person s name as a linking field. Names are not unique. You should use an autonumber as the primary key for each table and then a Long Integer Foreign...

Using MS Access: ms access 2003 FAQ, record navigation, data computer
record navigation, data computer, navigation button: you need to create a form. place several textboxes you want to edit data. bound the form to the table that contains required data. bound the textbox(es) to the fields. edit the data of the desired record by navigating from record navigation button....

Using MS Access: Need help designing tables, procurement company, numerical number
procurement company, numerical number, ref number: Hi Abbas, MS Access is perfect for your kind of assignment. Follow these steps to start: 1. create a new database 2. create a table 3 create a form based on this table. 4. set the data entry property of the form to Yes Now you can enter info in...

Using MS Access: Numbering, invoice number, inum
invoice number, inum, design mode: Hi Foti, My apologies for not being clear. In your invoice table that you already have, change the invoice field to the data type autonumber. I did not mean for you to create a new table. You do not need a second table. If there is already data...

Using MS Access: Option Group Toggle Buttons, school basketball team, high school basketball
school basketball team, high school basketball, high school basketball team: First why would you use Toggles for this? I would use a combobox. Removes all your headaches. But each control within a group have its own name and caption property. You can modify that caption property using VBA. Hope this helps, Scott Microsoft Access...

Using MS Access: Order of products in Access table, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, cheese bread: I would create a SortOrder field in your table. Use this to enter values (from 1 to X) that determines what order you want them sorted in. Now, create a query based on that table that sorts the values the way you want them. Use this query now to fill your...

Using MS Access: Order of products in Access table, sort, sort order
sort, sort order, order: Sy, Add a field to your Product table and call it SortOrder . Make the data type numeric. Open the table and place a number in each record s SortOrder field to represent the sorting order you really want. Then create a query or modify an existing query...

Using MS Access: Populating default values from a form, organization record, strsql
organization record, strsql, default project: Then put the code behind a button or add: If MsgBox( Add default record? ,vbYNo) = vbYes Then strSQL = INSERT INTO OrgProject (OrgID, ProjectID) & _ VALUES( & Me.OrgID & , 1); CurrentDb.Execute strSQL Me.Subformname.Requery End If...

Using MS Access: Printing one record in a form, microsoft access 2002, button wizard
microsoft access 2002, button wizard, key field: As I recall the button wizard will give you this option. But its simple to do, One line of VBA code: DoCmd.OpenReport reportname ,,, [keyfield] = & Me.keycontrol where keyfield is the name of your Primary Key field and key control is the control on...

Using MS Access: Problem with date format, type mismatch error, run time error 13
type mismatch error, run time error 13, ldate: Whoops, I missed that you were creating LDate as a string. No need. So lets try it again. strCriteria = [SiteID]= & Me![SiteID] & And [StartDate]= # & Date() & # That should work. Hope this helps, Scott Microsoft Access MVP 2007 Author:...

Using MS Access: Programmaticalley turn off the Acrobat Tab in access, acrobat tab, custom ribbon
acrobat tab, custom ribbon, custom ribbons: This is a bit out of my expertise, I haven t worked much with customizing ribbons. Essentially what Adobe has done, is add a customized ribbon to your system and then changed the registry so its loaded with your Office 2007 apps. You need to find that registry...

Using MS Access: parsing year-month-day into sep columns, microsoft access tips, string manipulation functions
microsoft access tips, string manipulation functions, free microsoft access: Is this data currently in a TEXT field or in a DATE/TIME field. How you handle this is important. If it s a DateTime field, you can just use the Month(), Day(), and Year() functions to break it apart. If it s currently a TEXT field, then you ll have to use...

Using MS Access: Query and case function, case statement, combobox
case statement, combobox, command button: You re right in that a user-defined function would be the best way to go. I cover them in depth in my Access tutorials, but in a nutshell, here s what you do: First, go to the MODULES section and create a new module. In here, you ll create a global function,...

Using MS Access: Query Macro, coursework, important things
coursework, important things, many thanks: Hi Mike, Many thanks for the question. Try the following: In the Macro, before the query is run add the following action: SetWarnings - set it to No down the bottom - I think this is the default anyway. But remember to turn your warnings back...

Using MS Access: Query to open in form view, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, access tutorial: You can t open a query in form view. That s what FORMS are for. Create a form based on your query, then open that. Watch my beginner Access tutorial for an example. Let me know if you have any other questions or comments. Also, be sure to visit my web...

Using MS Access: Query page setup, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, setup changes: Queries don t save page setup information. That s what REPORTS are for. Design a report that is based on that query. It s a little more work, but it s not hard. Let me know if you have any other questions or comments. Also, be sure to visit my web site...

Using MS Access: Query parameters, query parameters
query parameters: I tend to put the date range on a form from which the user will run the report via a button. The begin and end dates on the form are automatically set to the beginning and ending of the current month. ON the query for the report I set criteria for the date...

Using MS Access: Query Question, tbl, hard time
tbl, hard time, masterdata: If its only the one month, I would suspect a problem with the date. So I would try it this; try entering 1/1/10 & 2/1/10. See if that works. If it does, keep expanding the end date unitl it fails, then check the records for that date. On another note, NAME...

Using MS Access: Query Time Criteria, duration time, datediff function
duration time, datediff function, decimal portion: Add a date field to your table. Always enter it. You can then add the date to the time in your queries. for example: TotStart: SentDate+SentTime TotRec: IIF(Rectime SentTime, (SentDate+1)+Rectime, SentDate+Rectime then do your DateDiff on those two....

Using MS Access: Question, strsql, query command
strsql, query command, docmd: use the following code if you want to run from command button on a form : Private Sub Command0_Click() Dim strSql As String strSql = UPDATE tblMobile SET tblMobile.MobileNumber = 87894424931 WHERE tblMobile.MobileNumber= 9794424931 ; ...

Using MS Access: query re exclusion criteria, inclusion criteria, exclusion criteria
inclusion criteria, exclusion criteria, pears: I asked you to pate YOUR query here so that I can maodify it to get the desired result. however with the given details you can use the following query: SELECT * FROM yourtableName WHERE UCase(fldFruit) BANANAS And UCase(fldFruit) PEARS ...

Using MS Access: question regarding iif function and Between And function access, input parameters, text boxes
input parameters, text boxes, command button: Emma, you would be better off using ALL form parameters for your query rather than input parameters. Set up a small form that has your StartAge and EndAge options on it as TEXT BOXES. Then you can use them for the parameters of your query. In fact, you could...

Using MS Access: Reports - prompt for independent data, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, parameter query: Use a form. You can type in all of your parameters like StartDate, EndDate, ReportTitle, etc. into text boxes, then use that form to run the report with a command button. This tutorial will help you with the syntax: If you want to refer to a value on a...

Using MS Access: Running an access database on a mac, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Diane, there is NO version of Access that will run on a Mac. If you wait for Access 2010, however, and set up a Sharepoint Server, you ll be able to publish your database to the Web and have your Mac users access it through their Web browsers. Before...

Using MS Access: relationships in Ms Access, cascade update related fields, related records
cascade update related fields, related records, key field: Cascade Delete will delete all related records when you delete the one part of the relation. For example, if you delete a customer, all their ordered will be deleted. Casecade Update will update the key field of the related records when you change the key...

Using MS Access: Send Email to multiple recipients with "SendObject"?, e mail address, sendobject
e mail address, sendobject, response test: You can do this in two ways. Both of them involve using a loop to loop through the recordset of addressees. Something like this: Dim db As Database Dim rs As Recordset Set db=CurrentDB Set rs = db.OpenRecordset( SELECT Email FROM queryname; ) rs.MoveFirst...

Using MS Access: Sending Email to Multiple Recipients?, response test, tips access
response test, tips access, three tables: There really isn t a simple way to do this. Either way, you re going to have to loop through the records and either (a) send an individual email to each person, or (b) create a temporary variable with all of the email addresses separated by a comma or semicolon....

Using MS Access: Sending Multiple Attachments via Outlook using MS Access 2007, mail message, microsoft code
mail message, microsoft code, database in access: This is the code I use for just that situation: Do While Not rs.EOF strAttachmentFile = CurrDBDir() & rs.Fields( ElectronicFileName ) Set objOLAttach = .Attachments.Add(strAttachmentFile) rs.MoveNext Loop In this case...

Using MS Access: SendMail Macro, access database design, cc field
access database design, cc field, access file: Kevin, There is a bit more information I need on your Access database design. Since your question is a bit too complex for a simple short answer on AllExperts.com and requires a little clarification on my part, I would like to communicate with you further...

Using MS Access: Setting Focus After Requerying Form, member data, work flow
member data, work flow, system maintenance: Hereunder is your modified code, you will note I have added bookmark to return back to the same position after using Me.Requery. Because Me.Requery send the record pointer back to First Record. Private Sub cboPermission_AfterUpdate() On Error GoTo Err_Error...

Using MS Access: Setting Form Accessibility, check boxes, input data
check boxes, input data, microsoft access: I recently published a blog on this issue. Check it out: http://scottgem.spaces.live.com/blog/fakehandlerpage.aspx?wa=wsignin1.0&sa=648819901 if you have other questions, please feel free to ask. Hope this helps, Scott Microsoft Access MVP 2007...

Using MS Access: Special Characters in Access memo field, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, allexpert: In Access 2007 you can set a Memo field to accept Rich Text (or even HTML) in the field s properties at the TABLE level. In Access 2003 and earlier, you d have to use an ActiveX control, which I don t recommend, and it won t be standard across all of your...

Using MS Access: Splitting my database, support nightmare, database mdb
support nightmare, database mdb, database database: If the app was created in Access 2007 it will have an accdb extension. But if it was created in an earlier version it may not. I suspect that error message just hasn t been updated whihc is why it refers to MDE if the file is an accdb. You can easily tell...

Using MS Access: Stop AutoExec, autoexec macro, many things
autoexec macro, many things: A good AutoExec macro can launch one or many different procedures or objects. In my view, the actions in the macro should either open a form or run a VBA function. Though a macro can do many things, I recommend that you restrict this macro to simple tasks...

Using MS Access: Subform design, subform control, design question
subform control, design question, control layout: You can use datasheet mode, but I d recommend using Continuous Form mode instead, its more flexible. When you use the form wizard, elect to create a TABULAR form. In a many to many relation, you add a record for each combination. Hope this helps, Scott...

Using MS Access: searching for similar phrase in field, pope paul vi, query expression
pope paul vi, query expression, character field: You can use the Like Operator, but that only works on matching a portion of the contents not a similar content. For example; you can use: LIKE *Democratica* to find all titles with Democratica in the title. Hope this helps, Scott Microsoft...

Using MS Access: If and Then statements, docmd, combo boxes
docmd, combo boxes, button code: Hi Marita, Many thanks for the question. Try changing this code: If IsNull(D2D_Lobs) Then MsgBox D2D or RC Lob Code Field is Mandatory , vbCritical, Missing Data D2D_Lobs.SetFocus End If DoCmd.DoMenuItem acFormBar, acRecordsMenu,...

Using MS Access: Text Labels and prompts, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, label colors: In the OnCurrent event for your form (which runs when you move from record to record or open the form) set the label colors: Label1.backcolor = vbred Label2.backcolor = vbgreen Then, in the AfterUpdate event for ComboBox1 you could say: Label1.backcolor...

Using MS Access: Three Column values in one whith condition, ms access 2000, currentdb
ms access 2000, currentdb, column values: use recordset as follows Dim rst as DAO.recordset Set rst= Currentdb.OpenRecordset( tblName ,DbOpendynaset) if not rst.bof then rst.MoveFirst Do While Not rst.Eof If rst!Amount1 = 0 And rst!Amount3= 0 Then rst!Extra = rst!Amount2...

Using MS Access: Unable to edit records in search form, field names, workaround
field names, workaround, fiddle: Hi Deep, Many thanks for the question. The problem (obviously as you have mentioned) is the third form. It makes it too complicated for access to know where to put the information so it locks it. Sometimes you can fiddle with the relationships and...

Using MS Access: Union Queries, union queries, access report
union queries, access report, tips access: You have 6 different queries, but is all of the data in one TABLE? If so, you don t need a UNION query. I would just bring all of the data into a report and use SORTING AND GROUPING LEVELS (see below). If, on the other hand, your data is all in different...

Using MS Access: Unique Order Count, query design, drop down list
query design, drop down list, many thanks: Hi Sarah, Many thanks for the question. To get a distinct record, i.e. only 1 one record for each occasion. Right click any where on the grey section on the query design grid, (in the section with the tables, but not on the tables), choose properties...

Using MS Access: Updating a Text Field, auto updates, box auto
auto updates, box auto, combo box: Yes the Update events and a few other events are not triggered when you use code to update a control. So you really should do your Dcount in the After update event of the combo/ Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office...

Using MS Access: Using Command Button to Update Database/Query/List Box, numerator and denominator, command button
numerator and denominator, command button, text boxes: I almost always use bound forms. Access automatically handles the I/O between the form and the table when you use bound forms. With unbound forms, you have to do all the work Access does for you. While there are reasons to use unbound forms, that is rarer....

Using MS Access: Using Dim, editor tab, explicit statement
editor tab, explicit statement, variable declaration: Yep, you are correct, except that, if those modules are currently working, then there really isn t much of a reason to change them, except if you are adding procedures or editing code. You can also, always make it a practice to DIM your variables so Option...

Using MS Access: Using Mid String Query, string query, unit id
string query, unit id, muck: Hi Chad, Many thanks for the question. To do this you will need to use an update query. Which I presume you are. First make a copy of the table, in case there is a muck up :0) In the update query, choose the field you wish to update, the in the...

Using MS Access: Using If statement and Is Null statement, passport expiration date, delimma
passport expiration date, delimma, second date: Sorry but this does not make sense. the reason for that is your database is not normalized properly. When you have numbered fields like date1, date2,etc, you have a repeating group which violates the rules of normalization. Your task would be way easier...

Using MS Access: update one field of several records, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, 599cd: Yes. You want to use an UPDATE QUERY. You can use an Update Query to change records in a table. See this FREE tutorial on my website for more information and step by step instructions. http://599cd.com/tips/access/update-query?key=AllExperts ...

Using MS Access: using forms to set parameters to run a query/report, query report, microsoft access
query report, microsoft access, vba: OK, it looks your database is constructed properly. So that means you can fewer controls. For example: if you wanted all records that had three different test, you could use a List box set to multi-select to select the test you want to see. You can see VBA...

Using MS Access: VBA if, control names, object names
control names, object names, x control: Try: If NOT IsNull(Me.Sub_mon.Form.Hours) Then Also you need to change some of your field and control names. Hours and Date are reserved words in Access and shouldn t be used for object names. Hope this helps, Scott Microsoft Access MVP 2007 Author:...

Using MS Access: VBA: lock a subform at load, mrn, focus event
mrn, focus event, isnull: Try setting the Enabled Property to False. You also need to run similar code in the After update event of an MRN_reenter. But I think you miss a bet here. The way I would do this is, in the After Update event of MRN_Reenter I would use code like: ...

Using MS Access: visual basic code, microsoft access, vba
microsoft access, vba, microsoft office: There are several ways to do this. The simplest way is to build a query of the data you want, then add a column like this RptYr: Year([datefield]) Then set the criteria for that column to: [Enter Year:] You then build your report on that query....

Using MS Access: working but little problem, fawad, ali
fawad, ali: I am unable to understand your question. Please come up with some example. It is not my coding that I will know everything about it. If you can tell me with the example like Give me the date range From To to test and also explain what is being displayed...

Using MS Access: Yes/No data fields, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, greek letter sigma: Dean, there are a couple of ways you can do this. I would recommend an AGGREGATE query. You can easily add up the number of yes and no answers. See this tutorial for help, and if that doesn t work for you, let me know. There are lots of other ways to do this....

Using MS Access: Access 2003: Autofill/Auto Populate fields, carrier code, coverage type
carrier code, coverage type, correct option: right click Insur coverage Type combo and then scroll to Row source click (...) ellipses. it will take you to the query grid. see how the field 3 is used to match with field 1. use the same criteria for combo Carrier code also. If done ok otherwise paste...

Using MS Access: Access 255 Character Limit, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, memo data: You can set up an IMPORT SPECIFICATION for your data. It s a bit too much to go into here, but if you Google that term, I m sure you ll find instructions. An import spec allows you to specify what types of data you re importing - and you can tell it that your...

Using MS Access: Access auto invoice numbers with a twist, joe baker, auto invoice
joe baker, auto invoice, sequential numbering: 1. In reviewing your question, it appears that you have a table of contracts. Each month you create an an invoice to send to customers. I assume this invoice is stored in a separate table so you can mark it paid. If that s the case, how do you determine a)...

Using MS Access: Access Database Check with Date and ClassID, type mismatch, ldate
type mismatch, ldate, database check: The problem here is you can t use assign a value to a SQL statement like that. If TestID2 0 Then You are declaring TestID2 as an integer, but assigning a string value to it. Hence the datatype mismatch. Also why are you declaring LDate as an Integer?...

Using MS Access: Access Query/Pivot for the descriptive datas, access query, crosstab query
access query, crosstab query, cabin 1: Hi prabhu, Many thanks for the question What you need to try is a crosstab query. Query New Crosstab Then follow the wizard Choosing your table Next Then the item field Next Then the date field Next Then choose month Next...

Using MS Access: Access Security, level permissions, password control
level permissions, password control, password field: The key is not in that code. The key is in the code in the After Update event of the password control on frmLogin. In that code module, there is this set of code: If Me.txtPassword = Me.cboUser.Column(2) Then Check if password needs to be...

Using MS Access: Access SQL stop running at the end of certain tables, hot lunch, ff 6
hot lunch, ff 6, sql code: Your UNION query might be too complex. You might want to consider breaking this up into a Make Table query and Append queries. This will build a table with all of the same data, and you won t run into this problem. Furthermore, I have to ask WHY you have...

Using MS Access: Acess 2007, blank database, system tables
blank database, system tables, msys: What are the names of these tables? Do they start with MSys? If so, these are system tables that MS has been generating for ages. You probably have you system set to display system tables. Click the Office button, select Access Options, then, in the General...

Using MS Access: Auto Populate Dates in Access 2007, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, expression builder: You can do this as a calculated field in a query. If your original date is MyDate then your field will be: NewDate: MyDate+150 See this tutorial for more information: It sounds to me like you just need to learn how to properly create CALCULATED QUERY...

Using MS Access: Auto run macro, autoexec macro, auto run
autoexec macro, auto run, systems tools: I use the windows Task Scheduler (Accessories, Systems tools) to schedule the running of an Access database. Then in the access database, set the automatic running of the query, using the autoexec macro or other similar auto run process in Access. bo...

Using MS Access: Autofill?, combo box, microsoft access
combo box, microsoft access, vba: I ve written a blog on this issue. You can find it here: http://scottgem.spaces.live.com/blog/cns!AB37C52C6D3752C!175.entry If you have any specific questions after checking that out, let me know. Hope this helps, Scott Microsoft Access MVP 2007...

Using MS Access: Autofill?, 3 dots, column count
3 dots, column count, combo box: Hi Wendy, Many thanks for the question. I hope I have understood your question correctly. If so, try the following: Right click on the first combo box - that you want to choose to complete the others. I am presuming all the fields are listed in...

Using MS Access: Autofill Form, 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: Autonumber Generator, sequential number, dmax
sequential number, dmax, yy: 1. Yes that s exactly what I meant. 2. a) Again, yes, that s how you hide a control. b) The Name property is on the Other tab of the properties dialog. c) Not sure which code you refer to. If its the code to generate the sequential number, how you trigger...

Using MS Access: access 2003 table combining, separate tables, calendar data
separate tables, calendar data, simple matter: First you should not have separate tables. You should have one table with a date field so you can extract the calendar data you want. From there it would be a simple matter to use a Crosstab or Pivot query to compare months side by side like you want. Hope...

Using MS Access: access form into web page, sharepoint services, web note
sharepoint services, web note, spread sheet: No, with current versions of Access this is not possible. However, later this year, when Access 2010 and Sharepoint 2010 is released, it will be possible to convert the form into a web compatible form, upload the data to Sharepoint and use the revised form...

Using MS Access: apostrophe in textbox, project comments, syntax error
project comments, syntax error, apostrophe: Try using the Replace function to replace all instances of an with 2 apostrophes. When Access encounters double characters, it treats them as a literal rather than an operator. Hope this helps, Scott Microsoft Access MVP 2007 Author: Microsoft Office...

Using MS Access: arrays, combo box, loop 1
combo box, loop 1, different services: Why do you think you need an array? Can you give me an example of what your services and category tables look like? I assume you also have a client table. So what I think you need is a ClientServices table that would look like this: tjxClientServices ClientServiceID...

Using MS Access: assign categories to a value, roadcondition, case statement
roadcondition, case statement, speed value: You would use the After Update event of the Speed control to run a SELECT Case statement. Something like this: SELECT CASE Me.Speed Case 10 Me.RoadScore = 4 Me.RoadCondition = Bad Case 10 to 20 Me.RoadScore = 3 Me.RoadCondition...

Using MS Access: Barcode scanner with access, inexpensive scanners, barcode scanner
inexpensive scanners, barcode scanner, keyboard wedge: I would change the transactions table like so: TransactionID -PK TransactionDate ProductID PurchaseOrderID UnitPrice Quantity TransTypeID I would then add a table like: tluTransType TransTypeID TransType Direction Transtypes would be things...

Using MS Access: Building Expressions, microsoft access tips, free microsoft access
microsoft access tips, free microsoft access, query key: This all depends on how you want to display the results. You could create an AGGREGATE QUERY which can SUM up all of your Yes/No values - giving you a negative number equal to the total of your YES answers (because YES is tracked internally as -1). See:...

Using MS Access: Bulk email, mail client, mail message
mail client, mail message, office automation: You can use the SENDOBJECT method to send e-mails. You can either create a distribution group and send to it as a BCC or you can loop through your database and send the e-mail to each individual. If you use Outlook as your e-mail client you can also use...

Using MS Access: Button visibilty, windows xp home, microsoft access
windows xp home, microsoft access, vba: If condition then Me.controlname.Visible = False Else Me.controlname.Visible = True End If Or you can use a Select Case depending on the user level. Did you check out my blog on Login Security? I discuss this in there. http://scottgem.spaces.live.com/blog/cns!AB37C52C6D3752C!183.entry...

Using MS Access: Cascading combo boxes - adding, combo boxes, novice user
combo boxes, novice user, focus event: You start with something like this: Dim strSQL As String Dim strWhere As String strSQL = SELECT Products.ID, Products.ProductName FROM Products If Me.Combo1 0 Then strWhere = [Species] = & Me.Combo1 End If If Me.Combo2 0 Then...

Using MS Access: Categories and Subcategories, windows xp media center, classroom reference
windows xp media center, classroom reference, combo boxes: What you are talking about is a standard technique called Cascading or synchronized comboboxes. This article explains how to do it: http://www.utteraccess.com/wiki/index.php/Cascading_Combo_Boxes Hope this helps, Scott Microsoft Access MVP 2007 ...

Using MS Access: Combo box, transtype, column count
transtype, column count, relevant properties: You aren t making sense to me. Generally orders do cover multiple items. That s why you have order and transactions tables so you don t repeat the same data with each transaction. You can set the Date Entry property on the MAIN form to Yes so it can only be...

Using MS Access: Combo box, msysobjects, openreport
msysobjects, openreport, combo box: First, since AllExperts limits the followup you can ask you should start a new question for a new issue. Add a Yes/No field to your table to indicate Active or inactive. The problem with using a split form that way, is the both parts of the form are bound...