Search results for query: *

Hi! While I was surfing the web I ran into quite an interesting website, namely of Compagnie Financière Richemont S.A. (http://www.richemont.com/). The pictures on the welcome page change with each viewing. So does the color of the center table. I know there is some php involved. But I am not...

Hi People! I have a small problem with my VB code. It has to copy records to another table. It works fine as long as the AmountEuro field contains decimals(for example 2000). But when I try to copy one with decimals (for example 200,05) I get a syntax error. What am I doing wrong? Thanks...

Hi all! I want to rename a "#Error" value to "-". It looks much better :) But I am not sure how to do it. Thanks.. Sheila!

Hi! Please take the time to read about my problem. I have been at it for weeks and if I can't find a solution this time, I guess I have to give up my project :( But here goes: I would like to make a report which shows and combines data from two tables, i.e. 'Budget' and 'Invoice'. I am using...

Hi! I would like to make a report which shows and combines data from two tables, i.e. 'Budget' and 'Invoice'. I am using 5 fields, namely: 1. Budget Year 'from Budget table (the field is also available in the Invoice table); 2. Quarter 'from Budget Table (also entered in Invoice table); 3...

Hi! I would like to make a report which shows and combines data from two tables, i.e. 'Budget' and 'Invoice'. I am using 5 fields, namely: 1. Budget Year 'from Budget table (the field is also available in the Invoice table); 2. Quarter 'from Budget Table (also entered in Invoice table); 3...

Hi :) I am sure this is a very easy question for the experts. I would like to add a Nz Function to one of my queries. I have a field Budget which I want to give a "0" value where there is a Null value. Is that possible? What code should I use and where should I put in in my query? :)...

Hi everybody! I am trying to make a complicated code in VB. But I am not even sure if what I am trying is possible. I have a data entry form in which a date is entered. Now I want the system to derive some information automatically from this date and enter it two other fields in the table...

Hi guys! I have been struggeling with a Access problem for days but I reckon it is very easy to solve for one of you professionals :) So here goes: I am trying to link two tables (named "Budget" respectively "Invoice") to acquire certain information for a report. I joined...

This going to be a bit hard to explain :) But here I go. I have one form with two subforms. Subform 1 is linked to the main form. Subform 2 is linked to subform 1. I use the on current action in subform 1. See the end of this message for my code. Here is my problem: when I open my main form...

Hi all! I noticed an error in one of my query's. The following gives the formulas I entered in my field name. Rest Budget: [Budget]-[Committed]-[Invoiced] Committed: [BudgetCommitted]-[InvoicedCommitted] Ok, here is my problem. When the value of the committed field is negative. My Rest Budget...

Hi, I would like to make a search system for my database. I would like my method to use 2 forms; one to gather search criteria, one to retrieve and display results. On my search form I have two textboxes, txtAccountName and txtBudgetYear.I want the search system to assume that when one of...

Hi! Can anyone help me to recode this Access 2000 VBA code so it is compatible with Access 97? I really don't know how to. Maybe one of you can help me with another small problem. This code selects all records in my table budget and then compares it to the data entered in a form (to which this...

Hi all, I would like to make a two criteria search for my form. I was thinking of copying the example in the Northwind sample database. Here it works as follows. When you open the report 'Sales by Year' a form is opened, named 'Sales by Year Dialog'. On this form you enter two fields which...

Hi all, I would like to make a two criteria search for my form. I was thinking of copying the example in the Northwind sample database. Here it works as follows. When you open the report 'Sales by Year' a form is opened, named 'Sales by Year Dialog'. On this form you enter two fields which...

Hi, I would like to get a user confirmation before subjoined action takes place. I was thinking about using a message box: Call MsgBox("Replace?", vbOKCancel). But I don't know where to go from there.. :( Private Sub Button__Add__Click() Call MsgBox("Replace?&quot...

Hi, I have an access mdb file and if possible I would like to customize the icon. Is there any way to do so? If I need some software, no problem! I'll download it :) Regards from Roma, Sheila

Hi, I placed a similar message before in another part of the forum. But I think my previous idea was wrong, so here I try again :) I am using Access Y2K, but in the office they have Access 97. If anyone can present me a solution which work onboth, that would be super! I would like to transfer...

Hi, I placed a similar message before in another part of the forum. But I think my previous idea was wrong, so here I try again :) I am using Access Y2K, but in the office they have Access 97. If anyone can present me a solution which work onboth, that would be super! I would like to transfer...

Ciao ! I have one more problem to solve :( To clarify things somewhat I made this test screenshot of what I would like to do. Perhaps it is impossible but I think this should work. I just don't know how to program it. http://www.geocities.com/sheilaalighieri1980/screenshot.jpg I am using...