Search results

look at previous post for cleaned up code, guess you posted as I modified my response

I just got it !! Me.txtFields = Me.txtFields & jso.getNthFieldName(lngCounter) & ": " & jso.getField(jso.getNthFieldName(lngCounter)).Value & vbCrLf Now to assign it to a table and i'm set Thanks for your awesome code and help !!! Kevin

I tired that before and even just adding the .value to the end of the original string and get 424:Object Required

Using your original code I can get all the field names and If I declare and hard code each field, I can get the Value property to work. This will work as the fields won't change, unless I update the form, but looking more into it, there are over 50 fields returned from your code so an automated...

looks like its just the field names...

thanks for the link, i'll look more into this one as well as DB_Guys code when i get a chance this weekend as this one at first glance looks like its filling a PDF from a file vs going the other way.

At a quick glance, thats a pretty sweet setup as it was able to identify all the fields. I'll have to dig into it more later and let you know what I come up with. thank you

Not sure if this is where this would go, but Is it possible to import fields from a fillable PDF file into a table in access without having to convert the PDF to another format? What I would like to do is select a completed fillable PDF file, which would create a new record in the table, and...

Actually I discovered that as well when I started testing with additional users, but thanks for pointing it out !! I ended up changing a few other things as well, but it is now running as intended. Thanks again to all !!

Ha, that's exactly what it was, I can't believe I missed that, I guess thats what happens when you start coding after a long day and little sleep. DoCmd.OpenForm "UserInformation", , , "[UserLogin]= '" & NetworkUser & "'" It is a string, even says so in the code :banghead: Function...

theDBguy, I get what your saying, but "NetworkUser" is the name of a Function to get the currently logged in user on the PC Option Compare Database Declare Function wu_GetUserName Lib "advapi32" Alias "GetUserNameA" _ (ByVal lpBuffer As String, nSize As Long) As Long Function NetworkUser()...

Per your screen shot #3, You need an End IF above your 2nd Else statement. This is where indention comes in handy, as shown in arnelgp's code above, to help you make sure you closing each opening, especially in nested code. if x=x then if y=y do #1 else do #2 end if else do #3 end if

I am working on a database that will either automatically add a network user to the UserLogins table, and then open the UserInformation form to that record so they can add in their details, or if they already exist in the UserLogins table, then they will be redirected to the appropriate form...

SO I am now getting the desired results from the If/Then statement, however the Facilities Ticket Subform is still not displaying all records for some reason when opening the Faclities form, so I have decided to forgo opening the Facilities Form and just going back to the main page. I may...

Understood and no problem, I just added that comment to let him know I had replied.

reply pending mod approval...

I did not have Option Explicit, so that has been added When I check the RMA Transfer, varX=-1 and True=True When I uncheck the RMA Transfer, varX=-1 and True=True Looking closer at the code, it is looking at the wrong table, so I changed the table from "dbo_nFacilityTicketEquipment" to...

Form opens, but the subform doesn't display correctly I have inherited a ticket tracking database, where when a ticket is created, you can specify if a piece of equipment has been tagged for a RMA and it generates a RMA form for that piece of equipment. This issue is a RMA form is generated...

As missinglinq mentioned, is this a FE/BE setup?, is the DB shared on a network? I was running into this issue as well with a FE/BE setup as I had a front end Access DB, using SQL back end, on a network share and everyone that needed to use the DB would open it via a shortcut to the network...

Apparently I have already offended plog as he has already made up his mind about me based off of 2 posts, and based off of his responses, I have a good idea of the type of person he is as well. Anyway, I digress, so let me step back for a second and let you know where i'm coming from. I will...