Search results

Something I have done, (read about it here) it made a huge improvement Try turning off Name Auto-Correct Tools - Options - General tab Good luck

Split your database, then take a copy of the front end database and paste on your desktop, open this Front end and delete all linked tables which are associated to your BE database on this copy. Now to re-establish your connection with your BE tables, open your copied FE, by clicking “File”...

How about just setting the fields in your TABLE for "required" = Yes?

This is fantastic, I have just started compiling a pdf help tutorial for a product but this is going to be far more professional. Thanks jsanders! :)

I would like to know what would be the best way to publish my stock to a web site. This part is new to me. I don’t mind up dating the data on a weekly bases. I have created a simple db to which I imported slimed down tables and a query from my main db. My web page draws on my query from the...

Phil, Thanks for straightening me out! I notice mark curtis posted a reply and db to ElaJaunie, basically what you suggested. Thanks to all for your help

Thank you both, Cablegirl,, all boxes are bound, but thanks! Lister,, I have never tried macros, but will give it a go. the odd thing is what ever I do with my on click event, the result is all reports print, or I get 'enter peramitor ID. The strange thing is I have other forms/subforms which...

Hello everyone I have made a report “Service PPM”. I have a service form (Service table) with subforms (“Contracts”, “Service Visits”, “Peripheral” and “Peripheral extras” tables). My print button on the service form has the code below on the on click event. My problem is when the print...

Oldsoftboss, Thanks for that!

Oldsoftboss Do you have a copy of the icon zip, if you have, could you email it to me please? Your link draws a blank, looks like the site has closed down. Thanks! Trevor:)

Is your primary key an auto number? It would be better to let your table generate the primary key as an auto number, and if required have your own number field set for no duplication. Just checking!

dcx693, I will do that. I was in a cold sweet yesterday, it could have been much worse. Thank you again.

Hello dcx693, OK, I have found that since the import;, when a main form (Customer) is deleted with a delet function, with its sub form (Contacts) the entry in the Customer table is deleted but the contacts remain on the Contacts table, since the referential integrity was removed for cascade...

I did a “get external data” and imported tables and forms. Obviously I didn’t check ALL my program after the import, some how the links were deleted, but the db appeared to be working after the import. How it could I just don’t know. I just happened to look at my relationship form today and...

Hi dcx693, This is what is bothering me, I have tested at different levels of data entry and deleting, but nothing seems amiss. I am sure it happened at the time of the import, I checked back over several backups till the import and all are missing relationship links, but the one immediately...

Please HELP! I opened my relationship window to find all the links missing between tables, other than between four tables, which I had imported to my working db from my test db two weeks ago. The strange thing is that my db seems to work, original forms and tables work fine, as if...

Pat, Once again... Thank you! Trevor

Hello all, I have two subforms (incorporated in a main form “Service”), I would like each subform “contracts” and “Visits” to open on last record of each subform for that “Service” record. I have tried on both subforms open: DoCmd.GoToRecord , , acLast but they both still open on the first...

WOW, that was quick!! Thank you for that, off to try it. Regards

I am making a “service” form, which holds it data in a “service” table, I need to select a company via a combo from “company” table, this all works fine, but then have a second combo select only one contact from a list of contacts for that same company (Contact linked to Company one to many)...