Search results

  1. B

    How to create a checkbox?

    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?
  2. B

    How to create a checkbox?

    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?
  3. B

    Analyse Access data with Excel

    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...
  4. B

    Analyse Access data with Excel

    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...
  5. B

    Absolutely no popups

    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...
  6. B

    Analyse Access data with Excel

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

    Bringing in Excel sheet

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

    Bringing in Excel sheet

    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...
  9. B

    use dLookup as boolean to set visibility variable?

    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...
  10. B

    Where do I install Msowcf.dll?

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

    Where do I install Msowcf.dll?

    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...
  12. B

    Changing the Access Icon

    Thanks for your help.
  13. B

    Changing the Access Icon

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

    Disable mousewheel navigation in Access 2002 (XP)

    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.
  15. B

    Disable mousewheel navigation in Access 2002 (XP)

    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...
  16. B

    Breaking a table into two tables, joining them with a query

    Never mind. :) LEFT OUTER JOIN
  17. B

    Breaking a table into two tables, joining them with a query

    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...
  18. B

    Looking for an editable varient of DLookUp

    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)?
  19. B

    Wrong Form Dimensions

    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...
  20. B

    Looking for an editable varient of DLookUp

    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...
Back
Top Bottom