Search results for query: *

thanks I am still having one problem the syntax to update the table here is my code Option Compare Database Option Explicit Dim TotalElapsedMilliSec As Long Dim StartTickCount As Long Dim strsQL As String Private Declare Function GetTickCount Lib "kernel32" () As Long Private Sub...

user enters the custid they then chose whether its a worksheet or invoice by putting y in either of the txt boxes one for worksheet one for invoice when they are finished they click stop the timer on the form stops then they click finish and the timer populates the finished time in the finished...

thanks because the custid could be a new one. Maybe I am missing something could all the fields be bound and still allow new data entry because the table would start off fresh no data

I have five unbound text boxes custid starttime finishtime worksheet invoice one unbound txtbox box is called elaspedtime which is the time from start to finish that calculates I need when I click the finish button need the custid, starttime,finishtime,worksheet or invoice depending which task...

I have a form with txtboxes that the user is going to enter I need the data they entered to fill the table. I know I should know this but slipping my mind now lets say one txt box is custid once they enter I need that to fill the database table. Thank You

I been assigned to use the new feature in Access 2007 the problem is not all have info path and html is to large. Is there away I could have employees hyperlink and use the database on sharepoint and alert certain employees when the request for updates have been sent?

I am looking for an access template that would closely include the followng fields employee name: date of hire: current location: current job title: immediate supervisor: postions held at this company:(last three) postions held at other companies(last three) all degrees earned: education in...

I been assigned to use the new feature in Access 2007 the problem is not all have info path and html is to large. Is there away I could have employees hyperlink and use the database on sharepoint and alert certain employees when the request for updates have been sent? Thank You

BTW no I did not create the function I do not know the code to put in the function?

d hook up I am a newbie kind of what do I put in the function and how can I run it from a query for example where does this code go? Function it gives error> SELECT Concatenate("SELECT [Customer ID] FROM tbl0316Cust") AS CustomerIDs FROM tbl0316Cust GROUP BY Concatenate("SELECT [Customer...

Access keeps telling me the following syntax is wrong can some one help SELECT[customer id], Concatenate("SELECT [Customer ID].tbl0316cust")'

Expr1: SELECT[customer id], Concatenate("SELECT [Customer ID].tbl0316cust")' I am trying to have all the custid from one column come out in this format b2018, b2727, b324b can anyone show me how thanks

I need to create a macro in access that will grab the highlighted records in ms outlook and print only the attachments please help

I have a column with custid b2018 b2727 b324b I need it to export to txt delimited in the following format b2018, b2727, b324b there is a space after each coma

I have a spreadsheet book 1 with a list of customer id in field custid I have another spreadsheet called June 2009.xls with cust id I want to see if the custid in book 1 does exist in June 2009.xls cust id. I am trying to use this forumula but having trouble can anyone help with the syntax...

the question is how do I list my cust id in one spreadsheet and do a lookup to see if they are in the other spread sheet. I need to know if the cust id I have already exist in the other spreadsheet. I was looking at the vlookup

I have a spreadsheet that I cannot alter it has a Cust ID field in field C I want to list all my cust id that I am searching for in another spreadsheet in column a and then search the other spreadsheet called may.xls to see if any of my cust id are in spreadsheet May.xls column C cust id field...

I get this error while trying to import an excel spreadsheet how can I get around this error it is very important thank you

I have a contract that is sometimes annual from the anniversity date sya there anniversary is 03/08/99 I need to know how many months left if the contract expires 09/30/09 they pay annually.

yes that is right the problem is I have to separate each bill code into its own column and the rate for that code next to it for example bill code rate 334 2.52 660 1.70 220 15.30 so the query has to...