Search results

Actually I tried to simplify the question. What we’re doing is tracking sidewalk repair notices. We have numerous tables, queries, forms, reports, etc. in our database. Our inspector inputs data from the field into his laptop which in turn is uploaded nightly to the master file on our server...

I have a table with an ASSESS field limited to “Y” or “N”. I would like a memo to popup if some tries to enter an “N” into the ASSESS field (from a form) if the sum of a few other fields is > 0. I’m assuming I need a validation rule but can’t seem to get it working. Example: When entering an...

Thanks Alc, will do...

I have a database with a field LNAME with last names preceded by maiden names in parentheses. I would like a query that would update fields (LAST and MAIDEN) with the corresponding data: Example – LNAME = (Jones) SMITH LAST = SMITH MAIDEN = Jones Any ideas would be greatly appreciated...

Nope never totally resolved the issue. I had IT rewrite our Oracle update routine a bit and haven't had the problem in quite some time (in fact I forgot about it). But, I never did find a way to resolve directly in Access. Sorry, SKK

Good idea...

Yeah, I played with it a bit. If I open the query via a macro, I can set as RO. I'll just have a button or the users on the FE which will run the macro which will display the tables in RO mode. Thanks again, SKK

Oh well sure would be nice. What about showing the results of a query as read only? The query could be all records? SKK

I believe I may have asked this question before but… I have a FE/BE database. Is there a way to set the tables as “read only”? I’d like the FE to be read only, but allow users to see all the tables, not just forms etc. However, if they open the BE, they would have full control. Thanks, SKK

Thanks, SKK

Is there a way to link MS Access tables as "read only" in Access2000? Thanks, SKK

Thanks, SKK

Is there a way to have differnet forms open for various users? When accessing the database, I want most users to see form1, while a couple would start with form2. Thanks SKK

Disregard - I just got it (update query). Thanks again, SKK

I'm having a problem trimming off characters from the beginning and end of a field. I’d like to remove the first 3 and last 2 characters from text in a field called PARID. I’m assuming I use the MID function in a module. However I’m not having any luck. Any help would be greatly appreciated...

Thanks, SKK

Is there a simple way through either a macro or VBA code to add a field to an existing table? I’d like to add the field “ParID” (formatted as text) to a table called PARCELS. Thanks, SKK

Excellent - thank you very much, SKK

I'm looking for a way to run a macro if a table exists, if not run a different macro. Something like: If TableExists "tblONE" DoCmd.RunMacro ("macONE") Else DoCmd.RunMacro ("macTWO") End If I see some of these mentioned here but I've been less than successful at getting...

Excellent - this is exacty what I was looking for. Thank you very much... SKK