Search results

Anybody???

I have created a query that includes a module that determine what the actual order date should be. This works correctly. Now, I want to take that date in another query to only show rows where RPODate exceed the recommended date. I keep getting an error stating the query is to complex. If I run...

Thank you so much. I changed the calc field to determine when it was breaking. I couldn't figure out why the width * height was not multiplying correctly. I really appreciate your help!!!

Number Formatting Sample Here is a sample DB with the problem that I am encountering

I am trying to calculate the square footage on a form. The formula I have is (WxH)/144 For example: W = 6.375 H = 11.5 Square footage should be 0.509115 However I am getting 632.500000 The width (W) and height (H) are formatted as double. So is the square footage. Is this not correct?

Database growth Yes, each user has the interface on their hard drive and it is linked to the tables on the server. I moved the Admin interface (the one creating all the queries and doing all the updating) to a different machine. So far, the database is not growing as quickly as it was. The...

I have been reading through previous posts regarding database bloat and have not been able to find anything that might fix my problem. We have been using this database for many years. We have the same amount of people accessing the database. The problem is now we are pulling the information...

Stop Report Ok. I got my message to come up, however, it continues to pop up as the report formats. I am listing my code below. Basically, if this message pops up, I want to cancel the report. ????? Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(Me.BackPriority)...

I would like a MsgBox to pop up for the user if the Priority field is blank and the box count is not. I tried doing this on the report but the report will just not run. So I considered adding a module to the query. However, I get a Data type mismatch. Below is the module and query. Can someone...

I have a query in which I am splitting a long integer into Month, Day, Year and then putting it back together using Date Serial in another query. When I originally set this up, the date was coming through as 5 numbers. Now it is coming through as six. However, Access will error out if I try to...

The field cannot be null. It is a text value field.

I am trying to determine the state that a job is located in. If the ProjectID begins with a 2 then it is in California. If it does not then the job is located in Nevada. State: IIf(Left([tblMainFrontierUnits].[ProjectID],1)="2","CA","NV") What is wrong with this statement? I am getting a...

Query and Function Ok. I have reviewed what you posted and some other posts on this forum and realized that the best way to do this is to call a function in a query to calculate the WOSD. However, I am not having much luck with this. The WOSD is coming back as 12:00 am or 12/30/99. Can someone...

Subform looping Thanks Pat. I will search for the Recordset clone posts. I am storing the WOSD and WODD in a temp table that will be over written. I have a report that I need to be able to run that summarizes the number of units and boxes per WOSD. That let's us know how booked our...

Redesign Help Thank you Neil!! Sorry I don't think I was fully understanding what you were getting at. I did link the .csv file and that will work out fabulously. However, I still need to use the update queries. The csv file will change as units are added and removed. I will need to keep...

I have a form with an UPDATE button. There is a subfrm on this form that lists all my units. I want the update button to loop through all the records on the subfrm and update the WOSD based on the information below. Is this possible? Private Sub cmdUpdateWOSD_Click() Call UpdateWOSDChange End...

Figuring it out, need help with UPDATE Ok I have figured out my update queries. I still need help with automating the .csv upload. Someone mentioned that I need to create a file spec. I do not know how to do this. I am having a problem with my details table update query. My primary key fields...

Redesign help Hi, I am using a .csv file because the company has locked down the use of ODBC and this report has everything combined that I need. That is my only option at this time. Any help would be greatly appreciated. My problem with the WOSD and WODD is just that they are calculated...

I really need some help. I am supposed to have a rough working copy of the database ready by Friday and at this rate I am not going to have it done. I have an Access database now that we enter units in and track through our manufacturing plant to shipping. We are bringing an AS400 ERP system on...

I am creating an Access database that will be importing data from a .csv file several times a day. Every time a user tries to run a report it will run this update to ensure they have the latest information. Can I create some kind of code that states the table was updated at a certain time with...