Search results

  1. C

    Relink tables on Startup and catch ms access error

    Hi, Using the code found here: http://www.mvps.org/access/tables/tbl0009.htm I have put the function to relink my tables into the OnOpen event of my Startup form. The function relinks fine, however, if the back end tables are missing, ms Access reports it's usual error: "Could not find the...
  2. C

    How Can I Branch To The BeforeUpdate Event?

    I have setup all my form validation in the BeforeUpdate event. I know that Access will auto save the current record when you scroll to the next record, which works fine with my BeforeUpdate validation code. However, some users users just like pressing the "Save" button, becuase it makes them...
  3. C

    Steve Lebans Calendar Doesn't Higlight The Correct Dates

    Hi all, I don't know if anyone has come accross this before. I've been using Steve Lebans Calendar control (available here: http://www.lebans.com/monthcalendar.htm ) for several database application I've built. I only noticed recently, that after I've selected a date range, by highlighting...
  4. C

    Sumform SUM doesn't calculate on Load Event

    Hi All, I have a subform which has a field in the footer to calculate the sum of a field =Sum([SaleAmount]). On the main form, I have a textbox that references the subform's [SaleAmount], Main form control =[Forms]![MainForm].[MainForm_subfrm].[Form]![SaleAmount] I have a combo box which looks...
  5. C

    Can You Call the Description of a Database Object in VBA?

    Hi people, I'm using the following code to generate a list of the reports I want for a combo box: For Each accObjectQry In CurrentData.AllQueries Me.cboSelectReport.AddItem accObjectQry.name Next This grabs the queries for the reports I want to generate on my form through the combo...
  6. C

    Avoiding Duplicates in a One-to-Many Tab Conrol Form with Multiple Tabs

    Hi guys, I've been experimenting with Tab Control forms in Access 2003. I've setup 3 tabs on my form with a Tab Control. The first 2 tabs, Customer Info 1, Customer Info 2, reference the same table. The last tab, Payments, has a subform that displays all the payments the customer has...
  7. C

    Secure Queries through running in VB code

    Hi people, I've been considering how to setup my database to secure my queries. In this case, the data in the tables is not so important, as the process that is used to filter the data and produce an output. I was thinking of an alternative way to secure the queries, without going the...
  8. C

    Error: You cannot make changes to the design of the database at this replica

    I recently was asked to update a client's BE & FE database. It seems the client only has a replicated version of the database. I don't have the original Design Master. Problems with negative autonumbers (it seems are due to replication), made me want to remove all need for replication from...
  9. C

    Remote Deskptop connection to Access DB on Server

    Remote Desktop connection to Access DB on Server Hi I currently have an Access Database in a BE/FE, server/client LAN architecture at a single office location. My client would like to allow one user to 'add new records' to the database on the weekends (i.e. after hours), without needing to...
  10. C

    How to Keep track of Documentation for BE / FE Revisions

    Hello everyone, I have been wondering about how I'm going to keep track of revisions for one of my databases. Currently, I have the database split into a Back End (BE) and Front End (FE). In the work environment, the BE sits on the server, whilst all other 4 machines get a local copy of the...
  11. C

    Calcute Week Numbers Starting from 1 July of Current Year

    Hi everyone, I want to calculate the week number of a date in a year starting from the 1 July (of the current year) - as this is the beginning of the Financial Year in Australia. The starting day of the week is Wednesday. I've been trying to think how I could use the Access DatePart...
  12. C

    Change the Colour of a TextBox / Field depending on it's value?

    Hello fellow programmers, I have a tricky one for you. We have decided to split our local City up into different zones. Giving each zone a number and assigning it a colour. I have a form with all the customers who want jobs done in different parts of the city. This form has a text box on it...
  13. C

    Why is Access slow on Client computers across wireless network?

    I have completed a database for a company with 60 000 clients and over 100 000 job records. The database works at very resonable speeds on the Server computer, or the computer on which I installed the back end of the database. Each of the other 3 computers on the wireless network, have a local...
  14. C

    Backup Database OLE or DDE Error

    Hi ppl, I'm just about to install a database this week. However, I'm trying to provide a "Back up Database" facility. I noticed there was some code floating around to do this. However, I was hoping just to put it in the File Menu so users could backup manually. I have set the Startup options...
  15. C

    Use SELECT CASE statement in UPDATE query in VBA

    Use SELECT CASE statement in UPDATE query in VB Module, to convert Open Access Time Hi people, I'm working on upgrading an old DOS Open Access database for a carpet cleaning company. All the fields were imported into MS Access fine, EXCEPT the time field. This was imported as a Long Integer...
Back
Top Bottom