Search results

  1. I

    Split database: Back end file path (via vba)

    I found the solution: http://www.aislebyaisle.com/access/vba_backend_code.htm#linktables
  2. I

    Split database: Back end file path (via vba)

    Hey! I found this code on the help but i don't know hot to adapt it properly Sub ClientServerX1() Dim dbsCurrent As Database Dim qdfPassThrough As QueryDef Dim qdfLocal As QueryDef Dim rstTopFive As Recordset Dim strMessage As String ' Open a database from which QueryDef...
  3. I

    Change user in run time (without restarting Access)

    Hey guys! There is any possibility of changing user on the run without restart ms-access and prompt for user again? Cheers!:)
  4. I

    get report total pages before printing

    worked! thank you buddy!
  5. I

    get report total pages before printing

    hey guys! I put the following code in the report's load event and I always get 0 for: MsgBox Reports("my_report").Pages Do I need to set something to get the report total pages?
  6. I

    Interbase / Firebird -> MSACCESS (?)

    i have interbase server installed on my machine but it doesnt have a program to export the database
  7. I

    Interbase / Firebird -> MSACCESS (?)

    Hey guys! I got a Ibase/firebird database and I need to convert it to MS-ACCESS format. I searched on google, on this forum but I couldn't find a solution. I appeciate any help! Thank you!
  8. I

    Split database: Back end file path (via vba)

    Hey guys, How can I change the tables' splitted file path via vba? Ex.: c:\tables.mdb -> c:\new path\tables.mdb thank you.
  9. I

    suppress error messages (2)

    Hey guys! I set some permissions to the forms and reports. But I'd like to suppress "error" messages when the user try to access unauthorized objects. I used the forum search and i found the topic below which mention DoCmd.SetWarnings False suppress error messages But, in this case will I...
  10. I

    mess changing of object names

    thanks Freak! Rick's find & replace seems to work fine to my purpose!:cool:
  11. I

    I dont know what I want is called

    what you mean exactly? try the words RecordSource, DataSource, Save Register Be more especific. What do you want to do?
  12. I

    mess changing of object names

    Hey guys! I've a database which have some confusing names for its reports and forms. So as I found myself very confused when applying group policy to all the objects I was wondering if there is a way to rename those objects in a way that ALL the references in the hole database for the renamed...
  13. I

    Call Shell(...) - wait until app ends

    shame on me Shame on me! :o Sorry guys, I should tried a search before posting! But thank you! I'll check out the links!
  14. I

    tip: command line compressor utility (zip, rar, ...)

    Hey guys! I found a small freeware command line comporessor that you eventually may use for compact your databases or other purpose stuff. High compression rates! (zip, rar ...) enjoy! :cool: http://www.7-zip.org/ direct link
  15. I

    Call Shell(...) - wait until app ends

    Hey guys! just wondering if there is an way to command Call Shell("my_bakcup_string",1) and wait 'till the bakcup program ends to go next command in VBA thank you! :cool:
  16. I

    field appearance in report

    cool budy! worked! but it seems that I have to add the field to the form and set it visible = false otherwise the form gives an error that the field wasn't found but it worked great! chears!
  17. I

    field appearance in report

    Hey guys! I got a simple problem I can't solve. I got I field "SALES_TYPE" (field type is number) 1 <-> Light 2 <-> Master 3 <-> Special 4 <-> Premium So I want to show in report the words (light, master ...) not the numbers any idea? I'd appreciate any help!
  18. I

    like web flash interactive menu!

    Hey guys! this is a sample with labels enjoy :cool:
Back
Top Bottom