Recent content by flixx

To Pat: Thanks I'll take a look at and try a few things since i got few hours to play, but for anyone's FYI, Swishmax is the poor mans flash, heres the link if your intterested and you can download and try for free, software has a lot nice features and been around for 4 years or more, Swishmax...

HI: anyone got any suggestions about using access 2003 tables as the backend and swishmax as the frontend. Thanks in advance.

Just a thought: You might want to give this concept a try, Start by naming the Inventory Balance table - tblinb-Inventory Balance the add a field and call it inb-id , mke this a key field with no duplicates this is your one to many relationship or one to one works for both. Field names for the...

To Cevelctq: Just a suggestion, try creating a query with your table in it and then add the fiels you want , and under the Title set sort order to ascending or descending and that field only. Flixx.

To deejay_totoro: Have a go at this test sample, the query converts the text numbers to a numeric value, then sorts the values in ascending order. Hint: In the Query Grid always place the calculated field in front of text number field and sort both fields. Anyway the example is in...

To akcharlie: You might want to take a look at this mdb sample I built to resolve your issue. In short what I did was create 2 tables - client table with names only, address table with multiple addresses and phone and the primary address box. Then I moved to query editor and created...

To travismp: The only thing you needed to do in your query was to remove the iif statement from the new type field and just enter the field [Type] Proper Syntax is New Type:Type. which by the wau is qry_Main01 also created a qry_Main02 and did a field rename in that field just to give a...

To IanT: Try this iff statement either in your query or report or form IIf(Len([recnum])=4,"0" & CInt([recnum]), IIf(Len([recnum])=3,"00" & CInt([recnum]), IIf(Len([recnum])=2,"000" & CInt([recnum]), IIf(Len([recnum])=1,"0000" & CInt([recnum]),[recnum])))) the field [recnum] can be changed...

To aguy: Take a look at the Zip1 databse I have attached as a zip file, look at the 2 query's that are setup as examples. If you have any questions, just post them. Hope this helps, Flixx.

To anden7606: To resolve your query issue just do the following: 1. Open query in design mode 2. Click on View from Menu and select Totals 3. Under Total in the Query Design Grid a. Leave field [stockno] - Group By b. Change field [shelf] - Max c. Change field...

To LostandConfused: You might take a look at the links in your tables thats is if the tables are linked to a backend database file and check that the pathing is correct. Also take a look at all macro's and and check on the pathing, includes the modules, forms, and reports also. And under Tools...

The short answer is use DLookup on the after update property of time field you are using. DLookup command works like a query, so to speak and DCount is used to count the amount of something from something to something. Thats the real simplified explanation if you need more detail look under help...

It can done alright, but you need to have access to a web server with your web page. Also you will need to convert your forms to asp pages and and download to your site. Then in Frontpage use the asp pages to control your data. That is just a quick overview. If you have a high speed conection...

Tp pb21: In that case your only choice is to place in the specified data entry field property in after update a event procedure that will open a popup form for the data input person to enter data the a close button that will autosave the data and don't forget to refresh and repaint. Thats...

To pb21: If your using access 2000 or higher try using the tab control. In other words place a tab control on your form and then you can create the different groups you require for the specific fields. I would suggest you click on help and under the help index look at tabs before getting...