Search results

I could use the year as Year(Now()) and month as Month(Now()) but I need to display the month as a name not a number

I have a month field on my table, I have tried to ass "Now()" on the Default Value, but its not seems to be working, what I want is when the form is opened the default value would be the current month. Thanks.

ScottGem I think you didnt read my last post well :) hehe, its ok i got fixed. ;), I do appreciate your support a lot, thanks again.

mm, still not working, if leave both null then the error msg will popup, if only one it null then the msg wont popup!!. If Not IsNull(Me!commonth) Or Not IsNull(Me!comyear) Then DoCmd.OpenReport "RepRecords", acViewPreview commonth = "" comyear = "" commonth.SetFocus Else MsgBox "Error, Please...

Got working thank sth is not going on right here: If (Forms![Selectmonth]![commonth] <> "") Or (Forms![Selectmonth]![comyear] <> "") Then DoCmd.OpenReport "RepRecords", acViewPreview Else MsgBox "Error, Please Enter A Month and A Year" End If my conditions request that both commonth and...

thats not gone help, on both combo boxes(month and year) the user will first have to chose from that form the month and year then the report will be based on that selection.... i dont want the user to access any queries

I need a button that will open a report based on the selection of my 2 combo boxes on my form: find = "select count(*) from Records where Month = '" & commonth & "'" & "and Year = '" & comyear & "'" How can I open my report based on this query. Thanks.

Thanks , I have found my way out: this code for the new IT: Private Sub Command26_Click() On Error GoTo Err_Command26_Click Dim addme As String Dim StrSQL As String addme = txtname DoCmd.RunSQL "INSERT INTO ITList ([ITName]) VALUES ('" & addme & "')" Me.Refresh Exit_Command26_Click: Exit...

I have added this code for adding my a new IT from a textbox: Private Sub Command26_Click() On Error GoTo Err_Command26_Click Dim addme As String addme = (txtname.Text) strSql = "INSERT INTO ITList([ITName]) " & "VALUES ('" & addme & "')" Exit_Command26_Click...

Thanks ejstefl, I already know that, i would prefer the first option which is write my own code, though i need some help so i can start with.

as for deleting the record it should be the selected one from the list, as for entering the new record i use a textbox(unbound).

Deleting and adding from a table I have a form that has a list; the list is retrieving some names from a table. e.g Table name is “ITname” and I have a filed named “name” with the following: john, peter, mike, rock. On my form under my list I have a delete button, I want to the button to...

So If I understand correctly those were my steps: 1. I have created a folder a new folder in my server and copied db2 in there. 2. Open db2 and split it within the same directory. 3. Go to my network computer and map the file db2 (not db2_be) Am I doing the right steps?

Still not sure how to do this, after I convert my database and create an mde file few changes might accrue in the future, I have tried to make some changes for testing purpose and then create a new mde file and saved it with replacing the older one but I had lost my new data which was entered in...

http://brandon.fuller.name/archives/2004/08/31/13.29.25/ :) :)

I use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didn’t work. This is what I got: This error is usually associated with compiling a large database into an MDE file...

Ok, I got it fixed, but when the report page opens how I can set to view on 100%, by default is sat to view on fit

Ok what about this code Private Sub cmdPrintRecord___Click() Dim strReportName As String Dim strCriteria As String strReportName = "ACAAudio" strCriteria = "[ID]='" & Me![Text122] & "'" DoCmd.OpenReport strReportName, acViewPreview, , strCriteria End Sub Where Text122 is the...

is it possible to open a current record in a report, what I mean is while the user is going over the records and lets say that he wanted to print the current record I need to open and print that record in a report so it would look more professional, how can I do that? Thanks.

I had an error: 1. The first step that I did was selecting the security wizard option 2. Create new workgroup file information 3. I want to create a shortcut to open my security enhanced database 4. Then I was promoted to select which object i want to secure they were all selected by default...