Search results for query: *

I have a form that will be used several times a day. We don't need the data saved, we just print it out. How can I get the form fields to reset to blanks without closing and re-opening the form? Thanks for any suggestions. Carina

Thank You PHV! I knew it was just the way I was putting my "Like" statement together. Your suggestion worked exactly how I needed. Thanks Again. Carina

Hi all- I have searched for an answer in this site, but can't find a similar problem. I have a large database that was created with the name field as "Last, first". Unfortunately, with the diversity of entries, I can't split this field out. I want to be able to pull up all the records with...

I had a lot of problems with if...then too. I needed to convert a number to text. I finally got it to work like this: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) 'Converts the number from ref into text If [Forms]![frmDeedEntry]![ref] = "1" Then Textbox99 = "Highland"...

Don- It sounds like the "display database window" box is unchecked under Tools, StartUp. If you hold the shift key down while opening the database, it disables all the startup info. Not sure why it would show on one machine and not the other. I just started using 2003, and have run into...

I have a problem with a database I recently got dumped with. There is a button on an original form that opens a new form with the selected data, prints the data on a preprinted page, and closes the new form. It is supposed to switch printers before it prints, but it has quit doing that...

Tools>Options>view uncheck "Windows in Taskbar"

I forgot to mention, if your query is making a table, and the table isn't later deleted, the program will still ask you if you want to delete the previous table.

Tools menu, click Options, Edit/Find tab. Clear check mark in action queries box under Confirm. Hope this helps.

I didn't have the shift pressed, and thankfully my users don't know that trick! I gave the application its own name and icon since I typically have several open at a time. When the girls are running the application, the unique icon takes them to the database window, and another icon, a form...

We are running an Access 2000 db in both 2000 & 2002. Hiding the database window works great in 2000, but not so well in 2002. I have de-selected show database window in the startup tools, as well as disbling the special keys.(ie. F11) I have also included this: DoCmd.SelectObject...

The two forms are pulling data from the same table, just different levels of information. Each space has to have it's own record because it can be sold without selling all the other spaces. Ultimately what I want to do is print all the spaces on the deed like: "Space 001, 002, 003...

I have a main form which is a deed, and a subform which lists all the spaces associated with the deed. Each space has its own record. I want all the space numbers listed in a field on the main form. Basically what I want is: List [SpacesSubform].[form]![space] where...

Nevermind-I figured it out, I was using incorrect syntax.

Don't know if this is what you want, but when I need to print the same report with different groupings, I use a form with a combo box to select the criteria before the report generates. You would have to close the report in order to select new criteria though, so it isn't really interactive...

I am using reports to issue a deed. I want to insert a bound text box between two expressions and the text box will never be the same length. I was using labels and text boxes individually, but it makes for a very choppy printout when you can't predict the length of the text box. How can I do...