Search results

I'm adding data to the Excel file from Microsoft Access. What do I put into a cell to get a checkbox? For instance, if I was just going along in the spreadsheet, typing stuff in this cell and stuff in that cell, how would I enter a checkbox without clicking around in the toolbar?

I have an Excel file that has checkboxes in it. When I look at the cell, it shows a letter "c" in it. Just a c. I'd like to add a script that replaces the empty box and puts in a checked (x'd) box. How do I enter a checkbox into a square, empty or checked?

I don't output the file to Excel, I open the Excel file, grab the appropriate recordset, then place information from various fields in the table into the appropriate cells in Excel. It leaves the Excel sheet open in case I need to manually change something. It saves the file so that, after I...

You're not from the USA, are you? When you say 9,15 you mean 9 + 15/100 right? We write it 9.15 -- post the Visual Basic code that you're using here. I question, though, why you'd want to write it to a table then write it to Excel instead of just writing it straight to Excel ... Oh, you're...

If I try to "Print Preview", that page opens, showing a blank 1 page long document. When I try to print an IE page, I get a blank document. Somehow, all data is blocked from being passed from one window to another. You know, I get popups and such just fine on Firefox. I think I'll just use...

Check the format on the Excel cells. What are you using to get data from the Access database to the Excel sheet?

Me([Form Name]).Subform(MyOLEField) isn't giving me a reference to MyOLEField. Neither is Me![Form Name].Subform!MyOLEField

I have an Excel sheet that I'd like to bring into an Access Form -- populate the Excel cells with data from textboxes on the Access Form and print it. I tried copy/pasting various things in, but it's pasting even text from a cell as an Excel object (let alone joined cells and images). Where...

I'm trying to say something like: If (there is at least one record of this type in the form) Then turn variable on else turn it off end if If DLookup([Note], [Problem Info], [SocSec] = Forms![Apprentice Information]![Soc Sec #]) Then problemImage.Visible = True Else problemImage.Visible = False...

LoadLibrary(Msowcf.dll) failed - The specified module could not be found.

I have a text box on a form with the Control Source set to: =Pi() It's giving me a #Name? error, as is Control Source: =Radians(34) Seeing this note in the help file related to Pi() ... I searched my computer for Msowcf.dll and found it installed in: C:\Program Files\Microsoft Access...

Thanks for your help.

How do I change the Access icon? I know how to change an individual form's icon.

No, my problem is with those big mice with 5 buttons on them (both sides, top, etc.) that have really touchy wheels. It sometimes seem as though you barely bump the wheel and suddenly Access navigates through the next three records. I think I'll just use your save button, ghudson, thanks.

I've heard that there's an "easy" way to stop movement of the mouse wheel from navigating through records in Access 2002 (XP). All of the solutions that I've seen so far involve bunches of code which (given that my forms are so packed already) could slow my forms down slightly. Is there an...

Never mind. :) LEFT OUTER JOIN

Let's say that a table has been broken in two and I'd like to rejoin them with a query. Let's say 100 records in table1, 20 records in table 2. Here's a random example, I just made the names up off the top of my head: PersonTable (100 records) Person # (unique key) Name Address SpouseTable...

What about an updateable query? http://custom-software.biz/AccessWizard/Jan06.htm How can I link a query up to a control on a form such as a text box without using DLookUp(which would preclude updateing a field from the control)?

A form can't be smaller than the controls inside. For instance, let's say that you have two controls, side by side, like this: [Text1][Text2] If the left side of Text1 is at 0" and the right side of Text2 is at 5", then the whole form must be at least 5" wide. If you try to resize the form to...

I've been using DLookUp in controls on forms, for instance, the control source would be: =DLookUp("[BookPrice]","[BookBeltInfo]","[Soc Sec] = Forms![Apprentice Information]![Soc Sec #]") I'd like to put some sort of direct SQL statement into the control source so that the displayed value is...