Search results

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.

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

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

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:

Hey Guys, I need help with a little acces project I am doing, I need to query a table for those items which are out of date (if expiry date is before current date) annd get the total count of these out of date items, then i need to get the percentage of : total out of date items /total number...

hey all, the Help I have recieved on these forums has been incredible, so I thought I might give it another shot...... One of the attributes in my table is a date and I want to query it so that I filter out those dates that are older than 2years from the current system date, How Would I do...

Hey Guys, I need to make a access database to store some excel files for ease of use, problem is this is the first time I am using access in my life! I Have Created the tables, though I am yet to fill them with data, And I can run simple querys, The Problem I have Is the form Side of things. It...