Search results

Sometime ago I used a Access Macro feature that allowed me to keep the current form to remain the same while behind the scence, the form is actually closed and reopen. The reason the form has to be closed and reopened (using Macro again) was because I've provided a button in the form which...

Thanks... It works!

Just to further clarify my question. The Date given by the user is for a field in Table A (Date of Registration). The two previously entered dates are two separate fields in Table B (eg. BeginDate and EndDate)

I would like to know what internal function I can use to so that I can determine whether a Date given by the user falls within two previously entered Dates. Thanks...

Thanks...

I understand that in order to deploy my Access application for my users, one of the tools available would be to use XP Developer to package my application. I would like to know whether I can use SQL Developer for achieving what I want to do? Since I currently only have SQL Developer in my...

Thanks...

yes. There is an auto-generated key index field for the table.

I have a text field which contains user entered ID. The id varies such as M0017, 0007, S006 and so on. If a user enters a new ID say M0018, I'll need to pull the previously entered record (ie. M0017) for certain data processing. I'd like to know what built-in function I should use so that...

Thanks...

Once an Access application is completed, is there a runtime that I can distribute together with the application? This is so that I don't have to ask my users to purchase MS Access just to be able to run my application. Does anyone know of any website where I can get more info on the MS Access...

Thanks...

Thanks...

I have an original date (mm/dd/yyyy) such as: 6/01/2003. I'd like to use macro/query to change the date to a month based on another date field (eg. 7/15/2003), so that the result for the original date will become 7/01/2003. Any help would be appreciated. Thanks...

I've two dates/times in mm/dd/yyy hh:mm format. TimeA: 2/7/2003 2:00am TimeB: 2/8/2003 4:00am I have field (date field) and do a simple TimeB - TimeA, the result is 2:00 which is wrong as the second date/time is over a day already. Any suggestion what I should do? Thanks....

I've tried using the second query, but the problem is how to create new set of child records with their corresponding newly created (auto-generated) Bill ID (which is being used as foreign key in the Child table).

I have tables as follows: Parent(Bill ID, ...) Child(ID, Bill ID, ....) Now there is a set of records in Parent with their related records in the Child table. I've been trying to do mass copy of records from the previous month to the current month, this is so that my user doesn't need to do...

I'm using Access 2002. I have a Single Form (Parent) which contains a subform (Child) in Datasheet format, within the subform is another subform (Grandchild) which is in Continuous Forms format. However, when I expand all the fields in the Child form, only the first set of records in the...