Search results

Hi, I´m having trouble with an automated process. First, access exports a table to a text file. Second, excel opens the file and runs a macro on a workbook that contains linked data to the file. The workbook is linked back in access. A few days ago I started having problems. Sometimes the...

Hi, I´m trying to pass a variable (integer) from access to excel. I´ve tried both public and global in the declaration sector of a module, but it´s empty. I´ve tried searching the forum but I couldn´t find it. I suspect it is a fairly common question. Fuga.

I´m trying to create a report. I have a few questions: 1. I´ve understood from this forum that there is no automatic table of contents function like in word. Is this right? 2. You cannot export your report to word if it contains charts? So you have to create your own table of contents? This...

Hi, Is there a way to have the same printing options for a chart in access as in excel. I need to be able to print in high resolution. Fuga.

Hi, I use a few combo boxes on a form, and I would like to make them look better. Is there a way to change the way they look, apart from the obvious stuff? Are there som themes I can download? Fuga.

I got some help here a while ago: http://www.access-programmers.co.uk/forums/showthread.php?t=92015&highlight=redemption Fuga.

Or...I´ll turn myself into a professional web programmer:) But seriously, The tables will be of just three or four kinds, and I don´t think the users need to decide the number of columns. I think I´d know how to do it in VB or VBA. Fuga.

Thank you for all your help. First, I need some sort of login function on the site. The database functions will be: Creating tables with specific datatypes (without the user knowing it of course. The user will only think of it as adding a selection criteria for instance). The PK and relations...

Well, if all goes well, I think there might be 100 - 500 total users. Wasn´t there a program called frontpage? Fuga.

So there isn´t a MsOffice-like program with OLE and Vba possibilities etc? I don´t think there will be many simultaneous users. VPN might be an option. Would I use it like a frontend locally at the users end? And what about creating an activeX in VB and put that on the web? Fuga.

I think I want to have the functions on the extranet. The thing is I´m an absolute beginner when it comes to web-designing. My db contains quite a lot of Vba stuff, and quite a lot of calculations. Fuga.

Hi, Is there a good developer tool for turning an access db into a webpage? Or should I go about it in a completely different way? I want it to work just as it does, but I would like to have it on the www. Fuga.

well I´ll be ******. It turns out I really had a cirkular reference in the workbook. It is now working like it should. Thanks everyone for your help. Fuga.

Glad to help. For more info on the subject, do a search for "normalization". Fuga

If you re-use the name then you will have redundant data in your table, but that might not be a problem. But if, in addition to name, you also have information about the applicants adress etc, you will have trouble if the person moves. Provided He/she belongs to many groups. As you may have...

Thanks Rak! Very interesting. Fuga.

Neileg- I finally understood what you meant. I will try it. The thing is I might want to use this on more irregular curves as well, but maybe it works. I´ll let you know. Fuga.

Thank you for your answers. shades - this is the start of the thread. http://www.access-programmers.co.uk/forums/showthread.php?t=112321 neileg - The reason I´ve done it this way is that I want to determine the number of observations between an intersection and the cosinus function max/min...

Well, as a rule, you need as many end ifs as you have ifs. But then there are the elses etc. It´s a bit hard to know what youre trying to do, but think of it like tests: if(something) then Do whatever End if this was the simple case, now if you nest it: if(something) then if(something else)...

I´m not sure I understand, but if you do it this way, won´t there be a problem when one applicant belongs to several groups? Fuga.