Search results

Thanks for all your help and quick response. Steve

That sounds interesting. Having had a very quick trawl on the net for the definition of a junction table. At the moment their is a company table (holding company data), and business type table (holding business codes and their description). This is currently linked by a limiting one to one...

Hi everyone. I've just started a new role as Database Manager, and have been tasked with identifying problems with their current, 15 year old relational database (4D). Generally speaking it's a contact management database designed for targeting specific business markets for specific conferences...

Don't worry everyone, found the query property I was after.

Hi, I've been given a flat-file database to 'improve'. One field is simply titled 'Room' and refers to a room number in a school. I want to create a MakeTable query that will run through all the records and make a table containing one instance of each room number (for normalizing). Hope that...

Thanks PeterF. That's great to know for future reference but I just discovered Application.FollowHyperlink and used that instead. Thanks again.

Nope, I had tried that before the code I posted above. Changing it to this; Call Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE" & MyFilePath, "", vbMaximizedFocus) produces the same error; Wrong number of arguments or invalid property assignment.

I have the following code; Private Sub cmdProof_Click() Dim MyFilePath As String MyFilePath = "N:\Pictures\" & Me.txtBanID.Value & ".jpg" MsgBox MyFilePath Call Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE", MyFilePath, "", vbMaximizedFocus) End Sub I know the...

Erm...thanks, I missed out the full-stop before FindFirst and it works fine/ :) Thanks again.

OK, I've popper this code in; Now, if I'm reading this right, the first line says "work on the records in frmBannedUsers (parent form). The second line says "find the first record that contains the value of txtBanID". txtBanID is the name of the textbox we double click in the subform, and...

I have a form with subform...they are not linked (the form shows the table data directly and the subform shows a query of the table). The subform is set as a continuous form. I want to double-click on the unique field to open that record in the parent form. I have something similar in another...

I'm not sure what's happened with this thread, but yesterday there were about 4 or 5 replies before lagbolts which have mysteriously disappeared. It basically culminated with a post by myself saying I had fixed the problem. Very strange! Thanks anyway for the response you guys.

Well, I decided to stop trying to get the above to work and decide to code again from scratch. Why this works and the above didn't I don't know, but it's simpler and does the job fine. Private Sub Form_Current() Dim MyFile On Error Resume Next MyFile =...

OK...that's pointed me in the right direction, but not far enough it seems. Latest attempt: Private Sub Form_Current() Dim MyFile On Error Resume Next MyFile = Dir("C:\Pics\" & Me.txtStudentId.Value & ".jpg") If MyFile = ".jpg"...

Actually, I've progressed a bit...sort of. Private Sub Form_Current() On Error Resume Next Me.imgEmpty.Picture = "C:\Pics\" & Me.txtStudentID.Value & ".jpg" MsgBox Me.imgEmpty.Picture If Me.imgEmpty.Picture = ".jpg" Then Me.imgEmpty.Picture = Null...

I wasn't sure whether to post this in the form forum or here, but it's coding related to a form, so here I am. I have a simple form that uses a combobox to select a student. Selecting the student autofills the txtStudentID text box. I have a picture box, and the form has some code; Private...

I wasn't sure whether to post this in the form forum or here, but it's coding related to a form, so here I am. I have a simple form that uses a combobox to select a student. Selecting the student autofills the txtStudentID text box. I have a picture box, and the form has some code; Private...

Thanks, I'll have a crack with that.

Right, I've been staring at this problem and am still not sure what to do. I've set up my references as required, but there's no real inbuilt help for Access for this (that I can see)...I've also searched the forum for FileSystemObject, but I can't find anything relevant. I know (sort of) what...

Thanks, I'll have a look at that.