Recent content by poulsotw

the record will ideally actually be selected in a paramater query dialogue box - however it is possible that a main form will be set up to represent the records also - but that's not decided yet. so If I choose a record with an ID of J00122 in the main table several of the fields in the query...

the Access DB is actually linking to a paradox DB - I can't change the structure of that. So the new table is created in the paradox DB. The new table is basically a review table that stores records that meet certain criteria - based on another query that can be changed to add additional...

Hi I would like to set up a query that uses two tables. One of the tables, the 'main table', wil be used every time the query is run. Each time a new record is created in the main table a 'new table' is created containing a subset of data - the name of this table uses a ref ID from the main...

wondering if it is possible to query a set of Paradox tables without linking them ? have searched for the answer to this and advice seems to be that tables have to be linked. If that is the case is there a way to prevent changes to the table data being made in Access ? ie. allow them to be...

Hello just looking for some advice ... I have a Paradox database which is pretty big, I want use Access (Office 2003) to query a no. of tables in the DB and have the following questions 1. Is the best way to do this to link New MS Access tables to tables in the Paradox database ? then...

Hi Tiro thanks fro your reply, 1. I wasn't sure if this was the best way to do it, I found a macro today that enables / disables controls so I am confident I can sort this. 2. I had read that it is not good practice to import info from 1 table to another just so they can be joined - I...

Hello I am constructing a small database to house details of candidates that are invited to attend interview, whether they pass the interview and if so when they start work and on which shift. Nearly all of the fields relate specifically to candidates - as a result most of the information...

Fizzio thanks for your help, I will take a look at this I have a couple VB books which may help me get started. failing this I will drop you a line. As for the lists - the document forms part of a profile, the idea is actually to register the words that are present in the document as...

Hello just wondering if anyone has comments on whether it is possible to include a memo field in a form to hold several paragraphs of text and search this text for key words. What I would like to do is have a subform to hold a document such as a letter and be able to screen the letter for key...

Hi I am having a slight problem setting the view for 2 forms as Datasheet view, when opened they default to continuous forms view. One of the forms is opened from a switchboard the other from a control button on another form. I have set their Properties Default view to Datasheet but they...

1st Week still defaults to week 0 ... Rich thanks for this I have put the 2 functions in - unfortnately the FinancialWeek returns a value of 0 for the first week from 6th Jan to Sun 12th. Do you have any suggestions how to set this to 1 ? Does this mean it will **** the last week of teh...

Hello I have the following expressions in 3 date fields - Date, Week No. and Period, in a form :- Dat, Default Value =Date() Week No., Control Source =DateDiff("w","1-1",[Dat]) Period No., Control Source =DateDiff("w","1-1",[Dat])/4 for the days of this week the following values have been...

Hello I have a simple form and each record on the form starts with a date - the date the information is entered. I would like to set this to default to the date the record is entered - to save the user having to enter. In addition there is a field for the week of the year and the business...

I have taken some advice on creating a form with 2 synchronised combo boxes, subsequently I have turned this into a sub form within a bigger form. I made the necessary changes to identify the controls as belonging to a subform. The subform is displayed in datasheet view, with value list in...

thanks for your help, I have tried the following :- IIf(IsNull([Forms]![frmtblForecast].[frmSelector]![cboCategorySelect]),[CategoryID],[Forms]![frmtblForecast].[frmSelector]![cboCategorySelect]) and this seems to work. Unfortuntaley now when I select the category in the next subform record...