Search results for query: *

Brightstar, In answer to your query : 1) For Run-time access applications the users do not require a licence for access. 2) You will need to create an MDE file from your development DB in Access 97, read the information the Office Developer Toolkit guide for further info. I hope the above...

Hi, Beatrix I assumed the field was a mandatory field, thus it requires a y or n to be populated. If this is not the case then reply asap, and I should be able to provide a different solution. HoleInTheFoot

Hi again, The AfterUpdate Event is behind the text box "TxtSchCrt". However you have indicated your criteria is in the query, please can you send me a copy of the SQL string for me to access if a different solution is poss. HoleInTheFoot

Hi, If your question is referring to a report or form then Yes otherwise No see belwo for an example : 1) I am assuming you have an input for the search and this value is stored in a Text box, txtSchCrt, on the Report or Form then if you have the following Code in the OnOPenEvent ...

Hi, Beatrix If you set the default value for that particular field in the table where the data will be entered to Yes. This will solve your problem. Note you can only add records to a signal table at anyone time via data entry through a query within a relational database. If you have any...

Hi, Hammondo You maybe also experiencing the problem mentioned due to a slow Network, this can be tested for by opening the linked tables in your Front Database and monitoring the response time taken to veiw the data. If you have further queries give me a shout. HoleInTheFoot

Hi, aexley Check if the properties of the input box allow you to enter a string upto 100 characters. If you have any queries give me a shout. HoleInTheFoot

Hi, Hammondo You maybe experiencing these problems for one of the following reasons : 1) The Backend is on the C:\ drive of your orignal local machine. If so put it onto the network and re-link your front-end to the new location. 2) The backend and are loacted on the Network, however other...

Hi rgoa, You can get the desired result as follows I am assuming your data is stored in a single table i.e. Table1 then use the following queries, query 2 will give u the answer : 1) SELECT Table1.PRODUCT, Table1.SUPPLIER, Max(Table1.Price_ISSUEDDATE) AS MaxOfPrice_ISSUEDDATE FROM Table1 GROUP...

Gus, I'm assuming you have the folloing tables in your database : 1) Main Vendor table 2) Vendor Address table 3) The relationship between 1) and 2) is one to many. Now in the Vendor Address table add a start date and end date fields this should over come the problem your are having by not...

Matt, You need to create a table with an Id Field and an OLE Object field to add each of the Text files as appropriate as single record Holeinthefoot

Simplest way is 1) to base your Response View form on a select query which looks at the Response table i.e. "responsequery". 2) add two text box's to the Menu form (text1 and text2) 3) in each of the 12 buttons add the following in the On Click Event : Dim stDocName...

Simplest way is 1) to base your Response View form on a select query which looks at the Response table i.e. "responsequery". 2) add two text box's to the Menu form (text1 and text2) 3) in each of the 12 buttons add the following in the On Click Event : Dim stDocName...

Ensure all dates are entered when zero containers delivered this will resolve your requirement

Whoops missed this bit of info earlier : the Loop is checking if you have hit the space bar key which will also keep the music playing continuously.

After the "Loop" statement add the following statement Call PlaySound("", 0, SND_PURGE Or SND_NODEFAULT) ' stop playback

StuGreentree, Can you show me the code in the routine PlaySound ? For me to to provide you a simple solution