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: vbajock
  • Content: Threads
  • Order by date
  1. vbajock

    Bluetooth file transfer as an object

    Has anyone manipulated Bluetooth file transfer as a programmable object where you can feed it user name and file names etc so the user doesn't have to it manually?
  2. vbajock

    Hyper-V physical server unexpectedly created a snap shot for a VM

    Hi all, I am trying to figure out why a snap shot unexpectedly showed up on one of our production servers. This caused a big performance issue and we had to reboot the physical server to deal with it, as the VM was also stuck in the "backing up" mode. Anyone else ever encounter this? I can...
  3. vbajock

    Conditional Statements in app.config

    On a network that has both 32 and 64 bit machines, I am having to edit the app.config files to deal with this: <add key="ConnAccessDir" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files (x86)\SomeDir\SomeAccessDbDir\" /> which I have to manually change to this: <add...
  4. vbajock

    New version of Access, where is the Save As option?

    vbajock (Programmer) 17 Apr 13 16:05 Access 2013, talk about screwing up a good thing, you just can't find anything. Same with Windows 8. I have a query open and I want to save it under another name so I don't wipe out my original query, and I can't find the stupid Save As button for the...
  5. vbajock

    The new version of Access is a PIA. Where is the Save As option ?

    Access 2013, talk about screwing up a good thing, you just can't find anything. Same with Windows 8. I have a query open and I want to save it under another name so I don't wipe out my original query, and I can't find the stupid Save As button for the life of me. Anyone know where it is?
  6. vbajock

    How can I view the SQL statement a View is based on?

    Using SQL Server 2012 Management Studio, I can pull up the view in design view, I can see the graphical representation of the view and under it a listing of columns, is there any way I can see the complete SQL statement that generates the view?
  7. vbajock

    Bad keyboard lag time

    Has anyone experienced this? At first I thought it was the network I was on, but I copied my development mdb to the local hard drive, and it still does the same thing, and it is only doing it in access: whenever you type a keystroke, or select a group of controls using the mouse, there is a...
  8. vbajock

    RAM usage

    We have a pretty simple setup, a single server running two instances of SQL Server, a 2008 instance that runs our ERP and then a SQL 2000 Development server that is primarily legacy stuff. The server has 16 gigs of RAM. When you look at the Task Manager's screen showing RAM usage, it shows 1.7...
  9. vbajock

    64 Bit adventure

    I have a Access 2003 apps attempting to run on a new 64-bit Windows 7/Access 2010 box. The code refuses to compile API calls. According to various web sites, this is supposed to be the fix, but I can't get it to work. The 2010 box will not compile the code, it highlights the 32 bit call in the...
  10. vbajock

    Different behavior of Identity Field inserts on different SQL instances.

    I am writing a VBA conversion program that is intended to convert legacy Access data to SQL tables. I have run into a problem with the Identity columns on the SQL target tables - when I want to refresh the new SQL tables with additional records entered from the live Access tables, SQL will not...
  11. vbajock

    Stop users from displaying the database window

    Well, I put this program together that allows me to set database properties from a form, and the MSDN documentation stated that if I disabled the Special Keys and Display Database Window properties, the user would not be able to toggle the Display Database Window in the Startup Dialogue. Guess...
  12. vbajock

    Fomat Columns.NumberFormat for Yes No values

    I need to format a column that contains 0 (for false) and -1 (for True) with Yes or No. Is there a format using columns.number format that will do this? Thanks
  13. vbajock

    Having trouble with correct T-SQL syntax for linked server trigger

    This is the first trigger I've ever created, so bear with me.... First off, I created a linked server called "LDOS" . In the parent server that hosts the server link, I am trying to create an inserted record trigger that will insert values from the inserted record, into a table located on this...
  14. vbajock

    Font color for System.Net.Mail subject line

    Anyone know how to format the subject line so it appears in red in the user's Outlook InBox ? My code: Dim mail As New MailMessage() Dim sSubjectLine as string ="URGENT: ACTION REQUIRED!" mail.Priority = MailPriority.High mail.Subject = sSubjectLine.ToString ??-> code for changing font...
  15. vbajock

    How to determine if an email has NOT arrived using Outlook VBA

    Does Outlook have anything similiar to the OnTimer event in Access that would allow me to monitor an Inbox continously in order to determine if an email alert which should arrive hourly has indeed arrived? Or if not,is there some alternative method to do the same thing? Thanks in advance for...
  16. vbajock

    Preventing record deletion

    I have a table that I do not want any records deleted from unless I myself delete the record manually. Is there anyway to set a property on this table in SQL Server so that records can only be added or edited but not deleted by any programmer or user who accesses the table via ODBC/OLE Db? The...
  17. vbajock

    Folder rights for attached database

    If I have a backend database that supplies data to my front end application in a seperate folder, what rights do I need to give to the front end users on the back end folder? I want the front end to read and write data to the backend, but I don't want the users to be able actually open the back...
  18. vbajock

    Anyone using Dragon Voice Recognition software with Access?

    Is there a VBA object for it? Any tips, tricks?
  19. vbajock

    Displaying .jpg's in SSRS

    I have a number of jpeg files that are technician signatures,that I wish to display at the bottom of my report. They were originally stored in an Access database table as "Ole bound image" type, the table had two fields, the text showing the technician's name, and then the blob field where the...
  20. vbajock

    Rulers available in the IDE ?

    I can't seem to figure out how one monitors page size when designing a report. Is there a setting somewhere that will turn on rulers or is there something else I could use? Thanks!

Part and Inventory Search

Back
Top