Search results

The error is 'run time error -2146697203 (800c000d)': Method 'ImportXML' of object'_Application' failed.

To answer the Where Clause, would it look like this? CompThisYear: DCount("*","Open Issues","year([RequestDate]) = " & Year(DateAdd("y",-1,Date())) And [MyField]='COMPLETE') The second part, which makes sense but I'm not exactly sure how to build that.

How would I add additional criteria to the below. My criteria would be [myfield] = "Complete" Is this even possible? ThisYear: DCount("*","Open Issues","year([RequestDate]) = " & Year(DateAdd("y",-1,Date())))

I am attempting to pull data from an XML file via VBA without doing the import on external data. I created a blank table called "tblHolding". In theory, my code works the way i want which is: User clicks button, file explorer opens for them to select the file, imports data to "tblHolding", and...

In this example, I'm working with concatenated values. CBNOPREF = "No Pref" CBWORD = "Word" CBEXCEL = "Excel" So the if my data had each it would show (No Pref;Word;Excel) That's fine until my data only has excel, and would show (;;Excel) How would I had Nz to the following to eliminate the...

I'm not sure if I am over thinking this or what. But you want me to remove all the DCounts in my main query and make subqueries based on the DCounts? Honestly I'm not really sure what you both mean by making it easier. I'm hoping to get one of those moments where it all clicks, but I'm not...

Could you provide an example of the sub queries so I may develop this in my database?

Understandable on the names but I built my adobe pro form based on the live cycle names. So I'm 100% percent certain the name is correct.

It errors as soon as it tries to read the PDF. Its using the same structure as first PDF, but it errors on the pdf created with adobe live cycle Text1 = jso.getField("TextField1").Value

Can anyone provide any feedback with my adobe livecycle issue? Or maybe I am missing something easy.

Good evening, I am working with DCount in a query based on a calculated value [MyCalValue] that is a status. The status can be: Complete, On Going, Past Due, Additional Information, No Date. In the DCount, I want to return 0 if null. Sample that works fine Green...

So I've been working on the code for two different pdf forms. One form was created in adobe pro. I can basically get the form to do what I want, which is fill the access field on the form and display a text box with that particular data. The second form was built in adobe livecycle. I use the...

Currently the * is inbetween the "". I've moved the "" and * around but keep getting errors. I'm sure this is something really stupid but I haven't figured it out yet. 'MyTitle If Me.Text240 > "" Then varWhere = varWhere & "[MyField] Like *" & tmp & Me.Text240 & tmp & "* And " End If

Thanks for the name suggestion, I built this database as a sample for another db to see if I could get it to work. When I make the change "*" I get a run-time error as pictured in attachment. 'MyTitle If Me.Text240 > "" Then varWhere = varWhere & "[MyField] Like *" & tmp & Me.Text240 &...

I am running a search function that works, but is limited in one of my fields. If I want to search for "B", and search every title with an "B" in it (regardless of where the B is), it wont show. If I have a title that is labeled "BAC", it will not show if I search "B", unless I type "BAC"...

Thank you for the files. When running through the import txt steps, and since the text is all over, with only allowing for vertical line breaks, how would i get this to work properly.....? Right now the data would be placed in several records, rather than one. But let me elaborate a bit, lets...

Still searching. Was also looking at converting the pdf to txt, but still unsure how to reference the structure or specs. I created a sample database with the file information below if anyone can point me in the right direction. PDF File Naming PDF Name (Left) : PDF Object Name (Right)...

:confused: bump

Awesome. Thank you. I applied all the principles in my real database, and works perfect.

Do you mean like this? I tried with a If Else as well but it still shows #Type! Public Function get_Status(in_rd As Date, in_dd As Date, in_s) ' determines Actual status based on request date (in_rd), due date (in_dd) and user supplied status (in_s) Dim ret As String '...