Recent content by Deniseobx

Hello everyone, I need help in writing a query that would return the records that are not older than two weeks. I would appreciate your help in advance. :o

Thank a lot!!!

Hi Everebody, I need help with the the following: I have a form that has a listbox that gets its data through a query, the list box only shows two colums: Company and ProcessDate, also the query retrieves more fields, but I set the width of the columns to zero (For instance the query...

thanks a lot DJKarl!

HI ALL, I have the following code: Private Sub CmBXResolution_AfterUpdate() If (Me.CmBXResolution = "ESCALATED TO MANAGER") Then Me.Escalate = True Else Me.Escalate = False End If End Sub which means, if user selects the option "ESCALATED TO MANAGER" from my Resolution combobox then the...

Hi, thanks for your reply, I tried the code you suggested before posting to the forum and it didn't work that's why I got confused, I tried it again and nothing shows up on the Sorage_Charges textbox, do you think I need to add something else?, what a I doing wrong?

Hi, This should be simple but I can't get it to work, I have a bound form one of the controls displays a number of "storage days" from my table, I have another control that is not bound to anything, it should just display charges based on the Storage days textbox. I put in the default value of...

Hi, I am using a db that has macros to send the 20+ reports to outlook users. My boss would like to have those reports attached as PDFs instead of the regular snapshot format. I have found information on software like CutePDF, and Leban’s ReportToPDF module (...

Thank you, it works only that used VAL instead of CLONG

Thanks Keith that's exactly what I am trying to do, I changed my query using the function you sugested, but I am getting a error that says "invalid use of null", the following is my query, could you please take a look and see what I did wrong ??? Thanks in advance. SELECT * FROM CORP_CUST_DTL...

Would that work for any number of leading zeros? some record have 1,2,3,0r even 4 leading zeros, and maybe more, there are about 30,000 records.

Hi everyone, I have 2 linked tables from 2 different databases, there is a common field in both: “CORP_NBR” I need this field in order to create a join, but the problem is that in one table this field stores leading zeros and in the other table it doesn’t. I can see in design view that this...

Thanks to both of you!!!

Hi, thanks for the reply, I tried adding this to the Onload event of the form, but it didnt work, what Am I missing?: ************************************************ Dim URights As String If URights = DLookup(" * ", "Employees", "UserRights = 'Administrator' ") Then CmdAdministrator.Visible...

Hi everyone, I am trying to figure out what is the best way to hide/show a command button based on the current user priviledges. Basically all I have so far is a module that captures the NT id and inserts it into a Users table. I am not sure how and where to place the rest of the code, if the...