Recent content by whitesmoke

ok i managed find something to work with with at least do it with a template.. but it's only entering the last field can anyone see what i'm doing wrong code is below. thanks anyone!! Dim objWord As Word.Application 'Start Microsoft Word 2000. Set objWord = CreateObject("Word.Application")...

Hi. . I can't really find anything related to what i need. I need to be able copy a current records field values, load up a blank word document and place or paste the field values to the document. My user does not want to hassle with mail merge, they just want to be able to get the current...

forgot to remove the below in red.. have some patience man... sometime we miss the obvious... don't have to re-post if you are still having problem post your database so it can be looked at. If Me.dpre = [All Data Table].[Docket No Prefix] And Me.dsuf = [All Data Table].[Docket No Suffix] And...

remove variable from the field just use = DCount([SolicitaçãoID_P ],"Protoloco_O ","SolicitaçãoID=" & SolicitaçãoID.Text) you may or may not have to put quote on the initial field = DCount("[SolicitaçãoID_P ]","Protoloco_O ","SolicitaçãoID=" & SolicitaçãoID.Text)

can you say sayonara!!! don't really know if that's capable.. the only thing you can do is try importing all the tables queries etc. into a new database under a new mdw... you would have to recreate the user file in the mdw.. but it's better than loosing everything.. good luck bud!! i hope...

yes it will take vb code to do it. you can either create another 2 checkbox ( or option box) or create 2 buttons one for all and one for none.. create an expression event (code) for on_click use field1.value = -1 field2.value = -1 so on so forth of uncheck its field.value = 0

I think you lost the case... with the code you don't need your long code.. assign the code i gave you to your field Amostras.Text ..

i don't see the first part happening unless you have a 3rd field with some kind of relational capability. the second part can be achieved through a subselect using TOP and MAX methods. eg: select sum(amount) from (select top 15 max(sales) from tablename)

here is the easiest method.. variable = DCount([ID FIELD ],"TABLE NAME ","SolicitaçãoID=" & SolicitaçãoID.Text) you could even put this in a form could even user form.recordsetclone.count (i think)

FYI: this test for case sensivity in the password only.

here is the code i've used.. create a login screen with 2 text boxes (txtpass and txtname and an enter/login button on click event enter below. (of course have a users table to open.. work with it... -- code for Click event of cmdEnter_Click() Public Sub cmdEnter_Click() Dim rst As...

no, i want to be able to do the grouping of sums (getting the data in the query) prior to doing the report. the problem i'm having is capturing the data from the different date ranges withing the grouping. at least that is one of my major probs. thanks oh and oracle yes, my life would be...

use code below to print on the button click docmd.openreport acviewnormal "report name" do a search on it in the forum. as i would recommend before placing new posts.

hey all, thanks to anyone that can help i have 5 fields facid custid empid amount invdate. i need to be able to get totals on the amount based on fac, cust & emp based on a date range given by user, but here's the kicker.. i need to get the current month totals, month totals - 1year (so same...

do you want login screen based on ms access login, which is a hassle to do or a login based on a table with usernames?