Search results

sam, late here, even later for you! i only see JobNo in your location table...so it should be safe to construct an update query that references the combo box on your form... you will need to include the old JobNo as the criteria in your query, and in the Update To put the new JobNo from your...

yeatmanj, ---you wrote---- That's not what I mean. A "Continuous Form" (a form that displays all records like a datasheet) with the data displayed in columns instead of rows. ---------------- if you mean in multiple columns, like record 1 in column 1, record 2 in column 2, etc. you better...

sam, please don't double-post, it makes it hard on yourself and those trying to help. just do a reply to your original message... an update query may be the answer...but, it would help if you posted the structure of your 2 tables...esp. what are the PK's. al

the short answer is look in help for Autokeys... but, i suspect this won't be what you are looking for as they are global to your application. f-keys are not very user-friendly, and there are many other ways to get the same result. ---you wrote--- For example, I have a text box, and want to...

happy, i agree with jon k's explanation and advice... and yes, graham couldn't have known that you didn't fill out all the fields. i sussed it from 2 fields that are probably optional in your table: Me.txtParentfax = "" Me.txtParentmobile = "" all's well that ends well :) al

happy, a long shot... could AllowZeroLength:No be causing the problem??? hth, al

don't know of any 'work-around'. Nulls 'propagate'...if any field is a Null the sum will be Null as well. you would probably find the Nz function easier to use then an IIF. make sure you use the complete syntax...Nz(Myfield,0) in your query expression. hth, al

not sure if my parens are correct, but try something like: =IIF([SumCount]>0,([ExtensionA]+[CostB]+[CostC]-[ExtensionE])/[SumCount]),0) hth, al

jim, just remembered an additional bit of info... the application i mentioned had no problems with a TransferText import. but, i also had a .csv export (using an a97 export spec) that absolutely refused to work...no error messages, nothing! it just didn't create the .csv. a missing ref. was...

suspect the problem is in the import wizard, not jet. another new 'feature' perhaps? :( i recently did a project (created in a97) that imports .csv's using TransferText with an a97 import spec. and it works fine under a2k. hth, al

KAllen31, not sure what version of Access you are using. in A97 and earlier, an import specification for a .csv will work. later versions may be different. (import schema, whatever that is...) an Excel file is a different problem. but, as you are importing a .csv, you should be able to force...

do the export with a query and use an expression to do the date formatting. -----------you wrote------ I was told that you have less problems exporting in code rather than exporting it through Access. -------------------------- hmm...access has some pretty powerful tools already built-in...

ice, there are examples of check digit/encryption in the neatcd97 database. don't think it's what you want as a date/time encrypts to another date/time, so the unencrypt would require a lengthy user entry. no way around this. :( i suspect there is a simpler way to accomplish whatever it is...

while not in your exact format, here's a couple of excel links that might get you started: http://www.mrexcel.com/tip012.shtml http://lacher.com/examples/lacher18.htm hth, al

you indicate that you have a phone number field in your contacts table. remember a full phone number (555) 123-4567 is, in fact unique. if you require the user to enter a full phone # for a new record, you can then inspect the contacts table for dupes and warn the user of the possibility that...

try: Is Not Null for the criteria... hth, al

check this thread: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=26404&highlight=msgbox+bold hth, al

yep, that does it :) thanks

i'm certain i once knew how to do this! in a97: when you select multiple fields from the field list and drag them onto a form. is there a way to select ALL the fields and detach the labels from the controls? al

inheritance is now the preferred acquisition method... :) al