Search results

This could be done via script, but thats not really my speciality. I would suggest searching the forum for importing from excel since I am sure I have seen something similiar posted in the past. If you cant find what you need, I would post in the MODULES AND VBA part of the forum.

How many numbers per street? How many other per number? Obviously there can be 0 or more numbers to every street, but for every number there has to be 1 street (1 to many relationship). Now, if there can be 0 OR MORE other fields to each number, but only one Number field per other (a possible...

Your simply lookng to return the items with UNEQUAL (<>) prices? I would have to assume that your 2 tables share a common key or unique identifier. You would add both tables to the query with a link between the unique keys/identifiers, then add all of the fields you want to display. Then beneath...

Ouch Seems as though you have quite a situation there. Depending on the date of the machines and where they were purchased, you may be able to attain a copy of your licenses from the PC vendor. Also check with the software vendors for the licenses pertaining to the version of the software...

Have you attempted creating a linked table to the file? Then run a query to extract the data you need into a tbl within the mbd if you desire. If this is something you will be regularly updateing via delimited files, then this could be problematic, but if its a one time shot you may want to try it.

What type of Server? What OS is it running? You can always split a MDB into a FE-BE (front end - back end) system, having all of the GUI, queries, macros and modules in the FE and the tables in the BE. Put the BE on the server, and distribute the FE to the end users. You options of security...

I’m not sure exactly what you are getting at in the question. A bit of punctuation would make it more understandable. Try this; it might be what you want. If you can do it separately in the queries, create a field within a new query that hold the statements from the individual queries...

Since you can apparently send the same stamp multiple times, and you can send a single friend various stamps, you have the MANY-TO-MANY problem. You need to create a junction table that tracks the exchange fo these stamps. Create a junction table (tblSentStamps) and add fields identicle to the...

Have you taken conversation outside of the forum? Like asking for assistance and you and others transefer data/ideas in private e-mail. If not, then it sounds like your account has the problem, what you describe "I'm afraid the message returned below could not be delivered to the following...

It was my understanding that the replication was for the purpose of keeping one "MASTER" database for development, and have the replicant for distribution. The end users would have the replicant, and you as the designer keep the master. You can change/edit/improve/modify the master, and with...

Did you set these as a concatinated key? If you can use this as the PKEY for the table, select both fields and set them as the key.

Go into design view for the table, and set the field as REQUIRED = YES and the database will not save the record unless it is filled out.

How about creating a history table. Run a query for everything from the table, then change it to a MAKR TABLE QUERY. Name the new table tblHistory,. Once you have created the new table (and transfered some data) change ti to an append query, with the tblHistory as the target. Now copy and paste...

I agree, you'd think they could have done better size-wise.

WayneRyan has the answer, and something that is good to keep in mind. Anytime you have a field that contains a number that WILL NOT BE USED IN CALCULATIONS (phone #, SS #, your number) you should format that field as text. This will not only allow for the type of formatting you want, but allows...

Ah ha, first to vote. ;) I just thought I would let you know that I havent had any problems with the databases I create in the runtime environment.

You could use the query builder to make these changes, and could have used it to do the initial split. Say you have a table the has HOURS and MIN as the fileds you want to "TRIM" down either before the colon or after the colon. If you were to add a calculated field such as HRS...

You could try going into the SORTING AND GROUPING properties of the report. Select the field that you want it grouped by and set it as a group header. For every MIX (group header) you have, you can place the block filed in the DETAIL section of the group. It should turn out like.. MIX 1...

I have recieved my Database Proficiency Certification from the College that I take courses at. These are sets of courses that you take, and are equilivent to anything Microsoft puts out. I am currently taking the Networking course and we are working out of the MCSE 2k book. You can check this...

The compact and reapair function should do the trick, and you can also set the MDB to always compact on close. If it wont comapct any smaller, then chances are it is as small as it will get. If you need to compress it further for e-mailing or transfering on disk, I would recomend zipping it.