Search results

Has anyone seen a good way to prevent the thousands of password removal tools from working? I would simply like the Excel protection to NOT be easily defeated by the use of these tools. Any ideas? Bryan

I have a table with a field that has two Part numbers in the field- one being listed in () Parenthesis. example 56B900-09 (2221-9). I need to keep the Part Number in Parenthesis and delete the other in this field. What is the best way of doing this? Update query? Thanks, Bryan

Yeah I tried that but I have Labels that Visibility is set to True/False depending on that particular rows returns in various fields. It works for each row independently in the Report Detail "On format" event procedure but I could never get it to work in a form. All the labels would base their...

I agree....but then I would need it to change pages on a timed event so all pages eventually are displayed. Any ideas on that?

Hey everyone, We have an overhead projector that displays a report but can't fit the whole page on the screen because of font size/legibility. Has anyone seen any tricks or code that can slowly scroll the report up and down the page? Or does anyone know or use other software to better display...

Thanks for the help. I have started to recreate the form and it appears this will fix the problem. Bryan :rolleyes:

Yes the autocorrect is off and I have done several compact and repairs. The only thing that I have noticed is when I select the Event procedure and Code builder and the VB box comes up, I start typing Me.etc... the VB suggestion box doesn't come up with a list of code choices. It does on other...

I made a test(new) form and got the code to work. For some reason it is not working on the existing form. I don't feel the existing form is corrupt because other code works fine. I had it as a text box on the form, but I also tried it off using the Me.[Timestamp] = Now() It is something with...

Thanks for the reply. I tried both ways you suggested. Same Error. I even tried using the Date() instead of Now(), no help. I tried it in BeforeUpdate and AfterUpdate, no change. I know I'm overlooking something preventing my code to work and I just can't see it.

Thanks for the reply. I've tried the BeforeUpdate() as well. Same error. The Timestamp field is a date field.

I Can't figure out why this doesn't work on a form that I want to populate the Timestamp field when they edit the record. Looks like it works for others that have posted. Do I need to add a New Reference to the reference Libary? I'm running Access2k I get an error box stating the procedure...

Thanks Rich, I did make those changes. Good Advice. Any ideas on my form problem?

"Dis" allowing edits in datasheet mode when macros are used. Why won't this work? Hello all, I'm looking for someone to help me understand why a form of mine that has only 3 fields - [Name], [Date], [Notes] isn't working right. I have the form's "Allowedits = No" which works great except when...

Ok one last question from your quote: "1. How wide (how many bytes) is one returned record for the most commonly used query?" How are you measuring this? Are you counting the number of returned characters per line? ie. 1 character = 1 byte. My understanding of your reply would be that a...

Oops! I guess I forgot to mention the backends are on the same local server. So, locally both Dbs report in 12 seconds. Take them 1 mile down the street via T1 (to get to the backends). One Db takes 14 seconds(no big deal) and the other takes 1min15secs. Same computers. Same exact reports...

But what about the fact that the larger database was tested and doesn't run much slower? If it was the T1 wouldn't both Dbs act the same? Why would it only affect one and not both? Thanks, Bryan

Hello, I need help knowing what I should look for to fix this problem: My company has a database (Access 2000) that will run a report locally in 12 seconds. When we take the same computer and run the same report 1 mile down the street via T1 the report takes over a minute. Sounds like the...

No I didn't. The project was dropped at my company and I never learned how to do it. Sorry:(

I recently recieved a database that develops an ODBC error 3146 when the VB form opens. The debugger halts on the Call RegisterDatabase line as seen below. I believe I have the Microsoft Text Driver setup inproperly in the ODBC data sources dialog box in the control panel because I know this...

I had my code set that way originally, but it did not work. Now I just found an error in my NDT field.I just corrected it and rewrote the code the way you printed it. Works good. Thanks for the help Rich! Bryan