Search results for query: *

Hi jmunk, Check your bracketing .... if you can run it through a QBE then switch to Sql view in your query design and recut - repaste the query to a string value in your module. Also, I would change your string name to MyCriteria to make sure that you are not using something that SQL uses as a...

Hi Scottian, Yes .. that is correct if you know the path. But I want to use the images that Access offers me in the "Available Pictures" and I cannot find a path anywhere. I would guess that they are icon bitmaps but I still haven't been able to locate that path anywhere. Perhaps they are...

Hello everybody, I have an Access 97 form and on that form a command button. I want to add an image that is available within the picture builder but want to change that image based on other selections on the form. I know how to do this if I use an image path like C:\MyImage.bmp ... I can just...

Sounds like the memo field is full of carriage returns. You could try passing it through this function and seeing if you can now see the first two characters .. if so, then just change this function to remove all carriage returns instead of just the first that it finds and you would be OK I...

If you are interested (and not too far gone down the track you have) there is a knowledge base article 160502 "Using Automation to Add Appointments to Microsoft Outlook" (for Access 97 anyway) which shows you how to add appointments to Outlook from Access .... you could then use the Outlook...

Try releasing all of your objects before you exit your function - eg set XL = nothing. This is good coding practice to clean up after yourself. Also, if you are in a module and testing for a true value somewhere back on a form, don't use the syntax - if form!objectname then .... but rather...

Have a look at "Requery" in the Help text ... You will need to get a line like Me.Requery to run after you return to the Form 1 ... you can probably call that from Form 2 by referencing the object back on Form 1 I think. Hope this helps [pipe]

Greetings Troy McClure, I use the following code to link tables in an MDE every time it fires. Run the LoadConfiguration function first to load variables, then call LinkTables to link them to your database. Option Compare Database Option Explicit ' declare public variables for environment...

Am I missing something or do you just want a message box with a OK and Cancel button and then do something based on that ?? You can still use MSGBOX to do this ... the following is from the help text (I dropped Help and Context parts because I never use that)- Dim Msg, Style, Title, Response...

Have a look at the DateDiff function to calculate a date exactly a year ago .... Hope this helps [pipe]

The following code can be cut and paste into a new module. Provided you do not use the database in any objects of your main form, (eg a list box that draws information from a linked table) then you can put the code line LinkTables in the On Open event for your form. You will need to nominate...

My guess is that you would need to maintain a table of locations and time differentials (eg Melbourne, +10) and then use this (joining on location) to calculate the correct local time. Hope this helps [pipe]

Hi RealKiwi, I use the following code to clear the previous selections made in all checkboxes on a form ... you should be able to use the same sort of theory. Sub ClearSelections() Dim frm As Form, ctl As Control, dbs As Database, rst As Recordset Set frm = Forms!frmMainMenu '...

I have a similar problem and it seems to occur when a user opens and exports a report I have designed but their screen reolution is lower than mine. The solution there is to design at something ugly like 640 x 480 so that nobody can get lower than that and it seems to work OK ... OR Export...

I take it that you want to go to a number of different forms when you click a topic ?? How about you create a table that holds - HelpTopic eg Checked email FormName the name of the form that you want to open ControlName The control that you want to be taken to Use this table as the source...

The lines disappear because they are graphic objects and not text objects (in Access 97 anyway). Try creating a text box and filling it with "_" characters(beside the zero on your keyboard) ... these will export fine and look like a line anyway - except they are at the bottom of the text box...

In Query by Design (QBD) mode, don;t link the tables by dragging a field over another .. rather do it by dragging one field to the "select" area (at the bottom of the QBD screen) and set the criteria to either str(MyNumnericValue) to match a "dragged" text to a numeric or val(MyTextValue) to...

Hi JosephRoy, Create a new table called tblEvent_Schedule and add the fields - Event_ID as number Week_Number as number Event_Date as date Create a new form and add the objects - txtEventID as a text box txtNoWeeks as a text box txtStartDate as a text box btnSchedule as a command button Add...

Hey Randy .. your post wasn't there when I started typing my reply but we both come up with the same answer so we must be right !! Cheers [thumbsup2]

Hi Marie, I'll assume your form has the objects cbComplaintType (a combo box) txtAdditonalField1 (a text box) txtAdditonalField2 (a text box) txtAdditonalField3 (a text box) Firstly set the visible property of your three text boxes to false ... by default, nobody will see them. You will then...