Search results

Thank you very much, helped me out a lot there. I was having a look round as didn't think anyone would be on here at this time on a Sunday morning, and put together a couple of things I found and got it working, in more or less the same way as the example you provided.. strangely enough about 30...

I take your point and see what you are saying, but think you have got the wrong end of the stick. That is not concatenated that is the raw header data from the XML soap packet that the board sends on each transmission. That would be most helpful and appreciated if you could. The delimiter...

I have made a system for managing service calls and fieldworks. Part of this is checking the boards we install/service are working correctly. When the engineer calls in, we check the board - enter serial number, via ODBC talks to main server DB and pulls back what is listed below, along with...

Thanks for the help thats got it now and its working fine. Had some strange issue with a forgein constraint, but got that sorted now. Here is how it ended up Dim MemberID As Integer Dim TypeID As Integer Dim TimeslotID As Integer Dim AvailableDate As Date MemberID =...

insertavilability MemberID, AvailabilityID I get - "Compile error: ByRef argument type mismatch" By putting in call I get the same error come up Call insertavilability(MemberID, AvailabilityID)

Precisley what I have tried to do and getting no where. If I call the function with only 1 parameter defind in it then it works fine, but the second i put a second one in there I get errors, I have tried everything I can think of and followed the prompts that come up when doing it and nothings...

I'll give that a try, but I can't even get it working with only MemberID and AvailabilityID been passed, which should both be Integer.

This is doign my head in now. I have 28 combo boxes on a form, which I want to insert data into the table as they are chaged. Each one will pass the same sets of data just with different parameters which come from the form. Rather than putting the same code to insert on each of the 28 combo...

If this isnt in the right place could someone please move it to the right place. I am building a system for a local charity group I am chairman of, we assist the local emergency services and civil authorities during times of bad weather with the use of 4x4 vehicles, we use them to get...

Thanks for that, it worked, but has created another problem now. When I look at the query and run it, it works fine. But when i put that field into the report it comes up with another error message now: "Multi-level GROUP BY clause is not allowed in a subquery." The final code for the...

I have a DB that tracks fieldworks we do. Some jobs are chargeable some are not. When the jobs are closed down you select if it is chargeable or not, if it is then it marks the check box as true (-1) and shows a field for who to recharge the job to, which is then selected from a combo box...

Put an extra field in the job type table, which holds the name of the form to be shown in the navigation page. Put in an onload event which looks up the form name and set the navigations tartget page to that name, all works nicely. Private Sub Form_Load() Dim myNavForm As String myNavForm =...

Hi, I have a form which when open displays various bits of information relating to field works jobs we carry out. There are various types of jobs we do, and whilst a lot of the infromation is relevant to all jobs, some of it is specific to the job type. The form is made up of a naviation...

I have several field job types, and each one requires a different worksheets. Engineers could go out with multiple job types each day. What would be the best way, that I can just select the engineer and the day and it prints all the worksheets for that engineer for that day or date range...

I tried it without the ' first and it didnt work, works fine when I put them in.

I tried the DateValue previously to pull the date on from a date&time (general date) field and in a wry, but had no look in seething any criteria against it at all.

Hi Guys, I have been tinkering with Access for a few months now and have done a little with VBA but not massive amounts. Anyway I have made a system at work but it is largely based around forms that auto enter data into the tables open setting properties, saving and closing again on an open...

It currently produces a worksheet for the engineer, which is based on several queries, in fact the report has 3 sub reports in it with various bits of information. What I want to be able to do to is produce several difference worksheets from the one selection. So I select engineer A for...

I'll see if I can reduce it down when I get to work and post it up here.

I have made a DB that as well as other things, manages the field works we carry out at work. There are several job types that we do in the field. The jobs are created, and left unassigned to any engineer or without a scheduled date. The jobs are then scheduled outside the system using...