As far as the string
Code:
"[Location] = 'exampleName' AND [Removed_Date] >#02/07/2013# AND [Removed_Date] <= #02/08/2013# AND [Execut
Soulspike
Last Activity: Aug 26 '15, 08:57 PM
Joined: Jan 7 '08
Location: Denver Colorado
-
I will try out using the strVar method you are showing above, it does sound cleaner. This forum is a great place for me to learn better ways to do it. My biggest problem being self taught is keeping things clean and organized in my code. So I appreciate the ideas to help me improve that.
As far as the string
... -
Thank you all for you quick response on this. Setting hidden controls worked perfectly. I will do some research into the TempVars as I am not familiar with that.Leave a comment:
-
The variables are
Public myDate As Date
Public myShop As String
They are set on load of the form through open args, I have a parse function that allows me to send multiple variables.Leave a comment:
-
Access 97 to 2010 conversion problem
I have recently converted a database built in Access 97 to Access 2010. In 2010 I am now having a problem with an control on the form. The control now states #Name? as the shown value. I have the text box Control source set as:
...Code:= DCount("[RN]","tbl_DIC","[Location] = '" & [myShop] & "' AND [Removed_Date] > #" & DateAdd("h",-24,[myDate]) & "# and [Removed_Date] -
Want to forcast number of projects completed per year
I put that into my query and it gave me the year that the mod will be completed. Hopefully I did that right=).
But how do i get to a Quantity of projects complete per year. For instance I am starting with a dataset that has a single record(Table1 Above) with a run rate(Units/Day) and a Qty to complete(Total Units). I need to take that dataset and create an output that will have all future years(table2). So I should end up with... -
Sorry when i wrote out the tables i just used example data, i didnt calculate the actual times. What i wanted to show was that i need to see the total every year to the completion of a project. So I can calculate a cost per year for each project. The data is fake, i should have calculated the real stuff or mentioned that in the question.
Days/Week im using is 7
Additional information: I am talking about locomotive...Leave a comment:
-
Want to Forcast Project Completion
Hello all,
I am not very experianced in utilizing loops and recordsets but can not think of any other way to accomplish what i need.
I have a table shown here. I want to forcast out when the projects below will be complete by year complete. So basicly I need to take the average units/day and figure out what the total per year is and create a record for each project and year till the project is closed.
... -
Access 97 Developer Kit
Is the Access 97 developer kit software available anywhere. I have spent a significant amount of time trying to find somewhere to purchase this software and have been unsuccessful. I badly need the Access 97 replication manager.
does anyone know where I can get software this old.
Thanks
Damon -
VBA, Openform error in where statement
Hello all, I am haveing a problem with the openform method.
I want to open a form with the where method but It gives me an error
Run-Time error "2501"
The Openform action was canceled
You used a method of the DoCmd object to carry out an action in Visual basic, but then clicked cancel in a dialog box
Can you please help me figure out what is wrong with my code
...Code:DoCmd.OpenForm
-
first, thank you for taking the time to respond to my question. I am still fairly new to the VB side of things and this forum has been a life saver.
I copied the code into my module and I got a compile error: Expected: list separator or ).
I tried a couple things but couldnt get it to work. Any additional help is appretiatedLeave a comment:
-
dlookup criteria problem
Hello all.
Currently I am still useing access97 (sad I know) and I can not seem to get this dlookup function in my vb code to work. I keep getting a type mismatch error when I run the code. I am sure it is my formating of the line but cant seem to get it right. I verified my fields are all the correct data type.
Dim FirstQin As Long
Dim FrmDate As Date
Dim frmShp As String
FrmDate... -
Thank you so much, it worked flawlessly. I was able to get all my tables back and restore them in to a back-up file I had. Thank you so much for the help, you are a life saver.Leave a comment:
-
Corrupted Acces Database
Hello,
I am running access 97 and my database appears to be corrupt. When I open it I get the following error: "The Database Turnover.mdb needs to be repaired or isn't a database file."
I choose to repair it and it says that it was successful. Then when it trys to open the database I get the dreaded "Micorsoft Access has encountered a problem and needs to close. Wa are sorry for the inconvenience."... -
Data Formating In Query
Hello all I have a little formating problem. I have a query with the following code for one of the fields
This code should generate a number and allow me to use greater then less then to find groups of Fiscal Weeks. The problem is that...Code:IIf(DatePart("ww",[InitShoppingWO]![WORDER_OUTSHOP_DATE],2,2)=53,"1", (DatePart("ww",[InitShoppingWO]![WORDER_OUTSHOP_DATE],2,2))) -
very cool, looks like it works, I will test it on the table tomorrow and let you know how it goes. But looks like it does exactly what I needed. I can't thank you enough.Leave a comment:
-
No worries, no Hurry, I appretate everything you have already done. Thank you very muchLeave a comment:
-
Sounds like you understand. Here is and example.
Eqmt# ShoppedDate ReleasedDate Work Codes
1) 6198 11/11/2007 9:50 PM(A) 11/12/2007 10:57 AM(B) US TF
2) 6198 11/12/2007 10:58 AM(C) 11/15/2007 3:51 PM(D) PM PI
3) 6198 11/15/2007 3:52 PM(E) 11/15/2007 4:56 PM(F) PM TF
4) 6198 11/15/2007 4:57 PM(G) 11/17/2007 3:38 AM(H) PM EC MM
You take shopping #1 [ReleasedDate] and compare to Shopping...Leave a comment:
-
That sounds like a great Idea too, checking with my company to see if that is available. I know we use it for some other tools so it probably wouldnt hard to implement. I have not done much with access and multiple users are there any major considerations when designing a DB for multiple users?
Thank you all for your expertise.Leave a comment:
-
[font=Verdana][size=2]It looks like replication is the answer. I have been useing access for a long time and never even noticed that option. But reading about it now that you mentioned it, sounds like exactly what I need. Thank you very much for your input.[/size][/font]Leave a comment:
-
Yes you are correct, so those shoppings in the end would need to be one record. Because Each unit is shopped and released within 24 hours of the other I need to combine the records into 1 useing the ShoppedDate from the first record and the releasedDate from the 4th record. Then concatinate all of the work codes. I dont know if this makes a differance but there will be some records that may not have another within 24 hours so those would just...Leave a comment:
No activity results to display
Leave a comment: