Search results

Thanks all but that doesn't seem to make too much difference... Still not sure why using SELECT * with criteria returns field results not in the field name but my query returns them as with the column heading of Field0. Anyone able to help!! paul

actually no! its called APP_DATE. I chose a poor example...problem still remains Can you help Cheers paul

I have a query which takes all fields from a table and uses the [DATE] field to match the criteria of the DATE(), hence returning all those relevant records with [DATE]=DATE() Now if I select all records by using SELECT business.* in the QEB and select the [Date] field and set the criteria to...

Hi guys, I'm really having trouble to get access to use appointment information to create an equivalent appointment in outlook. I've used the follwing code, but I'm getting confused with my coding..can anyone help Dim outobj As Outlook.Application Dim outappt As Outlook.AppointmentItem Set...

Hi guys, I have a continuous form full of columns of data. I created a filter for this form which when applied sets the recordsource of the form to some sql statement. If the user chooses to 'tag' those in the selection for later data processing I have a selector field which is boolean. A...

Cheers PAT.. Worked Great... Appreciated..... paul

I'm using a cross tab query to fill in a grid of types of appointments made by consultants over a peiod of time... When the cross tab query runs if any appointment type has no summary values the whole feild is not reported on and only those with values are returned. Consequently the form I set...

cheers New one on me, but i'll give it a go...!

Justin, If you have a report which sets up your print format and the memo field is part of the report the execution of the report should print only the required record if your report Record Source tells it to select only the report from your form. i.e. your form should have a unique ID like...

If I'm following this correctly... 1) Create a form (say [Myform]) with unbound fields START and END dates as name of the controls 2) Set your query parameters for START and END date to refer to this forms controls i.e In the Criteria cell = Forms![Myform].start for the start date and...

Hi Guys, What I need to do is filter a form by as many criteria as is required by the user. Ie I have 10 separate fields and I want to beable to set up a filtering process which filters by one field, two fields, three fields, upto 10 fields if required. Slowly filtering the data down adding...

Hi, I've got a few forms that appear the order of display is what i'm having problems with. I'm using pop up which puts one form infront of another but there are situations where I need one form to be displayed infront of another when already open how can I do this...? I think I can use...

Hi guys, When creating a user version of my database I've created resitricted menu bars and changed the startup settings to disallow right click shortcuts etc on my editing version by mistake. Now I cant get the standard menus back. How Do I reset the menu bars and let me be able to customize...

Hi guys, I'm using a from which find clients with a combo box. The underlying query filters the datasource whether clients status is active, inactive, dead, live etc.. My combo box displays all clients regardless, what's the best way to set the combo box datasource to be the same as the form...

Hi guys, I have a query which i want to change the criteria of, depending on the control that was clicked from a form. This means that a form uses a query as its recordsource. Some controls on the form choose different queries for the form recordsource. I want one of the controls to use the...

Hi guys, I know how to use a filter to display data in a form. I use code to update fields a recordset using a DO WHILE. What I want to do is to update only the filtered records on the form... Does anyone know how I use the code to update a field only if it was part of the form selection...

Hi guys, anyone no the answer to this one... I want the user to select the data source for a form...That's not to bad by using controls, but Is there a way of using a combo box which actually displays a list of the queries in the database as a whole then uses this as the source as an after...

caf you need to explain this a little further

2 colums in a combo box.... set your column selection to a query or sql statements which reports on two columns Set your column widths to 2 and column count to 2 in the format tab. to update two colums in the table your updating use the after update event of the combo box. e.g...

Hi to all Access Nuts What I'm trying to do is allow the user to aplly a filter on a form to reduce the amount of entries to relevant companies. Then I want them to be able to loop through the selection and update a field in the releveant comapanies. Now, I know how I can loop through the...