Search results

I have created a multiple items form. There are three fields in the form. Sr No-Textbox-Primary key Geometry-Combobox Factor-combobox I want to acheive the following. When the user selects one of the following geometries, Square Rectangle Triangle Circle. A pop-up dialog should open up...

Solved. I created the db from start again. Don't know what exactly the problem is/was.

The FE is 1.37 mb and the backend is 1.37mb

I m stuck after taking immense pains to develop the database, Please some help.

Did that too.. Still giving the same error.

i did. I was able to create a file in the shared folder from my collegue's computer.

Nope I cant add any record. The row where we add the next record is frozen.

i did that. Still no luck. Same message.

I created an access database (.accdb). I used the database splitter to split the database into front and backend. I kept the backend in a shared folder in my computer which is a part of the company's windows network. I linked the frontend with the backend tables. The dasebase works fine on my...

My apologies for making this too complex. Let me ask my question afresh, I make certificates (reports) that have a unique allotment number and these certificates are signed by an examiner. In my table I record the allotment number and the date of signing the certificates. I need to get these...

Have I explained the problem correctly.

Here is what it finally burns down to, I have queried few fields, the result of these fields I need them in a separate field.

Can u elaborate sir? I will be glad to learn a new way of doing this.

Because I have to take signature from an authority after certain interval of time. The Date1 field, is the initial date, Date2 is six months after date1 and Date3 is 1 year after date1.

How? U mean to say like between results of date1 and date2 and date3?

Ok. I made a mistake typing all that. Here is the attached access file. I have a table (Table 1) containing fields Allotment Number and Date1 I query the table and the query has 4 fields Allotment Number and Date1, Date2 and Date3. (Query 1) Where Date2=Date1+180 and Date3=Date1+365 I query...

I have used the "Between [Enter Start Date] And [Enter End Date]" for all the fields, i.e. Date 1, Date 2...and used OR in between so that I get all the allotment numbers between those dates. Now, say a record in Date 2 fields falls between the entered dates, I get the result of the query in...

Thanks to all, I found the solution, It seems more than access I need to be fimiliar with SQL symtax and jargon,

Dear VBAINET Thanks for your help. I am new to Access and so far managed to create simple databases. But I am stuck here. I have a table which has many fields, of which "allotment number" and "date of sign" are 2 fields. I have created a query which calls these two field and I have created...

How exactly will I go about executing it, Where will I write the function. i wrote 18/3 and 25/3 as examples/