Search results

Does anyone know how I can find out the breakdown of how much diskspace my tables/queries/forms are taking up? Thanks -Nathan

http://www.mvps.org/access/modules/mdl0006.htm http://www.mvps.org/access/modules/mdl0007.htm

I guess I don't know what your question is. If you are trying to find the day of the week from a date you can use this in code: [code] Format(YourDateHere, "ddd") [code] ddd gives you the first three letters of the day. dddd gives you the whole name of the day.

Not that i know of. You could always set it to false so that the user does not see Excel being opened. DoCmd.OutputTo acReport, "rptTest", "Microsoft Excel (*.xls), RptPath, False

OK I have a big table. It has a few fields but that is not the problem. This big table links with another table on two fields (2 fields on the big table (TableA) can link with one field on TableB. I know not smart (I did not design and am not allowed to change this fact). So TableA can...

I just had to do something similar to this. I created a new table that had the same field names, field structure etc... I added the primary key on the fields that had to be unique. Then I ran an append query from the old table to the new one. Worked like a charm. Don't know if this is what...

You could set the variable when the condition is true. Set it to false if the condition is false. As you can see on the code below it is for the Unload event "Private Sub Form_Unload". example: If IsNull(Me![Reason for Modification]) Then iLetFormClose = 0 Me![Reason for...

Do a search on this forum for password. I think on page 2 or 3 there is a thread with some solutions.

2 things i jumped out at me. 1. There is no space between * and From 2. You are selecting from table Product yet your criteria says tabel Products Edit: third problem 3. strWhere = " WHERE (((Products.TagNumber) Like Me!TagSearch)) AND ((Products.CategoryID)=Me!CategorySearch));" should...

I have something similar to that I needed to do. I have a change password form and if they have to change password (various reasons) then this form pops up. I have a global variable that is set to 1 in this instance. If this variable is 1 and the form is attempted to be closed then it prompts...

try using vbCrLf

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q209898& ^^Try that one out. I did a search on google for: treeview MS Access Got quite a few hits. most all were 97 however. Sorry I don't know much of anything about the treeview control.

One of your fields could be how many 15 chunks of time the appt takes?

In the code window go to Tools | References then find it in the list.

In Excel fi you change the property of the cells to custom and type in "00000000" then it will add 0's to the beginning of the numbers that are less than 8 digits.

Neo: you can use the IIF() function IIF(Criteria Goes Here, True Action or Value, False Action or Value)

Sorry don't know of any links to employee databases. To help you with your problem tho: I would make a query with all the data you want on the form (including all the tabs). Set the form Control Source to this query. Then in each of the tabs you want "connected" put in the employeeID type of...

Are you wanting a used version i assume? Try Half.com DOH ! that is Ebay ... sorry.

I had a similar problem with a change password form I was working on. The box needed to use input mask of "Password" of course but then business rules dicatated max password size of 10 characters. What i ended up doing is when they would hit the submit button I validated the length of the text...

You will need to make a reference to DAO ("Microsoft DAO x.x Object Library") Then you can do Dim db as Database Set db = CurrentDB