Search results

New be with the same structure as the working be's. Link the table in new be to the fe, but give it a different name i.e. Import/Export Create a form that lists the customer names and has a check box. Write a query empties the import/export table. Write a query that appends the all ticked...

Have 2 tables. One is automatically updated with report names from MSysObjects. The second is manually updated with friendly names by the person who creates the reports. Query1 Add/Update/Remove table names from MSysObjects to table1 and table2 Table1 (query writes/updates list of tables from...

It shouldn't be replication, it should be transfer of data. Therefore no duplicates.

A Better Way to Fill an Access Listbox With Report Names How to Keep a Listbox of Access Report Names Current

There is xml. Exporting / Importing XML Or SharePoint. Having some/all of the data stored on (or should that be in) SharePoint, the different practices always have access to the records. So there would be no need to export/import. Obviously there are things to consider, i.e. do you want the...

All the Access objects are listed in MSysObjects. Reports have a value of -32764. So it is very easy to get a list box to dislay the list of reports. Just the names are a bit of a problem as it uses the actual report name. Actually if you read further on the author shows more ways. Might be...

I used to work for a large architectual firm and we had hundreds of onging projects. When I was emloyed as the IT manager the Exchange server was a mess. Users were forwarding emails like crazy to each other and saving emails as text files and putting them into project folders on the file...

I use a program that exports/imports data from one dataset to another (not access). What it seems to do is create a number of BE files in a folder. The folder is then sent to another user for importing. I guess it uses something akin to a Make Table Query. Then the second dataset looks in that...

Maybe this will help.

Whould this help you ?

Samle DB of using a custom ribbon to open forms.

Re: Access Package and Deploy - Make your db a "Standalone" app When I was at junior school (admittedly a very long time ago) they used to teach us the basics of a thing called punctuation. I do not always get it right, but I do know what Scare Quotes are. Maybe you should look it up sometime...

Thanks got it: USysRibbon <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="MyTab" label="My Tab"> <group id="MyGroup" label="My Group"> <button id="MyButton1" size="large"...

A quick and dirty method is to add a column to your query for the report. Counter:iif([field1] = "ABC",1,0) Then in your report add a sum field for this column.

I am building a custom ribbon and need some XML code help. I need this button to open a form. <button idMso="??????" size="large" label="MyButton"

Dim Msg, Style, Title, Response, MyString 'Put something here that fires off the Yes No If a = b Then 'Message box details Msg = ("First line of your message" & vbNewLine & _ "Second line of your message"& vbNewLine & vbNewLine & _ "New paragraph") 'Style of...

Date()-[Date Quote sent] or DateDiff("d", date(), [Date Quote sent])

With Runtime it doesn't matter what version of Access they have, or even if they have Access. Runtime is a seperate program that runs the app. It requires NO Access to be installed only Runtime. With 2007 onwards Runtime is free. The Deploy tool (also free) allows you to package the app, with...

Don't see how this is relevant. I was not saying that the OP should use Runtime to build the app. I was pointing out that the default ribbon is not available in Runtime and that one could create one's own ribbon. To that end I think the ribbon is a must cleaner look than the traditional drop...

See my post at Access Package and Deploy - Make your db a "Standalone" app . It has info on deploying, runtime and ribbons. A lot of what the OP requires. So if you do not create a custom ribbon you get nothing.