Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rafal444
  • Order by date
  1. rafal444

    Automatic backups

    Thanks, I have the backup procedure, it is the scheduler I need to get working with the code...
  2. rafal444

    Automatic backups

    How do I create a copy of mdb every one hour? Will it work when db is open. I also do not want to overwrite the old files. Just keep daily backups for 7 days, and keep all weekly backup for a year...
  3. rafal444

    Automatic backups

    Do you have more details regarding the scheduler? What exactly I need to setup? Right now it just backups from inside of MS Access, OnTimer method of the form...
  4. rafal444

    Automatic backups

    Yes, two files
  5. rafal444

    Automatic backups

    How do I setup automatic backups in Access? I setup OnTimer event on the form. The problem is that the form needs to have focus... The code, it copies the current db into new file... Any idea how to get this working when other forms are open? Maybe other solution?
  6. rafal444

    Tabbed Menu

    Can anybody help?
  7. rafal444

    Tabbed Menu

    How do I create a tabbed menu like on www.buysellcommunity.com? The menu has two bars: 1) Top bar (just tabs) 2) Second level menu (just links) Th second level bar should change depending what ios clicked on the first top bar I was looking into CSS Adapters, but the problem here is that the...
  8. rafal444

    You have entered expression that has no value

    Value is a calculated field on the report. =NullToZero([my query field])
  9. rafal444

    You have entered expression that has no value

    I am getting this error. How to test for it? I have tried for IsNUll(Value), is error(value) isempty(Value) All returns False! How to check for this error???
  10. rafal444

    Problems with a query

    ...statement out of all movies. I want to show the movie and the latest statement for that particular movie. This is the query I have: SELECT A.* FROM [QryReportBase_CalculatedAll Step 4] AS A WHERE (((A.StatementDate)=(Select Max([StatementDate]) from [QryReportBase_CalculatedAll Step 4] as B...
  11. rafal444

    Expressions Editions Nightmare

    ...Expenses]),IIf(IsNull([Domestic Distribution Expenses]),Nulltozero([Domestic HV Distribution Expenses]),([Domestic Distribution Expenses])*IIf(NullToZero([Domestic Revenues])=0,0,NullToZero([Domestic HV Gross Revenue])/[Domestic Revenues])),IIf([Dom HV Deals].[HVDeal]="Royalty",DMax("[Edited...
  12. rafal444

    Problems with Union Query

    Here is the query: SELECT ID, Film, Name, MovieRelDate, StatementDate, [Domestic Theatrical Distribution Expenses Calculated], [Domestic HV Distribution Expenses Calculated], [Domestic Other Distribution Expenses Calculated], [Domestic Distribution Expenses Calculated], [Domestic Distribution...
  13. rafal444

    Problems with Union Query

    I wrote the union query of queries A and B. When I execute each seperatly it works. When I execute A Union B I get "Division by zero" error. Does not make too much sense. Any idea?
  14. rafal444

    How to populate the whole recordset

    How do I populate (Move Last and Move First) the whole recordset when the form opens?
  15. rafal444

    Big Problems after updating DB to SQL Server

    I wonder, maybe I need to populate the whole recordset. I have noticed taht when I move to the last record, the SQL causing the problem dissapers from Processes window in Enterprise Manager
  16. rafal444

    Big Problems after updating DB to SQL Server

    I have moved all the tables to SQL Server using upsizing wizard. However now users experience big problems, the database hangs. I did some research and I have noticed that: 1) There is a blocking process 2) The blocking process SQL is: "SELECT "dbo"."Contacts"."ContactID" FROM...
  17. rafal444

    Multi-selection List Box

    I would like to have a way to select multiple Products from the list. How do I make the report to show only records selected in the list box?
  18. rafal444

    Automatic backup of database

    In fact I need to backup two databases, prefferably when Access exits: Front End and Back End database, minimum BackEnd...
  19. rafal444

    Automatic backup of database

    How do I automaticly backup database everytime user exits Access application?
  20. rafal444

    Linked db in current folder

    I understand, It is just my client is using x:\...\accesdb while I am using c:\my documents.... Everytime I give him new front-end, he needs to change links. He does not like it... Both databases are in the same directory. Is there a way to specify relative path or have some code to run when...

Part and Inventory Search

Back
Top