Search results

A query field "occurence" includes data that ranges from 0 to 10,000,000. I want to look up the corresponding "bi limit code" from a seperate table and store the lookup value as a field in this same query. Occurence...... BI Limit Code 0 - 100,000....................10 100,001 -...

Multi-Page Forms - Paging Down I created a cancel/event macro and input this macroname as an event in the "On Key Up" and "On Key Down" form properties to prevent a record update when the user pushs the key up or key down button. This did not work. I also tried a similar approach, but input...

I've created a complex form with several pages within the same form. The "Allow Additions" property is "Yes", which allows one to enter one record at a time. If anyone mistakenly uses the pagedown button on their keyboard, the form automatically saves the record before the data entry is...

Please disregard this thread. I've solved this issue.

I created a bound check box as follows: 1. Open form. 2. Click check box tool. 3. Drag field from field list into the form, where field is a yes/no field. Question 1:When I test the check box, the check is not stored in the bound field of the table. How do I fix this ? Question2: How...

I confirmed that my Internet Option setting is English, yet the MS Access Help Function still points me to websites with Chinese language.

When I create an option group it automatically stores selected option values as numbers. Is it possible to store the selected option as text ? For example one option group will allow the user to select one of seven days in the week. Can I store Sunday as Sunday instead of 1 ? How can I do this ?

When I use the MS Access help function, it sends me to websites where the language is Chinese. How do I correct the help function so the language is English.

Inserting Page Number I resolved my own question by simply inserting a page break with the pagebreak tool in the toolbox.

Question1: I inserted a page number in my form, which automatically created a page header with a page text box where I input "page 1". When I open the form I don't see the page number. How do I fix this ? Question2: How do I insert a second page.

Thanks Mippo !

My original Query A contains the fields Cost and Calls. I created a new Query B which has two fields: sum of the Total Cost and sum of Total Calls. I also created Query C which depends on Query A and Query B. Query C correctly calculates Cost per Call as [Total Cost] / [Total Calls] from Query...

I want to create a calculated field in a select query. Cost Per Call = Total Cost / Total Calls The Total Cost is a fixed value that will be entered after the user is prompted. The problem is that Total Calls is the sum of another field in the query called # Calls. Is it possible to calculate...

One final point for clarification. I deleted Table A of all records then imported the csv file into Table A using no specifications in the macro's transfer text action. I'm assuming the table will always maintain the same field properties that were in the original Table A setup even if the...

I completed the delete query, which will probably be the ultimate solution to the index problem. I just need to test a little further, but it looks like you solved my problem. Thank you very kindly sir.

I'm a sophisticated user of access, but not a programmer. I don't know how to build a delete query. Where do I put the code: "Delete * FROM myTableName" ? In the criteria of the delete query ?

I've actually done what you suggested in the past. The file contains 1.2 million records with 36 fields. The append can't be done in one step due to data overflow, but can be done in multiple appends which is very time-consuming. I found the import can be done in one step without data...

I'm trying to overwrite the table each time the macro is run, so setting the table with the correct structure is lost when the table is overwritten. I tried linking, but the linking function does not allow the option to index a field.

I'm importing a csv file into a table via a transfer text macro that is based on specifications requiring the Account No field to be indexed. The macro correctly imports the file, but the Account No field in the table is not indexed. It appears the specification that requires the indexing of...

Thanks for all your help. I'll be closing the thread. I always wanted to know what motivates scholars like yourself to provide so much help to others. Are you a good samaritan or are you employed by Microsoft or the World Forum. This question has always been nagging at me. Either way, I...