Search results

Thank you it compiled in my switchboard form. Thanks for the info as well. One more issue. When I exit my switchboard I now get this error in a popup window: 424 - Object Required Any ideas? Here is the code I have exactly: Private Sub Form_Close() '--- Public Function CompactOnClose() On...

Still no go. It now says Exit function allowed in sub or property and highlights the spot in below: Exit_CompactOnClose: Exit Function Private Sub Form_Close() '--- Public Function CompactOnClose() On Error GoTo Err_CompactOnClose If FileLen(CurrentDb.Name) > 5000000 Then '5...

Theres a program that automates windows task which I used to make the following: Found Here: Autoit Downloads Then make a txt file and name it with a .au3 extension. Put this code into the txt file and adjust what you would like then open the file with the program: DirCreate (...

:o Thanks. Still does it. I put a database name it and gives me the ; Error: Expected End Sub Oh boy my name is 2 words with a space...is that a no no for database names because it doesnt like the space. Giving me a error. Expected list separator or )

Im rather new so my experience wouldnt really help you...but this is your first post unless you just copied and pasted this from other forums...ah ha. Well your welcome!:p

Thanks that seems more my level...however yet need help. I put that code into my ON CLOSE on my switchboard and get this which obvioulsly doesnt work...but what would i have to do to fix this? I have tried a few things without sucesss. Thanks. Error: Expected End Sub Private Sub...

Thanks bob. Do you happen to have a table example and the code to check? So my module would just be this: Public Function getFileSize(sFilePath As String, Optional sSize As String) As Long On Error GoTo ErrHandler Dim nByteSize As Currency Dim nFileSize As Currency Const...

I found a much easier method. I created a exe file that takes the frontend off the shared drive and puts it on each users computer and takes the shortcut and puts it in the start menu and in the IE favorites of each user. All you do is send them the application file and once they click they...

Thanks for the help. Ok I am rather new so bare with me. So where do I put the: SendKeys("%T D C") Does it matter what I name the module? Does this automatically compact based on size? Thanks.

Hello, I found this here: Public sub subCompact() On Error goto Err_subCompact Dim fs, f, ProjectSize, filespec Dim strProjectPath As String, strProjectName As String strProjectPath = Application.CurrentProject.Path strProjectName = Application.CurrentProject.Name filespec = strProjectPath...

Yea thanks for the information. This is my first real database and not sure if things are setup the way should be...appreciate it. Thanks.

Hello, Looking for information on what reports should be based on tables or queries and the advantages or problems of doing the other. I have some based on tables and Brian said that he beleives that supposed to be based on queries not tables. Should it be queries, tables, both or doesnt...

Thanks Brian I may start a post about that if I cant find anything through searches...

Yea it is from tables...is that bad? This is my first database and really shootin from the hip. Yea see my table has a column named Amount. So on my report I have different text boxes that count the number of amounts, the total, and the average for the column. Now I trying to find the...

What kind you looking for, a general type? I have one I use on my site which is a mouse over type. Its in the far left column of the homepage http://www.first-ward.com. If you want something like that I could give you the css for it...when I am not at work. Let me know.

So i would have to make a query right? Ok now how would I start...I just tried and kinda lost with query's. Ok so I query the Amount in a new query...but how do I get the average of that column in a query and a count as well? Maybe I am completely off here but not sure. This is where I do it...

Hey thanks for the reply Brian... Tried your idea and it now wants the parameter value of text50 and text29. =sum(iif([Amount]>([text50]/[text29]),1,0)) Tried as well: =count(iif([Amount]>([text50]/[text29]),1,0)) Maybe I cant use Count or Sum when dealing with text boxes? Is it for tables...

Hmm something tells me I shouldnt be using Count, but not sure what else to try. I need to count the number of times in my table column Amount is greater than the average that is calculated on the report. The way I have tried, mentioned above, wants the parameter value for Text663, but why...

Hello, Having some confusion for a calculation on one of my reports. I am trying to count the number of times in my table column "AMOUNT" that is greater than the average. I have the average figured out on my Report as follows: [Text663]=[text50]/[text29] Then I have this to find how many...

Where's the Beef? The old lady from Wendy's...