Search results

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

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

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

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