Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 101287
  • Content: Threads
  • Order by date
  1. 101287

    Replica Database in MS Access

    I have a replica database generated with MS Access 2010. Because Access 2013 does not support the Replica database I need to convert the Replica database to MS Access 2013 Database. Does anyone have any guidance and/or "how to" accomplish this task? Or do you have any articles that I can read...
  2. 101287

    Message display on access database

    I have an access database that works like a switchboard. It call components (transactions) in other databases. However, when processing a transaction from the switchboard in the other database I would like to display the message from the other (transaction) database in front of the switchboard...
  3. 101287

    Quick question - MS Access upsizing to SQL server

    Does anyone know how to debug the errors when upsizing an access database (2010) to SQL server using the wizard? I tried to upsize the table but fail with no explanation to address the failure. Platform: Windows 7 OS/Office 2010/Ms Access 2010 Suggestions or guidance will be appreciated. Luis
  4. 101287

    How to requery record source in subquery

    I have a form with a subform. I would like to requery the subform by changing the roecord source in the subquery. Can someone let me know how to do that in vba. Need to do that to refresh the suform query information. Your guidance and assistance will be appreciated. Luis
  5. 101287

    Ms Access Web application

    Does anyone recommend an access book to learn Ms Access Web application development? I have search for book and/or articles but have not find one that provide good training on the subject. Guidance will be appreciated. Luis
  6. 101287

    SharePoint - Alert Icon

    Does anyone knows how to change the icon on SharePoint 2010 for the email alerts for a particular list? I have been searching but have not being able to find a solution. Therefore, you assistant and/or guidance will be appreciated. Luis
  7. 101287

    Help with Query - guidance needed!

    Need your guidance and/or help! Need query to rSead table and exclude records including wildcards from another table. The query developed is below. However, the expected results are not correct. Could you please advise and/or share expertise to fulfilled requirement. Thanks, Luis...
  8. 101287

    Query does not exclude the records with "Exclusion" on it.

    Can someone please help me with the query below. I am trying to exclude the records that have "Exclusion" on a field and the query is not excluding them. Not sure what is the problem with the query. Guidance please. SELECT tblDNSaudit.DNSName, tblDNSaudit.IP, tblAuditIdDescription.Category...
  9. 101287

    Writing to SharePoint list 2010 from Ms access

    Need guidance and/or code example. Need to create macro in MS access 2010 that write to a sharepoint 2010 list. For example, a table is update in access once the table is updated a macro needs to be trigger to add item in a sharepoint list. Your guidance will be appreciated. Luis
  10. 101287

    ADO for Excel Connection to access

    I would like to connect to an MS Access Database 2007 (Office 2007) and open the database and execute a query. I have the following code in Excel but I'm not able to get the database open and/or query to execute. Can someone let me know what I'm doing incorrectly.Get object error in Set...
  11. 101287

    Zoom Box Form

    When I used the Zoom box (hit shift+PF2) the content has a dark background. Then I need to click on it to get a white background. Is there anyway that I can eliminate the dark background when I trigger the Zoom box. Any guidance or suggestions will be appreciated. Luis
  12. 101287

    Access 2010 support of mdb extension

    Need to know if what I heard regarding that an access database with an extension of mdb once is change in access 2010, then the database is not operational is a "true" statement. Your feedback will be appreciated. Luis
  13. 101287

    Shrinking and expanding comment line in form

    I would like to know if someone could direct me to articles and/or code samples in vba to add functionality in access to enable a form comment line to be expanding or shrinking. For example, the user can click on icon and expand the comment line then click it back to shrink the form. I have...
  14. 101287

    Size form in Ms Access 2007

    I have a form that I would like to keep the same size that I designed instead of able to increase the size or able to maximazed it or change the size. Can someone let me know the parameters that I need to change so that none can change the size of the form. Thank you for guidance. Luis...
  15. 101287

    Email data collection question

    Environment: Ms Access 2007/Infopath 2007/Outlook 2007. When I use Ms Access 2007 to collect data via email and generate an InfoPath form, can I change the form (color, title etc) save it and then resent it and be able to keep the data collection functionality? Need to know if that's possible...
  16. 101287

    VBA Coding to override form

    I'm using ms access 2007. In the ms access application options I have a form to be open when the application is open. For example, in the Display form I have frmStart. Would like to check the display form object in the application options and override the form with a different form If an...
  17. 101287

    Open Form when Database Open

    I'm using ms access 2007. In the ms access application options I have a form to be open when the application is open. For example, in the Display form I have frmStart. Would like to check the display form object in the application options and override the form with a different form If an...
  18. 101287

    Ms Access 2002 vs. Ms Access 2007

    Could I copy an access table (2002) to an access table 2007? Or are they any constraints copying from one version to the other? Guidance appreciated. Luis
  19. 101287

    Transfer and/or replace Db

    Need some guidance reqarding how to copy a database in a testing environment to a production platform. The problem that I have is that I generated database in a testing environment and then I need to replace those database in the production environment. Need to know if there is a way to copy...
  20. 101287

    Find code not working - Form

    I have the following code in my access application. The works 95% of the time but in ocassion it does not retrieve a record in the table. Can someone provide some guidance to correct this problem. Or work around. This code is execute when the custmer enter a number on a form and the record is...

Part and Inventory Search

Back
Top