Search results

Couple of good examples Beef. I prefer the dynamic SQL method. (Can hit the SQL string length limit with the second method.) I would make one very slight alteration to your "Subject" criteria, in order to include a keyword, instead of only the starting word of the subject. ie: Change from...

I have finished my beer Len. I am enjoying yours now :)

I think you have missed the concept of an autonumber. You are doing the correct thing using an autonumber as your PK, but you should not be trying to restrict the PK range or value. I would suggest leaving the autonumber PK, and adding a seperate ItemNumber if you think it is required (ie...

Len, I do something very similar for all my Town State PostCode entries. I use multiple events to control the flow of operations. See if you can make sense of the following: Private Sub CboTown_AfterUpdate() Me.Town = Me.CboTown.Column(1) Me.State = Me.CboTown.Column(2) Me.PostCode =...

Attach the following code to your button DoCmd.SetWarnings False DoCmd.OpenQuery "YourAppendQueryName" DoCmd.SetWarnings True Note: the Setwarnings lines stops the "You are about to ...." default messages from annoying you. You will then have to requery your subform to display added...

Open the db using the "Shift Key" bypass. ie: Hold down the shift key while opening the db

More relevant to Calvin (and just rubbing it in for you AngelT) Calvin, If you use Acc2000 or AccXP, have you used conditional formatting to solve you problem? I use conditional formatting on continuous and datasheet forms with few issues. Brad.

DoCmd.GoToRecord , , acLast

Only error (I think it is an error) that I could find is your listing of referal type "Service Package" as "Service Package-GECC". Thus, "Service Package-GECC" filter will never return any matching records. But that is only a data issue. Cheers Brad.

Hello Mr Fish, Checking out other forums first - tut tut. Anyhow, had a quick look at your search form. Maybe I have missed the boat on this one, but the form filters by VISA quite nicely for me (With or without other cbo selections). Looks like your project is developing nicely. Brad.

I am not 100% sure if I am on the right track, but if you are wanting to make a copy of files, and name them based on the current date (or manipulations thereof), you could use the method mentioned here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=48841 HTH Brad.

Given that you only want to display the coming Friday's date, and not a date range, couldn't you use: =Format(Date()-Weekday(Date(),1)+6,"mmmm dd"", ""yyyy") Nb: * Date()-Weekday(Date(),1) takes the date back to last "First day" (ie: Sunday) * +6 advances forward to the 6th day (Friday) The...

Check your table structures: Tbl_Projects: ProjectID (Autonumber) PrimaryKey ProjectName (etc etc etc) Tbl_Payments PaymentID (Autonumber) PrimaryKey ProjectID (Number) Will be ForeignKey-Relates to Tbl_Projects PaymentDate etc No need for PaymentID in Tbl_Projects Brad

You will notice from you relationships window, that you have only a one-to-one relationship between table Projects and table Payments. Thus your subform is adhering to this rule, and only permitting one record in Payments for each Projects record. Until you correct the relationship, you will...

Along the same lines of the following. You should be able to adjust to suit your needs. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=48771 Brad.

use code as follows: If Len(Dir("c:\ExistingFile.txt")) > 0 Then 'File exists so rename FileCopy "c:\ExistingFile.txt", "c:\" & Format(Date, "mmddyy") & ".txt" Kill "C:\ExistingFile.txt" MsgBox "File renamed successfully" Else 'File does not exist - Unable to rename...

http://support.microsoft.com/default.aspx?scid=kb;en-us;255726

Well E, I have been happily on the beer for ~ 7 hrs, so this advice may be a little "suspect". Have just returned from the pub (quite early) and noticed you are still having probs. I have attached the db that I tested the theory on. Please note: This is not my db structure. It is actually...

As an aside, if you are keen to develop user apps, you will benefit greatly by doing some reading (search this forum) on naming conventions and normalisation. (You are breaking just about every rule written ;) ) Brad.

Sorry, I didn't realise that the Check box is bound to the Repo'd state in the main table. Given that your Sub is based on the "Repo_d_Click()" event, and your SQL uses a where statement based on "Repo'd" state : The Click event occurs before the update event of the record. Thus when the...