Search results

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?

just looked at the Access help with GroupLevel and it mentioned other things of which GroupOn seems to be the one I'm after will let you know if I run into difficulties.

Can someone please help me with trying to understand the pros and cons of using global variables. I know they can be used anywhere within the db but I assume that they consume memory.

anybody able to help?

Hi I have a column in a table that is surpose to be a numeric value. Now in my form when a user types in an incorrect value eg. "abc" and leaves the field they get a very un-user friendly error message "The value you entered isn't valid for this field. For example, you may have entered text...

HI I have a fe/be setup is there any code/function I could use to backup the be. Each of my users have their own front-end. Would the code need to kick users out of the BE to back. I would like to save it to a specific folder and needs to be run within my DB.