Search results

The normal way to reference a form is Forms![name of the form]!Control.value Is there a way to use a variable for the form name? i have a sub that is utilized by two forms and the same fields is copy to different form depending on what they select on the popup window. Privare Sub(FormName as...

The first thing i tried was compact and repaired but nothing i never got any error about corrupt data or anything and second for some reason the same code works on a different form that why i am clueless. I use the same code and pointed to a different form and it worked when i changed it back...

everything was working fine until a few minutes ago. I have not change any code but my forms show up with no data as if it was a new record. I have list form where a user can select a record to get a detail information about the record. Its working fine on my backup but i havent change any code...

I have a form that has some required field. i also has a button that save the changes once all the required field has been filled in. I want to make the save button only visible when all the required field been filled in. My question is what event should i use to make it visible. i have a...

does undo counts as a deletation I dont know if this is a silly question but does undo counts as a deletation. if that the case then i just use cascading delete if that how it works.

I know is there is way to get rid of the last record in query or list when i use a query its shows an empty records aswell which is confusing for user. its okey if the list contain many records but when it only contain a few record it can look confusing

I have a mainform and a subform. they are linked by an autonumber that are generated from the mainform. I have setup one to many relationship. one on the main form and many on the subform. I used the Autonumber generated from the main form. i utilized the Openform, acformadd to create a new...

When i create a table from scratch there is always a record and also when i run a query on the table there is always an empty record at the last line. Is there anyway to i cant get rid of it or hide it. it can be confusing and the user might add line that not suppose to be there. thanks in advance

What is the best performance for storing information in a table number or text. On my forms i have alot of combo boxes so i wonder which way will give more performance. The data in the table will be use to graph aswell. Pros 1.number is easier to sort, count pretty much any arithmatic...

I have an input form that has many (one-to-one) fields in it, i also have one field that is a one-to-many relationship in there. I dont know how to break it out of the form. a subform would solve the problem but a subform for one record worth the efftort and how would it actually look like. I...

Need direction I have a forms that list all the records in a table. when i click on an item on the list it gives me a detail section of that records. i have two buttons on the side that is details and create new record. Details does the same thing as double clicking. When user clicks on the...

I am creating a dummy forms that is tied to table but i dont have any field bound to the table yet. This forms act as a tempory table if dont like the changes nothing get save to the table. I am really interested in the code that when a user clicks the new record on the build in recordbar on...

I have a solution to that but i dont really want to try it I can always create a dummy table that the dummy forms is tied to in that way it will be bounded to that table. once the the user decide to save or not save i just run a delete query for that dummy table. I really dont wanna delete and...

Right now it only use with this form I have a dummy forms that user fill in the information nothing get save until the save button is click. I will only having one form so i wont need to be share with any other forms. i have declare a Private flag as boolen on top decration of the form section.

here is the code i wrote Private Sub Form_AfterUpdate() Flag = True End Sub Private Sub Form_BeforeUpdate(Cancel As Integer) Flag = True End Sub Private Sub Form_Dirty(Cancel As Integer) Flag = True End Sub Private Sub Form_Unload(Cancel As Integer) Dim answer As Integer If Flag = True Then...

Can you give me small exemple I think my problems lies in that the forms is not tied to anything so i dont know if that makes any sense. I have a save form. Nothing get save until they hit the save button. Since the form is not tied to any records the before and after update is not working...

I need to create a code that will pop a message box asking if the user want to save the change or not after they have edited the form when they are leaving the forms either by X in top corner or by going to a different forms. I try to use the after update and before update but no luck here. I...

i think the solution that you gave me will be building blocks for the next step I gonna use your code to get the records that has changed or new records into the table. From there i am going to use recordset to compare each line. it wont be alot of comparisong since i know which records has...

I need to create an autonumber that is customized, it starts either with a q or p then it follow two digit which is the current year then it follows a 3 digit sequence number so it looks like something like this. q06001 or p06001 The catch with this is when the year changes the three last digit...

the Next Step is to identify and point out the changes Okey the next step. showing the user what changes by color coding or some other way to make it clear to user which fields was changed. From top of my mind the only thing that comes to mind is using vba to identify which value was changed. i...