For Access, I often use a "combo box" to make a drop-down list of entry choices. Things like "yes, no, up, down, always, never." In Excel, I know there is a...
First of all select the column or cells that you would like the drop down to be located; such as column 'B'. Then click 'data', then 'validation', then select...
I am going to develop a Banking Solution for very small branches of a Bank. The branches are standalone and no remote transactions will be made i.e. only the...
M.A.- In my opinion, you should never use an Access mdb file for a "mission critical" application. It is impossible to secure and is too easily corrupted when...
... Travis, I have tried numerous types of reformatting of these cells using the format function -- but it ignors anything I select. For instance, in your...
Can you send me an example? ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf Of eileenh7 Sent: Monday, May 02, 2005 11:53 AM ...
In the Control Toolbar there are ActiveX controls that you can use. I would not suggest using very many of these directly in your spreadsheet, although what...
I'm using the below code to all my apps but how come suddenly I'm getting this error? Run-time error '3270': Property cannot found. TIA, George ... Option...
George- Open the VB Editor and choose Options from the Tools menu. Make sure you have NOT chosen the option to "Break on All Errors" on the General tab. You ...
Hi, Can someone help me figure out if its possible to merge two tables together into one while maintaining existing data? For example, Table A has fields X & Y...
Greg- Please explain what you mean by "there are duplicates." Do you want to eliminate the duplicates? Also are there rows in Table A or Table B that do not...
I have two tables. One master, and one that is a subset of that master. They don't have exactly the same fields. However, the key fields in each table are...
Michael- By "delete fields" do you mean "delete rows?" If so, do this: DELETE DISTINCTROW tblMaster.* FROM tblMaster INNER JOIN tblSubset ON tblMaster.[Tag...
Hi John, Thanks so much for the help. Yes the two tables have duplicate data, but not in every field. There are field differences in the two tables and I am...
Greg- Does either table have a Primary Key? Field Y? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" ...
I'm sorry John, yes there is a field in both tables called "ID" in Autonumber format that is set as primary key. Greg ... to ... you ... for ... with...
Good Afternoon I like to to Choose List Box in Query For Criteria ? How I can Choose when it ask me "Enter Parameter Value" I like to have drop down box. ...
Greg- Maybe we need to get down to brass tacks. What is the business problem you're trying to solve? What is the actual contents of these two tables, and why...
Ah, but the common field is "Y", and it isn't necessarily unique? Please see my earlier response and answer the questions I posed there. John Viescas, author ...
In reality there are many "Y"'s, multiple fields that are common to both tables. Then in the case of the fields that are not in the one we're importing to we...
Greg- You still haven't told me what's *really* in these tables. You have implied that the rows match on "Y" values, but now you tell me there are multiple ...
John, Here are the actual tables & fields. The ones with ASTERISK are common fields to both. What we want is to bring data from TblDowngrades inot SANDER...
Greg- How do I match a row from tblDownGrades with Sander? On ID? On Date/Shift/Thick/Width/Length/CSPCS, etc? If the match is on ID, which set of the nine...
I have been linking pdf files to a table and having no problem. I am using the ole object. Now I keep getting an error message of invalid argument, will not...
Well, an mdb file cannot exceed 2 gigabytes - so it looks like that is your problem. Have you tried compacting the database? You might find it best to store a...
Dear Greg, From the details furnished by you, I presume that you are trying append the data from one table to another which has duplicate data. There is a...
Oopps... Thanks a lot John. cheers, George ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com]On Behalf Of John Viescas Sent: Tuesday, May...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
