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

Nevermind, I'm a bozo.... I fixed it.. Private Sub DeleteRecordButton_Click() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb dbs.Execute "DELETE * FROM BREAKS WHERE MainID = " & Me.MainID End Sub

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.

That Works Perfect, thank you very much.

Thanks, that way seemed to almost work Application.Goto Reference:="ID" LastCell = [A65536].End(xlUp).Offset(1, 0).Address Range(LastCell).Select The problem is that I have my data, then some formulas..then a table below that, and the code you gave me seems to jump all the...

Thanks, I just tried that..doesn't work the way I want though.

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 sent you an email...I'm confused about mdw..I dont know what that file is or does or how I made it or anything.

Here is what I did. I created the database on my computer..then I created a MDE file from that..then I copied it to the server and went to every computer and put a shortcut on their desktops that pointed to the MDE file.(I made the shortcut by right clicking and creating a shortcut.) When I run...

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

What is Pack it wizard? I can't find anything about it in the help files. I'm using Access 97..it it something new that 97 doesn't have? the file the control uses is COMDLG32.ocx I think and all the computers have it..so I'm not really sure whats going on...or why it works on 2 of my...

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

Thanks that wont work though I dont think. for instance I have COLUMN01 COLUMN02 COLUMN03 54 0 32 454 3 0 0 454 43 0 0 4 Where do I put a where clause? I could see doing WHERE [COLUMN02]<>0 but then that would eliminate tons of...

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

Because when I calculate averages I dont want fields with 0's in them to be included in the average..therefore I make them Null and the built in average function ignores null values. Thanks I'll try that. Is there any way to set a a double value to null? like Dim Variable As Double Variable =...

I have the Nz()'s in there..its hard for me to explain. Is there some way I can Convert the value to a double before it gets loaded into the form?