Search results

No need for help,i figured it out Thanks :)

I have a custom menu bar that has a couple of menu lists, with a list of five custom commands that i want to run,depending on what is selected.I know you can assign a macro to each command,but is there a way to know which command has been selected. What i want to do is to have 1 macro that will...

After searching the web i found this Dim db As DAO.Database Set db = DBEngine.Workspaces(0).OpenDatabase("DbNameHere", , False) db.TableDefs.Delete "TableNameHere" db.TableDefs.Refresh db.Close Set db = Nothing It seems to do the job

Is it possible to delete a table from a remote access db. i.e table "A" is in database "A" from a form in database "B" i would like to run a routine that would Delete table "A" from database "A" i have tried using "DoCmd.DeleteObject acTable" but i think this only works for the...

It is possible-problem solved i just needed to convert sizes to pixels Regards Bjackson

Is it possible to retrieve the x an y co ordinates of a text box in relation to the client screen. I am trying to align a pop up form so that it doesnt obscure data. i have a main form with 8 subforms.The text box that i want to align with is in each subform,and i use a mouse move event on the...

Are You talking about excel(Cells ?) or access In access you can only use conditional formatting based on the values of that field.You cant refer to data that resides in other fields for that record. if you want to use several criteria on a report then use the on print event for the section...

RayH Worked like a charm,and was set out so even a dummy like me could follow it.The book i was working from layed out the formula ,but then at the crucial point assumed the reader knew what inverse cosine was.Why do they do these things? Thank you for your help Wayne Maybe...

Here is an interesting extract from an article that i have read (late Nov 2004) MICROSOFT INVESTING HEAVILY IN ACCESS Last week at the Access Advisor conference in Las Vegas, Microsoft announced their plans for enhancing Access over the next several versions. In his keynote, Richard McAniff...

Thanks Ray and Wayne I will test both and get back to you.It's creeping up to new year here so it will have to wait until A.Tomorrow or B.When i sober up, whichever sober comes first The trouble with kids is they give up to easily,or sometimes they think its not cool to ask for...

Thanks Jacob I am not sure whether that helps,as i said my skills in maths are ordinary to say the least.I cant convert the angle to radians because i dont know the angle,thats the part i am trying to work out.I cant grasp how to apply the inverse part of the equation (I dont know...

Thanks Wayne So the power formula is right,but you cant use Power() in access,just excel Any ideas on how i can get around using the cos function in access with out getting the compile error "Function call on left hand side of assignment must return variant or object". Are there any...

Thanks for the reply Pat i get a syntax error using ** I had a look at excel and it has a Power() function,and it also shows that you can use 5^2, which when used in access does give the answer of 25. However when a minus value its gives the wrong value ( well not the answer...

I am trying to work out an angle in a triangle(non Right angle).Does anybody know how you multiply a number by Cos to the power of -1.Does access have any functions for mutliplying numbers to the power of x thanks in advance Bjackson

check out this http://www.mztools.com/ Its an amazing add in for free Regards Bjackson

Well after a lot of wasted hrs it turns out the guy on the other end of the phone was stretching the truth a bit.His computer he assured me was up to date with all service packs and it must be my db that is corrupt.So i explained what i wanted him to try-namely importing all objects into a new...

I have been mucking around with column widths in several datasheet forms trying to set column widths to certain sizes with mixed success.I have had the best results by using the subforms on click event and on dlbclick event but it doesnt always fire either.It seems to me access must store column...

the procedure sets the column widths of the subform and hides or shows fields depending on what the search criteria is.It is fired when the main form has opened. I dont understand why it works on 1 pc and not all pc's.The syntax for the subform is obviously correct or it would error on all...

I am running a public sub procedure(named SetSearchColumnDetails) that resides in a subform (control name of SearchResults) on a mainform named Searchform.This procedure on my machine runs quite ok,but on another pc access give me an error complaining that the object either is not open or does...

your welcome, glad to put back some of the help i have received from these forums. Bjackson