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...
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...
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
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
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
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
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...
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...
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
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...
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
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
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...
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...
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...
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.