Search results

I inherited a mess and have been cleaning it up. Back/Front ends are separated. In the front end database I've deleted half of the forms, half of the tables are no longer linked. I've deleted a bunch of unnecessary code and tighted things up. Why is my database 4 times as big as when I...

This post is a solution, not a question. It took me a day and a half to find this and it seems to come up often: I swiped this from: http://www.lunasystems.com/tips.htm Synchronizing Subforms In Microsoft Access We're not talking about synchronization from a mainform to a subform but...

I just figured it out. Thanks for trying it. My problem is because the field is named "Prefix". When I changed the name to "AttendeePrefix" it worked fine. However, I still don't know why the scenario I stated above doesn't work. But, I don't really care. Thanks all for your help.

This is something WAAAAAY more basic than that. If someone has time, please try this. I'm totally under the gun here and this is a complete show stopper for me. The following doesn't work: Create baseline Event Management database using the wizard. Add attendee John Doe. Run "Attendee...

Those are the names and formulas. I broke it down as simple as I can and it doesn't work. It works for [AttendeeFirstName] but not for [Prefix]. I even tried creating another column named [Prefix2] and copied in the data from [Prefix] to see if that would work but I still get the error.

This makes no sense. I put a value in for every Prefix but I still get an error. These work: Prefix AttendeeFirstName =[AttendeeFirstName] This doesn't: =[Prefix] I looked at the field definitions and they are the same.

Thanks for the info. I'm new with Access and read in the manual that macros were on there way out so we should stick with code to get our work done. I'll have to take a look at them.

I want to create a field on my report that has the following: [Prefix] & " " & [FirstName] & " " & [LastName] The problem is, [Prefix] can be null so I get an #error in the field when it displays. I've tried using Nz() and iif(isnull()) to no avail. Any ideas? Thanks

I finally figured it out after an hour yesterday and an hour and a half today. The form needed to be opened using acFormDS in the code as follows: DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria Thanks for your help.

Wouldn't you think? It comes up as a Form even when I specifically state that Form is not allowed. I swear I'd hate Access if I didn't love it so much. :)

WOW, that was fast! Unfortunately it still doesn't work though. I have "Default View" set to Datasheet. I saw they said something about the ViewsAllowed in help. But I don't see that listed as an attribute. I have "Allow Form/Datasheet/PivotTable/PivotChart View" all set to Yes. I tried...

Very much a newby here. I have a form with Default View set to datasheet that allows all types of views. The form works fine in development, but when I open it up using a button, it comes up as a form. I tried recreating the form and the button to no avail. Thanks.

I have a subform that, when double-clicked, I want the cmdOK_click event of the form on which it sits to run. Thanks