Search results

Hello folks, Many thanks for all help i have received in this wonderful forum. I have experienced a very strange situation. When I converted my database from Access 2003 to 2007, for some reason i don's see all table relationships anymore. Now I am trying to restore by manually relinking them...

Thanks Bob. Much appreciated!

Hi there, I have a quiery that runs behind a command button and exports data to Excel; however i want the format to be csv. Is it doable? Any ideas or code suggestions are appreciated. Best, Atol

Thanks Gemma for the good examples.

thanks. not sure if Alen Browne website gives me what I need, but I will continue to explore knowledge. Gemma - I guess I my case I have about 10-ish users, which means I have to ensure the DB is secured just to prevent comlications. I guess I was looking here for "yes" or "no" answer regaring...

I am trying to understand what’s next after a database is created (meaning it is functioning, but not ready for multi-user environment and not secured yet). By reading various postings and some articles, it seems these are the key steps I need to follow in order to have a database ready to go...

Hey guys, you probably understand how much help you have provided to me with your comments! Big time ! And I like to give feedback to you too….... I added some creativity. ..hoping not in a wrong direction...I used this: Me.txtMyControl.SetFocus Me!Command18.Enabled = False I basically...

I see. But is the code correct? What other event can I put it on - like on "dblClick"?...I thought afther the event was over and the entry made - end of story... No more clicks are allowed to me made by the user...perhaps I am going in a wrong direction with my design for this.

Adam, Not sure if I got this right. I added in my code this: Me!cmdButtonNameHere.Visible = False, and I got a run-time error message '2165': "You can not hide a control that has a focus"..... coding is not my strong skill, and suggestions will be very helpul and appreciated. Best, Atol

Hi, I have a pop-up form on which there is a command buton linked to an "update query". Everytime the button is clicked, it makes a record to the table. I want to prevent from someone accidentally clicking twice (or more times) and making more than one record. I was thinking of finding a way to...

RG, You made my day !!!!! Can't say "Thank you" enough!!! Works like a dream! Best, Atol

RG, I guess I am not doing something right since I can't get this working...here are my steps and let me know which step I am messing up: 1. On my main form I have the following code on DblClick: Private Sub Form_DblClick(Cancel As Integer) DoCmd.OpenForm "sfrmPaymentEntryTEST", acNormal, ...

I did take care of the projected interest, but it seems still having hard time with figuring out on how to do the connection between the query with the projected history and the history table....I am using LEFT JOIN on three criteria - paydate, clientID, and LoanID; I also have a column from the...

Hello, I realize that storing a calculated filed is against the golden rule (at least in most cases), but here is a situation I believe I will need to do that. I have a complex query that calculates and keeps history of projected interest payments; I also have a table where I keep track of...

Nice! Thanks again RG! A Big Help !

RG, I think I found one of your old posts on this topic. http://www.access-programmers.co.uk/forums/showthread.php?t=141797&highlight=record+dirty Is that OpenArgs what you are referring to? Thanks.

RuralGuy, Thanks for your reply. Can you please elaborate a bit? Not sure what exactly I need to do. Thanks again! Atol

Hi, Here is my dilemma and I have been scratching my head for quite some time. I have two forms (related to two tables in one-to-many relationship). The forms are linked as form and subform and they work just fine. However considering the fact that the subform is basically a data-entry form...

Bob, very good idea. Thanks again. Rgds. Atol

Bob, I just tried the code. It did work fine, however it seems it keeps the respective Excel file in a read-only status. When I wanted to delete that excel file, it wouldn't let me. How can I close that Excel workbook so I can delete it? And the second part of the question is regarding this part...