Search results

Hi, Im doing somnething similar but getting an error trying to replicate this code: Table = "Card Usage" Form= "Stock Add" Text box for card number form = "TBcnf" Text box for card number to = "TBcnt" (I realise now that this acronym is a little inappropriate!!) Button with VBA in it...

You wouldent believe how happy I was when my test button actually worked!! now to make it more complicated and put it in to run before update...baby steps... I thought I was an excel whizz, then learned VBA existed...got functional on there and thought, of course I can make a database... I...

Thanks again Paul, Ill work on this now. Im self taught, the fact that my database has worked this long has amazed me. Im pretty much building extras into it as a means of learning, am not feeling patronised!! I was convinced it was to do with the demarkation of the quotes but I didnt...

Re: Duplicates multiple text boxes and an option: runtime 3075 error Thanks paul, Ive been trying to get this modified code to work I was wrong also when I stated that one of the fields was a number, change_number is actually listed as a text field due to the format (CHNG0000000000). I think...

Hi, I am trying to run a check that will make the user aware if the request they are adding via the form is likely to be a duplicate. If so I want the option to allow or reject the entry. Alternatively I have seen solutions that just notify on the form is something might be a duplicate, by...

Ive had similar happen to my query, be interested to know why too...

Ive now tried to modify it to do both checks but this is giving me the error again on too complex a calculation...IM sure it worked a few times then gives errors until i restart it. SELECT [SDC CU Query].[First Name], [SDC CU Query].Surname, [SDC CU Query].Company, [SDC CU Query].[Access...

OK this now works properly except for the original issue of the thread. I have the following code in the records source of the subfrom: SELECT [SDC CU Query].[First Name], [SDC CU Query].Surname, [SDC CU Query].Company, [SDC CU Query].[Access From], [SDC CU Query].[Access To], [SDC CU...

OK following your advise that the check needs to go in the subform record source, I used the builder (for the first part of this) but am getting the error message that it cannot be calculated as its too complicated or mistyped...why would the builder get it wrong :( SELECT [SDC CU...

I was all excited!! But it wont open :( At least I have a guide now on where the queries should sit! I think that was where I was going wrong, if i know where they are meant to go I can play with them. Bob: ill have a look now, ive looked at this buys links for other problems, hopefuly he...

ok, ive tried to build a model of what im trying to do, obviously a clean version. "Database concept" works as intended.. However when I try and expand on that it falls flat on my face. Im sure ive got the links wrong or missed something simple. I need the results in the subfrom, ideally...

Thanks for helping, sorry I wasnt clear. The above solution is basically where I am now. I have the query [QRY] and it has the two fields [Access From] and [Access To] This check placed in the criteria will give me a vaild result for each column and shows the data if it is true. I need...

I'm sure this is easy but I'm properly stuck I am making a database that processes access control requests for a large building. I need to filter what is a valid request between two dates. Requests come in with an access from and an access to text box on the table. I can get it to filter on...

Hi, Ive been trying to do this for about five days now, reading the internet, watching youtube and I just cant work it out. Please, please help :) ...pretty please This is for a database to handle requests for site access (I live in a shiny new datacentre). I have a main [mainAC] table...

Previously id been tring to use cancel=true to stop the code but I needed exit sub :) All working perfectly now

Apologies guys, I take full blame for the confusion. Ive found a new way of doing what I wanted but to try and clarify (in case your curious and because your trying to help me) I used the auto button wizard to make an add record button. I wanted to do a check but only knew how to do it in...

I probably did it the hard way and put it in all of the after update events of the text boxes and comboboxes. It operates abit like a nag screen :) There are two values that pop up (visibility=true if checks) that I must have completed so once they do this it leaves them alone but I get what...

In this age of war, isms and economic collapse that people still help each other. Each day i spend my free time trying to batter out my first shiny database and making up new problems as I go. Noone at work has the first clue what im doing so cant be any help, the internet as a rule is kinda...

I am trying to get the message Request added :) to show up when the new record command works. The message "add button error" show if there are any errors, rather than just doing nothing and stopping. However when it works I get both, I know I doing something very simple very wrong...

No you get macro, expression or code. Ive currently maanged to make the buttons "authentically" with VBA now im trying to get them to do the checks I want :) about 80% there now