Search results

Hey DBL - yes I think it would take a lot more than the ability to view Access reports properly to get Mac users to change! (I'd have one myself if they weren't so costly!). Anyways, I was kinda surprised that there isn't a Mac version of the viewer too. Pdf is always a safe bet though! It's...

Hey DBL - I'm surprised to hear about rtf and txt having problems! I'm also betting that if you had troubles with rtf, then you'll have trouble with word ones too! Snapshot should work! Do the users who receive the snapshot file have Access installed? If not, they will need the snapshot...

Hey Kevin, the reason for their low opinion is because it is kinda like cheating - everything you need for your report you should be able to provide in the record source. There are cases where I do use it because I need one little bit of info that has nothing to do with the report. Anyways -...

Hey Chris, I am no authority in this subject but I have been told that all palm browsers are text-only (that info was a bit dated though!). At work, we were told that if you wanted to test your site for anything, run it through Lynx (it's a text only browser). They are probably on their way...

Hey KevinG, try this: =DLookUp("[Points]","[Winning Teams Table]", "[Date]=" & datevar & "and [id] =4") It should be noted though that using DLookup is never the recommended solution (I've been guilty of this myself!). Try adding the date to your query and placing the new field in the footer...

Run your batch like usual: Call Shell("C:\z\test.bat") Your batch file could be something like: "C:\Report\ImportantReport.doc" Windows will know what program to open for known file extensions. Hope that helps! -Sean

Hi Tim, Sorry, but I don't know what to tell you! The code looks fine - are you sure you're using the right path? Have you tried running other batch files? I'm not sure what "Command Line Arguments" is used for, but mine is blank (and I do run batch files from Access). Let me know if you...

Hello - it may have run but then finished. Are you sure it's not running? Try adding the word "pause" to the last line of your batch file - that will keep it open until you press another key. Let me know if that works for you. -Sean

Thanks Elana! -Sean

Just change computers then! ...just joking:D Start comparing libraries between the two. In VBA go to Tools-References and make sure you have the same ones. (longshot, but worth checking) Also, go into Tools-Options-General and make sure that the "Track name auto Correct info" is deselected...

Hey Matts, sounds like you have design issues. I am envisioning at least 3 tables in your database. Table_Person PersonID Name etc Table_Question Q_ID Actual_Question Table_Answers PersonID Q_ID Answer Table_Answers is what joins everything together. Then, when you create your report...

Is your excel file open? That could be why! If not, maybe try to make sure that your table is closed too. Hope that does it! -Sean

Hi - you can place a page break in the group heading somewhere or go to the properties of the group header and change the "Force New Page" part. -Sean

Thanks llkhoutx! It's reasuring to know that it's possible! -Sean

Hello forum, I was wondering if it would be possible in a multi-column report to temporarily change the width of the detail section and change the number of columns to 1 whenever the group header is to be printed...? Background: I have a fairly complex multi-column report that I've eventually...

Hi Elana, I know this post is old but it's given me hope! I have the opposite problem, I need my group headings to go across both columns. Your problem may have been that you had the salesperson name in the page header where I think you want to put it in the group header. If you have done...

no problem PB! I learned a lot here and on the microsoft site. A lot of things that you think about doing aren't always in a book that you can reference. A book that I can recommend to you for when you get a little more familiar with Access is the Access Cookbook - O'Reilly. It's filled with...

Hey pb, if you are familiar with SQL you will have no problem here. If not, Access has a great query builder that I use even for my non-Access needs. I'll help you get started on this task. Create a new query - select your table. Double click the lastname. Beside the criteria part add...

Hello, the easiest "non-coding" way would be to make them all required fields (if none of them can ever be empty). This is done at the table design screen - look for "Required". Other then that, your gonna have to code it I would think. In the after_update part of the form, put something...

Sorry AutoEng - I can't seem to hide it programmatically. The thing is though, I tried to recreate your situation in my database (created a form to open another form in datasheet view). I hid a column and it remained hidden, to me and all my users. There must be a setting somewhere (and I...