Search results

Bit in blue :) Vince

Possibly the index bit is not supported?? Anyway - wouldn't it be easier to use a join or two in an Sql statement? Vince

Hi, As you have now found out, queries and feedback to the user don't go hand in hand. However there is always a workaround and here are a couple of options: - Have a form pop up just before actioning the code warning the user that if they for whatever reason turn off Access via the taskbar...

I don't think you can check the returns records property like that. I think (guessing as the help file here appears to be corrupt) that you need to open the query to see whether it returns anything, in which case you might as well use a recordset and .eof property (if the...

Left join and us the NZ function to return 0 for the null fields on the right side of the join. eg Select table1.blah1, nz(table2.blah1,0)+table1.blah1 as TotalCost from table1 left join table2 on table1.id=table2.id Vince

Hi, try docmd.execute (if you must use docmd - there are alternatives). The function you want is Msgbox Its used like this : msgbox "Successful! Your records have been deleted",vbokonly+vbinformation,"Record information" The intellisense should give you the options in the vbokonly part :)...

Search for 'accumulative' in the forum as this question came up before. Vince

You've obviously put some work into it, and thought about your design, but you have found it appears to be flawed (slightly). I take it this is for a school/college/uni project so keep all that you have done as a record, you can use it in the final documentation as an attempt and what happened...

If you create the Sql statement in VBA/VB first then yes. I'd say build an sql statement using one field to output what you want, then change the view on the builder to sql. Copy this into your code and place it in a string variable (strSql). Then whereever there is the field you specified, you...

180 days is approx 6 months so you'll need the following in the where clause [table].[datefield]<(now-180) Have an experiment, and postup what worked :) Vince

Create the new filtered form layout, use a default recordset initially to allow binding (I personally don't like binding) On the search form, initially I'll assume that the users will be searching using one name. First you need an Sql statement. So open a new query, add the table you want, drop...

If you can reorganise your tables then try this: tblStyle StyleID - auto style color size 1. tblForecast fields: styleid,week,units 2. tblWIP fields: styleid,week,units 3. tblOnOrder fields: styleid,week,units 4. tblOnHand fields: styleid,week,units Then these tables can be linked together on...

Hi, Almost there. There problem with looping upwards (through each form or from 1 to x forms) is that as you close a form the rest slide back and the looping pointer doesn't. for lngLoop = forms.count to 1 step -1 If forms(lngLoop).Name <> "Startform" Then DoCmd.Close acForm...

Customer MembershipNo (PK) , Name, etc Payment PaymentNo (PK),MembershipNo, paidAmt, datePaid, etc One the form you'd have selected or entered the membershipno; - Use a query to total the payments made so far (positive and negative) eg: Select Sum(paidamt) as TotalPaid from payment where...

I believe there is a Forms collection with a count object which only holds forms loaded or open (can't remember which). Loop from the max count to 1 and close each one. If it's VBA - docmd.close acform, forms(loopcounter).name If it's VB - forms(loopcounter).hide or unload (forms(loopcounter))...

Create Ten hyperlinks (labels) Tables (just so you can test): MainID - Auto MainDescription - text - 50 HyperlinksID - auto MainID - long Count - number (0-9 or 1-10) Hyperlink - text - 255 For each main table (rename as appropriate) you have up to 10 hyperlinks stored in the sub table. The...

Or alternative go for an unbound form then you code the save button to save. If the user doesn't click the button, nothing goes to the db. If they do, you validate their data to make sure its correct and if it is then its saved... if not the loving error message appears... Its an option :) Vince

Hi, ok so you want a questionaire plus login (to store user who completed) and probably some on screen stats reports for upper managment (outputs you can deal with later). First up you will need a login/register form to get peoples details. These are the usual suggested fields. UserID...

Hi, As Kev said, its create a new and import. Happened to me a while ago, and I got so annoyed ('cause of the custom menu as well as other bits) and happened because I was instancing windows and the comp ran out of memory. Anyway I wrote som code to create a menu for me, disabling all other...

OK. Hmmm. Now in the links you are joining to the title table via the full name/description, but you want the ID/code field returned. As the Payroll table is on the left most of all the joins, wouldn't this have the title code you need? Otherwise, which is more prominant, the casual or the...