Search results

Well it's exactly the programmatic install I'm interested in. Like I said examples for apps in VS/sqlserver abound, but for MDB/sqlserver I wasn't able to locate anything. Posting on the forum was precisely motivated by that: finding an answer which is difficult to be found elsewhere. So if...

Ok, I achieved the attachment thru studio management, no problem. My doubt is still how to deploy my FE_Access/BE_SQLServer app to someone who doesn't have sql server(express) on his/her pc. How do I sort of include a "runtime" for sql server to be installed on the target pc. Or do I always have...

Thank u for your answer Bob. Well I do have access to sql 2005 and the admin tools at the company, thing is I did the BE on msde for I was led to think that if I'd create it in sql 2005, I would not be able to distribute my app on a pc that doesn't have sql 2005 (or at least one of the other...

Hi there, I'm experementing these days with msde, since I feel it's time for me now to move to client/server developement. I upsized a test.mdb to msde (after all the recommended preps, mostly gleaned from this forum) and kept the fe in mdb format. All worked fine, but then I thought: what if I...

The code I gave u is simply for selecting image files on your computer and insert them in your form. Just place an Image frame on your form (Toolbox > image, choose whatever image, then delete the path afterwards in the properties of the frame) and name it IM1 (or whatever u like, but then u...

Just hold on a little longer, I'm working on it. Regards, Jaime

Well due the the feedback of u guys, for which I'm very thankfull, I think I will have to forget altogether about lookup fields in tables. For me the 2 most important reasons are, based on the feedback here: 1. Performance degrades, 2. If I'd decide to upsize to SQL server afterwards, it won't...

Hello there, I've lately come across some posts that condemn using lookup fields in tables. But how bad is this really? I mean it's quite a nifty feature, and it'd be really too bad if it hogs up resources, thus forcing us to leave it alone for performance considerations. I'd appreciate if...

I downloaded your DB and took a look. Well there's a lot to be done, that's for sure. You will need to do some serious research and study on the subject of normalization. There's a DB I made some time ago for a DVD sales/rental shop, which contains most of what you need. This is a rather full...

An animated gif will always loop, that's inherent to the animated gif construct, as far as I know. If u want to control frames u have to look to something like Flash Good luck Jaime

Thing is I disabled the nav buttons, so I had to put a button to do just that: go to a new record. But either way the question remains the same: does it or doesn't it bring down the whole rs from the underlying table into memory? I mean Jet has to know somehow where the last record is in order...

Sub btnActor_Click() DoCmd.OpenForm "frmActors", , ,"ActorName =" & "'" & Me.txtActors & "'" End Sub This presupposes that in frmMovie the actors appear in a textbox? Just change txtActors to whatever u named this control on your form. This code will open frmActors and show the selected...

Why seperate forms for each actor? If your DB would hold a 1000 actors you would use a 1000 forms? That defeats the whole purpose of a DB. But anyway, u can open any form/report/query u like from your current form with a button: Sub btnOpenForm_Click() DoCmd.OpenForm "Brando" End Sub A much...

Hi there, I have a form with the DataEntry property set to True. I suppose this guarantees that the (whole) rs of the underlying table is not loaded into memory. Say that, after I've filled in a new record this way and saved it, I want to go to a new record via "DoCmd.GoToRecord, , acNew"...

I'm not sure what u're really trying to do: "... Edit > Paste From >" ?? And how do u want to automate the picking of specific photos? For inserting photos in your DB you might consider using a button which opens a fileDialog. Sub btnAddPic_Click() Dim pic As String Dim result As...

I'll be d....! Thank u Keith, that was a real stupid one I did there. I guess I implicitly suppossed that switching forms would switch focus... Forgive me all ya forumers for this blunder. :o :o :o Regards, Jaime

--Access 2003 winxp Pro SP2-- Hi there, this apparently simple problem had me stay up all night without finding the solution, neither by myself nor by searching this forum or the web. Say I have 2 loaded forms: TopForm and BottomForm. BottomForm has an unbound textbox txtRefValue, in which I...

Thank u RG, I have a better idea now which direction to go. Regards, Jaime Premy

Simon, I read many other testimonials like yours. I think it's clear by now that it's a matter of good design (or good catch-up, for many, like me), to have a 100% access solution, for small/medium appliactions, which performs satisfactorily. But (sidetracking a bit here) when the need arises...

I'm happy to know that Jet does do some pre selecting, for it saves me the trouble of having to move all my backends to sql server. I now see it like this: for small to medium business applications jet will do very fine. It's only when creating big corporate/e-commerce/critical apps that it...