Search results

Create a new module with this code. Option Compare Database Option Explicit Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation _ As String, ByVal lpFile As String, ByVal lpParameters _ As String, ByVal lpDirectory As String...

Open up Query2, change to SQL view and paste this code to fix it. SELECT Authors.ID, [LastName] & ", " & [FirstName] AS Name FROM Authors;

Hi there, I have two versions of a database going right now. One of them is a live version and the other is a development version. I am making changes to the development version and then importing the forms with the changes made into the live version. I've run into a strange phenomenon. I...

Hello everyone. Here is what I would like to do. Right now I have a form that outputs a csv file (which the user names) to a certain folder called 'output'. What I would like to do is allow the user to specify the location of the file in case they don't want to put it in the output folder...

I was able to figure things out eventually. Here is the solution in case anyone comes across this thread in the future: strsql = "Insert into tableA SELECT tableB.Variable1, tableB.Variable2, " & combo_box.Column(0) & " as VariableA FROM tableB;" DoCmd.RunSQL strsql The syntax was quite...

Anyone?? Here is what I have so far. I keep getting an error saying that I need to add an exists statement. Where exactly am I supposed to put one? strsql = "Insert into tableA Values((SELECT * FROM tableB), " & cmb_box.Column(0) ");" DoCmd.RunSQL strsql

Inserting portions of a table and data into another table Hello. I would like to take an entire column of values from a table (lets call it table1) and a value that a user enters on a form and merge them together and then insert them into another table. So if table1 contains...

The thing is, the hyperlink is not a record. Are you saying the only way I can do this is if I make a table with hyperlinks?

Hello, I have a command button, which when clicked opens a document stored on a network via a hyperlink address. I would like to set up a txt box for administrators of this database so that they may enter a new hyperlink address for this command button in case the document is moved to another...

Thank you.

Can anyone tell me how I could get a subform to change its record source by changing an option button on the master form? I've done searches on the net and I'm shocked that I can't find this. It seems like it would be a common thing to do.

SELECT DISTINCTROW [T_NNI].[ID], [T_NNI].[NODE], [T_NNI].[FRNNI/FRATM], [T_NNI].[GATEWAY] FROM [T_NNI] ORDER BY [T_NNI].[NODE];

You have it right. The thing is, its not working. For simplicity's sake lets assume the field name is "Yes/No". In the properties->rowsource part of my combo box I have the following query entered: Select field_name from table_name where table_name.yes/no = value; The above query does not...

You forgot the "Endif" statement. A different approach might not be a bad idea. An group of option buttons might be better than 2 check boxes since you only want people to choose one at a time. If you insist on using check boxes you can place code in the Click Event of each check box that...

Hi guys, Hate to ask a question twice in the same day but... I'd like to know if its possible to run a query on a table with a "/" as part of a field name. I'd like to place the query in the properties/rowsource portion of a combo box. I've tried brackets and a bunch of other stuff but I...

Awesome. Thanks for the help guys and for the quick response.

Hello, I am trying to export a table generated by a query. I am using the following line of code to output to a file. DoCmd.TransferText acExportDelim, , MyTbl, "C:\whatever\" & ExportName & ".txt" This will generate a comma delimited text file with the results. What I would like to do is...

It means that one of the text fields has changed. The form has been altered, tainted, therefore dirty.

Thanks Mile.

Hi guys, I have a form with a few text fields in it. What I want to do is have a msg box pop up if the user leaves the form and the form is dirty. The msg box would then give the user the opportunity to save the changes or cancel before moving to the next form. What I've done that works, is...