Search results for query: *

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...

More details: Have switchboard with buttons. Each button trigger a transaction in another access Databases. The code to trigger the transactions is: Function PaxRemediation() Dim siteStr As String siteStr = "Site1" Dim objAccess As Access.Application Set objAccess =...

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...

Thank you. The problem was that the technician that install SQL server did not provided me the "sa" account password. Therefore, I have the DBA to provide my NT ID the proper access. Thank you all for collaboration and helping me identify the root cause. Luis

I tried the recommendation to create a new database. However, now I'm getting a permision error. I'm using the Management Studio SQL and I'm making the assumption that when I open it, it creates an instance of SQL server in the client. This assumption looks like is not correct. Wonder if I need...

In the wizard I selected to use NT authentication. Wonder if that's the problem. Luis

Did what you asked. However, get permission denied. Any suggestions? Does not make sense because the 2008RS is on my client. Thoughts or ideas. Thank you, Luis

The tool that I'm using is Microsoft SQL Server Management Studio. Not sure that the tool has that capability but not sure. Thanks for help. Luis

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

MajP your suggestion/recommendation work great. Thank you.

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

Thank you Andy for sharing your expertise. Your suggestion/recommendation work.

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...

PHV - it helps. How did you figure out that was a Null issue.

Yes I'm sure the value is "Exclusion". Yes, I created a query equal to "Exclusion" and it displays all the record with exclusion. Then if I change the = "Exclusion" to <> "Exclusion" then I don't get nothing on the query. I'm really confused. Thanks, Luis

The from that you mentioned is for the sub-query not the primary query. However, thank you for feedback.

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