Search results

Hi Guys n Gals I was hopin for some code help on a database that I have ? I have a simple database where I have a field called information_log (see attached) This filed is a memo type of field and it basically is a log of information about a specific fault. So every day someone puts new...

Hi Folks I am having some issues with the dcount function on calculated fields within a query. I have a report where I have some custom expressions which dcount certain values from a query. But when I preview the report the expressions show "Error" See below which is the report in design...

Hi Folks Im in the realms of calculated filelds within queries :eek: Im now at a stage where I want another calucating field. I log fauts/problems/issues to a simple database This has a field called opendate When the case is closed, which it updates a filed called closedate The format is...

Hi Folks I have a simple table that has a date field. This is called dateopened and is in the format ddmmyy hh:m I have a query based on this table. What I'm trying to do is workout the day that a case was opened from the date entered. i.e I have an entry that was opened on 10/08/06 My...

Hi Folks This is driving me mad. I cant see the tables , queries etc , forms, reports when I click the Database window icon on the toolbar. I need to add some more fileds to my tables etc I have form that shows via startup. Here is a screenshot of my problem :-...

Hi Folks I have a command button on a form that emails a report. The report is based on a query called Main query. When the email client fires up its attaching the report as main query.html I would like to specify the name of this report to mean something else. Can anyone give me some...

Hi Folks I have a text box which shows the following This looks at a table with a primary Key called Ref Number in a table called main with a field called open or clsoed and looks for the value open only. I need to specify another fileld, called engineer wheer I match the username =jimmy Im...

Another question on how might be the best way to do things with dates ? I have a simple database which is a fault database. I get an email request to investigate something and I log it and give it a ticket number. If I email back , I put the comments that I sent in the email in the update...

Hi Folks More questions from the newbie :eek: I have a very simple table with a field that will have only the values open or closed I created a query based on this table and used the count function (to count open or closed cases) and in the next querie field I used the group by open. This...

Hi I have an after update even on a field on a form. If the user selects Clsoed in obe filed it autoupdatwes another filed with the date and time of closure as follows:- However I need another statement (else), so that if he changes the status back to open then the DATECOSED FIELD is...

Hi Folks I’m a newbie here, so as usual it’s always followed by a plea for help. I’m From Scotland (live in Engerland) I used to dabble with access in 95 and I can see it’s changed quite a bit. I need a logging system for keeping details of faults that we have passed to various departments/...