I.T. Discussion Community!
rdavidson [Unspecified] -Collapse +Expand
-Collapse +Expand
rdavidson
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (7)

Search rdavidson:

Advanced
Personal Account . . .
rdavidson
 (Inactive)
Whitewright, TX, USA



Real Name:  rdavidson [Unspecified]
Primary Role:  Coder
Joined: Apr 2001 (19 years ago)
Visits: 3
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

7 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

rdavidson
recover damaged file...MSysDb
I was working with my main .mdb file, and as luck would have it, Access up and crashed. This does happen every so often, as is true with most software including Microsoft products, but this was a very bad loss., , Upon trying to reopen the file and recover what I have since my last save, I get the following error message:, , The Microsoft Jet database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its name and the path name correctly., , There was no object named MSysDb in my system, so I am assuming it is an Access feature. Other backups I have work just fine...only the file which crashed gives me this error., , It is possible to spend a day recovering lost work, but if there is anyway I could recover my lost file and sidestep this error message, I would be very appreciative., , ``allen
Posted to MB Topic: MS Access Interactive « Access Board
18 years ago

Anonymous
--- sajo
8 years ago
Nothing New Since Your Last Visit
4769
Hits

Microsoft Access

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

rdavidson
making subforms visible when necessary
Along with making elements visible, I have a subform which shoud only be visible when there is data for it to display (by this I mean that the subform has Master and Child linked fields so that it will display information based on the data entered into the main form). Any help with how I can achieve this would also be greatly appreciated., , ``allen
Posted to MB Topic: MS Access Interactive « Access Board
18 years ago
Nothing New Since Your Last Visit
1078
Hits

Microsoft Access

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

rdavidson
making elements visible on forms
I have some nifty boxes on one of my forms, which are initially set to not visible. At particular points in my code, I set the boxes, one by one, to visible...hence creating a status bar effect. However, when I set the boxes to visible, they do not appear. The lines of code which are setting the visible property to true are being executed, and upon inserting breakpoints, I can switch back to the form and see the boxes as they should be. However, just letting the code run, the boxes do not appear until the code is finished., , Any help with why the boxes are not appearing until the end would be greatly appreciated., , ``allen
Posted to MB Topic: MS Access Interactive « Access Board
18 years ago
Nothing New Since Your Last Visit
906
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

rdavidson
searching text fields, error number 3070
{Too Long!}
Posted to MB Topic: MS Access Interactive « Access Board
18 years ago

jdschram
I think this may be your problem...., , you said product code is a string....you SQL, searches for something that isnt a string *, , what you need to do is enclose the * so it reads '*' the quotes are required for strings..., , Hope this helps
18 years ago
Nothing New Since Your Last Visit
1511
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

rdavidson
access auto-organizes fields in subforms
dealing with subforms, when text boxes and labels are added, and then the elements within the subform are re-organized (in design view), access maintains it's own organization in Form View. is there a way to make access follow the organization I set up in Design View instead? I have looked through the properties for the subform, and see nothing that corresponds to locking the position of elements., , ``allen--
Posted to MB Topic: MS Access Interactive « Access Board
18 years ago

jdschram
change the default view of the subform to continuous forms....or if you need to use datasheet view, then open the main form, make the changes in the order of appearance in the Form View then save
18 years ago
Nothing New Since Your Last Visit
1307
Hits

Microsoft Access

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

rdavidson
accessing methods in a subform from the main form
i have a form which contains subforms. i have figured out a way ([subform_name].Form![object_name]) to access elements on the subform from the code of the main form, but i need to also access user-defined functions in the subform. however, when i try to make a call like:, , Call [subform_name].methodName, , or, , Call Forms![main_form]![subform_name].methodName, , or even, , Call Forms![subform_name].methodName,, , i get an error saying the method is undefined. any suggestions?, , ``allen--
Posted to MB Topic: MS Access Interactive « Access Board
18 years ago
Nothing New Since Your Last Visit
964
Hits

Microsoft Access
More...

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech