Search results

Hello, I would like to know what kind of Data Type I have to declare in order to share the value in a variable between process. As example the code below: Public Sub Form_Open(Cancel As Integer) Dim data As Integer DoCmd.openform "base" data =...

No, it is not. The Form called "base" is not opened in the moment I want to take the information from it, but it is included in the same file. I tested with the Form "base" opened and this code, mentioned above, works. I got the data that I need from that form. However, Is it possible to do...

Hello everyone... I need to get a info. from the other FORM and insert in a loaded form. So, I wrote: Private Sub Command2_Click() Dim Variable As Integer Variable = Forms!base!baseDetails.Form!Superior also I tried: Variable = Forms![base].Form![superior] where: base is the other form...

Could anybody else help me ? Thanks in advance.

Ozinm, Fisrt of all, thank you. I'm new in programming. So, I include the filed Data/Time, called GetData, in the Table. I didn't understand the variable "LastOpened < GetDate()" . 1 - How can I store the date in that new field after I opened the record ? 2 - Which kind of variable is...

Hello, I need your help or orientation to figure out how to control a randomily code to open a form/table record. I have a table/form and I open the record randomily through this code: record = DCount("[ID]", "FORM") myvalue = (Int(record * Rnd) + 1) DoCmd.OpenForm "FORM", , , "ID =" &...

Nice ! Congrats for this forum. Here you can learn a lot. There are a lot of Access experts... I started here an idea that could help me, and here I could learnt how to do what I suggested...that's awesome.. This is the result....even being an amateour database. If somebody would like to...

Help ... Hello, I'm writing a simpel code to execute ± what I want..that's simple and amateur..but it starts working.. I wrote the code below (that I learnt in this forum) and I need an Interruption in the program. For example, until a button action (e.g. minimize the form). That it means...

Piece of cake for you !!! Flash card (record) - Poup up & autoexec Hello every one, I'll really appreciate any help. I'm beginner in code issues, so that any directions will help me. I've already read a lot of threat posted here, but I'm not able to define what I need yet. What I wanna to do...

Thank you AN60. Now I have a direction that I needed. I found a good tread that can help someone who wants learn how to re-design the button command. http://www.access-programmers.co.uk/forums/showthread.php?t=52580&highlight=Mousemove+event...

Help How can I make the button effect on a label ? I've already had a code linked with a label, and when I click on the label I want to see the label going down and up like as a button. Is it possible to do that?

Thanks for your attention. Ok I've tried to do that through a label, and I already have my function code up & running such as: to open anothers forms,etc. But How can I create the button effect? In other words, how can I produce the depressed effect when I click on the button (now label) ...

I really searched, but I can't find. I supose that you refer to access 2000 when you say A2K. So this is that I'm using... I've tried seek in access help, book,etc but I'm unable to re-design the button command. For eg. to change the back color, etc. Do Anybody here have patient enough to help...

Hello all, How can I re-design my form command button? I mean, how can I change the back color from the standard access command button ? Or how I can let it transparent. Is it possible to create a round button instead of a square one ? I'm always using the tool box and so, the...

I have one report based on my table and form (off course). My problem is: when I add a new record in the database (via table or form), this new record does not show up in my report .... your "space" show up blank What I need to do to refresh these records ? Or what's the problem Thanks in...