Search results

I was wondering if anyone knew the answer to this... I have a form ("form1") with a list box, I will then click and open another form ("form2") and enter some data. Then go back to form1 and the list box will populate. Question, I wanted to set it so when I come back to form1 that it will...

Thanks for trying that G37Sam! I am not sure what is going on but it doesn't seem to be working correctly. I tried Steve R.'s approach and that works so and this time, I am not going to worry about it. I don't have time to figure out why it isn't working so I am just going to sweep it under...

Hello all, I am having an issue with an input mask not working correctly. I have a text box that has an input mask 0000\-00;0;_ which displays as, for example, ____-__ so a user can put in a number like 1234-56. If I type in a number manually, it works fine. Puts it into the table as 1234-56...

Thanks much! I was thinking that that was the road I had to take with this one. -Stoss

Hi, I was wondering if it was possible to append to an existing record. I have a table that has a memo field. I would like to pull a record and append new information into that memo field and keeping the data that was already there. ==edited== Sorry, I should have said that this will be...

Ok, got it to work. Very weird workaround but the following seemed to work. I ended up using the IsNull() because what I noticed was if the cursor was still in the memo field and I would hit the "Home" key it wouldn't detect that I had something in there. But, if I left the field it would see...

Almost everything is working now. One problem still though. Two of the controls that I am checking are memo fields. I am guessing at this point that is the reason why the IsNull() is not working correctly on them. I have read other articles with this problem but can't seem to get it to work...

Thanks all for the help, I think I got it. Galaxiom, thanks for the suggestion about the passing the object, etc. I was still having problems for hours and then I found that I hadn't declared the form in the function. I really didn't know I needed to but I tried it and it seems to work. I...

I think I understand what you are saying, just having a few issues. Basically, it doesn't run :confused: I can't get it to run the function (I believe that is where the problem is). Not sure where the problem is in my code... Here is the code from my customized menu If Screen.ActiveForm.name...

Thanks for the input! I am still a little confused about how to get around this. I have a custom menu and it can be launched from just about every form in my access database. I am having difficulty figuring out how to call this and have it apply to just this form (i.e. special validation that...

Hmm, Then I guess I should ask the question: What is the best way most people handle this? I mean, this seems to be a pretty basic and what I would think a common task. Don't most people code in validation and if the validation fails, it brings them back to the form? -Stoss

I have a form that users enter in data on. I am running validation on those controls using an "event procedure". I placed the code in the BeforeUpdate of the form. I have a customized menu that if the user clicks "Home", for example, it takes them to the main form (not the form that the data...

I must say, you guys on this website are unbelievable! Your knowledge is 2nd to none! Thanks you so much!!!!! I put the path to the different DB's into the SQL string (From section) and it worked perfectly. That was exactly what I wanted! I had no idea that was even possible. Now, I run...

As I have been playing around with this for countless hours, it seems that the query gets created and also it can be deleted but I still can't utilize it. I am still getting an error saying the object doesn't exist. Hoping someone can help! -Stoss

Hoping someone can help with this, this is driving me bonkers. Doing a lot of searching on this and nothing seems to help or work. Here is the complete code (except all the code that I did to make the SQL string) 'Query Creation Variables Dim qdf As DAO.QueryDef Dim dbs As...

Follow up to my previous post.... Thanks for the code. I did try it but I get roughly the same results. Basically what happens is I execute the code and then I get an error saying the object can't be found (error 7874), which in a way makes sense because it has to be created. I did notice...

Thanks for the reply, I will try that out and see if I can tailor it to my code. Two questions on that: 1. What is a workspace? And, what is workspace(0) mean? I have seen this around in looking for a solution but never have I found anywhere where they explain what it is. 2. Because I am...

I have a form, in which you can select a variety of option of where to output the data. Option 1 is to a spreadsheet, 2 is to an access report, and 3 it just to open a datasheet view. This is all based off of a crosstab query using a querydef (temporary query that gets deleted at the end of...

Hello all, I need some advice and someone to point me in the right direction. I have a table with a field in it that has text and a numeric value. For example, the field could have a combination of the following... 15 Mins or 1.5 Hrs. or 60mins Although most of data in the fields will be...

Thanks all for you help. I used the exit sub before it got to the error handling and that seems like a good way to go. It makes it easy to read and does exactly what I need it to. Thanks Again! -Stoss