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

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

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

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

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

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

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

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

How would you specify the data type for say, shortdate in a query when you calculate time? Or if I wanted to add and subtract numbers with a fixed decimal point. I know you can specify datatype with a parameter query, but then it asks for the parameter, which I dont want. Is there any way to do...

Validation Rules for Data Integrity I have a field that looks up the JobType using a LookUp Combobox from another table where these records for JobType will never change. I want the user to only be able to select from the Combobox for the job type they want and be able to type the beggining...

How would i go about saving the data in a calculated textbox on a form into a field in a table? For example, on the form there is =[MatchedPages]+[UnmatchedPages] that I put into a textbox. I now want to store those results in a table with the field titled TotalPages. How would I do this?

I'm having difficulty figuring out how to calculate time. To test this i have three fields. The first field is StartTime and the second field is EndTime. The third field, TotalTime stores a calcualtion, which is how much time is between the start and end times, which is basically the total...

Is it at all possible to append 100 or so tables into one main table? All attempts have failed, and i do not want to make 100 append queries to do this. Is there any possible oter way to do this, prefferably in VBA? -Thanks in advance :)

Hey guys, i had an idea and wanted to if it sounded plausable before i went into that crazy thing called development. The windows search bar onlly allows for 255 characters in the search box, making searchinf for large amounts of files much more difficult. Is it possible to have a form that...

I need to have a table renamed when a tab is selected, and when a different tab is selected, i need it to rename the first table back to its orignal name, then rename the next table. For example: These are the tables ConcatenateM&M-002 ConcatenateM&M-003 ConcatenateM&M-004 ConcatenateM&M-005...

How do I make a message box? not the ones that you find in macros that only allow you to press ok, bu i mean message boxes that can decide what action happens next, with yes & no buttons and such. Can anyone help me out?

Hi guys, here is my problem. I need a query(s) to preform the following tasks. Each part represents a what a query needs to do, if the parts can be combined to prefom the same task(s) with less queries, that is also acceptable. Part1 -------------------------------------- I have a fields...