Recent content by dobber

We have an Excel worksheet (running Office 2003 Pro) for which we have written VBA (Excel) code, placed behind a button on the worksheet. When the button is clicked, the Excel worksheet is converted to a PDF file. This works fine, except the hyperlinks (links to other PDF files, Word docs...

We have an excel worksheet (running Office 2003 Pro) for which we have written VBA (Excel) code, placed behind a button on the worksheet. When the button is clicked, the Excel worksheet is converted into a PDF file. This works fine, except the hyperlinks (links to other PDF files, Word docs...

I have a mailmerge that works perfectly well with an MDB file named WOW.mdb, but if I try to run it using an MDE (of the same database - WOW.mde), it fails. At first the problem involved another instance of Access being called up. I solved this by using some code I found to set the...

I have a mailmerge that works perfectly well with an MDB file named WOW.mdb, but if I try to run it using an MDE (of the same database - WOW.mde), it fails. At first the problem involved another instance of Access being called up. I solved this by using some code I found to set the...

I have a mailmerge that works perfectly well with an MDB file named WOW.mdb, but if I try to run it using an MDE (of the same database - WOW.mde), it fails. At first the problem involved another instance of Access being called up. I solved this by using some code I found to set the...

Our organization has an Access 2000 Database named "Audit" containing numerous forms, queries, reports, etc. We also have a database named "AuditData" that houses data only (containing tables linked to "Audit"). These databases reside on about 40 separate laptop...

Thanks for the great responses. I was able to both solve my problem and gain some better ideas for designing forms in the future. I really appreciate it.

I have fourteen text boxes on a form named "txtBox1", "txtBox2", "txtBox3", etc. I have another text box named "txtNumColumnsNeeded" into which the user types a number (1 to 14). Depending on what number is typed into "txtNumColumnsNeeded", I...

I have an Access table containing one record and one field named "color". The data in this field (green, blue, etc.) changes with input from an Access form. I also have an Excel spreadsheet where I want the "color" data from the table to be linked to cell A1, so that when...

I have an Access table containing one record and one field named "color". The data in this field (green, blue, etc.) changes with input from an Access form. I also have an Excel spreadsheet where I want the "color" data from the table to be linked, so that when the...

Please help - I know someone else also asked this question a few days ago, but they didn't get a response. Since, I also need a solution for this - I'm asking the same question myself this time. I have a form that picks random samples to be used to review financial documents. The user inputs...

Thanks to both Michael & Ronnie, both pieces of code worked well and did exactly what I needed. However, I refuse to disclose which one I actually used in my project. I really do appreciate all the help. I'm relatively new to Access, having been a Visual Foxpro programmer. Its going to take...

Thanks Lonnie, That worked great. Just what I needed. I had struggled a while on the problem, but could not come up with a solution that seemed simple enough (I don't like very complex code to accomplish a (seemingly) simple task). I appreciate you help...

Does anyone know of an Access procedure/function to determine the number of Saturdays in any given year (the years could include Leap Years)? Thanks in Advance for all reponses..

Thanks Terry, That's exactly what I needed. I'm fairly new at Access and I wasn't even aware of dcount.