Search results

I like Access too. I've been using it since version 1 was released just after Noah released the animals from the ark. I've recently started using .net, mostly because customers then don't need to purchase Access and I don't have to worry about which version they are using. I still mostly use...

Create a recordset "WHERE First = " & me.FirstnameBox.Value & " AND Surname = " & me.SurnameBox.Value After opening the recordset: If Not .BOF And Not .EOF will return True if there is a record which meets your criteria. Therefore show a messagebox telling you so.

1) You don't need to set relationships in Access 2) You don't have to have a primary key either, but you ought to 3) You can create an index with duplicates but I don't know that this is very efficient

Sorry if this has been explained elsewhere but I couln't find it. I have a data editing form where I use several combo boxes to select the data in an Access back end. In Access I can simply create a recordset of the data I wish to edit then set the value column in each combo to the value in...

Thanks for your thoughts. I have tried delivering apps with the run-time version but its always a bit of a nightmare. The client gets teed off and I end up with a headache. I don't deliver run-time versions any more for those very reasons. That's why I was considering converting them to .Net...

I have been writing apps in Access since version 1, mostly to track business processes for small companies. By now I have sort of got my head around VBA etc. I have now managed to use .Net as a front end to an Access back end. The advantage of this being that the client does not need to own a...

As an alternative and maybe more flexible, declare a global date variable, eg pubStoreDate. Set this to the value of the feeding control before opening the new form. In the form Open event, set your calandar control to pubStoreDate.

I need to create simalar reports in the apps I write. My method is to use ADOX to create a table in the front end. This table is the source of the report. I then use ADODB commands with the relevant SQL clauses to pull in the data I need. This table is then the basis of my report.

Do you have to create tables in code or are you given them for your assignment? How many advice strings do you need? You can create tables in code and add columns to existing ones using ADOX (Well, I can) but it sounds like this is outside of the requirements of your course.

Excuse me for butting in but I don't think that you do need a Select Case statement. I would be inclined to create a new table for your advice strings consisting of a key field and the advice field. Add a new field to your plants table which links to the new table. Now your testbox contents...

Right off the top of my head, I think you need to refer to the active worksheet (Obj.ActiveWorksheet.PrintOut), but of course I could be wrong

Rather than typing a lot of sample code here perhaps it would be more useful to nudge you towards using help in Word's code editor. Allo fo the information you seek is there, Its quite clear and you may be surprised at just how much you can achieve with Word.

Here's a function I use that not only sends an e-mail but has an attachment as well. Public Function MailOrderOut(SupAdd As String) On Error GoTo ErrorHere Dim olApp As New Outlook.Application, olNameSpace As Outlook.NameSpace Dim myItem As Outlook.MailItem Set olApp =...

I'm fairly sure that there is no such function. I've certainly not seen one. As I see it you have two options: Shell out to Excel or write the function yourself

To answer your question - Yes. To do it - In the VBA window, click on tools - name of yourprojectProperties. Another window will open. Click on the Security tag. This will enable you to set a password to protect your code with having to use an mde file.

Just as for a combo box, a list box can have a bound column. When you click on an item in the list, the value of the list box will be the value of the bound column item. eg FileToOpen = Me.FileList.Value You can then therefore run code that opens the file at the address of the file cliicked on...

Its an interesting point that you raise and I've been tempted myself as I never use bound forms. The thing that has stopped me so far is that comos in Forms don't seem to have the same abilities as in Access and that there are no reports in .Net. Of course, there is Crystal Reports but I...

I've found that its better to convert dates to DateSerial when manipulating data including dates. Of course, you need to convert the filter and the data in your table(s) but it avoids the problems you are experiencing and will avoid you code falling over in the future.

Hi Alan Thanks for that but I'm afraid that it doesn't work. The control box and the close button are still there and working, despite my setting them both to off and to no border in report properties

Seems like I didn't explain myself too well. There is nothing wrong with the report as I've trapped all errors before opening it in Preview mode. What I'm trying to achieve is to not have the blue line across the top of the screen (Whatever that is called???) with the little X to close the...