Search results

Well sometimes the Release ID will have a letter in it, so I felt that it could either be variant or string and I remember that you are advised not to use variant as a data type

Sure here you go Private Sub QuickLook_Click() On Error GoTo ErrorHandler Dim Qlookup As String Box = InputBox("Input cat's release number", "Release Lookup", "380") BoxFormat = Chr(34) & Box & Chr(34) Debug.Print Qlookup = DLast("'FIRST NAME: ' & [First] &...

I solved it, I just had to hard code the input box with Chr(34)

I have been trying the different suggestions, however I keep receiving an error of "3075 syntax". I thought it was the formatting of my code but I cant seem to pinpoint it. Dim Qlookup As String Box = InputBox("Input cat's release number", "Release Lookup", "380") Qlookup...

how would I go about doing this? Sometimes I have people that want to look up information on an animal based on their release # and I wanted to make it so that they could receive a simple message with all the information they need to know about who adopted out the animal. BTW i changed...

Hello, I am trying to use a dlookup to find information based on specific criteria but, every time I use it I receive an error "syntax error in date in query expression". however, I am not using any date format and I am confused as to why this is not working. Private Sub Quick_Look_Click()...

Okay I fixed the issue, I just needed a "" around the h, Thanks Uncle Gizmo and CJ for the help, I did implement the suggestions you gave me as well

I discovered that the problem lies in the datediff() procedure, I thought I coded it correctly? DateDiff(h, LrecDate, Now()) On Errror GoTo ErrorHandler Dim LrecID As Variant Dim LrecInOUT As Variant Dim LrecDate As Variant Dim Ldate As Variant Dim rstEmployee As DAO.Recordset Dim dbsNatCat...

Hi I am trying to use an SQL statement to input data into another table but I constantly receive a "invalid procedure call or argument" I have tried several different things to attempt remedying the problem, but nothing seems to solve the issue. I assume that there is something that I am just...

Hello, I would like to make it so that if that last record inputted with the same ID was inputted within the past 5 minutes then it will not input the new record into the database. Im not sure how to code that time frame, but more importantly how to tell access to not do anything if the...

hmmm... very odd because it works completely fine in my separate database that I uploaded, maybe there is a deeper issue with my larger database, thanks anyway at least I know now that my code works

Okay I removed the .Value from all the code, and I tried what you asked by using the same method but trying the pull the employee name into a msgbox however, i just received an error each time.

Im glad we have different opinions about the American foreign policy, but can you cite the sources where you read this? in my experience most things in life are not as simple as "I support you because today is thursday"

Hi I have been using the dlast function to look up the last record matching the inputted employee ID. I am trying to make it so that after looking up the last record access applies the opposite field to the [InOut] field however, it doesnt do anything and constantly applies a 0 (false) to the...

So this is strange, it seems to work, no more errors but its not really doing anything besides applying a -1 to the Boolean field [InOut]. Let me try and explain this from the top and from that I hope to clear any confusion. I am trying to implement a system in which an Employee will enter in...

Here is some sample data I will try and explain this better, if I input data into the 218th (new) record through the form I created it will give me a "no current record" error. I discovered that this is caused because I am at the end of records and trying input new data then access is...

this looks awesome, now I can finally make a pool.

I believe gun laws work, but only over the long run. If I take guns away from the public right now, crime will rise, but it will diminish over time because the people that are still obtaining guns will lose the ability, over time, to obtain them. The question is, how long are we willing to wait...

If I don't believe that there really is a seed inside a Apple, and then someone slices the apple in half and shows me the seed, if I still then do not believe it then what else proof could exist to convince me? I disagree with your sheep example, here is why: God appearing in front of me is...

I love that statement "If God appeared in front of me, I Might change my mind" like saying I dont believe cars exist, but if I get hit by one, then ill consider it. Besides that, I gave up my Christian religion a little while ago, been a strange world without the christian looking lens. Its...