Search results

Hi All Im trying to create a project file, when the wizard shows up it asks me to select a database to connect to. However in the list box it doesnt show any server to connect to despite having SQL Server 2005 installed on my computer. Im trying to connect to the Northwind Database for SQL...

regarding this sample db: http://www.access-programmers.co.uk/forums/showthread.php?t=155950 David i think your a genious couple of questions, how did you get the name of the computer that is being used, i.e the id of the user, is it something to do with the openschema in a code? what is a...

Hi All I have the following expression in my text box. But sometimes it return #Error. How can i trap this error so if it occurs then it will read 0. Thanks

Hi Gary What do you mean by samples?

Hi All I have a database that i located on a shared drive. Is there a way of telling who is accessing the database in any one go? i.e. a hidden system table that tells me this? Im trying to populate my treeview control with users who are accessing the database. Any help is welcome. Thanks

Hi All I have a bound OLEAttatchment in my Form. Im trying to unlock it then add a file then lock it again. The lock will not execute. Can someone help? Private Sub btnattach_Click() On Error Resume Next Dim sFile As String With Application.FileDialog(msoFileDialogOpen) .Show...

Hi All I have a database that has a Main Page which has gives the user access to many different sub forms. The problem I have it when a user selects one of the subforms or datasheets the Main Page, The Main Page then either minimises itself or shrinks its self down to size. I need my main...

Hi All I have changed the application title to what i want. But when the main menu pops up i.e. the menu with all the tables, forms, queries, macros etc, then it has the title of my Application i.e. "db1 Database(Access 2002 - 2003 file format)" ... how can i change this to something else...

Hi I cant get the Dlookup to work. =DLookUp("notes","tblcalendar","Date=" & [dtpicker1]) if i change to the following then it works =DLookUp("notes","tblcalendar","Date= #01/01/2008#") How can i get it to lookup the dtpicker1 to work? Thanks

Hi All I have 31 text boxes on my Form. Each representing a day in the month. I also have a combobox at the top of the form that list January - December. How can I have a form where the user can select the month in the combobox and type the information into anyone of the textbox...

Many thanks. You've gone down in my book of Legends :) I did try the following code but it didnt execute. Nevertheless yours works great. Me.oleAttatachments.SetFocus Me.oleAttatachments.Action = acOLEDelete

Hi again Thanks for all your help. I have one final question, how can i assign my button called 'btnDelete' to remove the ole obect which i have embedded into my form? Thanks

I must say that your a star!!!!! Works Perfect. Though, do you think its better if i was to link the onject rather than uploading it into my database - this would make my database much smaller. However, if someone was to move the files around then i suppose the link would become broken and...

Hi I was wondering if there is a way that i can add an attatchment to a form field where the field is an OLE field. for example, i can right click the OLE field and it gives me an option to add and an OLE, but i dont want the user to have to right click the form field to add the OLE every...

many thanks, works great :)

Hi All I have a query called 'Query1' ebmedded in to my search form called 'Form1'. I want to create a button that allows the user to export all the information displayed in the 'Query1' that is embedded within the form. How can i do this? Thanks

Hello I have a query within my form. I want to change the record source so it filters information down. im using the following code but will not execute. --------------------------------------------------------- Dim sSQLall sSQLall = "SELECT * FROM qSearch"...

Hi All I have the following SQL statement that will not execute. Can i get someones take on this. SELECT qrysearch.* FROM qrysearch WHERE IIf(IsNull(Forms!Search!tbxDate),[monthly report] Like '*',IIf(Forms!Search!cbxOptionDate="Equals",CDate([Reporting_Year] & "/" & [Monthly Report] &...

Hi All Im having trouble with the following SQL statement. SELECT qrysearch.* FROM qrysearch WHERE IIf ( ISNULL ( Forms![Search]![cbxDivDirector] ) , [DIVISIONAL DIRECTOR] = "Eric Daniels", [DIVISIONAL DIRECTOR] = Forms![Search]![cbxDivDirector] ) My problem is in the WHERE clause...

Many thanks Bob