Search results

Hi guys, I hope I can explain this issue properly. I have a table called "Payments" and a table called "WorkOrders". The "Payments" table contains a record for each payment that is made against a Workorder ("WorkOrder" table). There may me multiple payments agains a Workorder. A WorkOrder is...

fantastic!!!!! I just did it and it work!!!! Yippee! Thanks mate! Regards Greg

Hi CJ, I just came back and opened the form to implement your suggestion but I am now seeing the following SQL code: SELECT Customers.ContactFirstName, Customers.ContactLastName, Customers.BillingAddress, Workorders.*, Customers.City, Customers.StateOrProvince, Customers.PostalCode...

Thanks CJ I away for a few days and will try your suggestion when I return and will let you know how I go. Regards Greg

Hi guys Newbie here. I am using Access 2007 and have a database that has a table called "WorkOrders" that are basically an Invoice type of thing that contains some information such as when it was created, the ID of the Customer etc. I also have a table called "payments" that contains a record...

Re: When Using Query With "grouped By"option, I Can't Edit Record In Table, Access 20 I spikepl, Just to explain why I am doing things this way...I already have a form based upon Customer and a subform showing the WorkOrder attached to that customer (see the attached screenshot). I want to...

Re: When Using Query With "grouped By"option, I Can't Edit Record In Table, Access 20 Thanks mate. I'll have a play around with this using your suggestions and I'll let you know how I go. Thanks

Re: When Using Query With "grouped By"option, I Can't Edit Record In Table, Access 20 Hi and thanks for your reply. Here is a screen shot of the query that is actioned on the "Record Source"of t he Form.

Re: When Using Query With "grouped By"option, I Can't Edit Record In Table, Access 20 Thanks...is there an alternative?

When Using Query With "grouped By"option, I Can't Edit Record In Table, Access 2007 Hi Guys I'm a newbie trying to add some functionality to an existing Access 2007 database (running on Windows 10). I have a table called "Workorders" that I have created a split form for and have customised it...

Hi guys I am a newbie and am starting to use Pivot Table view to display some data in one of my tables. The table (lets call it "Parts_Sold") contains rows representing all of parts that have been sold, there is a single row for each time the part is sold. There is a field called "Part_Id"...

Thanks Dave, I'll try what you have suggested and report back.. Thanks for your help. Regards Greg

Hi Dave, I just tried a new blank database and the same error is displayed.....it's interesting that I can link to a DBF or Paradox file without any issues...... I have also tried with Outlook not running...

Hi Dave, I forgot to say that I have already tried the Repair. The XP PC that is also exhibiting the same issue does not have Office 365 or any other Office version installed.... Regards Greg

Hi guys I have spent many hours Googling and trying t solve this issue I have with an Access 2007 database. I and trying to link to Outlook 2007 using the "External Data/More/Outlook Folder option and keep getting the "Object Class does not Support the Set of Events" error message. I can link...

Thanks mate, it's late here and I'll have a play with this in the morning.

Hi Spikepl Here is the code that is connected to the form: Private Sub Form_Current() DoCmd.SetWarnings False Me!WebShopImage.Navigate (Me!Text45) DoCmd.SetWarnings True End Sub

:banghead:

I think this one is going to be above my pay scale :)

Thanks mate, I'll give it a try and let you know....