Search results

Hi there I am having problems with an IIF statement and I was wondering how I can get the query that I need to work. I have the following columns application_type: this has three values in it - Major, Minor and Other numberofdaystodecide: this is the number of days taken to decide a file...

Hi there I have a database that has some data in it from an old database. This data has been converted in to the new database (many years ago) and subsequently it has gone a bit astray. Basically my problem is this. My current database has 6 address fields in it. At the present time all...

Hi there I need help in a problem that I have and I "think" that VB may be able to help in resolving it. What I need to be able to is as follows: When a user creates a new record within a database a specific piece of HTML will be automatically written in to a column. How in the heck do I do...

Hi there I have some information in a database that I need to make sure sure is correct. There should be 11 characters (numbers, text and items such as /) within this particular field. I know that there is a number of entries that either has more or less than the 11 characters in this...

Hi there I have a small problem that I was wondering if someone could help with. When a user creates a new record I would like it so that some html is written automatically in to a defined column. Is this possible? I tried to use the default value property of a column but access does not like...

Hi Folks I need to calculate the number of days between two dates excluding the weekend (I am not bothered about bank holidays etc). I am trying to find out if applications made by people have been registered within 3 days. The initial date that the application has been date stamped is in a...

Hi there! I need to run some stats for my workplace that involves working out if applications have been registered within 3 days. How in the heck is this done :confused: I've had a browse through the forum and I noticed that VB seems to come in to it. Do I really have to use VB to work it...

Hi there I have a database that has two tables. Table 1 is called applications and table 2 is called contacts. Table 1 has two fields that relate (not through the relationships) to table 2. These fields are named thus: Officer and ContactTelephone Through a form I wish to be able to do the...

OK trying my best to figure out an append query but having little luck :confused: Hopefully can explain what I am after. I have a main form that has a number of fields two of which I need to match up in a where condition: ref and ryear. On this main form is a subform where the data from the...

Hi there If I have a form open on a particular record I would like to transfer the text from that record in to a merge document. Is this possible and if so, how :confused: I know that you can transfer the contents of a table but I am only after the record that is currently displayed on the...

Hi there I have two forms in a database. One is the main form the other a sub-form. On the subform I am running an append query. My problem is this. Once the query has been run I have to come out of the record and back in again to see the appended data. Can you tell me if there is anyway or...

Hi there I have two forms in a database. One is the main form the other a sub-form. On the subform I am running an append query. My problem is this. Once the query has been run I have to come out of the record and back in again to see the appended data. Can you tell me if there is anyway or...

Hi there I would like to build a database whereby when I create a new record it generates a new reference. What I'd like is say the first record to be: SNN0001 and then when I create a new record the next record would be: SNN0002 How in the heck do I do this :confused: Thanks for any help...

Hi there Need some quick help with VB. I have no idea how to write out the VB for what I require but I believe it may be quick and simple for someone in the know. What I need is a MSGBox to appear if a specific field has not been filled in when a user tries to save a record. When the box...

Hi there I have a bit of brain teaser. Is it possible to transfer text/ data from MS Access columns in to an email message. Basically what I ideally would like to do is the following: 1) Have a column that has an email address in it and transfer that in to the "To:, CC: or BCC:" of an email...

Hi there The basics of it are this. I have a main form entitled BAR_frm. On this form are 7 fields for an address named as follows: mainsite_organisation mainsite_address1 mainsite_address2 mainsite_address3 mainsite_address4 mainsite_address5 mainsite_postcode I have a seperate form...

Hi there I'm working on a query where I need to calculate the number of days left before a deadline. There is a slight twist though. I have created a query which has an expression field in it as follows: OfficerDeadline: DateAdd("ww",5,[Date_Valid]) I need to do the calculation off of this...

Hi there I am trying to work on a query which I am not sure if is possible to do. Basically I work for a local council and we are trying to return a list of jobs that have not been inspected in three months or more. The problem lies in that the table that holds the data has a number of...

Hi there I am trying to link in photos to a database but I do not want to create them as OLE objects within the database. I have seen on a database somewhere where you press a button and it opens up a box the same as if you were browsing for a file in windows. You then choose the file you wish...

Hi there I'm new to the forum and was hoping a kind person out there could help me out with a problem. Basically I work for a local authority and each week we produce a list of planning applications for our Parish Council's. Part of the query includes the category used by the ODPM (Office Of...