Search results

Hi, I'm having trouble with with auto correction (red lines etc.) showing under words spelled wrong. The option for auto correction is turned on, but it does not show. As far as I can tell, everything seems to be set correctly. I have also tried re-installing Office 2007, without any luck. Any...

Hi! Does anyone know how to reference the properties of an Access diagram object inside a form, for example the diagram title? Thanks in advance

Hi, I'm sending an e-mail each time a spesific report is made. If the user has'nt opened Outlook, it is placed in Outlook's Outbox, and is sent first when the user opens Outlook. Can I somehow start Outlook using VBA so the email gets sent when the report is run? Also, The user is prompted...

I need to register the activX control Date Time Picker. I'm struggeling doing so, Could anyone guide me in the right direction please. I'm using A2k3 Thanks in advance

Hi I'm using DoCmd.OutputTo acOutputQuery, "qselAccAnDataToFile", "*.xls", strLoc, False to output query data to Excel. Works fine. The Excel file is an old file format even though I have Office 2003. If I omit the output format, I'm prompted with a dialogue box which I can select the format...

Hi I'm using the activeX control Date and Time Picker which work fine. I'm having trouble though to set the MaxDate and MinDate from VBA. For instance me.DateTimepicker12.MaxDate="01.01.2008" returns an error 'Invalid date......'. I have tried many different formats for the date, but not the...

Hi Is it possible for an user to have access to only one folder on a network drive and no other folders or files on the network drive. Most users has full access to the network drive and belongs to a group called 'Everybody'. One user however, should only have access to a spesific folder on...

Hi all I have a numeric field in a form which initially is set to 0. When the user clicks or tabs to this field, it is blanked out in the got focus event by setting the field to "". This works great. Now, if the user exits the field by clicking elsewhere or tabing out of it, without entering a...

Hi I am looking to upsize a Access BE database to SQL Server. The FE database will still be MS Access. I would like to keep the FE as it is and use an ODBC connection to the SQL BE database. My problem today is that I need better performance since we are using the database over a WLAN...

Hi, Is it possible to check using VBA, if the connection for linked tables are OK? Thanks in advance

I am having problems logging onto the company LAN using a laptop computer. My company uses a domain, and our local server is running MS Windows 2003 Server. The IT departement of my company is trying to solve the logon problems, but they haven't had any success yet...(after many weeks!). This...

Hi! I was just wondering about the relationships between tables in a split BE/FE setup. If you have set up the relationships in the BE, do you need the same relations set up in the FE relationship window? Any insights to this will be greatly appreciated. Thanks in advance.

Hi I have a main form called Shipments. For each shipment of goods there will be an entry to this form. My problem is that I want to add records for each shippment details from a selection 'form'/listbox or something else. When I check a checbox called 'shipped' - the record should then be...

Hi all, I've set up security on my database before with great success, and now I'd like to use the same workgroup file (a copy with a new name and location) to secure a nes db. I open the new db, and join my earlier created mdw file. I'm prompted with that I have joined my workgroupfile. I...

I have a split database. BE located at a server and FE on each users workstation. There are 8 concurrent users at the most. This runs smoothly over the LAN. Now I'm adding a new feature to the database. I'm using a wheel loader to weigh products on a weight scale. The operator in the wheel...

Hi, I have a left join quert that's not working as it should The query is like this: SELECT tblProsesstider.CID, tblProsesstyper.PTID, tblProsesstyper.PBESKRIVELSE, tblProsesstider.CID FROM tblProsesstyper LEFT JOIN tblProsesstider ON tblProsesstyper.PTID = tblProsesstider.PID; The problem...

HI Is it possible to get more than 1 column per page in a continous form? TIA

Hi! I'm running a split MS Access database. Backend at the server and front end at each workstation. Now we want to use the database on a laptop with a wireless LAN adapter. The laptop will be placed in a loading vehicle which drives all over the company's site. When the laptop looses it's...

Hi! I want to update some records in one table from another table. How do I do this? I see how I can increase a value by 5% by setting the 'Update to' field in an update query to '*1.05', but I want the new value from another table. Thanks in advance

KHi, Is it possible to get the number of records selected on the record selection bar using VBA? TIA