Search results

This means that the declaration should be like the following Private Declare PtrSafe Function ..........

Thanks London , your code makes the trick, but i modified it to the following because I will make the error message as a "label" under Textboxes "username and password" Here is the code I use now Private Sub txtUsername_AfterUpdate() Me.Form.Filter = "UserName = '*" & Me.txtUsername & "*'"...

I have a login form that has : "txtUsername" "txtPassword" It linked to table:"tblUsers" that contain a filed "UserName" I set a form filter to filter the "UserName" like "txtUsername" Everything works fine if the typed username already exists in "tblUsers" but if the typed username doesn't...

Finally I found the solution: I just assign the .Left property of my reference as following: Me.txtBoxName.Left = 5 * 1440 and I adjust the (5) according to my form. Thanks Solved

Dear All, I know I'm stupid enough But really I can't get the meaning. :banghead:

I'm Sorry, can you clarify more how to use this. I put the code in the form on Load, but no change happened. Thanks

I made my database to run into 2 languages (English - Left to Right) and (Arabic - Right to left) Access only assigns one direction by default. What I want is to shift the direction of the form from LTR to RTL by VBA . How can this be done?????

Thanks for your help actually you did a lot to me. I decided finally to solve my problem by creating one main form which is linked directly to the table and then I added some some forms do [Id] field is unique Sent from my G-TiDE E77 using Tapatalk

This also does not work

I also tried adding = but still the same problem

I have two forms - frmVList with ID (from tblV - Table) -frmVDetails (with ID as "tblV.ID) as tblV is the table name that contains the ID. (That is because i made a query between some tables in the control source of [frmVDetails] I want to click ID in [frmVList] to open [frmVDetails] where ID =...

I saw the same in a sample database offered by someone for free but he locked importing external tables. He assigned a password to the VBA codes. I don't know if this is the solution or not, but at least it worth trying.

Sorry Again, It was my mistake, I followed your tutorials again carefully and it worked like charm Private Sub TestMGroup_Click() Forms![frmMain]![NavigationSubform].Form![frmTSGroupList].Form.Filter = "TestMGroup =" & Me.ID...

Thanks for all of you for your answers , unfortunately, tried all of them with no luck. the problem still exists.:banghead: this is the error message: Run-Time Error 2450 Microsoft access can't find the referenced form "frmTestsMain"

I have an unbounded Form Called [frmTestsMain] which includes 3 subforms: [frmTestsList] [frmTMGroupList] [frmTSGroupList] [frmTMGroup] has a filed "TMGroup", [frmTSGroup] has a filed called "TSGroup" and another lookup filed "TMGroup" linked to [frmTMGroup].TMGroup. [frmTestsList]...

I solved all problems It seemed that I needed to update all parameters for RunMacro with adding "[txtID]" parameter . Regards

Dear All I downloaded Access Desktop Service Template and made some additions and adjustments to it as follow: - I added Receiving Notes forms and tables with the same criteria as Quotes. - I modified some module parameters that I coped from table "Quotes" by changing the word "Quote" to "Rcv"...