Recent content by WilRel

Hi MLinq I'm using the code as follows: DoCmd.OpenForm "MyForm", acNormal, , , acFormAdd, acDialog I found this example somehow, but I'm not sure what it all means...

What I did was to create the form, but everytime I call it via code, it only displays one empty line, but when I call it manualy, it shows all the records. I presume its syntax again, but at this moment, my day-job keeps me a bit busy. thanx again regards WR

Hi Plog Thanks for your reply. I did try out a few things and found out a bit more about the structure and syntax. I do appreciate. What I struggling now is how to show this new table in a form, displaying in continious form view.

Hi again I would like to create a New Table [NTable] based on a Existing Table [ETable]. I can do so with a MAKE_Table Query but I would like to do so in CODE - to minimize the amount of Queries and to understand the use of code and the commands/methods involved. I did try to look in the help...

Hi everyone. I would like to thank you all for making this forum worthwhile and whishes all of you the best for 2012. Keepon Codeing:D Regards

Hi again As I am new with Access, I want some help on this basic question which have me pinned in front of this screen for the past two hours.:mad: I'm not sure how to go about and all of my syntax doesn't seem to help Here's the scenario: I have a Form displaying in the Page Header, the...

Hi again. I've made a mistake again... The laptop runs on Windows 7 and there are a lot of settings to look through cause I don't know what to search for. :confused: please help. WR

Hi Linq, Thanks again, but I'm used to Win XP and working currently from a laptop with Windows VISTA. I already forgot the place where I changed some of those settings, and to tell you the truth, I've been trying to search for it in the windows help file, but have give up. Can you help me...

Hi again I'm using Access 2003 and want to use a tab control on my Form. I've been looking around and can't seem to find a place/way to set the background color of the whole tab control. It looks flat and stay WHITE! There must be a way!:( I would appreciate the help again.. Thanks

THANKS!:D I went back to Access and thought of what you posted and yes, the light came on. Everyday a little brigther!! DisplayStartDate.Caption = Format(StartDate, "Long Date") or DisplayStartDate.Caption = Format(StartDate, "dd-mmm-yy") Regards! WR

Thanks, but I'm using Access 2003 and as I am using a label, and want to use a label, to show the variable, I cannot find the FORMAT property on the PROPERTY sheet. As I am a new user, I would appreciate if you could show me it in the right syntax, because I've been looking through the Help...

How can I change the format of the value displayed in a label? I have a Variable named StartDate, a Label named DisplayStartDate After the Form has opened, in the event ON OPEN I use the following: DisplayStartDate.Caption = StartDate The problem though is that it displays the format set...

:) Thanx again RainLover and MissingLinq. You sure did show me enough syntax and directions to get a good start and if it wasn't for me going on a 700km trip tomorrow, I'd be most probably still busy coding. Any way. Hope your Christmas was blessed and the very best for the new year. Regards...

Hi Linq I do appreciate your help. Slowly I'm getting there, but there seems to be one more hurdle for me to understand the new syntax. Consider the following: I have a Form that that lists all the employees currently active. To show the user the Active Date, because its not always the current...

Ok, so to display the value of the Global Var, you need to assign it manually to a text box. I can think of a few ways, but has obviously not done it yet. 1. I can thus only use a Unbound Text field, or can you use a label instead? 2. Assigning the value could maybe be done by using CODE to...