Search results for query: *

I'm trying to get Visual Studio to work right.. I installed IIS, and am now able to start a C# ASP.NET Web application.. but when I put buttons and text boxes and stuff on the form and try running it...nothing shows up...lables show up but they dont have any formatting that I put on them...

Hi, I'm having trouble getting this delete statment to work. here is my function, when you press the button it is supposed to delete the currently selected record. Private Sub DeleteRecordButton_Click() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb dbs.Execute...

I have a form and it shows a list of all the records, and there is a button to add a new record.(a new form pops up that allows you to add a new record.) But after the new record is added and the pop up form closes, I want the original form to automatically refresh so that it shows the new...

Can you not use the Avg? function in reports? it works fine in my Form's but when I make a report with the averages in the footer, it just shows #error on every thing. Thanks for any help

Is there any way to put a check box next to a record, and run a query only on records that are checked? How would I do that on a form? Thanks for any tips.

How can I make a macro that will insert a new row at the end of my data? I am able to do it manually, but I want to automate it and add it to a button (the button part I can do I just dont know how to select the last row of my data) Thanks

I set up groups and user accounts and it works fine on my computer but when I copied the database over to the server..and everyone runs a shortcut to that database...I'm the only one that ever gets the username/password prompt...how can I make it so everyone gets the prompt? (also when other...

I'm having a problem with an active X control. its a common control for an Open File window. It works fine on my laptop and one other computer at work, but the other 2 computers I get an error "no object in this control" I dont know why because the ActiveX control is registered I...

I'm trying to calculate the average of a column in a query but I dont want it to include the zero's in the calculation. For example COLUMN01 54.3 0.0 0.0 0.0 54.9 0.0 98.0 I want it to average only 54.3,54.9,98.0 I tried having my query return Null's instead of zero's because Avg ignores...

I want to put our database on the companies server. one workgroup needs to be able to enter new data and view data..the other workgroups only should be allowed to view the database. Does access allow you to restrict certain people from opening certain forms and doing certain things? also No one...

I have a form based on a Query (the query calculates all of its numbers by calling some VB functions.) anyway on my form I set the Format = Fixed and Decimal = 0 so that It would round off but it doesnt work...it still shows all the decimal values. Also the drop down list for Format in the...

I'm working on a querry but it shows a calclation from some data in the table the problem is the calculation is to long and complex to fit in the query field...so it wont let me do it. anyone got any ideas how I can fix this? Thanks.

I have a report that is too big to fit on one page however since I use the CanShrink setting..everything always is able to shrink to fit..but it still prints out a second page every time that is blank. Can I write a macro or something that makes it only print the first page? like print from...

Hi, I have a Report and text boxes on it, I can get the stuff in the textbox if I use access built in expression builder... but how can I get it using vb code? Lets say my text box is named TextBox and its in my report, which gets data from Table->Main How to I set TextBox =...

I'm having trouble with this... I have some fields say FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 TOTAL lets say the user types values into Field2, Field3, Field4 but leaves field1 and field5 blank... WHen I calculate the total I want it to work without having to type 0's into the blank fields.. I'm...

In Access 97 how do I get the current directory/path? I tried Dim MyPath MyPath = CurDir I also tried Dim MyPath MyPath = CurDir("C:") (I think) but it says library not found for CurDir... any Ideas? Thanks

In Access 97 how do I get the current directory/path? I tried Dim MyPath MyPath = CurDir I also tried Dim MyPath MyPath = CurDir("C:") (I think) but it says library not found for CurDir... any Ideas? Thanks

I'm using Access97 but can't find the answer in those forums, this is mainly a Visual Basic question. How do I create a blank file? Right now I am using. Open "test.txt" as input for #1 'read the data in. close #1 the problem is it crashes if text.txt doesn't exist....how do I...

I'm trying to store/save some info in files..but if the file doesn't exist yet then when I do, Open "test.txt" for input as #1 gives me an error if test.txt doesn't exist...in C++ the open command creates the file if its not already there..how do I do this in VB? Thanks, its...

have a table but some entries are the same for example my table might have BOB BOB JOHN SAM BOB I want to fill a combo box with these values but don't want reapeats in the combo box...so the combo box would have BOB JOHN SAM I tried spitting the table up and making relationships but it didn't...