Search results

I wonder someone would help.. I have a form where I enter two dates i.e. a commence day and a final day and I also have a save button. I would either a. have a control on the save button which pops up a message if the final day is greater than the commence day and so preventing the save...

Hi, Grateful for advice. (Using MS Access 97 and 20003) I have a database with a number of clients. I have created a form that will query the database to find me the number of clients that contain a name, eg. Smith I get the following:- Mr J Smith, Mr and Mrs A Smith, A Smith and B Smith...

Hi all, I don't know whether I am in the correct forum but since I am looking at creating a form I thought I might ask here. The idea I have, simply put, is of creating an A-Z type of directory whereby by clicking on a particular letter a listing of all records commencing with the letter A...

Hi all, I'm having difficulty bringing to the front a form that I am calling from another form. i.e. I have a button on the main form. This button calls up another form but rather than popping up in front it remains behind the main form. Any idea why this is happening?

Hi all, I wonder whether it is possible for the following to be carried out: I would like a routine that would copy paste certain information that has been inputted into a particular field via a form (into a specific table) to be copied onto an email template. Presently I have a button on...

Hi guys, I'm sure this is a simple question which I 'll probably kick myself when it finally works. I have an input form...simple enough with a couple of combos thrown in. Howver when I click the button for the next record (after having clicked the save button in order to save the record) my...

Hi, I would like to know whether the following routine is possible. (I am using A97)! I have a table of addresses:- A1 A2 A3 Country There are occasions when the address is so short that Address 3 (A3) is not required even though the country field is filled in. I also have a report which...

Hi all, I would be grateful for assitance: My problem is as follows:- I have two fields A and B formatted (as y/n)which need to be populated per record. I have inserted two option buttons to cater for these two fields, i.e. by ticking either box the value is saved in the record. The...

Hi all, (I am using A03) I've looked into this issue using the search facility but I havent managed to find suitable assistance. I am checking the options in an option group. I am hoping that the user is made aware that the options have not been toggled. Given the option using vbOKCancel...

Hi, I am trying to apply an adapted function/module (from this site) to a textbox that I have created in a report, but with no luck. Can someone assist me? Thanks :confused:

Hi, I've checked many other posts regarding this same issue but I'm still having probs. I would prefer a Before Update event procedure. The code I'm using is : If DCount("*", "tbl_XXX", "[ID]="" & "[NOM]= Y") > 0 Then where tbl_XXX is the table being updated [ID] is one of the fields...

Hi, Grateful for advice I have a table with different fields, lets say field A and Field B Field A can have duplicates Field B is a y/n toggle I would like a constraint which prevents two records having identical data in those two fields. Thanks

Hi all, This is perhaps a deviation from my previous post and which i thought was getting me nowhere. Anyhow my current problem right now is : I have a main form and a subform. The subform is based on a query (whuch is based on a number of related tables. The purpose of the subform is to...

Hi all. Grateful for some advice. I have a form and a subform. The subform lists a number of records in continuous form format. This comprises of items bought. each item has a supplier, an invoice number, product, cost, received and paid. Note in this list there may be several records...

Hi all. Grateful for some guidance witha problem I'm having. So far I have a parent form and a subform. Basically the parent form is a search form where I have an unbounded box where I enter the product I am looking for. I have a Search button on this form which has an event procedure that...

Hi all, I need to convert this A03 function into A97. Help greatly appreciated:- Function IsLoaded(ByVal strFormName As String) As Boolean ' Returns True if the specified form is open in Form view or Datasheet view. Dim oAccessObject As AccessObject Set oAccessObject =...

Hi all, I've checked the forms forum for a similar thread. I have a form which reads off a table A. I have a delete button on the form but it wont delete the current record on the form. Table A is related to another table. I'm using A97 ...any clues anyone! thanks

Hi all, I have inherited a database with a table with plenty of duplicate records. In some cases the a record may appear more than once. I have kindly been given the following code but somehow I cannot get it to work. I am getting a runcode error. In my example database I have three fields...

Hi all, I've just inserted a new field into an already existent table, and I would like to populate this field which spans over two thousand records. I would like to create a vba script which will allow me to do this. I'm assuming that I would have to create a new module but I'm not quite...

Hi, I have the following: I have a table which i am populating via a form. Simple enough! However I have an unbound text box which looks up a field value and returns a value. This value is not saved in the table.It is there for information purposes only. When i close the form and then...