Search results

hi aman As i understand it Excel and Access both use the MSGraph 'engine', so yes you can do the same thing in Access. I find it best to add second axis the chart by hand rather than using the wizards (i do not even know if/where the options are) 1. double-click on the chart object in the...

Hi BettyWho The first thing i notice is on the line of code;[Forms]![Client Demographics]![DOB] =>Date() and <Date()-6570 Then You have not set the expression correctly. in multiple condition IF() statemnet you need to include the data source for each condition, so [Forms]![Client...

Hi Elie, This all sounds TOO familiar. I am a Supply Chain Manager :eek: I think Minty has the answer for you in terms of display. Create a form for each sub table. Is your current display form a single form or a continuous form? If continuous, create an InDetail form, if single then that...

Hi Elie I think we may need more information to help. Can you provide the names of the 3 sub-tables and the relationship(s) PK/FK that link them to the Jobs table. Also a little insight into the purpose of the 3 sub-tables may help. From what you have said so far, i get a feeling your 3 sub...

The following code is unchecked, but should provide what you are looking for. I have coded this making the following assumptions; 1)check_Name fields are filled sequentially 2) checktype bound column is = to a chaeckname Private Sub checktype_AfterUpdate() Dim intCheckName As Integer...

Hi Tor I would suggest coding in the AfterUpdate event of the combobox checktype. You can easily check each check_name field for a value and check the new name is not in the other fields.

Hi Valery I have just invoked export and import on my custom ribbon and by default it went to My Documents. If your custom ribbon is not in My Docs, search for the file type .exportedUI.

It should not matter which Office program you are using, the customisation files are exported/imported in the same way. As to where the file is actually stored, i do not know.

Hi Jallen, Generic process here would be to have a button on a form (Booking History?) to create a new booking. This opens the New Booking form. After the customer enters their account name.ID etc, carry out a Dcount() to verify the account exists and display the New Customers form if not (OR...

Hi Derek In design mode, double click your graph (same as your image). Right click the graph and select Data Labels and tick the Value box.

And second that welcome.

Couple of good functions Jim. Maybe think about providing a way to indicate what the week/weekend days are? In this day and age many people do not work Mon - Fri.

If you want to append the value of the parameter, the parameter request needs to be in the Field section. If you want to use the parameter to restrict what is appended, then the parameter request needs to be in the Criteria section.

Hi Valery Custom ribbons are stored in a folder. New PC, no custom settings:banghead:. You can export/import ribbon settings, so if you still have the old PC, export those and import to the new PC. Here is a good link...

You can use the CurrentView property to determine a forms display state. The 'trick' is the event trigger to check the state. The On Deactivate is one option, as is a timed event. The problem is detecting the state whilst it is in design view. You could use code in another form (timed trigger)...

Have you thought about encrypting it with a database password? Without the password you can not get to the database from another database using Get External Data.

in the text box properties, set the Format to a date format and the picker will display.

try supplying the value of the constant acFormatXLSX. I assume something like "XLFormat(*.XLSX)"

hi ryetee First step, use the Database Tools>Analyse tools and see what that tells you about the table - Analyze table for example, will show you what forms, queries & reports are connected to it. If the table is not in the database (eg linked to another source - the table name has a little...

Hi Neil You will need to use CreateItemFromTemplate method. 1st create a template in Outlook. then instead of using Set objEmail = objOutlook.CreateItem(olMailItem) use Set objEmail = objOutlook.CreateItemFromTemplate("Path To Template")