Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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] & "'...

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*'"))...

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...

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...

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 & " ]...

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...

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...

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...

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...

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...

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...