Recent content by mrrcomp

Did anyone get this working in Tabbed Documents Access 2016 64Bit

Hi Does anyone have this working in Access 2016 64 Bit??? Tabbed Forms?? Regards Meir:banghead:

Hi I'm looking for a solution for Gantt in Access. I downloaded your demo however it crashes with runtime error 1004 - Unable to get the type property of the Axis Class I don't see any references that are "missing" when I open the code. Any suggestions? Regards Meir

Hi Yes tried all combinations.. nothing seemed to work. Curious enough I also had some problems with form names that weren't recognized in the VBA code (specifically ones with "s" in the names) and I had to enter the code and retype the names using the Turkish Keyboard?? The major...

Thanks for your quick response to my post.. I am using the dsum as a "calculated field" and the result is #error (in turkish). I tried to write the dsum in VBA immediate code window and also will not calculate.. Regards

Hi When transfereing my application to a user who has Turkish MSAcess 2007 installed a query that has a Dsum function inside it gets corrupted i.e. the commas get converted to SemiColons inside the designer. Even editing it back to a turkish comma the user still gets a wrong punctuation error...

HI In your criteria you need to add a space between the first and second values and you need to add quotes around the text string DCount("[projectid]","tbDV","[ProjectID] = " & [Reports]![rptProjectRecord].[projectid] And " [DVStatus]=" & chr(34) & "Approved" & chr(34)) The above should...

Hi I am new to this forum. I must admit it looks like lots of great people helping one another. I guess the idea of Paid Membership is to help defray the costs of keeping the service online? Am I correct? I was thinking about a 2 component option being a WebStore and a point award for...

HI Had it originally as just function. didn't work thought that making it public would open it up.. Regards Meir

Trevor Hi Was wondering if i could pick your brain for one more point with regards to Access Add-In. I have a function in the Add-In for example Public Function getlan() as string getlan="bla bla bla" end function When I attempt to call the function from within a form in the current...

Hi Trevor Thanks for the response. I was actually looking for a method to get the data from a table in the currentproject into the listbox. I found a work around where as I create the tables etc that I need in the Add-IN and only at the end of all my processes do I copy the tables down into the...

Hi Did changing to regular open solve the problem? Regards Meir

if the mdb front end is exclusive open on your comp then certain options won't be able to be done from both locations. Is the problem you have right on the open of the db or when attempting to read / write data Meir

Hi You need to be sure that when you open the db in Access that you don't "open as exclusive" Close Access and reopen be sure that after you pick your mdb file on the right the option is "open" only Hope this helps Meir

Hi The scope of the variable is only for the sub that its in. You need to declare it outside the scope of any of the code behind the form subs. Hope that helps