Search results

Welcome to the forum. Please can you tell which version of Ms-Access Database you are using as a back-end database? is your database has linked tables to C++ (not sure if it is possible) by the way, you can make a copy of your access database before doing any experience, then apply the...

Hi, Check your query if it is updatable or not? your query could have inner joins which might have preventing your data to be updated.

Hi, It's easy to populate one combo based on another combo. You have to make query for your second combo. In the criteria, when you select the column id of the first combo ( in your case the school id in the first combo) the second combo will be populated only for the selected school...

You want to display something i.e a subform if a condition is true? this you can do easily with VBA codes in event procedures, but as a good database developer you should keep your tables integrity, normalizations, and relationships as clean is possible to prevent it from being messed. In your...

Try to understand Defining relationships between tables in a Microsoft Access database. This applies to: Microsoft Office Access 2007 Microsoft Office Access 2003 Microsoft Access 2002 Standard Edition However the basic concept is same for all the version of Microsoft Access. Hope this will...

Dear Naud! you have to create two text boxes on the main form to enter the two dates you want the result, then make your result query to your main-form row source, and call the criteria of your desire dates in the query i.e your text boxes field in the query. create a button on the form to...

Hi, Reece Why you are not thinking about the login form? where you can provide username and password to the user so they can type their username and password which will be registered in a logTable with the time and dateStamp. Regards.

bob! function not always returns a VALUE ;) so former and latter typo has no meaning:D

Hi Bob! Yeah! I have noticed these Type Item Description Qualifier PtrSafe Indicates that the Declare statement is compatible with 64-bits. This attribute is mandatory on 64-bit systems. Data Type LongPtr A variable data type which is a 4-bytes data type on 32-bit versions and an 8-byte...

I hope someone can change the following win32 bit API call to 64bit very soon::) Private Declare Function GetSystemMenu Lib "user32" (ByVal hwnd As Long, _ ByVal bRevert As Long) As Long Private Declare Function EnableMenuItem Lib "user32" (ByVal hMenu As _ Long, ByVal wIDEnableItem As...

hmmmm, so when VBA7 is releasing? I am exited:rolleyes:

Yes its really a BIG problem now, I remove all my 32bit API calls from my Application, coz its not working with 64bit configuration. now the problem is I am not able to find out any 64bit function on the net:confused:

I use the following query as my record source to the list box: SELECT tblLocation.Status, tblLocation.Location, tblLocation.LocationDetail, tblLocation.LocationStatus, tblLocation.ReqToActivate, tblLocation.ReqtdDte, tblLocation.ReqBy, tblLocation.sUserName, tblLocation.ReqName FROM...

Wish you a Happy Birthday Rabbie, where is the cake?

I have written the following code on my my main form on timer event to kick-out any user from the application: If Exit_user() = True Then Call SaveUserInfo("out") 'save user info Application.Quit acSaveYes End If The Exit_user() function check the following: Public Function...

That's a nice idea Mr. ghudson! but I have some senarios with my application. consider the following: I have written some codes which close the application automatically when nobody is using it for 30 minutes. I want to close the application (kick-out all or some selected users from the...

Agnieszka! this problem is coming just when they installed Access-2010 on the new computer with 64-bit configuration and window-7 operating system. I am using Access since 1998, and I did not find any problem with Autonumber key re-seeding behavior. I used all verions of Access. In this...

Yes! It is possible to cotrol the null value with the NZ function in Ms-Access Try this:

Hi Steve Schapel! I don't want to disable the button on the form, I just want to disable the X button (clsoe button) on the Ms-Access Database window on the top right cornner to close/exit the Access Application entirely. I dont want the users to close the Application throught this X button. I...

I think you have a Date field in your table where you want to record the date of birth of the petient, but sometime the petients don't know their date of birth, so in this case you can create a text filed in your table for example petient_Age to record the Age data.