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...

Still didnt work Hi Matt Just tried And it made no difference.....arrghhhhhhhhhh :D Any other ideas ? Cheers Jimmy

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...

Hio Adeptus Ive been away for a bit and Ive just cheecked out your post. Brilliant , all sorted now. can I ask you another question ? I have an expression and Im trying to find a value that is greater than 1 but less than 2 I cant seem to get it right ? Can you help me out ? Cheers Jimmy

Hi Folks I have been with a calulated filed in my querie. I have Expr1: ([dateopen]-[dateclosed]) Please remember that my dateopen and dateclosed are formatted as ddmmyy hhmm Its not as simlistic as I thought for instance here is a snapshot of my table So the 1st call was closed in...

Just thought I would let you know i did the following This gives me values in days 1.1 2.36 etc But at least now I can do a Dcount on all calls <=1 and may calls >1 >2 etc Watch this space. Still looking for amy good tips from you guys :-) Cheers Jimmy

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...

Hey Guys Many thanks, manage to sort it all out ! Now know how to use calculating fields in a query ;) Many thanks Cheers Jinmmy ;)

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 Ghudson Im using AC97. My DB was ok this morning , i.e I could see all the data. I then had a systrem crash, after that I have al the records in form view, i just cant see the tables etc Ive tried the shift key , and it doesnt work Its also not not behind my form ? Any ideas

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 :-...

Anotehr question on querie expressions ? Hi RV I need some more advice =DCount("[Ref number]","main","[casestatus] = 'open'") The above does a dcount on the table main to find all open cases Imagine I have a query called test which is based on all records of the table main. I would like to...

ok all sorted I took ur advice and changed some of my fileds to no spaces and my expressions worked ok :D But thanks again :-)

More help needed Hi RV Another question ? =DCount("[Ref number]","main","[casestatus] = 'open' AND monthopen like '**/07/**'") I can make a query with has the criteria set too **/07/** and also where the status is open I can then do a DCOUNT on this query whcih would give me a count of all...

Thanks M8 Hi RV Many thanks for the reply. All sorted now ;) cheers Jimmy

Hi raskew I just thought I would let you know that I used your code above and it was very helpfull. Cheers Jimmy

Expression not functioning Hi Rv I have tried the code below and it doesnt work for me, I get and error in my text box ? :confused: :confused: :confused: I have attached an example, check out the form. (AC97 as its all I have at work) Appreciate any advice Cheers Jimmy

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...

Hi Elbweb Yihah :D All sorted now It works a treat...many thanks I may have some more questions coming... Im sure you know that once the thirst for knowledge starts.....it can....explode...but my questions will probably be very basic , but if they help someone else then taht can only be a...