DeveloperBarn Forums

Count problem

todd2006 — Sat, 13 Mar 2010 19:04:31 GMT

Hi,

I have 2 tables

codes
StudentMembers

In codes the table design is like this

Code:

Id

PromoCode

Price

In StudentMembers the table design is like this

Code:

Id

Name

Code

Price

DateSigned

What I want to do is display ow many students used what code so my query is like this

Code:



Select Count(Code), PromoCode from Codes, StudentMembers where Codes.PromoCode=StudentMembers.Code

the query is not working

any idea

todd

Calling void isn't creating instance of an object

richyrich — Fri, 12 Mar 2010 12:33:30 GMT

I can't seem to work out why an instance of an object isn't getting created when I create it in a sub routine.

In Page_Load if i have this:-

Code:

private Order order;

protected void Page_Load()

{

   if(!ispostback)

   {

      buildOrderItemList(ActionChoice.Build);

      order = new Order();

      order.orderItems = new List();

      order.id=-1;

      this.dlstOrderItems.DataSource=Order.orderItems;

      this.dlstOrderItems.DataBind();

   }

}



protected void buildOrderItemList(Action)

{

   Order order = new Order();

   order.orderItems = new List();

.

.

.

}

Without the lines in red, I get "instance of an object" error. If I create the instance in the page load I don't get the error.

I use a similar technique with another Data List and it works fine.

Can't work out why the instance isn't working in the void.

Any ideas?

Storing Stock Levels / Calculated Fields

richyrich — Thu, 11 Mar 2010 10:42:07 GMT

I'm working on a project at the moment that will require storing of stock levels for individual products. The slight complication is that the products are chemicals and are stored in bulk and pre-weighed amounts (no, they're not illegal drugs!)

If I used table salt as an example, that might help to demonstrate. Each time you produce a batch of salt you get a yield (say the first batch produces 100g). You might sell the salt in amounts of 1g and 5g.

From the first batch, you pre-weigh 10 lots of 1g and 2 lots of 5g. So, the pre-weighed stock is 10 lots of 1g and 2 lots of 5g and your bulk stock is now 80g. As you sell the pre-weighed, you make up more and more pre-weighed packs until your bulk is down to 20g. So you make some more and this batch yields 110g. So your bulk is now 130g. You carry on transferring bulk to pre-weigh.

Each product is stored in the db and against that there is a weights, currency and price table for pre-weighed.

What will also be stored is the product yield per batch and as each product has pre-weighed packs produced. The weighed amounts are very precise and in much smaller sizes than the example I've given, hence the need for accuracy.

So, I think, in theory, my current bulk stock could be calculated by taking the sum of all the batch yields - the total of the pre-weighed packs made up. The pre-weighed stock could be calculated by taking the total packs pre-weighed - the sum of all those dispatched.

But then would this gradually get slower and slower as the number of items included in the sum grows and grows?

The other slight complication is that customers may ask for product from a specific batch (if they've had product from that batch before) so I can't really just bulk all the batches of each product in together. I need to have the ability to break it down by stock of each individual batch.

Would I be better just storing the current stock level of each batch in a seperate table / field and then summing them all up to get by product? Even though, in theory, I'm storing a calculated field.

Or any ideas on the best way to handle this?

date problem

todd2006 — Wed, 10 Mar 2010 18:22:29 GMT

hello,

Code:

datetoday=Date()



sdate=rs("Startdate")

edate=rs("EndDate")

What I want to do is if datetoday is between the sdate and edate then set a variable

here is the code

Code:

If datetoday >= sdate and datetoday <= edate then

        setflag="1"

else

        setflag="2"

End if

but its saying setflag="2"

in the table the value of sdate="1/2/2010" and edate="4/11/2010"

any idea what i am doing wrong

todd

Queries Query for search fields on form

Rebelle — Wed, 10 Mar 2010 17:32:24 GMT

Hi All,

Ok, everything seem to be working ok until I added this criteria for one of the fields in the query and on the form.

Code:

>=[forms]![form4].[qDays]

All the other fields use something like :

Code:

Like [forms]![form4].[qEquipment] & "*"

Is there an issue with using a like in some criteria and >= for another?

C#, passing variables between forms

CCCSteve — Tue, 09 Mar 2010 18:34:15 GMT

Hello all,

I have a hopefully simple issue. I am trying to take a large block of code and move it to its own CodeFile.cs so I can just reference it with 1 line instead of posting the same code multiple times.

So I have my code file in place inside of CodeFile.cs which refers to textboxes and such on Form1. My problem is that my CodeFile.cs doesn't have the objects defined in there since they only exist in Form1. How can I fix this so it matches? Hope this made sense.:confused:

file path

todd2006 — Tue, 09 Mar 2010 14:59:06 GMT

Hello,

I have a folder called fileslocation I need to get the path of the folder and display it on the screen

I have used this code

Set fs=Server.CreateObject("Scripting.FileSystemObject ")

but trying to figure out how to search for a specific folder

any thoughts

todd

Forms How to use browse for file and enter path into field?

MaxxMills84 — Mon, 08 Mar 2010 16:32:47 GMT

Hi there! This forum has helped me immensely before, and so hopefully y'all can do it again...

I'm working in Access 2007 and I have a database that is referenced by a number of ASP pages.. I just uploaded a bunch of files that are to be associated with specific records, and I am trying to connect links to files on the server with their specific records.

The easiest way to do it would be if I could just look-up the record using a form that I already have created, and then click a "browse" button or similar to find the file, and then have it store the location (i.e. subfolders and filename) into a field for that record.... except with slashes "/" instead of backslashes "\", and without the drive letter or any higher-level folders....

For example:
I want to pull up "John Doe" and then where the "Link" field appears in the form, I want there to be a button that says "Browse". When you click it, it automatically opens to a specific directory: "H:\server\files\downloads\All_PDF"

Then I can use a normal file browser window to find John Doe's file: "\Day_1-Wednesday_2-24\Hydrologic1_130_2-24\DoeJ_Hydrologic_1330_2-24.pdf"

and have it save the entire path and filename without the drive letter or any higher-level folders and replace all of Windows backslashes with slashes for the web, so that the actual text data saved into the field would be something like: "downloads/All_PDF/Day_1-Wednesday_2-24/Hydrologic1_130_2-24/DoeJ_Hydrologic_1330_2-24.pdf"

I found code on this site: API: Call the standard Windows File Open/Save dialog box which looked promising, but I don't know exactly how to change it or where to insert it.

This forum thread How to add browse button to access 2007 form - Software Development also had a brief discussion which makes it seem like there's a built in feature for this in Access 2007... Any help?? :confused:

Cascading Filtering Lists

Rebelle — Mon, 08 Mar 2010 14:26:19 GMT

Hi All,

I've looked and implemented the cascading filtering lists according the sample posted and it seems to be working but its very slow because I have like over 800,000 records.

Do you have any suggestions I can do to make this work a little better for me?

Thanks in advance. :)

Possible to close window from non-parent?

bryceowen — Fri, 05 Mar 2010 18:31:33 GMT

Just like the title asks, is it possible to close a window from one that didn't spawn it?

Here's what I'm doing:
I have a PHP script that constantly refreshes. If something happens with the data that is being refreshed, a popup will appear to alert whoever is watching it. If the situation clears itself, I want the popup to disappear.

Windows XP Password Recovery

mehere — Fri, 05 Mar 2010 16:22:35 GMT

I have a friend who had an issue (most likely virus) with their PC and instead of getting the virus removed had another friend try to fix it by reinstalling windows (XP). They set an admin password and now can't get into the PC. Either they don't remember the correct password or it's just not accepting any. Is there a way to get into the system? A way to bypass the admin password?

I love when people get others to fix their systems when they have no idea what they're doing.

Thanks.

God of War

jmurrayhead — Thu, 04 Mar 2010 22:58:50 GMT

So my friend got my hooked on God of War. I bought the God of War Collections which has both GoW and GoW II. I beat the first one last weekend and let me tell you, this is probably the best game I have ever played. The story is excellent, the graphics are superb, the gameplay is exciting and challenging...overall an awesome game. I can't wait to start on GoW II.

Anyone else play this one?

First Asp.net Website

todd2006 — Wed, 03 Mar 2010 01:45:11 GMT

Hello,

Guys I am working with a group of 5 developers to create a asp.net website.

Can someone tell me what thinks should I focus more on i mean should be create classes first for the website or should be focus more on master pages

any help is highly appreciated

todd

Rename worksheets in Excel file exported from Access

Rebelle — Tue, 02 Mar 2010 19:21:11 GMT

Hi All,

I've created a simple macro that contains "Transfer Spreadsheet" to directory:
c:\myfiles\NewFile.xls

I'm using export to export 5 different queries into the new file, this all works fine but example the first query name is qryGrandTotalsForYear then this comes across in excel on the tab name. Is there a way I can give it a name prior or during the export?

I would want qryGrandTotalsForYear to be Yearly Grand Totals.

Thanks in advance for any suggestions here. ;)

IF cell does not contain 'blah' then show 'this'

CCCSteve — Tue, 02 Mar 2010 18:49:47 GMT

So I am finishing a report and the data is all correct and everything but as a superficial request I need to change a value that = 'NaN' to just show 'N/A' instead. How can I get this to work? I have tried IIF statements but it doesn't seem to pan out. Thanks for any help.