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