Search results

Some users don't have MS Access. Others would simply prefer to see / manipulate the data using non-access programs. Text backups are significantly smaller than a database duplicate. There's a number of reasons, the simplest being...shit rolls down hill.

You should normalize your attachfile fields. I think something like this might work. for i = 0 to attachmentscount -1 'if you don't have this count, you'll need to do a fieldcount in tabledefs if i > 0 then attachfile = "attachfile" else attachfile = "attachfile" & i end if set rs =...

I have a number of database that I would like to backup table data. I would like to use a single database (db1) to cycle through the others (dbA-dbZ) and export all the tables to text/spreadsheet/etc. Current process: db1 opens dbA ....OpenDatabase(dbA...) db1 imports all tables from dbA...

Currently, I just wanted to treat an unbound text box as a memo field - with zero restrictions to what an end-user could input. In the application it was going to be a password field that would accept all input, no matter how ridiculous. In truth, I can't imagine a great reason why someone...

Last item in a table is arbitrary - if you sort/order differently, the results may change every time. If you have an extra item meeting your criteria, why not just subtract 1 from total? Or if your id is an autoID, you could use Max() (or Not Dmax(...id))-- assuming you don't start renumbering.

Primarily, it's a personal pet peeve for txt boxes which should be unrestricted as to input. Chances that an end-user would ever enter a double quotation? ...slim to none. But they should have the ability to enter it. If I wanted to have the text box unbound, is there any way to designate it...

update: How do I allow a USER to input, in form view, a value of into a text box.

How do I put into a form text box?

--> Resume Usuar_Exit

Simple Union SQL query will join the two countries for analysis. Do this for as long as you can... caveat below: Access will BREAK at >2GB. Given your current description you may want to split countries into entirely different DATABASES (rather than tables). These databases can be easily...

Assuming you can't touch the BE, you can still secure an access FE by the usual steps: Disable all special keys Disable Shift-Bypass Update all Forms with a KeyDown filter to ignore any keys you don't want pressed (ie. F11) Hide Ribbon / Menus.

If you're looking to export rather than import: (assuming you use outlook)

Without further details this is going to be very bare bones -- To imitate the picture, Try: New Form > Form > Default View: Continuous form Header: 3x command buttons at top: Save, Reimport, Exit 4x labels: Code/Desc, Amount, Payable/Vend..., Income... >> combo box filled with bill...

Thanks for constant assist. That VBA is the work around I was thinking of, but I was really hopeful there was an easy little force.vertical.scrollbar = true. :D

I really appreciate the help - this is very very close. 3 changes to the file you provided: 1. add a filter to the form: test = "Test2" 'this will filter to a single value in our test table 2. Filter on Load = Yes 'this will enable filter on opening form 3. Allow Additions = No 'this...

Thank you for the attempt. A few differences in our forms: Mine: Default View = Continuous Record Source bound to table Single Record view due to result of filter and/or other criteria Yours: Default View = Single No record source The problem arises when there's a continuous form that...

I have a continuous form that is excessively tall. It has a single record when filtered. The vertical scrollbar doesn't appear. I can't see the bottom of the form. How do I enable the scroll bar? :banghead: attachment: example included - Please open testform, then attempt to view bottom...