Search results

Your thought about building the table with four columns was the correct one. Change the table design and your query will be easy. Generally, you want data in tables to grow vertically not horizontally. As an aside, where is this summary data coming from? If you have a table with the order...

update If you remove the olAppt.Save then outlook creates the appointment and saves it in the desired folder on the olAppt.Move call. Hope this helps - Fran

I could not create the appointment in a sub Calender but was able to move it to the desired calender. Check out the updated version of your code - This should accomplish what you need 'Error 429 occurs with GetObject if Outlook is not running. On Error Resume Next Set objOutlook =...

I think you are using the wrong object and method to get the desired folder. The getdefualtfolder method does just that gets the default folder of a particular folder type. To get a non-default folder I think you need to use the folders object

I have an Access 2007 Data Project (ADP) database using a Ms Sql 2012Express db server. I know this is not a supported platform and the project option goes away I think in Access 203. While I'm having no issues with this configuration I'm thinking I should switch to linked tables to come...

1. In the database you attached you did not have a primary key defined for either table. This prevented the query from being updateable. - Probably my fault - the db I sent you was missing these as I had just imported these tables from another db and did not check the table definition. Once...

If I understand your issue correctly you are attempting to assign a property to an entity. ie Assign the State Property to a City. This is very simple. I think you may have over complicated your design by attempting to have your forms based on a query that joins the tables. You should...

I agree with Cronk. Constantly changing properties of table definitions to support an on-going requirement of a business process screams for a need to change to the process. Usually data should pass all validation requirements before being added to permanent storage. Consider adding these...

Here's some vba code that should do what you are looking for. You can place this code in a module and call from anywhere. Just pass to it the TableName, FieldName and New Setting (True or False) You can call this at the beginning of your Append Process with setting False then again at the end...

I just tried to recreate the issue in Access 2007 and could not. I wonder if different versions are treating case differently.

No shouldn't have any problem. As you have stated you have no forms, vba macros or other objects currently referencing the field so you didn't break anything by changing the name of the field. Any new objects you create will reference the new field name. My comment regarding changing field...

Sounds like a simple case of case insensitivity. Since your attempted change to the name was only from upper to lower case access was not recognizing any change. So there was no real change to save. But when you changed the name by adding an extra character then removing the extra character...

Changing names of fields is always risky business - you will need to make sure any object (form, query, macro, report, vba code ...) that references that field is updated to the new name. Are you getting error messages? Are the fields used in any relationships? Im pretty sure you can't change...

Try putting the code in the after_update event instead of the click event.

Sorry SkyCraw I'm not sure. This is an area that I only have enough knowledge to get in trouble with so.. I am concerned I might be leading you down the wrong path. Having given fair warning It may be in the Office Button/Server/Connection/Data Link Properties or if you are using ADO which...

Don't know if this will help but you might want to check the versions of the connectivity libraries used on the different machines.

Design 1 is the way to go. Don't worry about record count with proper indexes you'll be fine. Proper normalization of data structure will make for a simpler more efficient system.

I would build the Exception table to have a separate record for each client/employee combination. Additionally I would add an {Exception} flag to the client table to indicate which rate they use -standard/non-standard or both (some employees standard, some non) rate tblExceptions ExceptionID...

Attached is a version of the db that dynamically links the combo boxes to the underlying fields in tblPinouts There probably is a more elegant approach using arrays of controls but I don't have the experience to do it. The approach taken assumes a maximum of 40 pinouts. The limitation of this...

I couldn't help myself and wanted to take a crack at this form design take a look at the attached db - it is in A2007 format The screen is called chips. The vb is a little crude - rather like using a blunt hammer but it seems to do what you want. You would still have to dynamically assign...