Search results

Hi MSLady, I hope you had a lovely Easter as mine was great. I suppose with the conversion from lower case to upper case, you could always convert both table data required and entry comparison string so it does not matter what is in the table and/or what is entered to compare both will end up...

Hi Sounds problems with your system files. Not sure what version of operating system you have but maybe try at a command prompt; It will require you to have your operating CD. Good Luck Robert88

Hi rubyred77, Check this link; http://www.access-programmers.co.uk/forums/showthread.php?t=104913 One of the attachments SampleSearch2003.zip accomodates what you are wanting. Good Luck with it. Robert88

Hi All, I see no one else has any detail in the "Group Membership", so is it safe to assume that it is not accessible by members.......? :eek: Robert88

Hi fulltime, Not sure if this will work but what happens if you place on the end of your code Excel.Application.Close Robert88

Hi IanT Here is an example; Use ALTER COLUMN to change the data type of an existing field. You specify the field name, the new data type, and an optional size for Text and Binary fields. For example, the following statement changes the data type of a field in the Employees table called ZipCode...

Hi paulS30berks, What type of fields do you have these values stored in, as this is going to make a difference to how these are calculated? Robert88

Hi despatcher, You'll only need one table for this, just include a department field. Then use a query for each department (dept 1,2,3) to get information for each department, then for admin have another query that has all information. Robert88

Hi ShepHeard, Screen resolution If you cannot reduce the form size is it possible to increase the screen resolution (obviously dependant on the form size, this will depend on what screen resolution you increase it too, if possible?)? With a screen resolution increase (dependant on your screen...

Hi If you open the form in design view and select the form properties, goto the "Format" tab and change Record Selector from "NO" to "YES". This will then give you a bar on the left hand side of your form while you view it. If you select the bar and hit delete it will allow you to delete the...

Hi TJBernard, By default the kodak image viewer is the default image viewer of Windows XP. Windows 2000 did not have this viewer, hmmmmm..... Is the viewer installed on your Windows 2000 machines? Has this file been registered on your Windows 2000 Clients? Does the file exist on your...

Hi RaptorZ Maybe you have lost your link, using the connection manager you can re-link it if you know where the BE is located. Robert88

Hi Lee Pearce Check this connection; http://www.fontstuff.com/access/acctut10.htm Robert88

Hi TJBernard, What operating system are all these users machines running on? Robert88

Hi Joshann, With your tables being so general it is hard to determine if it is correct or not. I suppose the relationship it has will depend on the context it has with the content of what is in the databases.:rolleyes: The information that is to be input into the tables has a relationship...

Hi mohammadagul, I suppose this all depends on the equipment used to connect to the internet. The equipment will vary the connection to the outside world from your BE. For ful bore secured office, you might consider servers, ISA Server, firewall, routers, VPN tunnels (to secure conections)...

Hi shepHeard, Is it the subform you talk of transposing? If so go to its default view property and change it to datasheet view. Hope this helps. Robert88

Hi Saharlan, One line in your code needs changing (shown red); Old Code; DoCmd.TransferText acImportDelimited, "VartecImportSpec", "tblVartecImport", strFolderPath & objF1.Name, False New Code; DoCmd.TransferText acImportFixed, "VartecImportSpec", "tblVartecImport", strFolderPath &...

Hi alwynb Check this link; http://www.access-programmers.co.uk/forums/showthread.php?t=101435 Good Luck with it.:p Robert88

Hi MSLady, I have come across this problem before. Solution, restrict the input of the data to either UPPER or lower case, in my case I made all input entries UPPER CASE. Here is an example of conversion to UPPER CASE. :p Dim LowerCase, UpperCase LowerCase = "Hello World 1234" ' String to...