Search results

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]?

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?

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...

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()...

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...

hi the main idea that i have user form to start my main table , i will choose grad then it will make filter to all student in the same year then it will make filter to all subject of that year then it will give me pre-entered codes related to that subject and each of these code has multi papers...

hi first,i have table contain three filed 1-name 2-url 3-date i am making continues form but i have web browser activex object but it do not show the url unless i activate the record ( clicking on the record ) ,how to make all record show it url simultaneously. second, in this continues form...

hi i have web browser in form and it is connect to fields . the problem is that not all the images in same size so i want to fix the web browser,and resize image size automatically to fit web browser size this is my try : Sub Test() Form_sheet1.Show...

hi everyone i have a data base with movies name and a web link photo and i want to make form shows it as grid view is that possible ?? best regards like this

i made a form with check filed i want if i check this filed it copy filed from table1 to new record in table2 i made like this Private Sub track_BeforeUpdate(Cancel As Integer) If Me.track.Value = True Then Database.Form_Mtable.Watched.Value = End Sub any advice plz

i have many table and two of them has the same filed name i tryed to make macro that update time for particuar one but it does not work why ?? every time it runs it ask me to stop run all macros :mad:

hi all i had made a main table and i put a yes/no field . i want if i check this check box vba will copy one cell value from main to another field and put it as new record every time i Change the value of the record or cell in the main filed ? thank for help :)

i have seen a lot of youtube videos about relation in access but still didn't under stand , i will explain the situation. i am making a data base for watching TV series so i create three tables 1- name 2-seson 3-episods and the ideai is every series has many sesons and every seasno has many...