I have a calculated time value and would like to see it in decimal values for example:
Time value is 5:27 I would like to see the decimal value of 5.45 (I got these values using Excel formulas, but I can't get it to work in Access)
I have to input alot of time data into a spreadsheet and I am wondering if there is a way to just be able to put in the numbers and have it format to time for example:
I put in 1330 and it converts automatically to 1:30 PM?
I have 2 controls on a form, one is a text box called "teams", the other is a combo box called "channels".
I want to be able to limit the data in the channels control to the team in the team control. The tables involved are
Teams with fields teamname
Channel with fields channel and teamname...
I am trying to pull down info from stock pages into my access database. One way I was told to do this is by pulling the data using SQL. Does anyone know if this is the right road to go down and if so is there anyone who could point me in the right way of getting started ( a tutorial
maybe?)...
Thanks that worked great. Perhaps you know if there is a way to create a control similar to the ActiveX Date Time Picker control. I want the user to be able to click the drop down box and be able to select a time. I would like a clock like appearance to it if possible (similar to the calendar...
Every time I open my form that has the DateTimePicker control on it I get the following error message:
Can't set value to Null when checkbox property=FALSE
Is there a way around this error without having to set the property to TRUE and checking the box every time you change the date?
Thanks
Bob
I am trying to create a modified version of Access's User Level Security. My scenario is as follows:
I have an opening password screen in which the user will select from a dropdown box their UserID, I have 1 hidden fields on the form that will contain their user level. What I need is to place...
I am trying to undo changes to a subform's record (not delete the record just undo the changes). I have a button on the mainform called Undo my code behind it is as follows:
Private Sub UndoButton_Click()
Me.Undo
Me.sfmOrderDetailsSTATUSCONTROL.Form.Undo
End Sub...
I need help in trying to figure out a way to import an Autocad .dwg file into my database, cut and paste some data onto it then print it out.
If anyone has any ideas let me know Thanks.
Bob
Trying to find information on how to set up security on a database so that users can only access the data they are responsible for in the tables. I know the user level security prevents acessing forms, reports, etc. but I have people that I want them to only see their records when they log onto...
Is there a way to close 3-4 forms at once. Say that many were open and I wanted to get back to my main menu from the 4th form is there a way to code it so the other 3 forms also close?
Thanks
Bob
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.