Search results

I am trying to find the quick way for texting the Month off this formula: =MONTH(NOW()) but the value that gets returned is a Number and it seems like there is an easier way than nested if statements to get what im wanting. Now, I would like to keep this out of VBA perty please. Ty! Daxton

What is asked of me to do is for Access to tell when an employee has reached 30 days, 60 days, & 90 days. Now I know how to do something like it in excel but I don't know what the formulas or anything that I would use in Access would be. Daxton

I know i've asked this question b4 but I can't find it in the search forum. I'm trying to make the rectangle where it's just the lines or the inside of it is clear. I tried the Order part of it but that just changes the order so that other stuff that is created can be see thru it.

How do you put VBA in for a table, well for a value in a table? I'm used to using VBA in excel but I just started using access and I don't know anything about it. Meaning how do u get to where vba is put in? B/c what I am trying to do is have a table that has a number for every record that is...

What the problem is, is this db that I'm making. Its a Bill Of Lading, which is a form that prints out and gets shipped with all of our parts that we ship off. Which we work in a plastics plant. So is there a way to get access to start on that #? The # we're on is 1680 and I want it so access...

I have a table that was hidden. How do I make it to where its not hidden anymore b/c I cant select it and tell it not to hide it. I shoulda asked this b4 it was hidden.

I'm making a db for my bosses acquaintance. I thought the one i made in excel for her would be good enuff last year but now its not big enuff. I made it in excel cuz I didnt know access and I thought it would be good enuff, but now she wants to make it longer so what im doing is making it all...

What's a query?

I was using Left() Right() Trim() in Office97 and i switched to 2000 and it doesnt allow the use of those functions unless you install those functions with 2000. I know there's another way of doing it becuz i've done it b4. But I cant remember how. Does anyone know?

Im somewhat of a beginner. I know a little vb and im just starting to get my feet wet in OLE. Now what i currently have is working but it has alot of useless steps. I keep my data in access. I run a form that runs a query based off the inputed data from the form. Access then exports the data...

How do I write to a query using code? The query is based on suppliers. But if my query returns null and i output the query to a spreadsheet. My spreadsheet program will not know where to put the data because it doesnt know which supplier the spreadsheet refers to. So, i need to be able to...

The GetOpenFilename in excel works like this: theFile = Excel.Application.GetOpenFilename This pops up your system file directory and lets you browse for a file. And then sets your object (theFile) to the filename and you can do whatever using the filename (open, save, etc.). WORKS GREAT in...

If an excel spreadsheet is open already or if the worksheet that is going to be used is already open within the workbook before i output my query. Any suggestions on what code to use to test for these open sheets. Thanx, Daxton Allen

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

I am using the OutputTo Statement. When i leave the filename to Output to....blank, access prompts me for the file, this is good, that's what i want it to do. But lets say i want to then take and open the file in excel. How would i code that? I know that i somehow have to set an object...

When using the DoCmd.OutputTo Statement, What is the correct code to use for the Output Format. Say im outputting from a query to Excel spreadsheet. Ive tried .xls, *.xls, (*.xls), "*.xls", ".xls", etc. No Luck yet. If anyone could help with this matter. It would be great. Thanx, Daxton

when i run my form from a macro, it opens up as the correct size. Running the form itself Opens it up Maximized. Is there a fix for this because i didnt see anything in the properties window. Thanks, Dax

I have a problem in my query. I want to prompt the user for criteria using a custom dialog box form that i have made but my query will not run it. The problem comes when i type the formula in the Criteria cell. I type: Forms![Supplier Menu]![Supplier Menu] then when i click elsewhere...