Search results

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

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

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

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

Hello I have a form called "frmSelector" with 2 synchronised combo boxes "cboCategorySelect" and "cboProductSelect". I copied these from Article 98660 from MS Knowledge Base. This links each combo box to a query, the first combo box also has an After Update macro (the only macro) which...

Hello I haven't done a great deal of work with MS Access or other application other than the very very simple. I am currently trying to get my head around manipulating the rowsource for a combobox on a simple form. The table that the form is based on is very straightforward with a bunch of...