Search results

  1. R

    Strange problem going on on the backend database.

    just sent you the private message georgedwilkinson.. Thanks in advance..
  2. R

    Strange problem going on on the backend database.

    Would you like me to upload the whole database? Dont know what is failing on the backend database, it seems to be the data because it starts deconffiguring the frontend database, now it doenst wok on some querys and displaying subforms, what could be happening? Let me upload in a FTP the 2 files...
  3. R

    Strange problem going on on the backend database.

    Hello.. I got a frontend and backend database, on the backend obviously i got all the data shared in a server.. Well the problemhre is that after been using the database for 1 week now it displays an error on a statistics that i put starting the program.. it says "Mismatch of data in the...
  4. R

    Whats wrong with Date() ?

    No I dont.. I have a field named EntryDate and DateFinal But non called Date. What else it could be ?
  5. R

    Whats wrong with Date() ?

    Hello, I jsut finished a database for a project, it works at its best on my pc, but when I installed it on other pcs, the date on the reports using the command Date() which means today right now they wont show, they display a #NUMBER on the reports. How can I fix that, cause it works alright...
  6. R

    If Query subform contains data, Display a MsgBOX?

    As the topic says, how can I make a button to explore a query based on subform so if the query contains filtered data then do not let advance.. but if it is empty then let close the window. Thanks in advance.
  7. R

    VBA for applying Value on only the filtered data in subform?

    Guus2005.. I just uploaded a sample database, could you help me out of this? Thanks alot in advance.
  8. R

    VBA for applying Value on only the filtered data in subform?

    Up!.. Anyone can help please?
  9. R

    VBA for applying Value on only the filtered data in subform?

    Here I post the access database.. The second window when you do the product pickign and save it, it has a cancel button that will unmark all the products in the list and return them to warehouse. Hope it can be done. Thanks
  10. R

    Whats wrong with this code?

    Hello.. Well I got a product picking with a checkbox.. when I click it.. if another checkbox from the record is marked as "blocked" then it would ask if you really want to pick that product.. If dont it will Undo. But if yes it will mark a field with a textbox content and checkbox another field...
  11. R

    Counting first 3 numbers of a field "###A#####"

    Excuse me, where I use that code? Its SQL, so how can I introduce it on a Query, or on a Listbox? In the data properties of the listbox? if the table name is "BASE" and the fieldname is "Lote" How it would be? thanks
  12. R

    Counting first 3 numbers of a field "###A#####"

    Sorry I did not explian myself very good.. I got a field called "lots" It stores this data: 005A010038 005A050247 001A010011 077A010012 255A080029 076A080165 234A040003 001A010018 005A050252 047A010006 004A070368 252A010001...
  13. R

    Counting first 3 numbers of a field "###A#####"

    Hello there.. I have a field with lots of data with the format: 001A020001 001A020002 -001A150345 002B010001 - 002B230225 etc.. So I want to count just the first 3 numbers and see the total of 001 = 345 002 = 225 So in one field display the variable im counting and in another field the...
  14. R

    Encoding Big Access 2007 database?

    Yes it is a split application.. I got a backend on a server and the frontend in my computer. Will appreciate very much the best ways to protect my programming from being decoded.
  15. R

    Encoding Big Access 2007 database?

    Hello there, Im trying to encode my database so the VBA I used cannot be watched in the future.. But it gets me an error saying I cant encode it.. I click in more help and displays this: What can I do for protecting it ?
  16. R

    Custom serial numbers(licences) for access developer install?

    Thats what I tried to say.. my mistake. What choices I got for protecting the database I created?.. Its the fruit of 2 months of work so I dont want that the Corp. where Im installing it be able to install it in all the computers they want.. so I want to limit it with licenses or something.. any...
  17. R

    Custom serial numbers(licences) for access developer install?

    Intellectual property of the database design and programming.. It can apply?
  18. R

    Custom serial numbers(licences) for access developer install?

    Hello, just wanted to know if there is a way for asking for serial numbers before installing an Access 2007 developer with runtime?
  19. R

    VBA for applying Value on only the filtered data in subform?

    Guus2005 .. Im really breaking my head doing all kind of crazy codes for making it work.. could you do an example file.. I could pay you via paypal.. please send me a private message with your contact to talk more deeply about this.. im willing to pay for this.. Sincerely.. rodvaN
  20. R

    VBA for applying Value on only the filtered data in subform?

    Guus.. The code I got is.. Private Sub Comando40_Click() Dim strSql As String strSql = "update BASE set SalidaAlmacen=False " & _ " where Shipment=" & Forms!salidas!Shipment & "" CurrentDb.Execute strSql End Sub Its throwing me this error.. Its been an error '3061' in...
Back
Top Bottom