Search results

It's been giving me the correct figures?? It takes the max from old which would be yesterdays date. And the min from new which is also yesterdays date.

Thanks Pat, The tables are already linked, and whenever I try linking them as a date / time field I get a NUM! error. Not sure why but i've managed to make a workaround anyway. I looked at the "old" file and took the Max of the Date field and put that into a new table with 1 entry. So the new...

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...

Not sure if pat meant to post that on this message?? Sometimes, but not every time I run this macro, I get an error "Data type conversion error" Any idea why this is? I'm using the code as below, running on several different tables (Each table has it's own nullpartsX function and fields...

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...

Nevermind you cant call a sub from a macro so i just changed them to functions. ta

How Would I run this code from a macro? I can use the openmodule macro but it only opens it and doesnt run the code. The run code macro doesn't give me the option to run this... Thanks again!!! Rob.

ZDog that worked great! thankyou very much it's really appreciated!!! Is there a way to get the Table and Field ID's linked to a Form text box?? E.g. Sub nullparts() Dim i As String Set myDb = CurrentDb() Set MyRs = myDb.OpenRecordset("[Forms]![exampleform]![textbox2]" ) 'Replace Part with...

The error message was "error user defined type not defined"

I had an idea that maybe if I get it to make a new record at the end where it finds a null value, and copy over the values (using a clone script i found) from the previous record and then deleting any null values after it runs. So, I'm trying to use: Private Sub nullvalue_test() On Error GoTo...

No, not really :( What I need is for it to look at the value, and if it's null copy the previous value in that field into the null value. For example: 1 2 2 3 4 5 Would look like this: 1 2 2 2 3 3 4 4 5

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"...

Thankyou as always you're a great help! Rob.

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...

lol I feel daft! I figured out that I'd set the form with the subform to open as read only so the form couldn't close.

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...

Thanks to you both for taking the time to help out. I decided to go quick and dirty as it's something which isn't a permanent reporting requirement - just something we're experimenting with. The code Format((Int(CSng(Mid([Sent Date / Time],15,2))/ 2) * 2),"00") worked exactly as described and...

Thanks PArso, managed to find one. for those that are interested, the answer was to add: Private Sub combo16_Change() Me.Combo31.Requery End Sub This re-runs the query whenever combo16 changes.... cheers all.

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...