Search results for query: *

Hi, thanks for the reply LittleMaster. I managed to resolve it. There was something wrong with the main form (frmMaintenanceMenu) I recreated this form and it seems to have fixed the issue. I couldn't use the tabbed documents option as it was going to cause issues with other forms in the...

I have a clients database which has a strange issue. When I go into one of the forms (frmMaintenanceMenu) and then view other forms from this and close them (sms log in sample provided) it resizes frmMaintenanceMenu and any other open forms (they appear like a popup rather than taking up the...

Hi Andy, thanks you set me on the right track. I went back a level and removed the grouping from the main query (I introduced main project table for this). What I then did is have two nested queries for each of the fields to get the data from the log tables. The only limitation is I couldn't add...

Thanks for the reply Andrzejek. I didn't even notice that I have changed it so my sql is now as below but I'm still getting a syntax error. I just cant seem to get my head around the group bys in the query which is causing me the issue, I have tried using aliases in the main query for the values...

Hi I have two tables tblProjectLog fldProjectID fldProjectDesignPhaseID fldLogDate fldProjectIDLog - primary key tblProjectDesignPhaseList fldProjectDesignPhaseID - PK joins to same field in tblProjectLog fldProjectDesignPhase - text (example of data 'Planning, 'Detailed Design' and...

I did a bit of additional work on it today. I have found out I can change the marker by specifying an additional url as one of the properties in the maps.googleapis.com url. I think what I'll do is setup 8 separate url's (each pointing to an image of an arrow pointing in a different direction)...

Hi, I have created some code in an access form which allows users to select a vehicle from a dropdown list click a button which opens internet explorer with the current position of a vehicle shown as a marker on a google map. To do this I use the following code DoCmd.Hourglass (True) Dim...

Thanks Duane, I knew there was going to be an easier solution but its up and running now so I'll leave it as is:) If I have to alter the width of the chart I'll take up your solution rather than adjusting my 100 separate textboxes. Thanks Justin

I've included a screenshot of the report in case anyone wants to use it in the future. Thanks Justinhttp://files.engineering.com/getfile.aspx?folder=e8abcfb2-35f2-4bb9-8e13-059088ab16de&file=complete_chart.JPG

Thanks for the reply. I ended up going with a different solution which gave me a bit of extra control over the grouping and appearance of the chart. I just created a continuous report with a textbox to show each task. Next to this I have 100 small textboxes called (box1 to box100) and in the on...

Hi, I have been searching and can't seem to get this working. I have a ms access bar graph which has a list of tasks on the y axis. The x axis shows the percentage completed of each task (value between 0-100) I'm trying to set the maximum value of the x axis to display 100 and the scale in...

Hi, please bear with me I have been googling and I'm still trying to get my head around the best method of having a mobile device (ipad/android tablet) communicate remotely with an ms access database. At this point I'm only after a high level understanding and just need to know if I'm on the...

Hi, I'm currently investigating moving an access backend to SQL Server. I'm new to sql server so please bear with me. I have my head around how I'm going to do things but would just like peoples opinions on the procedure I'm looking at creating to manage the locking and if it will work...

Thanks for the reply kjv1611. I'm actually going through the process now of using a temp frontend table which gets updated with the record selected via a ado connection (will most likely change to a pass through query). With the frontend table I have one record which I set to null then update...

Hi, I'm currently investigating moving one of our Access Databases to SQL Server. Originally I was looking using stored procedures to populate unbound forms as well as update the data when a save button is clicked. This sounds nice and clean however there are a couple of forms in the project...

Hi kjv1611, thank for the reply. Sounds like a good idea. Just create an open office file with script to do what I need and run the file from access. I have found a bit of documentation on automation between vba and starbasic. So I will have a bit of a play around with my initial plan and see...

Hi all, This is my first post so go easy:) I have done quite a bit of searching but cant seem to find what I'm after. I currently have an access application that exports data to a new excel file, I then use some vba to loop through and insert subtotals and change formatting in the new file...