I would like to display strokes that I have saved previously on an inkPicture Object in Ms Access (it is on a form via ActiveX). The strokes are saved in a table as an ole-object in the field 'Strokes'. Now, doing it once is easy enough (one line of code), I can use this snippet without any problem : Public Sub loadInkImage(MyInkPic ...
I have a field in a table that I want to store a potentially long error string. To this end I selected varchar(MAX) as the data type. I have created a stored procedure that is used to enter that data in the table and for the field "ErrorDescription" I used the following parameter definition. @ErrorDescription as varchar(MAX) The probl...
I have two tables, UsersSample and UsersSearching. UsersMain is a table of the majority of available users. UsersSearching is a table of any users who have searched on the site. I am trying to determine if a user from USersSample has searched (and appears in the UsersSearching table). But I'm having difficulty even beginning this S...
it is possible to do it ? then how to do it ? ...
i have about 20 users who have their own access front end and write to a backend. i need to do an update to the backend, and every time i try to do it offhours, it seems that someone is still logged on because the file is locked! how do i get around this? i do tell the users to log off at the end of the day but a lot of them forget! is...
I have an Access 2003 report and some of the fields within the report are NULL. I can use conditional formatting to change the color and other aspects of the text-box control but what I want to do is to display "XXXXXXXXXXXXXX" in fields where there is no data (i.e. NULL). Can this be done using conditional formatting? ...
More out of curiosity than any real problem; the question came up today and I know I've seen 1899-12-30 used as a "default" date and a zero date in Access and older SQL Server apps. Just wondered why - where did that come from, and why isn't 1899-12-31 used then? ...
I am upsizing my back-end from Access 2003 to SQL Server 2008 R2. My pilot migration attempt went all right, but it appears the Access 2003 front-end won't play well. (I can make native links if I convert it to an .adp project, but then I can't modify the front-end; so it's back to .mdb, which uses (slow) ODBC links.) Apparently I s...
I will be writing a little Python script tomorrow, to retrieve all the data from an old MS Access database into a CSV file first, and then after some data cleansing, munging etc, I will import the data into a mySQL database on Linux. I intend to use pyodbc to make a connection to the MS Access db. I will be running the initial script in...
The system I'm building is attempting to read Microsoft Access DBs from a different system. I essentially need to be able to read the data, parse it, and do something with it. If I could somehow load it into an associative array, a database, or anything else, that'd be great. Our users will have to import these files themselves, so we c...
I have an application with the front end in Access 2007 (Access 2000 file) with the backend on SQL Server 2008. The application has been running for two years now and I have noticed that on some PCs the queries are taking forever to run while on others it runs quite fast. Each PC has its own file of Access, so they don't share the file. ...
Hi folks I have created an application form using MS Word and a whole bunch of form fields, and I have an Access db that can import all the data I need from this Word doc, thanks to this: http://msdn.microsoft.com/en-us/library/aa155434%28office.10%29.aspx Now everything works just fine (I even managed to get it to import into multip...
I'm trying to rebuild an Access adp application in Access 2007. I started with a blank database, linked the SQL Server tables I need with ODBC, and then copied over all of the forms from the original application. I then updated the data sources for the forms to go to the correct tables. When I open one of the forms, I get the error "Sy...
I am using Access 2003 and I have a form that collects some filtering criteria for the report. Once the criteria is entered the user clicks and "OK" button and the report is launched using the following VBA. DoCmd.OpenReport "ReportName", acViewPreview After the report is opened I issue the following command to close the form that col...
All right, I've got two tables in my Access 2007 database (well, more than that, but the question applies to these two...): part part_no ... supplier_id special_supplier_id ... And supplier supplier_id supplier_nm (NB: Caption="Supplier Name") special_supplier_flg Now I've built a query : SELECT p.part_no, s.s...
Hi, I need to write a query like SELECT substring(variable, startPosIndex, endPos) from Blah blah ; startPostIndex = indexPosition('#') endPos = lenght(variable) - 1; So basically my query to access will be SELECT substring(variable, indexPosition('#'), lenght(variable) - 1) from Blah blah ; The query that I have written to get if...
I would like the user to import the files into my Access VBA, I wonder if I can make the interface to be a bit like Windows Explorer: With the window split into 2 halves, user can highlight the directory on the left half, and then the right half will show the files inside (even better if it can filter the file with specific extension), ...
I am using this code for importing encrypted excel into access 2007: xlApp.Workbooks.Open FileName:=dlgOpen.SelectedItems(i), PASSWORD:=strPasswd It works nicely if I give the correct password, or nothing (I'll prompt user to enter the password again for they give a blank password), but not for wrong password, Access will prompt for e...
SELECT * FROM TABLE1 ID Name 1 SOF 2 USER I want query which can one or two or four .... times ID = 1 in row like What will be the Query of this in Ms.Access? ID Name 1 SOF 1 SOF 1 SOF 2 USER ...
Hey all, have managed to finish the database; but have run into a problem with something I did in the beginning. Basically, the calculations in the database are done using VBA code. Now I've run into a problem where instead of slecting just the last two years worth of data, it is now slecting and using data from more than two years ago. ...