Search results

Hello: Here is an article on the subject: http://support.microsoft.com/kb/209576/en-us Regards Mark

Hello: Please do the following: 1 Break into your code module and click in the top area of the code that contains the statement "Option Compare Database" or "Option Explicit" 2 Click on the "Declarations combo box and in the drop-down list you will see all the code for every control you...

Hello: From just a quick look at your spreadsheet, it looks like you want to have a relational database design with a parent table called offices and a child table called Data for instance. I put together a basic design from what I could understand of your spreadsheet. Regards Mark

Hello: I am glad that suggestion worked because that is what I use. Depending on the complexity of your tables, it might be that your asking too much of Access at that time, or end of file, or line characters, or a corrupt table. Regards Mark

Hello: Great! Good luck with this. Regards Mark

Hello and welcome: Thats great, but what can we help you with in this project. Regards Mark

Hello: Here you go.............. http://www.utteraccess.com/forums/showthreaded.php?Cat=&Number=1459102&page=&view=&sb=5&o=&vc=1 Regards Mark

Hello: Maybe this may work for you: http://support.microsoft.com/kb/247771/en-us Regards Mark

Hello Try importing both tables separately. Then use an append query in Access to combine both tables. Make sure both tables have the same amount of columns ad field names. Regards Mark

Hello: If you had a column in Column A and a Column in B, the formula for Column C would be: =A1&B1 Just copy it down for the rest of the rows Regards Mark

http://www.systematix.co.uk/business/sql-training/ http://www.systematix.co.uk/ http://www.ptr.co.uk/microsoft-sql-courses.htm Regards Mark

Hello: The easiest way would be to do this in a query. Relate both tables by a primary key then base a query on these two tables. Add a third column to concatenate your columms. Then run the query and utilize a MakeTable Query to make a new table. Regards Mark

Hello: One way would be to extract the first letter of this string using the LEFT$ function and then capitalize this character and then add it back to the rest of the string. Regards Mark

Good luck with this! Regards

Hello: For your date, use an "Input Mask" that will insure that a user enters a valid date! Regards Mark

Hello: Search for your string "Member Photos" etc. Then add the slash if you need it. Regards Mark

Hello; Yes that is correct. Below is the syntax: InStrRev Function Description Returns the position of an occurrence of one string within another, from the end of string. Syntax InstrRev(stringcheck, stringmatch[, start[, compare]]) Regards Mark

Here you go....... Please see the attachment. Regards Mark

Hello: Here is a link with the syntax information: http://www.mvps.org/access/forms/frm0031.htm Regards Mark

Hello Enclosed is a link to how to do a cascading combo box as Ken was alluding to above. http://www.utterangel.com/utterangel.aspx Regards Mark