Recent content by Funkyaccess

is it saved as a 2007 xls format?

Might be a bit late. but look at ORACLE Application Express(APEX) its free opensource front-end for ORACLE DB and you can migrate access db to it with a click of a button. If you want more info then PM me or visit (http://apex.oracle.com)

has it worked?

Many thanks both I've now got it working using your examples. ANy ideas how I could find the same for a quarter? ANd nother question is there a way to start the weeknumbers based on Financial year rather than Annual year and the same with quarter

I have a report which formats a value for me but its not doing quiet what I need it to. This is its control source: =format$([tblColumn],'ww',0,0) Which return for eg. 41 I need to return the Mondays and Fridays date of week 41. Is there another way I can change the weeks to work...

first off typo "wtaph" shoudl be wpath and you could try another way to get the path and try this DoCmd.TransferText acExportDelim, "", "taulukko kysely", "acFormatTXT", wpath, False, ""

Sorry my fault as well its not controlsource but DefaultValue. Now login to the attached DB. click on "Transaction" and the ServerID should be set. What I did to get this to work? first I change the global variable to gblServerID Then with the login form's code I did the following...

I think I've spotted the error. Its to do with name conventions. it difficult to see what ServerID is if ServerID is a global variable/table column and textfield. So if we name the variable to gblServerID then where ever you see that name you will know its refering to the global variable...

whats it test's passcode?

Tom is this a cut down version? I cant see where you setting ServerID. Where does your user login?

tom, with your form go into design view. open the properties windows (alt+enter) then got to form and then the event tab and find on load event and then click the "..." at the end of the field. then select code builder and then paste my example in and change txtbox to be the textbox name that...

Correction: Environ("username")

tom as part of your forms on load event you can say something like Me.txtBox.controlsource= ServerID

I thought that was a answer as well because I have a form that uses the logo but on my report whe n I type Me.imgLogo. it gives me other options and Picture is not one of them. I only found the Picture attribute when I used .Report

HI I have this bit of code Private Sub Report_Open(Cancel As Integer) Me.imgLogo.Report.Picture = gblIMAGEPath & "logo3.gif" I get run-time 2455 you enters an expression that has an invalid reference to the property Form/report. Any ideas?