Search results for query: *

I currently have a database in Japan. On their side it shows all in Japanese, in my side English. I'm moving their database state side and having them login remotely. However, the terminal server is not loaded for just Japanese. Is there a way to have their database in Japanese and not...

I currently have a query for data entry on one aspect of my database. I have two fields with drop downs. However, one of the two (TestType) is based on the other (TestName) in the table. Is there a way to select the data in the TestName field and have it automatically populate the TestType...

I currently was given an Excel project for test data reporting. There are groupings by TestName, TestType then columns by TestData, TestTime, and TestNumber. Now, when I pull them out of MS Access into Excel they come in as columns only. What I need is for the TestNumber to pull in as a row...

So, I recently picked up a Japanese client and am currently their only support. Which means I support them blind and deal with the intense language barrier. I have never seen a search feature not work unless the code was shot, but since this is part of the built in toolbar with MS Access I'm...

I have the necessary query ready, and I can make it a "Make Table" for a merge purpose. But I would like a single button dump the data from that query/table into a Word doc. What is the easiest way to do this? Thanks -Jose

Using a formula, how can I check to see if the database is local or on the server automatically using a @dblookup? My main db is TestDb.nsf and it is pulling names from TestDbNames.nsf using @dblookup on dialog field name Name. I'm trying to use an @If and checking to see if the db is local or...

I have varioud drop downs (1 @dbcolumn, and 4 @dblookup's based on what the @dbcolumn displays). How can I get it so that when the user selects a value for the @dbcolumn drop down, the other 4 fields are automatically populated? Thanks

I went through the help files and various FAQ's and couldn't find anything that will help. I've tried changing the alias, the server, well, pretty much everything that is possible to change in a @Command([Compose] formula...can you guys help me out on this? Thanks in advance...

What is the server parameter to allow the lookup feature to pick between EITHER a local OR server located database (it has the same database name - ie DB1)? I tried "": "DB1.nsf" and that works partially. If I throw a server name in the quotes it won't look at local. Any ideas? Thanks guys.

I have a unique ID field that pulls from one table and I'd like to have it saved to another table when I hit the save button. How would I go about doing that? Thanks for the help!

I have a model number field that is duplicated (no more than 2 copies of the same data). What I'd like to do, is bring the 2 docs that have the duplicate model number together as one doc in a view. Is this possible? (ie) ModelNumber - xyz, Field2 - 10, Field3 - 2500 ModelNumber - xyz, Field2...

Is there a way to combine duplicate records into a single record? Then to display all non-duplicate records the same way? First, I have field1 that has duplicates because the associated data has a high end and a low end. I'd like to combine the high end and low end and only show one field1...

I would like, preferably, to have a selection formula in a view to pull documents that have a specific number. This number is generally like XX-00000. But on occasion it can be XX-00000-XX. It's the latter that I DO NOT want to show in my view. From what I've read, lotus script appears to be...

I have security set up on my database. I was wondering that when I user logs into the database, that it would automatically put their name into the form they are using? Is there a way to do this using an bound text box to pull that information? Thank you for your time.

I want to have an @If determine that if the field value is >= 10 and <=25 and another field's value is >10, then the result will be "Failed". But using 3 &'s isn't working and I figured this out before, I'm just having a lapse this Friday afternoon. Example of what's not working: @If(Field1...

I have a field $12 and $11, and I want the difference of the two. However, I want to convert them from a string to a date field first...how can I do that? Thank you!

I have a field that allows more than one date to be entered in the form. Then I have a view trying to calculate the difference between that field and another date field. Example: ReportDate minus TestDate (TestDate being the date with multiple dates) How can I set the view up to have the...

I currently have this set up to invoke Outlook, however due to Outlook security, 2-3 separate pop-ups kick in : 1.(A program is try to access email address you have stored in Outlook. Do you want to allow this? If this is unexpected, it may be a virus and you should choose no.) Then if we...

I created a shortcut that is supposed to open Access, then open the front end of the database and then the system.mdw. For some reason, it will not start the system.mdw file. I've done this a hundred times and this is the first time it doesn't ask me for a username/password. Here's what it...

Is it possible to pull data from an Excel spreadsheet and have it dump into a Notes view? I had it set up to currently dump into Access without a problem, but have come across numerous issues going into Notes R5. Has anyone ever attempted this? If you have, could I see some of your code to...