Search results

I have been looking for a way to modify a tables structure so that a text field, or memo field may be changed to a hyperlink data type without changing it via design view. Currently, I am playing with the GetFiles sample database, and i grap a file path coresponding to a file. I would like to...

Hello all, I have been playing with the GetFiles.mdb, featured in the Sample Databases section, and have come accross two issues I cant seem to adress alone. First off, I would like to add the file path to an existing table called 'Indexing', to a certain field called 'Filepath'. There is...

Never mind the button attempt! Im trying this but its not working! How does the syntax go for this? Private Sub Form_Timer() Forms!frmProcess!Process_subform.Form.Refresh End Sub I got frmProcess as my main form, Process_subform as my subform. But I get an error that says 'Field...

How do you refresh a subform? I have a button which processes data and exports it, then deletes all records in the table. this table is the one on the subform(in datasheet view), and all the records say #DELETED, and I cant get them to refresh. This is what Im using now. Private Sub...

Any one have any ideas? or is this more like a VBA question?

I need a field to update to the next number starting with the number the user enters. The field Is Called Record_Num and it needs to be text datatype, not AutoNum. I am using an Update Parameter query to ast the user for the first number, but I cant figure out how to make it Count of the number...

How Would you select a folder director Instead of a File? What I need to do is have the path selected to the folder and Use the Dir() function to return all the contents of that folder to a field in a table This link is to a discusion on this topic, but I figured this is more VBA related...

This is getting me closer, but how exactly do I implement this? where or how do I use it to pull in the file names? I put this code into a Module called GetFiles, but what do I do after this to get the file names? Or how or where do I call the function? Option Compare Database Sub...

I need to scan a directory and add file names in that directory to a table. I was told that the Dir() command can scan for file names and you can use ADO/DAO code to insert them into your table. But, I need some guidance on excatly how to do this. Can anyone post some examples on how to do...

What if the Time is less than one hour? Im getting a ERROR "Cannont Divide By Zero" now that im testing data. *EDIT* I will repost the line that is giving me touble in a few... It is because I'm returning the value in hour, but if its less than 1 hour, it get the error. How can i fix this?

Oh wow, what did i get into, lol. Thanks a whole bunch man im going to look into the database. :)

woot, thanks

How do I defualt the form to a new record without using the DATA ENTRY option set to yes. The Users will not be allowed to edit or delete the data after it is entered, they need a supervisor to do that, but they are allowed to add new records and view existing ones which is needed. So is it...

thanks man!

How is it possible to limit the users view for the toolbar for when the form loads? For instance, my form's default view is set to form view, and they cannot access desighn mode, but in the menu bar up top, it is possible for them to do so. Without removing the toolbar from that PC, is it...

I got it it kinda goes like this. So far it works for less than 24 hours, but is it possible for more than 24? AveragePPH: Format(Sum([pagecount])/(Sum(DateDiff("h",[StartTime],[EndTime]))),"#")

how do you get an average of pages per hour for this? Average PPH: Int(Sum([EndTime]-[StartTime]))*24+DatePart("h",Sum([EndTime]-[StartTime])) & " hr " & Format(Sum([EndTime]-[StartTime]),"n"" min ""s"" sec""") Any help? -thanks

Is it possible to fomat the color of a record in a query if it meets certain criteria such as: number<1000 , then display the record in red I looked it up in the microsoft access help, but i cant make sense of what they are talking about. Any help? -thanks

Thanks man, I'll try it out.

TotalTime: Sum(Format([PageCounts].[StartTime]-[PageCounts].[EndTime],"Short Time")) Access says "inccorect data type " when i try to execute this command in the Field Row of a select query. It runs fine without the Sum, but i get individual totals for every record, when i need just one overall...