Search results for query: *

Hi, I need a little help creating a calender system which I can use to determine the "working hours" for my company for the next year. For example: I wanna set the default working hours from 8am to 5pm, monday till friday. Then I want to set the 24th and 25th of may as days off. I also wanna...

Hi, I'm looking for the best way to implement an advanced search function into my application. Right now I have my main form which has one text field, a search button and a subform. The subform shows the contents of MyTable in datasheet view. When the user enters something into the textfield...

I'm using Microsoft Access 2000. When I run the application on my machine (which has the full version of Access), it works fine even with the /runtime command. But when I run the application on a machine which has only Access Runtime installed, it returns that error. I tried re-installing the...

I'm having problems running applications on Access Runtime versions. When I run a fully functional application .mdb on the runtime version, it returns an error: Execution of this application has stopped due to a runtime error. The application can't continue and will be shutdown. But when I turn...

Hmm, The whole /cmd method does not seem to work on Access Runtime. It returns an unknown application error as soon as I try to get the value of command. Function CheckCommandLineStart() ' Check value returned by Command function. If Command = "autorun" Then 'autorun...

I used the /cmd method to pass the value autorun to my application. On several places in the code I check this value and if it is set, I just make the application press the buttons automaticly that normally would have to be pressed by the user. "C:\Program Files\Microsoft...

Is there a way to pass a parameter to Access ? My application is kind of a wizard-like tool to do a data export and some other stuff. When I just run the application, I have to press the start button to trigger the code. But I also want to be able to schedule this task without having to press...

Now I'm confused ... I compiled the exact same application that keeps returning the error into a MDE and it runs just fine with the Access Runtime ?! I thought an MDE was just a compiled and encrypted version of the MDB ? If I just compile the MDB and try to run it on the machine with the...

Ok, here's the code that gets called at startup. The error does seem to be in here somewhere, cause when I comment all if this code except for the DoCmd.OpenForm "frm_connectie" it does open the connection form without problems. Looks like it already returns an error on the very first line of...

I tried the /decompile option, but that didn't solve the problem. Compiling did return a few minor errors in my code, but I fixed all of them and still my problem isn't solved. I have no idea how to isolate the error. All I can tell is that it doesn't even seem to get as far as the Form_Load...

Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down. Still no luck with the Access runtime version. :(

Nevermind my last post. I didn't see there was an example included on that webpage. I figured it out now. :) Just have to test it with the Access runtime now. Thx for the help.

I tried API, which seems to be working. But how do I get it to return the location of the file instead of opening the file ? I need it to put the location in my textfield so that I can use this to relink my tables. Also I want the filetype to be more than 1 option. In this example I can only...

I found some code that makes my application check the link to the backend database at startup. When the link is broken, it displays a pop-up form where I can specify the location of the database file. This pop-up form contains a CommonDialog control to browse to the file. I'm running the Access...

I changed the query so that I will create a new temporary table and store the records I need (orderID, status and client name) in this table. That solved my problem. Thx.

Ok, that solved the problem. I just limited my recordset to the records I need by using an SQL statement. So there is no need to use a filter anymore.

I have a very weird problem with filtering a recordset. The code below is triggered when I press a button. It first runs a query which creates the table temp and then I want to step through each record which meets the criteria in that table using a recordset filter. Set db = CurrentDb() Set rs...

I can't really do that, cause the data in clientsA gets downloaded from an Oracle database every night, while the data in clientsB is inserted directly from the application I'm developing. If I do it this way, I'll have to update the clientsAB table everytime a user inserts data into clientsB...

I have 2 tables with client data, and 1 table with all the data about the orders these clients make. Now I'm trying to make a query which will show me all orders (ID and status) and the client name (which can be from any one of those 2 tables). Here is what the database kinda looks like, but...

I changed the name of the field to recordselect. I tried all possible combinations listed here, but still the same error keeps popping up. Any other ideas ? DoCmd.RunSQL "UPDATE MyTable SET recordselect = True" DoCmd.RunSQL "UPDATE MyTable SET recordselect = -1" DoCmd.RunSQL "UPDATE MyTable SET...