Recent content by dannewestis

Works great. Thank you! :)

I'm trying to get the file size of files that can be up to 8GB. filelen() only works up to 2GB, as bigger files than that returns a negative value. I understand there are methods to retrive the correct file size for files bigger than 2GB, but I haven't quite understood how it works...

Excellent! Thanks! I think this should do what I want. :)

Hi, I'm rather new to the VBA part of Access and hope that maybe someone can help me out. This is what I'm trying to achieve: Find records that meet certain criteria, through an SQL statement (I have a query, but not sure how to do it in VBA) For each record in the array, check if the...

I get an error when trying to set autostart to true for the WMP control in VBA (it's false by default). Me.wmplayer.URL = path_to_file works fine (although Me.wmplayer.filename doesn't). But this gives me the error message "The object does not support the property or method"...

Thanks neileg and Pat! I split them up in two fields and have it working quite fine now. Only issue is when someone is changing the member (and thus getting a new code) and then changing it back to the old member. Then the original number is gone and the new number is one higher than the then...

Hi, I've set up a database that is acting as an interface for another database that plays mpeg2 files on scheduled times. But now that I've come this far I was thinking of doing that last step too and integrate mpeg2 playout in my own database. I'm writing now to ask about what experiences...

Hi, I export a query as csv to upload to another database on a web site. When that csv file has been exported I'd like the query to be emptied, so that the next time I export I don't export duplicates. What's the easiest way to do that? I've been thinking of having a field in the table with a...

Hi, I'm trying to get the maximum number in a table field to increase it by one depending on the member that is selected in a drop down in a field. I have three tables: members, programs and times. Each member can have N programs and each program can be broadcast N times. Each member has a...

Thanks! Worked excellent (after I managed to find the Swedish equivalent... :) )

Hi, I'm combining two date/time fields in a query to an integer. The first field has the date, the second the time. I'd like the resulting integer to be without the opening 0. How can I do that? That is, these are the two fields: 2006-09-14 (date/time) 15:00:20 (date/time) And I'd like those...

Hi, Not sure where to post this as it covers both queries, forms and partly tables. ISSUE: I need to add two records to a query with one record in a form. Is this possible? BACKGROUND: This is a database with TV programs and the times they are to be broadcast. Tables: One table...