Search results

I can't solve this one: I have Private sub Openfile_Click() dig G as Long Dim strDocpath as string strdocpath = "C:\Users\MvP\Documents\manual.pdf" G = Shell("RUNDLL32.EXE URL.DLL,FileProtocolHandler " & strDocPath, vbNormalFocus) End Sub The strDocpath is correct, but the file won't...

Hi, I want to add attachments. I want advice before getting started. I figure I could do one of two things: - use attachments in a table, storing the attachment in the db; - leave the attachments outside the db and hyperlink to it. The first solution is easy, but I prefer the second one...

I split my database. In the BE I have a table Sourcestab. In the FE I used a make table query to create Sourcestab_fe. I have a form to add records to Sourcestab (BE). I also have a search form searching through Sourcestab_fe. On opening the search form, I want to update Sourcestab_fe (add...

I have what I assume to be a newbie question: I'm creating a database that will soon be used by some others. In order to prevent unwanted changes in the structure of the database, I open up homeform with the following code upon opening the database: Dim i As Integer For i = 1 To...

Hi, I'm trying to hide labels on a report when text boxes are empty. The labels and text boxes are in the details section. I use: Me.labelName.Visible = Not (IsNull(Me.txtName)) Me.labelStreet.Visible = Not (IsNull(Me.txtStreet)) ... I put the in the OnFormat of the Details section...

I have no education in VBA. I developped some notions of it, though. Usually, I can solve the problems in my database with some copy and paste from this excellent forum. However, this time I don't manage. Here's what I'm trying to do: I have a form linked to a table that contains groups of...

I'm stuck again. Here's what i'm trying to do: I have a table with adresses with multiple fields (ia emailadress and a check box) I have a table with emailgroups with two fields: groupname and groupmembers. The field groupmembers is basically a string of emailadresses seperated by a...

Hi, I'm strugling with the following: I have an existing table with columns ResID, StID, WCID, Res, Com. StID and WCID are linked to other tables. The StID, WCID and Res columns look like this: StID WCID Res 1 1 12 1 2 12 1 3 14 1 4 15 2 1...

I have a table with names of persons. They all have a unique ID. I have a different table with a column which is linked with a one to many relationship to the unique id. I would like to be able to automatically generate the following: for every ID in the PersonsTable, I would like eleven...

I have a couple of controls on a form that I wish to hide/disable. So far no problem. However, I want them to be unhidden or enable when a certain value is chosen in a listbox on that same form. Any one any suggestions? Thanks in advance!

Hello, I will be forever greatful to anyone who can help me with this. Here's my problem: In a form based on a query, I want to modify al the records by using a command button. Here is what I have so far: When one clicks the command button, a form with three controls opens: Field (combobox)...

Hi everybody, I would appreciate any help I can get on the following: I have a form that is based on a query. What I would like to be able to do is to create a command button that allows me to change all the selected records at once. e.g. one of the fields is a text box containing relevant...

I fail to create a button on a form which opens another access database if clicked. Any suggestions anyone? Thanks!

I have the following code: For i = 0 To conMaxControls - 1 If f.Controls("cbxFld" & i).Enabled = True Then If f.Controls("cbxFld" & i).Value = strcbxFld Then f.Controls("txtVal" & i) = strKeyword f.Controls("txtVal" & i).SetFocus End If End If Next i strcbxFld is a string...

I have a command that creates a table1. However, when I run it two times, I get an error message because table1 already exists. That's why I used the command DoCmd.DeleteObject "Table1" in the Err_Create_Table section. However, when there is no table1, I get an error message. Is it possible to...

I have five controls named cbbx0 to cbbx4 on selectionform. I have a loop for i = 0 to 4. I have f set as forms!selectionform How can I refer to the controls? If have this For i = 0 to conMaxControls - 1 If f.["cbbx" & i].enabled Then ... But it doesn't work. Can anyone help me? Thanks...

Hi, I have the following problem: I have a search form that searches a table which is composed of various tables of other databases (built with append queries). Because the table is composed of different tables (of different people), their keywords may vary (basic list which can be updated by...

Hi, can anyone tell me whether it is possible to create a new table1 in which all the results of query1 are entered by using the select ... into command? I just don't seem to manage to do it. Thanks.

I can't find what is wrong in the following code: DoCmd.RunSQL "UPDATE Table1" & _ "SET Table1.Checkbox1 = False" & _ "WHERE Table1.Checkbox1 = True;" Can anyone help me out? Thank you.

Hi, I have a form based on a query. On the query is a button to print a report. Since a user may not want to print all records, I have added a checkbox on the form. The default value of the checkbox is false. The report filters on the checkbox being true. All is fine, when the user marks...