Search results

Anyone have any ideas.

Private Sub ToggleLink_Click() On Error GoTo ToggleLink_Click_Err If ChildFormIsOpen() Then CloseChildForm Else OpenChildForm FilterChildForm End If ToggleLink_Click_Exit: Exit Sub ToggleLink_Click_Err: MsgBox Error$ Resume ToggleLink_Click_Exit End Sub Private Function ChildFormIsOpen()...

the main form FLAM is Single.

The 2nd form and the 3rd for is both continuous.

Hi, I have a subform(OtherFac - 2nd Table) inside a form (FLAM - 1st Table) but now i want to make another subform from another [Oblig - 3rd table]. But when i try to create a relationship between the 2nd and the 3rd table its gives me an indeterminate relationhip not a one to many which is...

SELECT QueryForExsGettingMonths.Customerid, Count(QueryForExsGettingMonths.MnthYrs) AS CountOfMnthYrs FROM QueryForExsGettingMonths WHERE (((Left([QueryForExsGettingMonths].[Code],7))=[QueryForExsGettingMonths].[MnthYrs]) AND...

i have a deadline

its seems simple but the aggreagete query error is maddening. if i just cousd see the result...someone help pls.

Hi Guys, This is the query what im trying to do is get all the customers which have exceeded their acccount limit at least twice in a month with a table that only displays the customerid and the date of the excess. Now Here is what i have done so far. I made 2 queries The First Query...

is there any way to keep these kind of messages from ever displaying like a before Autoexec Macro run code.

They managed to fix it themselves.

Well he is just the user . I don't really know who set it up on his PC.. but i figured this was something someone good at macros would be able to figure, out why im getting this error. Anyways, i used to get this error when i send this same system home to use it on my MS access 2007 (One i...

Hi Guys, we have a system to enter data and print data. now to secure the database, I have created an autoexec macro that runs at startup and check if the user is me. If its is, it will enable the bypass key so that the user (myself) can view the design view of the code else it will disable it...

True. This solution will be helpful in analysing data as well. thanks. Also if you know any books that teach on such complex queries and methods just lemme know. thanks. Im sure i need a lot more in the coming months. Thanks 4 the help bro.

Dude that was awesome. I'll probable need to use this same thing for some other work also. Thanks a bunch..I guess all ineed is to just find the difference at this point 4 the 2 dates and use a criteria to filter out everthing except for the Increases. Awesome Bro. Thanks. God Bless

i understand what you are saying buddy but i want to get the increases for a particular day so i can display all the increases only. If there were 100 or thousand different names how can the user go through each to find the increases a of a particular day. You kno what im saying. Im trying...

Okay, See I have written a query but it only works for one instance or a particular name that i have to query for like seen below (I have to Query exactly Jacobs name to Get all the ammount for jacob that has increased.) But i want to go one step further, and query all the names for a...

Okay. HMMMMMM....

Hi Everyone, This is my table and Im tring to write a query that will give me all the Names as of a particular date Ex:22-02-2010. and with it give me the increase in the ammount of that particular as of the previous day. i going nuts using the query builder. please helppp!!!! Really need...

i know the thread is closed, but could any of you give me a sample query i new to this.