Search results

Hi, I can add to my make table query UDate: Date() that will add a populated field to the output table that has today's date in it. I can also add something similar like this for example V_Num: [V_Number] and when ran, will prompt with a dialogue box to add some data, it will then create the...

Hello, I created an update query to a text field in a table. However, it inserts the data at the end of the string and I need to insert it at the beginning of the string that already exists. How do I move it to the front instead of the end? :confused: This works but puts it at the end...

A field in a table can be populated by a lookup up but it has to be done manually or with a form. A "new" table can be created with a query that matches the data. Is it possible to skip these steps and create a field that automatically populates with the data from another table based on...

I have a Make Table query that has a Total: Sum of the field QTY. When I run it, the table data is correct but the field name is SumOfQTY. I would like to leave it as the original field name. Since it's in a unique table I'm not concerned with it being confused with another QTY field. How...

I am running into a couple problems at the same time and could use some suggestions: I need to export a table to .txt I need to have the field names as well as the records Some records are part numbers with a leading zero like 043095 Some records are part numbers with dashes and alpha's like...

Hello, I am trying to help someone long distance. Their db has tables in Share Point and one query in particular is kicking up multiple error messages. (we both have the same permissions) I ran the same db from my PC and it worked just fine. Since I cannot duplicate it I think it is some kind...

Or maybe even undock it? I know I can show it or not but sometimes it's in the way or not big enough. If I open it to show the full length of the names it makes the working window too small. Seems like there should be a way to move it to the bottom for example. Then you could see the full...

I just want to automatically add a current date and or time stamp field to table whenever it is created so I know how fresh the data is. Is there an easy way to do this? :confused:

I have an existing report. I want to use it with a different query. (basically the same query as the original, just renamed fields) I copied the report and renamed it something else. I went into the properties for each field and changed the control source so it uses the correct query and field...

I "had" tables that were links to .xls files. Now everyone has upgraded to Office 2010 so I need my linked files to point to the same place and file name but with the .xlsx extension not the old .xls so how can I do this without recreating everyone one by hand? Linked Table Manager shows the...

I have a very small db that has a very limited purpose to be ran by users with even less Access experience than me. If that is possible. :D So, I want to: (1) write a macro that will run when the db is opened. One table is a network connection. One table is on the C:\ drive of the user. (2)...

This seems so easy and yet I am stumped with where to start. Two tables: Table 1 is a list of part numbers in this format 123-456-789 Table 2 is a list of part number prefixes that identify what the part number family is. Example: part number 123-456-789 is a "widget" because in Table 2 is...

Does anyone know if it's possible to change the color of the worksheet tab based on information in another cell? It would be a really nice feature if the tab color could be controlled by a cell in that worksheet. That way you could flag the user easily if that worksheet needs to be looked at...

I'm using 2003 and not getting anywhere so maybe someone can help me out. I have four very basic queries but all draw from different tables and it's not interelated data. The output of each is only three rows but the data is 12 columns. One for each month. (actually 13 because of the main...

I want it to check for a table called DOWNWU_ImportErrors and if found delete it. If not found go on with the rest of the script. I really would like it to just delete all the tables but I couldn't figure out a way to make that work so I have to be specific on the table names for now. If...

In my DB I have an AutoExec macro that calls a function. In the function I begin with DoCmd.SetWarnings False but it still runs and shows all the activity. I also added it to the end of the function too but it doesn't help. Why can't I just have it execute and run in the background without the...

I created an autoexec macro, with the screen off Action that imports a text file to create a table. Sometimes that process will create an error table so I added the steps to use the Action of DeleteObject for that error table and the original since they are nolonger needed. The problem is IF...

I did a search and do not find anything on this problems specifically. So, looking for some guidance. I wrote a macro to convert a table to a text file and leave it in a folder on my C drive. (one column, all part numbers so text only, no numbers or dates) The problem is that it's putting...

I have my working union query and I tried to add the "Make Table" function to the union query. When I try to run it I get the error message: "An action query cannot be used as a row source." Here's my SQL statement. SELECT DISTINCT ALL_WU_DATA.Component, ALL_WU_DATA.MMPP INTO UP_TO_WM IN...

I have one table and my query finds the records I need and outputs two columns of data. Like this: 1, 2 1, 2 1, 2 I need those two columns (different fields of the same record) to be in one column so I can eventually use the make table and use it for another purpose. Like this: 1 2 1 2 1 2...