I made form by wizard, but when I run this, first I have in fields first record from table, and I can edit this record, but I don't want to have this. I want to have blank field and when I click add button i can add new record, not edit.... ...
I am using the Shell() function to execute an external application in MS Access. Shell() returns a task ID of the specific process that was started. I need a way to check if that process is still running or if it has closed. I'm sure that I will need to do some sort of windows API call but I can't seem to find anything just now. ...
REPHRASING QUESTION: i apologize for being unclear. i have a textbox and a button a form. when the button is clicked it runs this saved access query: select * from sqlservertable where field=form!textbox.value i have an access front end and sql server back end. this query is not working. it doesnt like me passing this parameter form...
Hi, I have a dropdown that is bound to a column in an excel spreadsheet. I select a customer in the dropdown and then populate some address fields with related data also from the excel spreadsheet. Code: Private Sub cboCompany_Change() Dim customerName As String customerName = cboCompany.Value custo...
Is there a way to check if an OLEObject has a LinkedCell property? For example labels and buttons don't have linkedcells while others do. I am trying to write a piece of code that can replace the linkedCells by looping through all the OLEObjects in a sheet. Thanks in advance. ...
I have an import which I made with the wizard, at least far enough just to save the specification. It imports CSV files, with headers, quote text qualifiers, and comma delimited. I then use the import specification in some vba that fires from a button click event. Here are some things I am wondering: So if the fields in the data are ou...
I have a long list of origins and destinations in Excel, using webquery I can fill in the cities and postal code to give a webquery like: http://maps.googleapis.com/maps/api/directions/xml?origin=Scoresby&destination=Melborne&sensor=false This returns me a long XML file, but all I need is just the distance. Is there a way to ex...
i would like to distribute an access front end to some people and i want to make sure that they do not edit anything in it; however when i change the extension to ACCDR it makes all the forms and tables disappear. what settings do i have to change in order for them to be able to open forms but not view them in design view or make any cha...
Suppose i have my mailbox configured and i have a special folder for mails with attachments in outlook 2007. What i want to do is i. either configure outlook to save the attachment of mails coming in a specified folder (Mails with Attachments) to specific folder in my computer drive in a desired folder ii. Or if i can write some macro ...
i am having a problem with access sql SELECT statement. the problem is that when the backend is ACCESS-2007 it works; however when the backend is sql-server-2008, it is not returning anything. here is the statement: SELECT IIf([Lab Occurrence Form].[1 0 Preanalytical (Before Testing)] Like '*1.11*Other*','1.11 Other',[Lab Occurrence For...
i have an access front end. users need to be able to open a table and edit the contents of a table. this is a multi-user application. please note that i do not care that i might run into problems with people editing the same data. how do i allow a user who only has the access RUNTIME to be able to edit and view a table? how do i force ...
i have an access front end and sql server backend. i would like to know which users are currently using the database. is this possible to do using access or sql-server? ...
i am distributing ms-access-2007 front ends. the back end is sql server. a user will click on a button and it will return a query from the sql server 2008 database. is it possible to requery this query if the user clicks the button again? usually the behavior of access is that if you query it again, it displays old results. how do i m...
Currently, my VBA code creates a single file for each note. Here's some simplified sample code: Sub saveNotes() Set myNote = Application.GetNamespace("MAPI").GetDefaultFolder(olFolderNotes) For ibi = 1 To myNote.Items.Count fname = myNote.Items(ibi).Subject myNote.Items(ibi).SaveAs "C:\Temp\" & fname & ".txt", 0 Next ...
Hi all. I know this is a total noob question, but can anyone tell me why this function always returns 0: Function Cd(Re As Double) Select Case Re Case Re < 1 Cd = 24 / Re Case 1 < Re < 1000 Cd = 18 * Re ^ (-0.6) Case 1000 < Re Cd = 0.44 End Select End Function Whenever I call it in the spreadshe...
is it possible to detect whether there is an open query using VBA in access-2007? i am opening a query like this: stDocName = "Meeting_Reasons_Frequency" DoCmd.OpenQuery stDocName is it possible to detect whether it is open? ...
I'm working with a dynamic array in Excel VBA. The number of columns (m) is fixed, however, I do not know how many rows (n) will be required. The help documents state that ReDim Preserve myArray(n, m) allows me to make m larger, but not n. However, I need to increase the number of rows (n) while preserving my data, not columns (m)! F...
In an MS-Access form, I have the following code attached to an event: Dim frm As Form, rs As Recordset Set rs = Me.RecordsetClone 'do some stuff with rs ' rs.Close Set rs = Nothing Set frm = Nothing My question is: is the rs.Close required ? Is it even good (undesired side effects ?) ...
Two-headed question here guys, First, I've been trying to do some searching for a way to read .xlsx files in python. Does xlrd read .xlsx files now? If not, what's the recommended way to read/write to such a file? Second, I have two files with similar information. One primary field with scoping subfields (like coordinates(the primary ...
I am attempting to emulate a (no longer existing) mainframe report generator in an Access 2003 or Access 2010 environment. The data it generates must match exactly with paper reports from the early 70s. Unfortunately, the earliest years data were run on hardware that used IBM floating point representation instead of IEEE. With the help o...