Search results

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...

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...

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.

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...

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...

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 ?

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

As the topic says.. I dont have configured those fields on the table to be required because other options in database will have conflicts. But I would like to make a VBA to check if one of those 5 fields, or the 5, or 4 fields are Null when user clicks on "button1" and then display a MSGBOX...

Greetings.. I would like to know if there is a VBA to apply a value on all the fields that are filtered in a subform.. For a better understanding I took a screenshot and made a detailed explanation on it. Thanks.

As the the topic says.. When Click on checkBOX for true then DISPLAY an input for adding value to a text field on the same table. What would be the code for adding what you type in that inputbox add it on the field? Thanks

Well I got this code on a subform in a checkbox. Private Sub SalidaAlmacen_Click() Me!SalidaNum = Forms!MYFORM!("[Shipment]").Value Me!chkBOX2 = False Me.Requery Forms!MYFORM!MYSUBFORM2.Requery End Sub What it does is when I click it, It will automatically get a field value...

Whats the command to clear current field when adding AfterUpdate() and BeforeUpdate() ? Im using something like this but not working. Private Sub Data1_AfterUpdate() If Data1 = LCase(Data1) Then MsgBox "You have to use CAPS" Me.Field = Null Me.SetFocus Else Resume End If...

Greetings, I need to know which is the code for launching buttons without pressing them. Ive tried button_Click.Execute , button.Execute, Me.button_click = true etc. Which is the correct way for this? thanks

Greetings.. What I want to do is making operations with data inside the BASE table, Im gonna split weights. For example. If I got 1000 lbs of chocolate from the same lot, and I want to split it for sending 400 lbs to a client?, Is there a Way of duplicating the the entire field just making the...

Hello there, I used to have this code for generate fields from Data1 to Data2, like A001 to A005, it would generate A001, A002, A003, A004, A005. So it works with this code. Set db = CurrentDb Set rs = db.OpenRecordset("Almacenes") For x = Val(Right(Me!Data1, 3)) To Val(Right(Me!Data2, 3))...

Hello there, is this possible? I got this query subform with the same fields that appear on the main form, what I want to to is when chosing the row of data in subform, make it display on the main form. Thanks

I got this code that generates data from a rank you asign on "Data 1" and "Data 2" fields, it works great except I dont how how to display an error message if you dont put the same letter on Data 2 that Data 1 and viceversa.. and if you use Minus. -------------------------------- Private Sub...

Hello.. I got a form with a click button, when I click it I want it to generate a number like "AAA0900001" the 09 number means the current year, and the 00001 number is the counter +1 When it generates, place it on a field on the new form. Thanks in advance.

Hello, I got this code for setting data into my filtered subform. --- Private Sub Command18_Click() Forms!SALIDAS!SALIDASpickingsubform.Form.SalidaAlmacen.Value = False Forms!SALIDAS!SALIDASpickingsubform.Form.EnAlmacen.Value = True...

Hello, I would like to create a field that autoincrements everytime the form is opened. It must be based with 3 letters KTN- 2 digits from month,- last 2 from year and then 5 fields for counter 00001, 00002 like -- KTN-0609-00001 KTN-0609-00002 KTN-0609-00003 KTN-0609-00004 KTN-0609-00005 So...