Search results

This is killing me... and so is my customer. I have set my application options default Find/Replace behavior to General Search. It works fine the first time the user does it. Thereafter, however, it reverts back to Look In: <specific field> and Match: Whole Field. Is it possible to make it...

For the life of me I can't get an input mask to work for date/time. I want to store flight times like this: Example: November 16, 2003 11:15 PM What mask do I use? The following isn't working: 00/00/00\ 00:00\ >;LL;0;" " I can't even directly enter the data into the table with no mask.

I created my own menu to attach to forms for my app. It looks fine on my computer, but everyone else has other menus too. Please tell me I don't have to set the menus on every single client...

I have an all-purpose query I display to the user on which they can filter/sort, etc. If they make any changes (filters, etc) it prompts them to save the query. Is it possible to avoid that prompt?

Is it possible to get a query to use a customized menu like you can with forms?

Is it possible to export relationships from one database (development) and import them into another (test). I have to do it again on the move to production.

I have a list box I'm requerying using code but the value doesn't change. "qryDelete" deletes the current row they have selected. str = Me.lstControl.Value DoCmd.OpenQuery "qryDelete" Me.lstControl.Requery Me.lstControl.Selected(0) = True str = Me.lstControl.Value The value of str doesn't...

I can't get my tab page to allow me to put another tab inside of it. What gives?

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 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

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