Search results

Bob I put mmm/dd/yyyy in the Format ppty of the table and it showed Apr/14/2009. I couldn't get to to show APR, only Apr. WIS

I don't know whether you've sorted out the date display. Try this - it seems to be an undocumented feature. Go to the table and put mm/dd/yy in the Format ppties for the date fld. Go to any form that uses that date and also put mm/dd/yy in the Format ppties.

format(mydate,'dd/mm/yyyy') Use Format(mydate, 'dd/mmm/yyyy')

Something else to look at: Go to Tools -> Options -> Edit/Find and make sure Confirm -> Record Changes is ticked.

There is a simple way to stop someone getting your frms, rpts and mdls - put a password on your code. They'll still be able to get your qrys and tbls. Unfortunately, the "AllowByPassKey" can be easily broken up to A2003. But you cannot (easily) break a db in A2003 with ABPK set to False even...

Something to think about: What happens when you've reached 9999 records. Could this happen in 1 mth? There is also a risk of duplication as next yr 04 mth could have 0001 in it as well. If there is no chance of 9999 records in a month I would put 2 digits of the yr in as well to stop...

Create an unbound cbo box on the form with the following: ColumnCount: 1 RowSourceType: Value List Row Source: "All";"Active";"Inactive" Default Value: "Active" Set up a qry with all the reqd flds for the form. To open so that only Active shows: OnOpen event or put it in a...

What Vassago has said is spot on. However, you can go a step further and have an unbound cbo box on the form that shows "Active" as the default, but you can also show "Inactive" and "All". If you need to make an "Inactive" back to "Active" you can do it on the form.

Run the query on its own and go to the bottom of the records it is producing. If the * on the Navigation Buttons is grayed out that means that the recordset (query) is not updatable and so you won't be able to edit/add/delete any records from the form. You then have to make the Recordsource of...

This should fix your problem. Go to form design. Open the form properties box and change any ppty but then put it back to it's original value. eg If Allow Form View = Yes, make it No and then back to Yes. (This is the key to being able to alter the size and position of the pop up form). DO...

Should it be: Me.ComboBox01 instead of Me.Combo121 - in the 1st post you called the cbo ComboBox01. Have you changed the name to Combo121?

Get the form up in Design View. Double click in the little square at the very top LHS side of form - this will drop down the form properties box. Click on the "Data" tab and you will see the "Allow Deletions" ppty. It should be set to Yes. You might need to set the "Allow Edits" to yes as...

Does the output you require have to be in individual flds (ie 9 for the example given) or can it be in 1 fld, with commas and spaces between each element. The 1st 3 flds can be easily combined with a Total ("Group By") select qry but the last 2 are the problem. If all the data per ID can be...

Can you dump the db in a zip file on this forum so that we can see exactly what is going on - there appears to be 3 tbls which need to be joined in a qry. If the tbl structures are satisfactory ie no 2 of the tables are giving a many to many relationship, then what you want should be easy via...

This will only work if you have a unique fld ie Primary key fld set in the table. eg CodeID, Autonumber. As a rule tables should have a unique fld - Primary key (except if they are very simple lookup tbls with only a couple of records in them). You can do this with 2 (cascading) qrys, ie the...

Are you trying to delete the record from a form? If so does the form properties have "Allow Deletions" set to Yes.

This will give you a wrong answer if both d and m are <= 12. You must use "mmm". Format(VARIABLE, "dd/mmm/yyyy") or perhaps more correctly, Format(VARIABLE, "dd-mmm-yyyy")

You are right. I wanted to show the catch with "mmm" instead of "mm" - so I just copied what had been done and put in the Format fn.

I've had similar trouble - fixed with the Format fn. strQueryString="SELECT * FROM CPST where dt >= #" & Format(strFromDate,"dd/mmm/yyyy") & "# AND dt <= #" & Format(strToDate,"dd/mmm/yyyy") & "#" You MUST use mmm. When I 1st did it with "dd/mm/yyyy" it returned American dates if both "dd"...

I use Shanes idea of a continuous form as well - however I make the colour of one field eg ShopID or ShopName etc different to the other columns and have the user double click on that. Heres an example of the code in the continuous form frmJobs: Private Sub txtTitle_DblClick(Cancel As Integer)...