Recent content by fenerfan

Hey people, This should be any easy one to solve: I need to split a field in my query into two separate fields, e.g fullname into a first and last name, so "John Smith" will appear in two columns, "John" and "Smith". Thanks in advance.

anyone got any ideas?

hey people, is it possible to automatically center the form controls(labels, buttons etc). because When I create a database on one computer, the controls change position when opened in another computer with different display settings... Cheers...

sorry mate didn't work... MyMonth: DatePart("mmm",[Date_Rasied]) here is what it returned: Equipment_Name Event Date_Rasied MyMonth sump pump 609359 12/06/2007 #Error

Hey People, Is it possible to take out part of a date in a query and put it into a new column, e.g. if one field is : "Date"... with entries such as 12/05/07.. etc, is it possible to have another column "Month" that has the specific month in the date column.. e.g the one above will have...

your a legend mate, cheers

Hi There, I am having trouble with something that should be very simple, I have a textbox and am trying to check if it is empty: if text0.text = "" then ......... end if. problem is that it doesn't work, tryed a few variations, either returns an error or doesn't return anything at all, any...

Ok guys, here is my problem, I have a table with 3 rows, looking something like this: Crew Date Score A 1/6/07 12 A 3/5/06 14 A 5/4/07 12 B 3/6/07 13 B 7/5/06 10 B 9/4/07 11 C...

Hey Lads, I am trying to create a chart in a report that is liked to several queries, so I get several lines in a line graph. But so far having no luck at all, is there any way I can do this???

Hi, When I filter a for linked to a query by date, the Date I input has a MAJOR problem. for example if I enter 12/07/2006 into the textbox, and press the control button running the following code: Me.SBFRM_FLUE_DUST.Form.RecordSource = "SELECT * FROM qry_flue_dust " & BuildFilter...

Hey All, I have to attributes in my table, [Date1], and [Date2] , I need to add a validation rule to ensure [Date1]< [Date2], I am trying to do this in design view using the validation rule under date1 properties (I put in - <[date2] ) but It keeps coming up with errors When I try to save...

:eek: :eek: Hi Everyone, There are some absolute aces on this board, and I have another question.... I have a vb button on my form that when pressed produces a print preview of one of my reports. What It also needs to do is highlght some of the lines in the report, the condition being...

Hey All, I Have a button on my form when pressed it shows a report in print preview mode. The code looks like this: DoCmd.OpenReport "(REPORT TITLE)", acViewPreview Is there any way I can manipulate this code to set the header of the report???:confused:

Hi All, How do I set an integer 'X' to two Decimal Places ANYONE???:confused:

Here is the table: description Mech_Procedures (ID, Procedure Number, Issue Date, Expiry_Date, Reviewer) I need a query to return all IDs where (expiry Date < system Date) (I know How to do this part) But I need to also have a count for the total expired, and be able to have tis as a...