Search results for query: *

Hi Guys, How can I create a desktop Icon for my Access Application? Thanks in Advance

I have only 5 records in my table but when I run the following code below (without) the loop, it prints only the first record in the table and with the loop it prints only the last record in my table to the report. How can I move through (print) all the records in my table to my report...

I hope I can explain the issue I'm having suffiently ... in any case here it is: I connected to the SQL server successfully but I'm having problems generating my reports anyway. And I suspect it's due to the & "" below ... but if I remove them I get an error too. Field1.DataValue =...

How can I find a record in a recordset (connected to the SQL Server via code) I modified my code to look like: Private Sub List1_Click() Dim Template As String Template = "[ERemark] = " & Chr$(34) & List1.List(List1.ListIndex) & Chr$(34) rs.Find Template End Sub Result: the list was blank...

Sorry for the long code (below) but I am still trying to get a connection to the SQL server. When I run the app, I get a run-time error '3704' with the description Operation is not allowed when the object is closed Please help! I've attached my entire code for the data entry form: Option...

I created a very simple application in VB 6.0 (a couple of you helped straighten me out a few times) with an MS Access back-end for my local agency. But now there's an opportunity for our sister agencies around the country to adopt the applications too. So we decided to put in on the SQL server...

Please Help! I'm trying to list all the records in one of my databases (Trip) by searching the "TravelAmt" field which is a numeric (a double to be specific)field. I'm getting a: --- "Run-time error '3464': Data type mismatch in criteria expression ---- I know I can't use Chr$() (because it...

This is a little complicated to explain but here I go anyway: On an ActiveReport I have to display an "*" (in FldIndicator) if field24.datavalue (a percentage itself) is greater than my GetFiscalYearPercent function (thanks again Hypetia) or "" if not. Needless to say I can't seem to get it...

Here I go again bugging you nice people with my problems. In any case, on a form I have: a.) 3 frames - user Info, Travel, and Training (with multiple labels and text fields on each). b.) EntryType comboBox (with Travel, Training, and Both) My goal is to allow the user to enter information...

I’m trying create a function to get the “percentage of Fiscal Year elapsed” for a fiscal year that started and ends on 10/1/05 and 9/30/06 respectively. How do I determine: Format "ww" returns week of year (1-53) for a year that starts and ends September and August respectively. Thanks in advance

HELP, this desperate VB beginner!!!! I created a Database Application: VB front-end and MS Access back-end. Now I'm trying to generate a couple of reports. I'm using a DAO control but I am STUCK big time: I'm trying to get a percentage (field2/field1 - values passed from the Access table) and...

Hello All, can I change a field type from text to memo after upsizing from Access to Sql Server. The 255 characters (Text) does not seem to be enough for my users. Do you foresee any problems with that? Please Advise. thanks in advance

I need MAJOR help. I'm trying to upsize an Access app to SQL Server (using the Upsize Wizard) - it refuses to upsize the main table (Error: Export Failure -- Table skipped). How can I fix the problem? Please HELP!!!!!!!!!

Help!!! How do I create a unique ID field? [YY - MM - (Autonumber)] example: 04-04-9458 I already tried "[yy]& - &[mm]& - &[Fieldname]" putting each element of the ID in separate field. Hence trying to combine them into another field. Thanks in advance