Search results

Can anyone tell me why this isn't working?!! Function Testmodule() Dim TT As String TT = "*" Dim SQLquery As String Set MyDb = CurrentDb() SQLquery = "SELECT BizTalk_Import.F1, BizTalk_Import.F2" & _ " FROM BizTalk_Import " & _ " WHERE BizTalk_Import.F1 = " & "TT"...

Hi all, Our company is currently rolling out an SP2 update to all of our PC's and this problem has reared its head on all of the updated PC's so far. Basically when someone opens a database from a shared drive, they get an error stating that the file was made by an unknown publisher (seems to...

Hello All, I've got a database which has several fields but the ones I'm interested in are: Seconds1 Sev Seconds2 Sev2 Seconds3 Sev3 etc... Basically Seconds 1 holds a number in seconds of outage time, Sev tells me which severity the incident was at at the time. So for example the database...

Hi all, I'm trying to create a database to manage contacts coming in to us from another company. Their extract has a reference number and updates (kind of like a call logging system). Every time an update it placed into the system, it's put onto a new line so you see this: Reference...

Hi, I'm trying to figure out how to get this working and i'm struggling to get my head around it. I need to create a Database which looks at outages in a system and calculates the outage time. Initially this seemed easy enough and I soon had a database which would figure out hrs / mins of an...

Hi, I've got a database which uses two files "Old" and "New". The "Old" file contains data from 2 dates, date1 and date2. The "New" file contains dates from two dates also, however one of the dates is tha same as that in the "Old" File, i.e. date2 and date3 The dates are stored as TEXT, not as...

I'm sure this should be simple but I can't figure it out. What I want is for a text box on a form to display the number of records within a table. Basically I've got a make table query which creates a table ox X records depending on how many records in the original table match the criteria. So...

Hi, I'm not sure if I'm going about this right but I'll give it a go ;) I have a Database with a lot of tables and queries. Queries run on Table A and make a new Table "Table X". Another query runs on Table B and creates "Table Y". A third Query then compares Table X and Table Y's "Minute"...

Hi guys, this might be a quickie, I did a quick search but couldn't find anything :/ Basically my database creates a table which some people would rather analyse within excel because they're not comfortable with access. I can get the table exporting to an xls file no problem, howeevr what I...

Hi, I've got a database with a linked table to a CSV file which is automatically extracted from some logging software. The Database is used to search for text strings (e.g. "example") within several fields wichin the automated extract and then show the results with any duplicated instances...

Hi, I've got a form with two combo boxes. What i want is for the selection within combo box 1 to determine the selections available from combo box 2. I can get it to work on the first instance, i.e. when the form is initially ran, however if the selection of combo box 1 changes, the selections...

Hi, I have another database with "Sent Date / Time" column which contains date / time in the format "yyyy-mm-dd hh:mm:ss.sss". I need to run a query on the "Sent Date / Time" field to output yyyy-mm-dd hh:mm but in groups of two minutes. for example: Sent Date / Time 2 minute...

This should be a quickie I hope - I've got two columns: Date / Hour, Avg Response Time. I want to make a further two columns, one called Date / Hour (unique) and one called Av response/hour I want the Date / Hour (unique) to look at all the dates and hours in the date / hour column and only...

Hi, I've got a multichart Pivotchart and am trying to print it off, however because there are so many minicharts created, they are useless when printed onto the page. Is it possible to split these over several pages (e.g. 6 per page) so that they print off at a decent size? Cheers, Rob.

Hi again, Hope everyone had a good christmas / new year! I need a little help with an access query. I'm trying to add a column called "Week Number" to a database with "logged Date / Time" as a record. I need the date / time field to be looked at and then a week number be produced from it...

Hi, I've got a database with the date / time set as: dd/mm/yy hh/mm/ss, what i need is just the date and the hour, so 22/12/04 15:13:15 would read 22/12/04 15:00:00 I don't need it to round up (e.g. if it was 15:32, i don't want it to display as 16:00). I'm guessing this is easy but I'm...

Hello, I'm trying to have a dynamic title on a pivot chart based on what's been selected in a combo box. what happens is: User click item in combo box Clicks "Get chart" button Button runs a query and displays chart based on this query All the above runs fine and the chart is produced...

Hi, I need a make table query to run when a database is started - that's the easy part. What i can't figure out is how to set the table field properties as it's created. I need two of the fields to be set as Date / Time however I can't find anything which seems to give me this option. I'm...

Hi there, I've got several queries which create pivot charts displaying various data. Currently, I've got a form with buttons which when clicked display the pivot chart view of the query so that it can be printed off etc... What I now want to do is to get Access to create a report which...