Search results

Mr. Hartman was partially right, the issue was that in the report was a grouped by [First name], and that is why it was prompting for the field name every time I run it. The issue is solved thanks for you help.

I have a table has two fields [First Name] and [Last Name], I want to create an expression in the query of both of them as single field. The issue happened when I deleted the parents fields. Access starts to show up the "Enter the Parameter Message".😓

When I create an expression query, should I keep the parents fields? e.g.: Expr = [First Name] & [Last Name] should I keep the parent fields in the query I mean [First Name] and [Last Name]?

I am not limited to array, I am opened to any other solution. "I made a query and grouped it to get the distinct value," if this may give another way?:unsure:

I looked for it, and its not clear. Please write any example or reference page.

Hi, As in the title: the main goal is to create a report for each subject and save it as PDF. this code do the job. Private Sub Command15_Click() Dim sql As String subcol = Array(14, 16, 30, 74, 289, 200548, 201103, 200594, 200569, 402031, 201105, 157) For i = 0 To 11 sql = "SELECT * FROM Y7M...

Hi every one, I am facing a new issue with the MS Access report, when I am creating a stander report of a query, the data is visible. When I am adding a group or a sort it become empty. any solution?

thanks for your suggestion it was helpful.I found some mistakes ,however that did not fix the issue. "does not work" means the SQL do not append new records to the table. but i change some of the names like instead of "subject 1" i used "subject_1" which help to fix it. thank you very much all ;)

Private Sub Command200_Click() Dim strSql, strSqlfees As String, i As Integer For i = 1 To 8 ' strSql = "INSERT INTO [Copy Of tblsyllpus] ( Studentname, subject, ExamDate, enddate, Qualification, Syllabus, Code, [Component Title], [Session], Duration, gradyear )" & "SELECT [Form responses...

i hope someone tells me the solution :D

Unfortunately i got the data base like that multiple entries for one record :banghead:

hi i have 8 textboxes and i have 16 append queries.Two for each one of the textboxes. Each one of these Queries has a criteria equal to the textbox. is it possible to write a loop to all textboxes and change the criteria depend on the textbox name? and i will use just two append queries...

thank you, in the beginning, i were using poster link and it was fine, but recently they change some thing with their sever, so the old link was not valid any more , and i have 70 shows, it is not easy task, then i found about the scraping , so i looked for it.

thank you very much. this is a code found on internet but it is not working probably for 1. i am using the main IMDB not what did you recommend 2. some debugs. Private Sub Form_Load() Dim IE As New InternetExplorer IE.Visible = True IE.Navigate "http://www.imdb.com/find?ref_=nv_sr_fn&q=" &...

hi i have a small db form series i watch, and i red about ability to query from web sites like imdb or myanimelist and i may get poster link or series episode number , i am not big programmer, So what do you have thoughts about this thing:confused:

hi i have a webbrowser activex control in my main form,and this is the code in itPrivate Sub Form_Open(Cancel As Integer) wb1.Navigate2 "about:blank" Do Until wb1.Document.ReadyState = "interactive" DoEvents Loop End Sub Private Sub Form_Current()...

because when i watch a series - as you know series has seasons - usually series start with season 1 which i put in the main record, then when i want to see season 2, season 1 will transfer to sub table, and i will fill the season 2 information. the last season will be the main record and old...

hi i have main table called tblseries and sub table called tblseason and they have relation between both, i made a form from the main table and in the same form is shows the sub form on the left, this form has button if i press it, it copy the data from main record and put it as new record in...

hi i am using this code on click with button and it work well DoCmd.ApplyFilter , "status='seen'" DoCmd.SetOrderBy "ldate ASC" DoCmd.GoToRecord acDataForm, Me.Name, acLast but when i use it with form on load the filter and go to the last row does not work but the sort work so why ?? I...

hi as in title i have database and user form it was working good until today . before when i enter new record it stay at the end of the database, but now when i add new record ans close the database and reopen it the record become first not just in user form but also in database ,and i am not...