Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: aquinox
  • Content: Threads
  • Order by date
  1. aquinox

    open a specific form in VB 2005

    Hi, wondering if anyone might be able to help me here. I'm a beginner to Visual Basic 2005 Express Edition. Initially i thought it would not be much different from VB Application for Access as i'm a bit more comfortable with it now. But because i want to move our database to SQL Server, i...
  2. aquinox

    text get chopped off in half at the end of a page

    Hi, wondering if anyone might be able to help me here. In the report, most of the text-boxes have been set with "can grow" properties to "yes". This way, regardless of how long the content of the relevant fields, they would show all the content. If they are too long, then they'd push down...
  3. aquinox

    a little square box appearing in the data

    Hi, wondering if anyone might be able to help me here. It may be a trivial question here but I just couldn't solve it. I would like to replace the "return carriage key" with something else but just don't know how to put it into code. In the table, i can see that there are some that look like...
  4. aquinox

    how to refresh form that has subforms in it

    Hi, I have a problem with refreshing a form which has two subforms in it. For example, Form AForm has subform1 and subform2. In the form, there is a button called "Add New". When clicking the button, another form BForm will pop up allowing user to enter relevant fields. What i'd like to happen...
  5. aquinox

    produce PDF as well as name the filename automatically

    Hi, I was wondering if anyone might be able to help me here. This is what i would like it to happen. I would like to be able to produce PDF out of Access reports as well as naming the file out of the records automatically. For example, When clicking on a button called "Get PDF Reports" on a...
  6. aquinox

    question on report customization

    Hi, Just wonder if anyone might be able to help me here. I have a question on Access report. I have a database built using Access 03. I have a report that has a several subreports whose control sources are based on queries. Sometimes, there are occasions where in the sub-reports, there are a...
  7. aquinox

    how to subtract date or time in Access

    Hi, Wonder if i could get some help here. We have a company management database created using Access 03. I was asked to put on a form that would calculate an annual leave for all staffs. I know the formula how to work out the annual leave. However, what i'm stuck here is we really want to do it...
  8. aquinox

    new to vmware

    Hi, Just wonder if i could get some help here. I'm new to VMware. From my understanding, it allows multiple OS on a single machine. I guess my question here is the other day, i was trying to download it (thought it's an open source) but had to purchase it. Is that right? how do i install it...
  9. aquinox

    operand without operator - invalid syntax

    Hi, Wonder if i can get some help here with the syntax. The following is the code i'm trying to put into a control source of a textbox. =iif([SubJob_Name] = "", dlookup("[Job_Name]","Job Register","[Job_ID]='" &[Job Register]![Job_ID] & "' AND [Industry_No]='"[Job Register]![Industry_No] & "'...
  10. aquinox

    need help with query

    Hi, I'm afraid i've got the wrong syntax here and wonder if i can get some help here. In one of the combo-boxes's control source, i have the following code =iif([Subject Code] = "O",dlookup("[J_ID]","Rate Department","[J_ID] = 'Team*'",dlookup("[J_ID]","Rate Department","[J_ID] <> 'Team*'"))...
  11. aquinox

    comparing two table of two diff. of the same database

    Hi, Wonder if anyone might be able to help me here. I have a series of Databases with different names made based on the versioning order. Recently, there has been a lot of changes happening to our data in the database. If we compare a table from the current version of database with the table...
  12. aquinox

    help with query issues

    Hi, I was wondering if anyone might be able to help me with query issue. Here is my query. SELECT ... Format(60000+700*(([WindTime]-[NewTimeToSpill])*[GHD PDWF]),"$0"),"0") AS BladderSize, 30+(DLookUp("[WindTime]","[Locations]","Location='" & [Location] & "'")) AS WindTime, [Pump...
  13. aquinox

    variable in query doesn't work

    Hi, I got problem with the following query. The problem is that it returns nothing. It's a long query. The one shows below is not the complete one. strSQL = "SELECT ProjectQuery.PN_Order, ProjectQuery.Proj_ID, ProjectQuery.PS_Name, ProjectQuery.FS_Name, ProjectQuery.[" & year1 & " ]...
  14. aquinox

    can't get fixed amount

    Hi, I was wondering if i could get some help here. In my query, i have the following field which is the result of a calculation as follows IIf([EductionOK]="Not OK",Format(60000+700*(((1.1*[WindTime])-[NewTimeToSpill])*[GHD PDWF]),"Fixed"),"") AS InstantESize. My objective is to be able to...
  15. aquinox

    DLookup issue

    Hi, I got a problem with DLookup. I'm using Access 2003. Here is the code In the form, i have a combo-box that has a list of towns. the following is the code that i put in the control-Source of a textbox that shows the result of DLookup. In the control-source...
  16. aquinox

    how much usage does VPN incur at min

    Hi, I have something to ask and hope anyone here might be able to help me here. Once the VPN connection has been established between home and the office, how much broadband usage does it incur at minimum? by minimum, i mean when there is no activities of downloading or uploading files in the...
  17. aquinox

    how to delete Personal Folder from Outlook 03

    Hi, I wonder if i could get some helps here. I know by default, outlook 2003 creates a folder called "Personal folder" for us automatically. We then add and configure a new email account for ourselves. By default, any sent items are sent to sent item folder in the Personal folder. My question...
  18. aquinox

    how to export tables, queries from a database

    Hi, I was wondering if anyone might be able to help me here. I've been writing up a technical report for the database. My question is whether there is a way of extracting/exporting all the tables including attributes and their types, queries, forms and reports into (don't know) a word document...
  19. aquinox

    VPN connection established but can't access files

    Hi, I was wondering if anyone might be able to help me here. I have a linksys WAG200G wireless modem router for my ADSL broadband connection at home. And i have troubled with getting the VPN connection to work. Here is how the network is set up at home. ADSL goes to Linksys modem router. Then, i...

Part and Inventory Search

Back
Top