Search results

the error occured in this line of code, and the error message is "Invalid Password" Set dbLink = DBEngine(0).OpenDatabase(strDBPath) I tried your code your suggestion and same error that i have. DBEngine.OpenDatabase (strDBPath, , , "MS Access;PWD=" & strPassword) i have a code to...

i tried but still password in error. i tried it manually and the password is ok. so sorry it's been a week now that i tried everything but it just seem not working. i just want to relink the back end to the front end at runtime whenever the back end is moved or mapped in a different netdrive.

thanks aob for the reply, i appreciate it , i already insert your suggestion but i think before it reach that code this command makes an error due to password too. Set dbLink = DBEngine(0).OpenDatabase(strDBPath) any idea where to put the password in this code? thanks boss

Hi Guys, I have a Back end (with password) which resides in a netdrive while the front end is installed in each individual users desktop, the problem is, some of the users netdrive was mapped in a different way (different letters..some are J others are G). I'm looking for code that I can...

Thanks Boss.

hi spikepl, can you please send another link because the attached one is not found anymore.

thanks a lot cj, i manage to play with it and here is what i come: Dim dbs As Database, tdf As TableDef Dim fld As Field Set dbs = CurrentDb Set tdf = dbs.TableDefs!<DataBase Name> For Each fld In tdf.Fields 'don't include those fields in the list If fld.Name = "Field1" Or fld.Name...

can i do this in a query? because I want both field name and field description, I can use this to my hide/unhide fields at run time.

hi cj, jdraw and solo712, i do appreciate your replies, it give me great idea. but in my 7th post i already figure it out and i got the result which what i'm expecting of. i'll still consider the link's that you guys provided to me. and study the sample's. pardon me for being a newbie in...

Sorry boss, here is the correct statement that gives me what i needed: SELECT UserFile.UserID, UserFile.UserFname, UserFile.UserLname, Max(DataFile.TranDate) AS MaxOfTranDate FROM DataFile INNER JOIN (UserFile LEFT JOIN [DataFile Query] ON UserFile.UserID=[DataFile Query].UserID) ON...

thanks for the reply cj, anyways i found a way to resolve my problem, here's the statement: SELECT DISTINCTROW DataFile.UserID, UserFile.UserFname, UserFile.UserLname, Max(Format$([DataFile].[TranDate],'dd-mm-yyyy')) AS [TranDate By Month] FROM DataFile INNER JOIN UserFile ON DataFile.UserID =...

here's what i did. first i created a query to get all the employees that have transactions: SELECT DISTINCTROW DataFile.UserID, UserFile.UserFname, Max(Format$([DataFile].[TranDate],'dd-mm-yyyy')) AS [TranDate By Month], Sum(DataFile.NoEmail) AS [Sum Of NoEmail], Sum(DataFile.NoPhone) AS [Sum...

hi guys, i'm trying to create a query of all employees doesn't have any transaction for a certain range of date and will also shows the last transaction date they have. i have two databases one is the transaction file and the other is the user file. i'm trying to play around and yet i'm not...

I found the problem, the culprit is my pop-up form message. I call this form to display a message before setting the source object of the subform control. I deactivate the procedure and replace it with a label message followed by doevents and everything is working fine.

Hi Members, I'm hoping that you can enlightened me with this case I'm working. I have this code to apply alternate color of my datasheet and it's working fine in my test database, but when I apply it into my production database (a split database), the out come is not consistent, as if the...

I'm Juan and a new member here, I'm an average access user and currently doing some small projects here at my work. I find this site very useful specially in seeking answers in my problems. Hoping by joining this site will enhance my knowledge by the help of my fellow members and of course by...