Search results

Hi All, What i am trying to accomplish here is this:I have 2 forms one is prod form and the other is report form. When user updates something on the report form i need a msgbox to be popped up in the prod form for all other users who are working on it. I can use a timer control to check if...

Hi All, I wanted to know if there is a way to check emails that have been receivced in lotus notes. It needs to check if an email is received particularly with the subject that is already available in a table in database. if it can check it needs to inform the user working on the database that...

hi all, I have written a small html coding with javascript. I have used radio button to say yes or no. The problem is the selection of the radio button is not being passed to the variable in the java script. fine the code below. pls help me out . it works fine in chrome browser but not in ie8...

Hi All, I am importing excel sheet data into a table. It has a field for amt and it imports into temp table as text and then sends it to main table where it converts it into currency. Now the problem is the data from the excel sheet looks like 00002145 and when it comes to the main table it...

hi all, i have divided my access file into 2 components. one is the front end and the other is the backend which contains tables only. Now the problem i have is i run a macro which loads the data from an excel sheet into the tables. I cant run the macro on the front end since they are all...

hi all, i am trying to get normalization concepts right in my desing of database so as to avoid wastage of space and corruption of data. i have 12 queue (people work on this data which they get from different sources) an they will require to enter informatin related to the queue in the...

Hi all, I have form which is designed based on a word template. I want text boxes to populate based on user input. For eg if user says 5 then i want 5 text boxes to populate. Is it possible? Even if possible how do i ensure that when user submits it it gets submitted in the table.

I have been searching this forum but to no vail. what i require is able to create multiple text boxes based on user input. For eg if user says 5 then 5 text boxes need to be created and so on so forth. I can predefine the text boxes which i can make them appear and disappear based on the input...

Hi All, I will try to be clear as much as possible. I have a list box which generates a list of questions based on the input given in 2 earlier boxes. I have given check boxes beside each of those questios. User selects the check boxes if he has done what the questions says. Now i want to...

hi all, i have a query which give me a result of few records. For eg it give me a list of 10 records. I want also to generate a serial number in the output of query to list the records from 1-10. i cannot create a sno in the table. cany anyone guide me

hi all, i have a form on which there are list boxes which populate a set of question based on the selection of the previous list boxes. Now i want to be able to populate check boxes for all the question that populate on the list boxes so that the user can check them. The question can vary...

Hi All, i have a query which gives me a result of set of records. I want it to be auto numbered for making it random. I have tried several ways to increment by writing an expression but something goes wrong. For ex in the queyr that i have written like SELECT TblAccq.Pan, TblAccq.Queue...

Hi All, I have a created a db which if it can be used by other countries (offices of the same organisation) would be very effective. The workflow requires other people in other countries to act on the db which would in turn be acted on by the people i work from. There is a common network drive...

hi all, i am trying to send emails through lotus frm access. I have been able to input in the body of the lotus the query results but i would like it have coloums and rows. I have no idea how to do this. i did a bit of reasearch and found that html would allow me but i could not figure how to...

HI all, I want to trigger macro express when a key is pressed in ms-access database. i have developed a database in ms- access which multiple users use. Now when they complete a work they need to send an email to business are confirming the job is done with a formatted excel sheet to which a...

Hi All, i want to calucate sla - the numbr of days items needs to be worked and it should exclude holidays and weekends (saturday and sunday) . for example. today is monday and 20th and the SLA for the item is 5 days which should be friday the 24th. but assume since friday is holiday and...

Hi All, My database contains records with unique ID's . they can have account number repeating. i have a button which they click they get 1 record and it checks the account number if it has repeated and has not been resolved (identified by a status col) it will need to throw all of them to the...

Hi All, i am trying to open an mde file and i get this error message. i have developed this database for production in my company. But suddenly when i tried to open this after testing at the end of hte day i am unable to open it. Can anyone help me. If at least i am able to import the tables...

Hi All, i am designing a database for my company. They enter all the details and also they will require to attach a word doc which needs to be looked whenever necessary. for example they should be able to enter all details like acct no, refe no and along with this the doc associated with the...

Hi All, when i try creating reports this the following error message i receive: "There was a problem retrieving information from the printer" I dont understand why does a printer need to be installed for creating a report