Search results

FYI: If it is slow to open for you, try opening just Access then do the File - Open, highlight the mdb in question, then hold the shift and press enter. I found that some were so slow opening that I wasn’t getting into design view, but if you open Access first, it seems alot quicker.

"I did that for some other things" Just how bad was the installation CD your using? I would recommend contacting Microsoft support if you have purchased a copy of Access or Office that is this corrupt.

Bravo, I tip my hat to you sir. This is something that I have wanted to do for quite some time, but was told from day one (by teachers) that it could not be done. Rest assured that those who have told me this in the past are about to be enlightened. I guess that will teach me to believe...

DATA MISMATCH ERROR means that you are trying to put one data type into a field that requires another. An example would be puting text into a number field. Open both tables in design view and make sure the FIESLD TYPES match, but if you have an AUTO NUMBER, make sure it updates to a NUMBER...

I had a very similar issue, what I did was import the information, then run code to manipulate that data in the exact manner you stated (fill in the blanks w/ the previous #) The thread is loacted here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43336 Or Search form...

You should still be able to hold shift key while opening the database to get to the database window. To lock it down even tighter, you could use the database tools to create a MDE file from the database. Go to help and type in MDE and see if it is what you are looking for. Saving your Access...

When you have the databse open, left click on TOOLS on the toolbar. From the tools menu select STARTUP. This will open the startup dialog box, from which you can set the options you are looking for. The upper right Display Form/Page will allow you to select the form you want to show on open, and...

Open the subform and display the properties. Look at the data source, which you stated was a table. To the right of the datasource field in the properties window, you will see a ... button. Click on it and you should invoke the query builder. The basics of what you have your form based off of...

At first glance, I would say to change the YEAR to DATE in the DD/MM/YYYY format. By doing this you can calculate the period from this field, eliminating the additional field. When you create a report, you should first generate a query that would return the select data you want and base it off...

Base it off of a query that pulls the data from both tables. This way the tbls hold thier structure and you get everything you need.

-You state "a contacts friends". Is there a min or max amt to this? Can one person have 20 friends and someone else have only 2? Can someone have none? If so, you might be better off creating this letter in an Access Report rather than word. -You also stated that there would be a field...

Do the fields your importing contain calculations? Also, check the field formats between the two and make sure they are the same.

You state that its a peer to peer network, but have a database server. How exactly is it networked. Why did you upgrade it in the first place. I think if some basic restructuring of the network environment were to happen, you would see signifigant increases in speed. Has anyone ran any diagnosis...

No problem, sorry i didnt get it the first time.

In the ON OPEN event for the report, you could add the code to make the group headers visible property false or true. Me.GroupHeader0.Visible = True or Me.GroupHeader0.Visible = False You would have a refrence like If form1.chkbx1 = True then Me.GroupHeader0.Visible = True Else...

How do they open the report? I would think that you have a GUI that they use to open it, so add a few controls to it that allow for them to group by certain fields if they want to. Then open the report with conditions set on thier selections or lack of selections. This would allow you to use 1...

If I am not mistaken, you will require a fullversion of adobe acrobat. Once you have this, you can compile documents into pdf files as easily as sending something to a printer. You would have to first run the process of converting the file/report into the PDF format, then retrieve it and send it...

Have you check the level of security assigned to the shared drive / folder? In most environments this is inherited, so if the folder has restrictions, they are applied to everything in it.

See how restrictive the settings are. Assuming you are running a windows OS, open MY COMPUTER and see what drive letters are used. Pick a letter NOT in use and open the command prompt/DOS window. Type in this and substitute Z for whatever letter you picked net use Z...

Check and see if the VPN clients are part of the same workgroup. If they are not, this could cause errors in allowing them into the shared resources. Also, I would check with the network admin as to the specifics of the VPN connection. Maybe he could allow for a modification to the connection to...