Search results

Another Way Hello, Another way is to create a Blank Database and name it "Your Database name FE" and import all the objects, "Forms"Queries"Reports"Macro" ect but not the tables onces you have done that create another one that and name it "Your Workorder name BE" in this one put all your...

Great logos Audrey I think you have some nice logos, I thought of doing some but your look awsome!!! DaniBoy

I'm sorry guys!!!! I know I was a little inpatient with this question, fisrt I thought I was not explaining my self well enough, then from seeing people reading and not replying I realy thought I was not explaining my problem right, so I asked with out putting all the code. After viewing that I...

Hello Pat, I think its great that you are writting a book!!! something else you could do is a reference booklet that explains all the event procedures on access. i.e. like what is "on form load", "on no data" "on dirty" ect..... and give examples. I think anyone would by that in a heartbeat...

Does the SQL on Access have a character limit? Thank you, DaniBoy

Hello, I am trying to put some iif statements on my query expression, when I did it on design view it kept cutting off the code because of the 1024 character limit, I then went to SQL View and I was to type in more code. Today I need to type more code "iff statements" that actualy looks the...

I thought so!!! Yeah, thats what I had in mind but wasnt sure.... Thanks for your help Congent1 DaniBoy

I figure it out!!! But I Have a problem!! I know this is a Access Forum, I have a problem with the DatePart("q", (Date)=1)(or 2,3,4) Well, we use fiscal year for our quaters and with this am getting regular calander year, jan-mar for quater 1 and so on. Is there a way of changing the default...

Dont know how to put it on query!! How would I put the datepart on the query? Do I still do the between date and date? Would you explain it to me!! Thanks DaniBoy

I figure it out, but now my expression is to big. This is what am trying to do, I have three fields, [newcartsizecode] , [cartsizecode] , [datedelivered] and [Expr1]. I need to pull out a value from this fields depending on the case: Cart size Codes= 0120,0135,0164,0196 Fiscal Year Quaters...

Thanks pat Pat, I figure it out, but now my expression is to big. This is what am trying to do, I have three fields, [newcartsizecode] , [cartsizecode] , [datedelivered] and [Expr1]. I need to pull out a value from this fields depending on the case: Cart size Codes= 0120,0135,0164,0196...

Hello, I want to make a iif statement where I can also check on a date value on an expression on a query, here is my code: Adjustment: IIf([newcartsizecode]>[cartsizecode] And [datedelivered] Between "10/01/01" And "12/31/02","1.00",Null) I get an error on this code, what am I doing...

Hello, I have a problem!!!!:(. I have a query for a report where I have some parameters, between[date1] and [date2], and I have another where the user needs to put in a [name]. I want to make the imput box that pops up, to have a drop down where the user selects the pre define names. How do...

Thanks Pat I am sorry about the question, I tried looking at the windows help and I searched under set day name. I had a mind block from sitting in front of the computer for about 5 hr straight working on this database!!! Once I saw your post, I felt realy stupid!!! Thanks for tracking me back...

Hello Guys, Thank you for all the help you have giving me, I now have a full time job as a database manager and I am desinging some new databases for the Alachua County Waste Collection Office in Gainesville Florida. You guys are the best help I have ever gotten for access. Not even my...

Thank you!! it works!!

Hello Guys, I have a report that is grouping by a certian field. But I need to insert a page break after each individual group. In other words I need it to run a report for each group. Example: If am grouping employees name by department "Administration" "Sales" "Accounting" the report...

hello, I need to know, where do I go to set my mail server as default. I have outlook express and another software called groupwise at work, where in windows do I select the one I want to use as default? I called my IT at work but they dont know much!! :) Thanks DaniBoy

Hello guys!!, First of all, I love this new look, its great!!!!:D I have a problem with a SQL code. I got the code from getting help here. Well here is the code. SELECT Addresses.AddressID, WorkOrders.DateSent, WorkOrders.WorkorderID, WorkOrders.NewCartSize, WorkOrders.CartSize...

Hello, Can you tell me if this code is written right? if not whats wrong with it. #1 Function Addition(ByVal MyVar as Integer) MtVar = MyVar + 1 Addition = MyVar End Function Sub command_OnClick() Dim MyVar as Integer Dim result as Integer MyVar = 99 Result = Addition(MyVar)...