Recent content by crispy02

I have the book that you mentioned(Access 2000 Developer's handbook Volume 1 and 2) but I cannot seem to find the function that you have mentioned., If you have an example of the function that you would not mind sharing it would be greatly appreciated. Chris

What I am trying to do is call a stored procedure on Sybase Central using the call statements and (-1229999914,-9998452); are the 2 parameters that are needed to run the stored procedure which is why I am using the pass through query. So, can I still use any of your options below? I am sorry...

I need some help and hopefully someone can help me. I have a select query that I have created and it gives me back call statements to be hopefully used in a pass through query. My problem is I do not know how to make this happen. I will need to run the pass through query for each call...

I am not sure if I can do what I am trying to do but here goes. I currently run a select query that gives me a results list of inspection types. Then a run a query that takes the results from this query and the results from another query to see what inspections were not completed. This works...

I am having a problem running a stored procedure from Sybase Central in Access. I have no problems running functions. I can run the stored procedure if I hard code the parameter instead of reading from a table. So I know that the ODBC connection is working. This is what I have in Access...

Here is the database in 97. Thank you for looking at this

I am not sure where to start. First I havea form where a user enters data on a screen and check offs checkboxes and the data is saved in a table to be used later. Once it is in a table I read another table to get the value I want instead of the -1 that shows up. My question is in a query I...

Do you have a example of a continuous subform suggestion that you could send me? Thanks

Currently a have a form where the user can click on a button and runs a macro that produces a report in preview mode. I have a user who would like to press more than button at a time to run 3 reports a once. Or could I set up a listbox where he could select the reports he wants to run and have...

Help, I have a list box where I have set the multiselect property to Simple. I have 2 tables set up one with the customer name, address and phone number. The other table is where I plan to store the information that is selected in the listbox which is related to the information in the first...